The following columns must have values when updating the various sections of an Item:
Column/Section
Item
Revisions
Categories
Item Upload Action
○
Item Number
○
○
○
Organization
○
○
○
Category Upload Action
○
Category
○
Revision Upload Action
○
Revision Code
○
To elaborate on the table above:
• For ALL updates, the ‘Organization’ and ‘Item Number’ are required.
• When updating item attributes, the ‘Item Number’ and ‘Organization’ are required. The remaining Revisions, Categories, Attachments sections can be blank or removed in this scenario. If data exists in these other sections, it will be ignored when the section ‘Upload Action’ column is blank.
• When updating Revisions, it is necessary to populate the ‘Organization’ and ‘Item Number’ fields in the Item section, together with the information fields in the Revisions section. All the other attributes in the Item, Categories and Attachment sections can be blank or removed in this scenario. If data exists in these other sections, it will be ignored when the section ‘Upload Action’ column is blank.
• When updating Categories, it is necessary to populate the ‘Organization’ and ‘Item Number’ fields in the Item section, together with the information fields in the ‘Categories’ section. All the other attributes in the Item, ‘Revision’ and ‘Attachment’ sections can be blank or removed in this scenario. If data exists in these other sections, it will be ignored when the section ‘Upload Action’ column is blank.
