BOM Import Dashboard - 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

The BOM Import Jobs page allows you to import the Bill of Materials data into Smart Materials. On this page, you can setup the definition of OMI import jobs. You can also start the execution, and review the results and the protocols of your jobs on this page.

BOM Import Dashboard

To understand this page, you need to know the following:

Cell/Column

Description

Notes

Job code

Refers to the unique name of the import job within the actual project. When you click on any job code, the Job Information page will open.

Data Source

Specifies the source where from OMI should take its data. The default is to load it from flat ASCII files.

User Comment

Shows the comment related to the import job added by user.

User

Shows the name of the user

Job Start Date

Refers to the date of completion of the import job.

Job End Date

Indicates the status of the requisition jobs.

Job Status

Indicates the status of the job. The Job Status is shown as

  • New - Job is yet to be started.

  • Error - Job has been terminated. Check the log file for additional details.

  • Scheduled - Job starts at the scheduled time .

  • Stage - Job has been paused for review using Pit stop.

  • Ready - Job has been executed.

In Stage, when you pit stop the job, it imports data to a temporary table before loading it onto the database. You can review the data as well as make changes if needed using the Review Data button. This is only available for flat configuration imports.

Take a look at this video to understand how to import BOM data using Flat Configuration:

See Also

What are the relevant project/discipline defaults settings that I should know about?

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.