Import ETIM Data
https://docs.google.com/document/d/1yU7lqIppB_uvekxoyYQjFCOtjFnlzYnHKK53vcFQpEE/edit?tab=t.0
Steps to Import ETIM (with demo data)
Section titled “Steps to Import ETIM (with demo data)”-
Open menu item Other/Settings/Query Tool. Click Browse file and upload “insert_uomid_desc.sql”. Click Execute to run query to insert “ETIM UoM” into the system
-
All import mappings and channels are already available in Demo Data
-
DE-de language set as default for the Import
-
Run imports for Classification Groups
-
Run imports for Attributes
-
Run imports for Values
Steps to Import ETIM (manually)
Section titled “Steps to Import ETIM (manually)”-
Open Query tool and run “insert_uomid_desc.sql” query to Insert ETIM UoM descriptions into the system.
-
Open menu item “Settings/Classificatons”. Click Create to create a Classification with Id “ETIM9”
-
Open menu item “Settings/Value Mapping” for Value Type with ids and import the Mapping files (uom(mappingETIM), attributetype(mappingETIM)) “Value_UoM_Id_ETIM_Internal” “Value_Attribute_Type_ETIM_Internal”
-
Create 3 Import channels for Groups, Attributes and Value lists with Predefined formats (there are also 3)
-
Run each Import channel with “ETIM-9_0-csv_de.zip”