Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
item_import_notes [2017/01/12 15:35] steveclarke [Field List] |
item_import_notes [2017/09/05 10:46] (current) 72.38.112.148 |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== Item Import Notes ===== | ===== Item Import Notes ===== | ||
| - | FIXME requires more copy editing | ||
| - | |||
| - | FIXME more ties back to item, attachment, reference, author, copyright, etc. | ||
| - | |||
| The grid below is a list of all accepted data fields for an [[item_entry|Item]] imported via Word or Excel. The Word Import template consists of a table with two columns. The left column is the field name, the right column is the field value. Each row in the table corresponds to a different field name/value combination. The Excel Import consists of a header row of Column names, and one row per Item. | The grid below is a list of all accepted data fields for an [[item_entry|Item]] imported via Word or Excel. The Word Import template consists of a table with two columns. The left column is the field name, the right column is the field value. Each row in the table corresponds to a different field name/value combination. The Excel Import consists of a header row of Column names, and one row per Item. | ||
| Line 25: | Line 21: | ||
| ==== Item Types ==== | ==== Item Types ==== | ||
| === Multiple Choice Items === | === Multiple Choice Items === | ||
| - | For Multiple Choice (MCQ) Items (4 option, 5 option, true/false) FIXME (link glossary item type), you do not require the OptionText5, OptionCorrect5 or OptionValue5 fields, unless creating a 5 option item. For 4 option Items, you can omit these fields. | + | For Multiple Choice (MCQ) [[concepts#Item Types|type Items]] (4 option, 5 option, true/false) , you do not require the OptionText5, OptionCorrect5 or OptionValue5 fields, unless creating a 5 option item. For 4 option Items, you can omit these fields. |
| None of the red rows apply to MCQ type Items. If importing MCQ type Items, all of these fields can be omitted. | None of the red rows apply to MCQ type Items. If importing MCQ type Items, all of these fields can be omitted. | ||
| Line 59: | Line 55: | ||
| |GROUPID|Numeric \\ ‘’ (empty)|[[item_group_entry|Item Group]] must be numeric \\ Item Group x is not setup within the Bank|GroupID must exist and within the selected Bank. \\ Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | |GROUPID|Numeric \\ ‘’ (empty)|[[item_group_entry|Item Group]] must be numeric \\ Item Group x is not setup within the Bank|GroupID must exist and within the selected Bank. \\ Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | ||
| |GROUPSEQUENCE|Numeric \\ ‘’ (empty)|Item Group Sequence must be numeric|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | |GROUPSEQUENCE|Numeric \\ ‘’ (empty)|Item Group Sequence must be numeric|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | ||
| - | |DISPLAYTYPE|1, 2, 3, 4|Display Type must be 1, 2, 3, 4.|| | + | |DISPLAYTYPE|1, 2, 3, 4, 5|Display Type must be 1, 2, 3, 4, 5 \\ 1 = 4 Option \\ 2 = 5 Option \\ 3 = True/false (2 Option) \\ 4 = Constructed Response (0 Option) \\ 5 = 3 Option|| |
| |AUTHORID|Numeric \\ ‘’ (empty)|[[author_entry|Author ID]] must be numeric \\ Author x is not setup within the parent Bank|AuthorID must exist and within the selected parent Bank. \\ Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | |AUTHORID|Numeric \\ ‘’ (empty)|[[author_entry|Author ID]] must be numeric \\ Author x is not setup within the parent Bank|AuthorID must exist and within the selected parent Bank. \\ Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | ||
| |COMPETENCYID|Numeric \\ ‘’ (empty)|[[competency_entry|Competency ID]] must be numeric \\ Competency x is not setup within the parent Bank|CompetencyID must exist and within the selected parent Bank. \\ Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | |COMPETENCYID|Numeric \\ ‘’ (empty)|[[competency_entry|Competency ID]] must be numeric \\ Competency x is not setup within the parent Bank|CompetencyID must exist and within the selected parent Bank. \\ Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | ||
| Line 84: | Line 80: | ||
| |<color red>ITEMMUSTPASS</color>||‘False’ or 0 \\ ‘True’ or 1|ENABLED must be 0, 1, True or False| | | |<color red>ITEMMUSTPASS</color>||‘False’ or 0 \\ ‘True’ or 1|ENABLED must be 0, 1, True or False| | | ||
| |ITEMTIME|Numeric \\ ‘’ (empty)|ITEMTIME must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). \\ This field is only used for Online testing. It otherwise has no impact on Item Writing or Marking Center Exams.| | |ITEMTIME|Numeric \\ ‘’ (empty)|ITEMTIME must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). \\ This field is only used for Online testing. It otherwise has no impact on Item Writing or Marking Center Exams.| | ||
| - | |EFFECTIVEDATE|Date|Effective Date must be valid format.|Value must be in format YYYY-MM-DD (e.g. ‘2016-01-01’)| | + | |EFFECTIVEDATE|Date|Effective Date must be valid format. [[concepts#effective_and_expiry_dates|Effective and Expiry Dates]]|Value must be in format YYYY-MM-DD (e.g. ‘2016-01-01’)| |
| - | |EXPIRYDATE|Date|Expiry Date must be valid format.|Value must be in format YYYY-MM-DD (e.g. ‘2016-01-01’)| | + | |EXPIRYDATE|Date|Expiry Date must be valid format. [[concepts#effective_and_expiry_dates|Effective and Expiry Dates]]|Value must be in format YYYY-MM-DD (e.g. ‘2016-01-01’)| |
| |CUSTOM01|Alphanumeric|CUSTOM01 has maximum length of 50 characters.|Value must be <= 50 characters. \\ If nothing entered, will replace existing values with blanks.| | |CUSTOM01|Alphanumeric|CUSTOM01 has maximum length of 50 characters.|Value must be <= 50 characters. \\ If nothing entered, will replace existing values with blanks.| | ||
| |CUSTOM02|Alphanumeric|CUSTOM02 has maximum length of 50 characters.|Value must be <= 50 characters. \\ If nothing entered, will replace existing values with blanks.| | |CUSTOM02|Alphanumeric|CUSTOM02 has maximum length of 50 characters.|Value must be <= 50 characters. \\ If nothing entered, will replace existing values with blanks.| | ||
