Item Import Data Format
Header |
Required |
Data Type |
Data Requirements |
ItemName |
No |
String |
Summary: 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: (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: 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: Notes: |
Scenario |
No |
String |
Summary: Notes: |
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 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: Notes: TRUE = Response is correct (key)
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:
Example: “Color:Blue; Size:Medium” |
Notes |
No |
String |
Summary: Any notes about the item. |
Item Import Sample Files
- Item Import Sample - Simple.csv
- Sample file with multiple item types.
- 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
- Topic IDs are not in the file, and Items will be imported with Topic set to Unassigned
- The topic can be assigned to the correct topic in Item Management after import
- Item Import Sample - All Fields.csv
- Sample file with multiple item types, Topic IDs and Item Tags
- 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
- Blueprint must have Topic IDs in the file configured, or you can remove Topic ID in import file
- Blueprint must have Item Tags in the file configured, or you can remove item tags in import file
- Translation Import Instructions
- To view instruction to import translations of existing items please visit the article linked above.
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.