To import BOM data to Smart Materials with the Flat Configuration data source option on the BOM Import page, you must define a flat configuration on the Flat Configurations page.
When should I use the flat configuration import?
If you wish to import your BOM data into Smart Materials, you can do so using the Flat Configuration page. It is a facility within the BOM import through which you can define the column mappings of the available Excel/ASCII file, which would then be used to start the BOM import. You can also write your own BOM Import Logic which can then be used in place of the internal import.
Using the following steps, you can import a BOM data into Smart Materials:
-
Collect your data in an Excel sheet. Use this Excel sheet for the import, or generate a csv file that contains the columns of the data separated with a freely definable separator.
-
Define the columns so that Smart Materials knows the meaning of the columns in the Excel/csv file.
-
Start the import.
The Flat Configuration does not work for product groups and can only be used for projects.
To collect your data, you can use any tool that you want, provided that it can be converted into an Excel or csv file for the import. You can freely select the order of the data assigned into the columns but this is later mapped in Smart Materials before you start the import to ensure that they are stored in the correct manner. You can fill all columns of all rows completely or you can leave columns free, but you should account for it later when you map the columns in Smart Materials.
After you have gathered all the data, save the Excel sheet in the *.csv format. If you have already loaded the data into a CSV file, then just click save as Excel stores the data with semicolon separated columns.
You can use any character as a column separator, but if a character defined as a column separator occurs within a string, an error arises while importing the CSV file.
What are the available items in the Flat Configration Items page?
In the Flat Configuration Items page, while defining the column mapping, all columns of the file to be imported must be entered in the correct order of the occurrence in the file, without any gaps. You can choose the appropriate item from the select list but if a column is not used in the Excel sheet, just choose IGNORE from the list of values in the Item field, so this column is not read during the import. The available items with their meanings are as follows:
Items |
Meaning |
---|---|
GUID |
Unique identifier for the record |
IGNORE |
Dummy column |
NODE_ATTR |
Horizontal Location and Interpretation of Node Property |
NODE_LEV0N |
Horizontal Location of 0th Node Name in Hierarchy on Position Level |
NODE_LEV1N |
Horizontal Location of 1st Node Name in Hierarchy on Position Level |
NODE_LEV2N |
Horizontal Location of 2nd Node Name in Hierarchy on Position Level |
NODE_LEV3N |
Horizontal Location of 3rd Node Name in Hierarchy on Position Level |
NODE_LEV4N |
Horizontal Location of 4th Node Name in Hierarchy on Position Level |
NODE_LEV5N |
Horizontal Location of 5th Node Name in Hierarchy on Position Level |
NODE_LEV6N |
Horizontal Location of 6th Node Name in Hierarchy on Position Level |
NODE_LEV7N |
Horizontal Location of 7th Node Name in Hierarchy on Position Level |
NODE_LEV8N |
Horizontal Location of 8th Node Name in Hierarchy on Position Level |
NODE_LEV9N |
Horizontal Location of 9th Node Name in Hierarchy on Position Level |
POS_ATTR |
Horizontal Location and Interpretation of Position Property |
POS_CC |
Horizontal Location of Commodity Code on Position Level |
POS_CG |
Horizontal Location of Commodity Group on position level |
POS_CP |
Horizontal Location of Commodity Part on position level |
POS_IDENT |
Horizontal Location of Ident Code on Position Level |
POS_ISTAT |
Issue status per node |
POS_ITR |
Horizontal Location of item rule on position level |
POS_LSTAT |
Horizontal Location of item rule on position level |
POS_MAIN |
Horizontal Location of main assembly position |
POS_NUM |
Horizontal Location of the position number |
POS_OPTION |
Horizontal Location of Option Code on Position Level |
POS_QTY |
Horizontal Location of Quantity on Position Level |
POS_RTYPE |
Horizontal Location of Record Type on Position Level |
POS_SHORT |
Horizontal Location of Short Code on Position Level |
POS_SIZ2WU |
Horizontal Location of Size2 with Unit on Position Level |
POS_SIZE1 |
Horizontal Location of Size1 on Position Level |
POS_SIZE2 |
Horizontal Location of Size2 on Position Level |
POS_SIZE3 |
Horizontal Location of Size3 on Position Level |
POS_SIZE4 |
Horizontal Location of Size4 on Position Level |
POS_SPEC |
Horizontal Location of Spec Code on Position Level |
POS_SUB01 |
Horizontal Location of Sub Position Number at assembly level 1 |
POS_SUB02 |
Horizontal Location of Sub Position Number at assembly level 2 |
POS_SUB03 |
Horizontal Location of Sub Position Number at assembly level 3 |
POS_SUB04 |
Horizontal Location of Sub Position Number at assembly level 4 |
POS_SUB05 |
Horizontal Location of Sub Position Number at assembly level 5 |
POS_SUB06 |
Horizontal Location of Sub Position Number at assembly level 6 |
POS_SUB07 |
Horizontal Location of Sub Position Number at assembly level 7 |
POS_SUB08 |
Horizontal Location of Sub Position Number at assembly level 8 |
POS_SUB09 |
Horizontal Location of Sub Position Number at assembly level 9 |
POS_SUB10 |
Horizontal Location of Sub Position Number at assembly level 10 |
POS_SUM_ID |
Summarize equal idents on position level |
POS_TAB |
Horizontal Location of a table detail to identify commodity code |
POS_TAG_LO |
Horizontal Location of tag number long layout (standard/login language) on position level |
POS_TAG_L2 |
Horizontal Location of tag number long layout (second language) on position level |
POS_TAG_L3 |
Horizontal Location of tag number long layout (third language) on position level |
POS_TAG_NU |
Horizontal Location of tag number on position level |
POS_TAG_SH |
Horizontal Location of tag number short layout (standard/login language) on position level |
POS_TAG_S2 |
Horizontal Location of tag number short layout (second language) on position level |
POS_TAG_S3 |
Horizontal Location of tag number short layout (third language) on position level |
POS_UNIT |
Position Quantity Unit (NO LENGTH but pcs, EA, and so on) |