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:10] steveclarke |
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 | + | 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. |
| - | + | ||
| - | FIXME wiki colour insensitive. All colour cells must be changed to x or xx type references | + | |
| - | + | ||
| - | 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 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. | + | |
| ==== Field Names ==== | ==== Field Names ==== | ||
| Line 23: | Line 17: | ||
| This applies to Status, Substatus, Enabled, ItemMustPass and Answer fields. | This applies to Status, Substatus, Enabled, ItemMustPass and Answer fields. | ||
| - | When validating IDs, like the fields GroupID, AuthorID, CompetencyID, CopyrightID, AttachmentID or ReferenceID, the ID must be a whole number, the ID must be setup in CE and must be in the selected Bank FIXME (Bank) being imported to. So, if Author "25" exists in the "Help-Import" Bank and you are importing to "LiveData-Production" bank, then the Author "25" does not exist in "LiveData-Production" bank and an error logged. | + | When validating IDs, like the fields [[item_group_entry|GroupID]], [[author_entry|AuthorID]], [[competency_entry|CompetencyID]], [[copyright_entry|CopyrightID]], [[attachment_entry|AttachmentID]] or [[reference_entry|ReferenceID]], the ID must be a whole number, the ID must be setup in CE and must be in the selected [[concepts#Banks and Bank Level|Bank]] being imported to. So, if Author "25" exists in the "Help-Import" Bank and you are importing to "LiveData-Production" bank, then the Author "25" does not exist in "LiveData-Production" bank and an error logged. |
| ==== 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 pink highlighted 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. |
| === Dichotomous MCQ === | === Dichotomous MCQ === | ||
| For Dichotomous MCQ Items, it is not required to bring across OptionCorrect//__n__//, OptionValue//__n__// fields. You can alternately bring across the OptionText//__n__// for each Option and also bring across the Answer field. The Answer fieldwill set the Option Correct for one option only and set its value to 1. | For Dichotomous MCQ Items, it is not required to bring across OptionCorrect//__n__//, OptionValue//__n__// fields. You can alternately bring across the OptionText//__n__// for each Option and also bring across the Answer field. The Answer fieldwill set the Option Correct for one option only and set its value to 1. | ||
| - | For Dichotomous MCQ you can omit the yellow highlighted rows. | + | For Dichotomous MCQ you can omit the green field rows. |
| === Non-Dichotomous MCQ === | === Non-Dichotomous MCQ === | ||
| For Non-dichotomous MCQ type Items, each Option//__n__// should have its corresponding OptionCorrect//__n__// and OptionValue//__n__// rows set if you require more than one correct option and different point values for the Options. | For Non-dichotomous MCQ type Items, each Option//__n__// should have its corresponding OptionCorrect//__n__// and OptionValue//__n__// rows set if you require more than one correct option and different point values for the Options. | ||
| - | For non-dichotomous MCQ you will want to include the yellow highlighted fields. | + | For non-dichotomous MCQ you will want to include the green field rows. |
| === Essay/Constructed Response/Rater Items === | === Essay/Constructed Response/Rater Items === | ||
| - | For non-mcq type Items you will want to include some or all of the pink rows to set max values, default values and alternate scoring options for the human rated Essay/Constructed Response type Items. | + | For non-mcq type Items you will want to include some or all of the red rows to set max values, default values and alternate scoring options for the human rated Essay/Constructed Response type Items. |
| ==== Update Item vs Add Item ==== | ==== Update Item vs Add Item ==== | ||
| Line 53: | Line 47: | ||
| ==== Field List ==== | ==== Field List ==== | ||
| ^ Field ^ Description ^ Valid Values ^ Errors ^ Rules ^ | ^ Field ^ Description ^ Valid Values ^ Errors ^ Rules ^ | ||
| - | | ITEMID | Numeric | Item ID must be numeric. \\ Item x is not setup within the Bank | ItemID must exist and within the selected Bank. \\ When this column is included, an update will performed on the indicated Item. \\ When this column is NOT included, a new Item will be added to the system. | | + | |ITEMID | Numeric | Item ID must be numeric. \\ Item x is not setup within the Bank | ItemID must exist and within the selected Bank. \\ When this column is included, an update will performed on the indicated Item. \\ When this column is NOT included, a new Item will be added to the system. | |
| - | | EXTERNALID |Alphanumeric|External ID has a maximum length of 30 characters.|Value must be <= 30 characters. \\ If nothing entered, will replace existing values with blanks.| | + | |EXTERNALID |Alphanumeric|External ID has a maximum length of 30 characters.|Value must be <= 30 characters. \\ If nothing entered, will replace existing values with blanks.| |
| |DISPLAYID|Alphanumeric|Display ID has a maximum length of 20 characters.|Value must be <= 20 characters. \\ If nothing entered, will replace existing values with blanks.| | |DISPLAYID|Alphanumeric|Display ID has a maximum length of 20 characters.|Value must be <= 20 characters. \\ If nothing entered, will replace existing values with blanks.| | ||
| |STATUS|‘Active’ or 1 \\ ‘In Development’ or ‘Draft’ or 2 \\ ‘Field Testing’ or 3 \\ ‘Inactive’ or 4|Status ‘x’ is invalid.|When set, SUBSTATUS is also required to be set.| | |STATUS|‘Active’ or 1 \\ ‘In Development’ or ‘Draft’ or 2 \\ ‘Field Testing’ or 3 \\ ‘Inactive’ or 4|Status ‘x’ is invalid.|When set, SUBSTATUS is also required to be set.| | ||
| |SUBSTATUS | Valid Values (depends on Status and Bank type): \\ **L&C** \\ Status ‘Active’ \\ ‘Active’ or 1 \\ Status ‘In Development’ \\ ‘New’ or 2 \\ ‘CPS and SME Reviewed’ or 3 \\ ‘Held for Review’ or 4 \\ Status ‘Field Testing’ \\ ‘Field Testing’ or 5 \\ Status ‘Inactive’ \\ ‘Inactive’ or 6 \\ **TR** \\ Status ‘Active’ \\ ‘Level 1’ or 1 \\ ‘Level 2’ or 2 \\ ‘Level 3’ or 3 \\ ‘Level 4’ or 4 \\ ‘Clone’ or 5 \\ Status ‘In Development’ \\ ‘New’ or 0 \\ ‘Level 1’ or 1 \\ ‘Level 2’ or 2 \\ ‘Level 3’ or 3 \\ ‘Level 4’ or 4‘ \\ ‘Clone’ or 5 \\ ‘Held for Review’ or 6 \\ Status ‘Field Testing’ \\ ‘Field Testing’ or 7 \\ Status ‘Inactive’ \\ ‘New’ or 0 \\ ‘Level 1’ or 1 \\ ‘Level 2’ or 2 \\ ‘Level 3’ or 3 \\ ‘Level 4’ or 4‘ \\ ‘Clone’ or 5 \\ ‘Held for Review’ or 6|Substatus ‘x’ is invalid.|When set, STATUS is also required to be set.| | |SUBSTATUS | Valid Values (depends on Status and Bank type): \\ **L&C** \\ Status ‘Active’ \\ ‘Active’ or 1 \\ Status ‘In Development’ \\ ‘New’ or 2 \\ ‘CPS and SME Reviewed’ or 3 \\ ‘Held for Review’ or 4 \\ Status ‘Field Testing’ \\ ‘Field Testing’ or 5 \\ Status ‘Inactive’ \\ ‘Inactive’ or 6 \\ **TR** \\ Status ‘Active’ \\ ‘Level 1’ or 1 \\ ‘Level 2’ or 2 \\ ‘Level 3’ or 3 \\ ‘Level 4’ or 4 \\ ‘Clone’ or 5 \\ Status ‘In Development’ \\ ‘New’ or 0 \\ ‘Level 1’ or 1 \\ ‘Level 2’ or 2 \\ ‘Level 3’ or 3 \\ ‘Level 4’ or 4‘ \\ ‘Clone’ or 5 \\ ‘Held for Review’ or 6 \\ Status ‘Field Testing’ \\ ‘Field Testing’ or 7 \\ Status ‘Inactive’ \\ ‘New’ or 0 \\ ‘Level 1’ or 1 \\ ‘Level 2’ or 2 \\ ‘Level 3’ or 3 \\ ‘Level 4’ or 4‘ \\ ‘Clone’ or 5 \\ ‘Held for Review’ or 6|Substatus ‘x’ is invalid.|When set, STATUS is also required to be set.| | ||
| |ENABLED|‘False’ or 0 \\ ‘True’ or 1|ENABLED must be 0, 1, True or False| | | |ENABLED|‘False’ or 0 \\ ‘True’ or 1|ENABLED must be 0, 1, True or False| | | ||
| - | |GROUPID|Numeric \\ ‘’ (empty)|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 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 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).| |
| - | |COPYRIGHTID|Numeric \\ ‘’ (empty)|Copyright ID must be numeric \\ Copyright x is not setup within the parent Bank|CopyrightID 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).| | + | |COPYRIGHTID|Numeric \\ ‘’ (empty)|[[copyright_entry|Copyright ID]] must be numeric \\ Copyright x is not setup within the parent Bank|CopyrightID 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).| |
| - | |{color pink>VALUEIFSKIPPED1</color>|Numeric \\ ‘’ (empty)|VALUEIFSKIPPED1 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color red>VALUEIFSKIPPED1</color>|Numeric \\ ‘’ (empty)|VALUEIFSKIPPED1 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |VALUEIFSKIPPED2|Numeric \\ ‘’ (empty)|VALUEIFSKIPPED2 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color red>VALUEIFSKIPPED2</color>|Numeric \\ ‘’ (empty)|VALUEIFSKIPPED2 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |VALUEIFSKIPPED3|Numeric \\ ‘’ (empty)|VALUEIFSKIPPED3 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color red>VALUEIFSKIPPED3</color>|Numeric \\ ‘’ (empty)|VALUEIFSKIPPED3 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |VALUEIFSKIPPED4|Numeric \\ ‘’ (empty)|VALUEIFSKIPPED4 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color red>VALUEIFSKIPPED4</color>|Numeric \\ ‘’ (empty)|VALUEIFSKIPPED4 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |VALUEIFSKIPPED5|Numeric \\ ‘’ (empty)|VALUEIFSKIPPED5 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color red>VALUEIFSKIPPED5</color>|Numeric \\ ‘’ (empty)|VALUEIFSKIPPED5 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |VALUEOTHER1|Numeric \\ ‘’ (empty)|VALUEOTHER1 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color red>VALUEOTHER1</color>|Numeric \\ ‘’ (empty)|VALUEOTHER1 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |VALUEOTHER2|Numeric \\ ‘’ (empty)|VALUEOTHER1 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color red>VALUEOTHER2</color>|Numeric \\ ‘’ (empty)|VALUEOTHER1 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |VALUEOTHER3|Numeric \\ ‘’ (empty)|VALUEOTHER1 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color red>VALUEOTHER3</color>|Numeric \\ ‘’ (empty)|VALUEOTHER1 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |VALUEOTHER4|Numeric \\ ‘’ (empty)|VALUEOTHER1 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color red>VALUEOTHER4</color>|Numeric \\ ‘’ (empty)|VALUEOTHER1 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |VALUEOTHER5|Numeric \\ ‘’ (empty)|VALUEOTHER1 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color red>VALUEOTHER5</color>|Numeric \\ ‘’ (empty)|VALUEOTHER1 ID must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |WEIGHTING|Numeric \\ ‘’ (empty)|WEIGHTING must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color red>WEIGHTING</color>|Numeric \\ ‘’ (empty)|WEIGHTING must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| |ANGOFF1 |Numeric \\ ‘’ (empty)|ANGOFF1 must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | |ANGOFF1 |Numeric \\ ‘’ (empty)|ANGOFF1 must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | ||
| |ANGOFF2 |Numeric \\ ‘’ (empty)|ANGOFF2 must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | |ANGOFF2 |Numeric \\ ‘’ (empty)|ANGOFF2 must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | ||
| |ANGOFF3 |Numeric \\ ‘’ (empty)|ANGOFF3 must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | |ANGOFF3 |Numeric \\ ‘’ (empty)|ANGOFF3 must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | ||
| - | |ITEMVALUEMAX|Numeric \\ ‘’ (empty)|ITEMVALUEMAX must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color red>ITEMVALUEMAX</color>|Numeric \\ ‘’ (empty)|ITEMVALUEMAX must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |ITEMVALUEDEFAULT|Numeric \\ ‘’ (empty)|ITEMVALUEDEFAULT must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color red>ITEMVALUEDEFAULT</color>|Numeric \\ ‘’ (empty)|ITEMVALUEDEFAULT must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |ITEMPASS|Numeric \\ ‘’ (empty)|ITEMPASS must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color red>ITEMPASS</color>|Numeric \\ ‘’ (empty)|ITEMPASS must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |ITEMPASSTYPE|0, 1, 2|Item Pass Type must be 0, 1, 2.|| | + | |<color red>ITEMPASSTYPE</color>|0, 1, 2|Item Pass Type must be 0, 1, 2.|| |
| - | |ITEMROUNDTYPE|0, 1, 2|Item Round Type must be 0, 1, 2.|| | + | |<color red>ITEMROUNDTYPE</color>|0, 1, 2|Item Round Type must be 0, 1, 2.|| |
| - | |ITEMMUSTPASS||‘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.| | ||
| Line 129: | Line 123: | ||
| |OPTIONTEXT5|Alphanumeric \\ ‘’ (empty)||If nothing entered, will replace existing values with blanks.| | |OPTIONTEXT5|Alphanumeric \\ ‘’ (empty)||If nothing entered, will replace existing values with blanks.| | ||
| |ANSWER|‘A’ or 1 \\ ‘B’ or 2 \\ ‘C’ or 3 \\ ‘D’ or 4 \\ ‘E’ or 5 \\ ‘’ (empty)|Answer is Invalid. Must be A-E or 1-5.|Sets the Item OptionCorrect value to ‘True’ and it’s OptionValue value to 1. \\ Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | |ANSWER|‘A’ or 1 \\ ‘B’ or 2 \\ ‘C’ or 3 \\ ‘D’ or 4 \\ ‘E’ or 5 \\ ‘’ (empty)|Answer is Invalid. Must be A-E or 1-5.|Sets the Item OptionCorrect value to ‘True’ and it’s OptionValue value to 1. \\ Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | ||
| - | |OPTIONCORRECT1|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|CORRECT must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONCORRECT1</color>|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|CORRECT must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONCORRECT2|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|CORRECT must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONCORRECT2</color>|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|CORRECT must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONCORRECT3|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|CORRECT must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONCORRECT3</color>|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|CORRECT must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONCORRECT4|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|CORRECT must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONCORRECT4</color>|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|CORRECT must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONCORRECT5|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|CORRECT must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONCORRECT5</color>|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|CORRECT must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONVALUE1|Numeric \\ ‘’ (empty)|OPTIONVALUE1 must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONVALUE1</color>|Numeric \\ ‘’ (empty)|OPTIONVALUE1 must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONVALUE2|Numeric \\ ‘’ (empty)|OPTIONVALUE2 must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONVALUE2</color>|Numeric \\ ‘’ (empty)|OPTIONVALUE2 must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONVALUE3|Numeric \\ ‘’ (empty)|OPTIONVALUE3 must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONVALUE3</color>|Numeric \\ ‘’ (empty)|OPTIONVALUE3 must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONVALUE4|Numeric \\ ‘’ (empty)|OPTIONVALUE4 must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONVALUE4</color>|Numeric \\ ‘’ (empty)|OPTIONVALUE4 must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONVALUE5|Numeric \\ ‘’ (empty)|OPTIONVALUE5 must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONVALUE5</color>|Numeric \\ ‘’ (empty)|OPTIONVALUE5 must be numeric.|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONENABLED1|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|ENABLED must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONENABLED1</color>|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|ENABLED must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONENABLED2|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|ENABLED must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONENABLED2</color>|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|ENABLED must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONENABLED3|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|ENABLED must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONENABLED3</color>|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|ENABLED must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONENABLED4|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|ENABLED must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONENABLED4</color>|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|ENABLED must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONENABLED5|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|ENABLED must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONENABLED5</color>|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|ENABLED must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONDONOTSCRAMBLE1|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|DONOTSCRAMBLE must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONDONOTSCRAMBLE1</color>|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|DONOTSCRAMBLE must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONDONOTSCRAMBLE2|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|DONOTSCRAMBLE must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONDONOTSCRAMBLE2</color>|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|DONOTSCRAMBLE must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONDONOTSCRAMBLE3|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|DONOTSCRAMBLE must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONDONOTSCRAMBLE3</color>|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|DONOTSCRAMBLE must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONDONOTSCRAMBLE4|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|DONOTSCRAMBLE must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONDONOTSCRAMBLE4</color>|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|DONOTSCRAMBLE must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| - | |OPTIONDONOTSCRAMBLE5|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|DONOTSCRAMBLE must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| | + | |<color green>OPTIONDONOTSCRAMBLE5</color>|‘False’ or 0 \\ ‘True’ or 1 \\ ‘’ (empty)|DONOTSCRAMBLE must be 0, 1, True or False|Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value).| |
| |RATIONALE|Alphanumeric \\ ‘’ (empty)||If nothing entered, will replace existing values with blanks.| | |RATIONALE|Alphanumeric \\ ‘’ (empty)||If nothing entered, will replace existing values with blanks.| | ||
| - | |ATTACHMENTID|Numeric \\ ‘’ (empty)|Attachment ID must be numeric \\ Attachment x is not setup within the parent Bank|AttachmentID 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).| | + | |ATTACHMENTID|Numeric \\ ‘’ (empty)|[[attachment_entry|Attachment ID]] must be numeric \\ Attachment x is not setup within the parent Bank|AttachmentID 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).| |
| - | |REF1ID|Numeric \\ ‘’ (empty)|REF1ID must be numeric \\ REF1ID x is not setup within the parent Bank|REF3ID 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).| | + | |REF1ID|Numeric \\ ‘’ (empty)|[[reference_entry|REF1ID]] must be numeric \\ REF1ID x is not setup within the parent Bank|REF3ID 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).| |
| |REF1SECTION|Alphanumeric|REF1SECTION has maximum length of 25 characters.|Value must be <= 25 characters. \\ If nothing entered, will replace existing values with blanks.| | |REF1SECTION|Alphanumeric|REF1SECTION has maximum length of 25 characters.|Value must be <= 25 characters. \\ If nothing entered, will replace existing values with blanks.| | ||
| |REF1PAGE|Alphanumeric|REF1PAGE has maximum length of 20 characters.|Value must be <= 20 characters. \\ If nothing entered, will replace existing values with blanks.| | |REF1PAGE|Alphanumeric|REF1PAGE has maximum length of 20 characters.|Value must be <= 20 characters. \\ If nothing entered, will replace existing values with blanks.| | ||
| |REF1DIAGRAM|Alphanumeric|REF1DIAGRAM has maximum length of 20 characters.|Value must be <= 20 characters. \\ If nothing entered, will replace existing values with blanks.| | |REF1DIAGRAM|Alphanumeric|REF1DIAGRAM has maximum length of 20 characters.|Value must be <= 20 characters. \\ If nothing entered, will replace existing values with blanks.| | ||
| - | |REF2ID|Numeric \\ ‘’ (empty)|REF2ID must be numeric \\ REF2ID x is not setup within the parent Bank|REF3ID 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).| | + | |REF2ID|Numeric \\ ‘’ (empty)|[[reference_entry|REF2ID]] must be numeric \\ REF2ID x is not setup within the parent Bank|REF3ID 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).| |
| |REF2SECTION|Alphanumeric|REF2SECTION has maximum length of 25 characters.|Value must be <= 25 characters. \\ If nothing entered, will replace existing values with blanks.| | |REF2SECTION|Alphanumeric|REF2SECTION has maximum length of 25 characters.|Value must be <= 25 characters. \\ If nothing entered, will replace existing values with blanks.| | ||
| |REF2PAGE|Alphanumeric|REF2PAGE has maximum length of 20 characters.|Value must be <= 20 characters. \\ If nothing entered, will replace existing values with blanks.| | |REF2PAGE|Alphanumeric|REF2PAGE has maximum length of 20 characters.|Value must be <= 20 characters. \\ If nothing entered, will replace existing values with blanks.| | ||
| |REF2DIAGRAM|Alphanumeric|REF2DIAGRAM has maximum length of 20 characters.|Value must be <= 20 characters. \\ If nothing entered, will replace existing values with blanks.| | |REF2DIAGRAM|Alphanumeric|REF2DIAGRAM has maximum length of 20 characters.|Value must be <= 20 characters. \\ If nothing entered, will replace existing values with blanks.| | ||
| - | |REF3ID|Numeric \\ ‘’ (empty)|REF3ID must be numeric \\ REF3ID x is not setup within the parent Bank|REF3ID 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).| | + | |REF3ID|Numeric \\ ‘’ (empty)|[[reference_entry|REF3ID]] must be numeric \\ REF3ID x is not setup within the parent Bank|REF3ID 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).| |
| |REF3SECTION|Alphanumeric|REF3SECTION has maximum length of 25 characters.|Value must be <= 25 characters. \\ If nothing entered, will replace existing values with blanks.| | |REF3SECTION|Alphanumeric|REF3SECTION has maximum length of 25 characters.|Value must be <= 25 characters. \\ If nothing entered, will replace existing values with blanks.| | ||
| |REF3PAGE|Alphanumeric|REF3PAGE has maximum length of 20 characters.|Value must be <= 20 characters. \\ If nothing entered, will replace existing values with blanks.| | |REF3PAGE|Alphanumeric|REF3PAGE has maximum length of 20 characters.|Value must be <= 20 characters. \\ If nothing entered, will replace existing values with blanks.| | ||
