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