Within the "Item Attribute Overview" screen there are options for Export Attributes and Import Attributes.
Export Item Attributes
The Export process will create an output file in Excel format which you can then use to edit your Item Attribute Values for Items within your system.
Simply select Export Attributes from the menu bar and the system will automatically create the file for you based on the the data that is currently visible on the "Item Attribute Overview" screen. If you wish to reduce the number of Items that are included within the Export file then you can apply filters before using the Export option and the system will then only Export the data according to the filters that have been set.
The file will be saved to your Downloads folder with a naming convention structured as the text "ItemAttributes" followed by an underscore and the Date and Time, e.g. ItemAttributes_010623 0900.xlsx
An example of the output is shown below.
Import Item Attributes
The Import process will read data from an Excel formatted file, expected to be structured in the same way as the file created through the Export process.
This means that the file MUST contain a header row consisting of the Item No. and Description in Columns A and B of the file, followed by any Item Attribute Name that you are importing values for, from Column C onwards
It is recommended to use the 'Export Attributes' option before importing Attributes - as this will provide you with the required Template in Excel format which you can then modify as required
Note: You only need to include Items and Attribute Names within your Import file for which you want to update Item Attribute Values.
The following rows after the header will include the values for the Item and Description followed by the Attribute Values you wish to create/update against the Items.
Simply press the 'Import Attributes' menu option to start the import process, at which point the system will request the file that you wish to import and (if necessary) the Sheet Name within the file and the details will be confirmed prior to importing as shown below.
If the details are correct then press the OK button to proceed with the import process.
The system will attempt to update or create Item Attribute Values (it does not delete anything) against the specified Items by reading each line in the file and taking the relevant action and a confirmation message will be shown afterwards identifying the number of records that have been successfully imported.
If there are any errors during the import, the system will process the records that it can, but will additionally identify the errors that it has found during the import process. A message will first be shown identifying that the import processed with Errors and will identifying the number of total records processed and those that were successfully, as shown below.
In addition to the above summary, the Error Messages screen will also be shown, detailing the specific errors that have been found within the file for each invalid record. In the scenario below the system has identified that the Item does not exist on line 22 of the file.