Data Import
      Back to home
      1. Administrator Knowledge Base
      2. Admin Application Guides
      3. Data Import

      Item Translations Import Data Format and Sample

      Item Translations Import Data Format

      Header

      Required

      Data Type

      Data Requirements

      ItemName

      Yes

      String

      Summary:
      The item name for existing item.

      Notes:

      Must match an existing Item Name for the Blueprint, and existing translations cannot be overwritten.

      Scenario

      Yes, if used for source language

      String

      Summary:
      Scenario is displayed during test delivery above the stem.

      Notes:
      See "Item Import with Formatting" and "Item Import with images"

      Stem

      Yes

      String

      Summary:

      The stem of the item.

       

      Notes:

      See "Item Import with Formatting" and "Item Import with images"

      ResponseOption#

      Yes, if used for source language

      String

      Summary:
      The # response option for the item. "#" should be replaced with the response option number. The required response option columns in a file depend on the maximum number of response options for the Item Types contained in the file.

      The response option number starts with 1 and goes to the number of response options for an item type. For example, a MC4 (four option single response item) requires four columns with the header "ResponseOption1", "ResponseOption2", "ResponseOption3", and "ResponseOption4"; and each of the columns must be populated for that item row.

       

      Response options not used for a given Item Type should be left empty. For example, ResponseOption4 will be empty for a MC3 item (three option single response)

       

      Notes:

      See "Item Import with Formatting" and "Item Import with images"

       

      Item Translation Import Sample File

      1. Item Translation Import Sample.csv
        1. Sample file with multiple item types containing translations in Spanish
        2. Items in the file match the Item Import Data Format and Sample File, and will allow user to add translation to the sample items
        3. Additional columns then those listed above will be ignored
          1. The item export contain additional columns, and is frequently used for translations outside the system.
          2. The item export file can be updated with translation to the fields listed above, and additional columns will be ignored.

      Contact Us

      If you have any questions or need additional assistance, please contact us by either emailing support@certiverse.com or by submitting a ticket from this article.