Flat Configurations - Intergraph Smart Materials - 10.2 - Help - Hexagon

Intergraph Smart Materials Web Help (10.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
Web
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2

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:

  1. 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.

  2. Define the columns so that Smart Materials knows the meaning of the columns in the Excel/csv file.

  3. Start the import.

    The Flat Configuration does not work for product groups and can only be used for projects.

How do I collect Import data?

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)

Flat Configuration