Upload columns are a method we use to control when we are performing a certain transaction in the Wizard. These columns have the following options unless specified otherwise below:
• Create
Sets the section the column resides in to create the data in that section. The Wizard will not assume other sections are also being created.
• Create All
When set at the top level of the data hierarchy this will default down the sections. Effectively making all sections set to Create. This will also work if set half-way down the data hierarchy but will not set the actions up the hierarchy.
• Update
Sets the section the column resides in to update the data in that section. The Wizard will not assume other sections are also being updated.
• Update All
When set at the top level of the data hierarchy this will default down the sections. Effectively making all sections set to Update. This will also work if set half-way down the data hierarchy but will not set the actions up the hierarchy.
• Delete
Only applicable to the ‘Categories’, ‘Cross Reference’ and ‘Transaction Defaults’ sections in Item Mode.
In Item Wizard the following sections contain an upload Mode/Action column:
• Items
o Item Upload Mode
o Catalog Upload Mode
o Category Upload Mode
o Revision Upload Mode
• Organization Assignment
o Assign Action
o Only Contains the Assign option
• Maintain Categories
o Upload Action
o Only contains the Create and Update options
• UDA Items
o Item UDA Upload Mode
o Contains Create, Update and Delete options
• Description Translations
o Languages Upload Mode
o Only contains the Update option
• Transaction Defaults
o Subinventory Upload Action
o Uploader Upload Action
o Contains Create, Update and Delete options
• Cross Reference
o Cross Ref Upload Action
o Contains Create, Update and Delete options
• Specifications
o Specifications Upload Action
o Spec Element Upload Action
o Contains Create, and Delete options for Specification
o Contains Create, Update and Delete options for Spec Element
• Item Relationships
o Maintain Relationships Upload Action
o Contains Create, and Delete options
These upload modes/actions are taken into account when performing either a validate or an upload.
This is a requirement of the item interface tables; the Wizard must tell the interface if the item is being created or updated.
Create Action
‘Create’ action will only specify the transaction type for the section it resides in. If there are more than one section required as a part of the Create transaction you may populate other upload mode/actions with Create as well.
Logic has been applied to these columns when populating with certain transaction types. For example, you cannot have an Item being created while you are updating a section lower in the hierarchy as this record in theory will not exist yet.
Create All Action
‘Create All’ action can be used at the highest section in the sheet. When the record is processed in a Validate or Upload, any lower sections will be defaulted to the same transaction type.
If there are already transactions specified in any lower sections, they will not be overwritten as the Wizard will have assumed the user populated it.
Update Action
‘Update’ action functions the same way as the Create however the logic is reversed. When Update is supplied at the header level of the data structure you may have either ‘Update’ or ‘Create’ at lower sections.
Update All Action
‘Update All’ action will function the same as the ‘Create All’ option where it will default down every section with an upload mode/action. The only difference is the logic in which the Wizard validates the columns.
For example, if ‘Update All’ is supplied in the header section and ‘Create’ is at the lower sections this will be accepted by the wizard validation. ‘Update’ and ‘Update All’ will only fail when the record being updated does not yet exist.
Delete Action
‘Delete’ action will remove the value from the database permanently.
You must run the Create and Update processes separately
Due to constraints within the Oracle Interface, you cannot update Item and create Item at the same time.
To update items, you must be in ‘Update’ action when you submit the Item Import Concurrent Program(s). Likewise, when creating new items, you must be in ‘Create’ action when you submit the Item Import Concurrent Program(s).
Refer to section:
