Item Import Data Format and Sample

Item Import Data Format

Header

Required

Data Type

Data Requirements

ItemName

No

String

Summary:
The item name, which is typically auto generated for new items.

Notes:

If item name is omitted an item name will be generated using the Blueprint settings for new items. Item names must be unique for every item within your organization.

ItemType

No

String

Summary:
The item type being used.

(If field is omitted, a default of MC4 will be used)

To view list of Certiverse supported item types, visit the end of this article.

TopicDisplayID

No

String

Summary:
An existing Topic ID from the Blueprint into which the items are being imported.

Notes:

Only the lowest level Topic/Subtopic ID in a tree can be assigned

If the TopicDisplayID is omitted, the item will be assigned to "0. Unassigned Topic", and the items topic can be updated in Item Management after the item is imported

The string can have the character "#" at the beginning, which we strongly recommend, so that the Topic ID is not mistaken for a number value when editing data in applications like spreadsheets

Examples:

“#1.1” 

“1.2.1”

Exhibit

No

String

Summary:
Exhibit will be displayed split screen with the item during test delivery.

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

Scenario

No

String

Summary:
Scenario is displayed during test delivery above the stem. The scenario can be stored separately from the stem to separate background information and the question.

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

Stem

Yes

String

Summary: The stem of the item. Be sure to end each stem with a question mark or a colon.

Notes:

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

ResponseOption#

Yes

String

Summary:
The # response option for the item. "#" should be replaced with the response option number. The required response option columns in a file depends 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.

If the number of response options for an Item Type is less then the response option column number, the field should be left empty. For example, if the item is a MC3 item (three option single response), the "ResponseOption4" will be empty.

 

Notes:

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

ResponseOption#IsKey

Yes

Boolean

Summary:
Indicates if the first response option is a correct answer.

Notes:

TRUE = Response is correct (key)
FALSE = Response is incorrect (distractor)

 

MC (single response, example item type "MC4") items can only have one ResponseOption#IsKey field be TRUE

MCR (multiple correct response, example "MCR5-2" items must have the number of correct options be TRUE.

For example:

MCR5-2 must have two ResponseOption#IsKey be TRUE

MC2 can only have one response option can be TRUE

ResponseOption#Rationale

Yes

String

Summary:

The rationale for the response option.

Notes:

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

Reference

No

String

Summary:

The reference(s) for the item.

Notes:

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

ItemTags

No

String

Summary:

Tags associated with the item.

Notes: 
Item Tag must already exist for the Blueprint.


Item Tag Value must be valid for the configured Item Tag. 


Item Tag and Tag Value should be data pairs separated by a colon.


Multiple Tag and Tag Values can be included, and should be separated by a semicolon.


Only one Tag Value per Tag 
Item Tag Values can have letters, numbers, periods, hyphens and spaces.


Item Tag Values cannot use punctuation, including commas or colon sign.

Example: “Color:Blue; Size:Medium”

Notes

No

String

Summary:

Any notes about the item.

 

 Item Import Sample Files

  1. Item Import Sample - Simple.csv
    1. Sample file with multiple item types.
    2. Blueprint must have all item types in the import file enabled, or you can remove item types not configured for your Blueprint from the import file
    3. Topic IDs are not in the file, and Items will be imported with Topic set to Unassigned
    4. The topic can be assigned to the correct topic in Item Management after import
You can find a how-to video here.


  1. Item Import Sample - All Fields.csv
    1. Sample file with multiple item types, Topic IDs and Item Tags
    2. Blueprint must have all item types in the import file enabled, or you can remove item types not configured for your Blueprint from the import file
    3. Blueprint must have Topic IDs in the file configured, or you can remove Topic ID in import file
    4. Blueprint must have Item Tags in the file configured, or you can remove item tags in import file
  2. Translation Import Instructions
    1. To view instruction to import translations of existing items please visit the article linked above.
You can find a how-to video here.


List of Certiverse supported item types with item type codes:

Item Type Import Code Item Type Name
MC4 Single Correct Response - Four Options
MC2 Single Correct Response - Two Options
MC3 Single Correct Response - Three Options
MC5 Single Correct Response - Five Options
MC6 Single Correct Response - Six Options
MCR4-2 Multiple Correct Response - Four Options (2 Correct & 2 Distractors) Dichotomous Scoring
MCR4-3 Multiple Correct Response - Four Options (3 Correct & 1 Distractor) Dichotomous Scoring
MCR5-2 Multiple Correct Response - Five Options (2 Correct & 3 Distractors) Dichotomous Scoring
MCR5-3 Multiple Correct Response - Five Options (3 Correct & 2 Distractors) Dichotomous Scoring
MCR5-4 Multiple Correct Response - Five Options (4 Correct & 1 Distractors) Dichotomous Scoring
MCR6-2 Multiple Correct Response - Six Options (2 Correct & 4 Distractors) Dichotomous Scoring
MCR6-3 Multiple Correct Response - Six Options (3 Correct & 3 Distractors) Dichotomous Scoring
MCR6-4 Multiple Correct Response - Six Options (4 Correct & 2 Distractors) Dichotomous Scoring
MCR7-2 Multiple Correct Response - Seven Options (2 Correct & 5 Distractors) Dichotomous Scoring
MCR7-3 Multiple Correct Response - Seven Options (3 Correct & 4 Distractors) Dichotomous Scoring
MCR7-4 Multiple Correct Response - Seven Options (4 Correct & 3 Distractors) Dichotomous Scoring
MCR7-5 Multiple Correct Response - Seven Options (5 Correct & 2 Distractors) Dichotomous Scoring
MCR8-2 Multiple Correct Response - Eight Options (2 Correct & 6 Distractors) Dichotomous Scoring
MCR8-3 Multiple Correct Response - Eight Options (3 Correct & 5 Distractors) Dichotomous Scoring
MCR8-4 Multiple Correct Response - Eight Options (4 Correct & 4 Distractors) Dichotomous Scoring

 

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.