Item Translations Import Data Format and Sample

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.

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"

Scenario*

Yes, if used for source language but should be combined with Stem column. See notes & summary for example and details.

String

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

Notes:
If a Scenario was used for the source language combine the Scenario and Stem content in same Cell under the Stem Header (see example below). The Item Management Portal will recognize the first part of the content belongs to the Scenario and appropriately add content to the Scenario field and the second part of the content will be recognize as the Stem.

Example:

Header = Stem

Content in Cell =

<p>This is the Scenario Content</p> <p>This is the Stem content</p>