The import process is divided into three major steps:
-
Configure the CSV load.
-
Load the CSV file data into an intermediate table in the Smart Materials database.
-
Transfer data from here into the Smart Materials BOM area.
Within the BOM import, there is a new facility to import data into Smart Materials, called Flat Loading Config. All elements are put together in one record separated by a free definable delimiter, for example, ‘;’. So this is an easier way to import. Just collect your data in an Excel sheet and export it to an ASCII file. Then all you have to do is define the column mappings of the ASCII file in Smart Materials and start the Flat Loading Config import. In addition to this import, you can write your own BOM import that is used instead of the internal import if you want to add some proprietary functions and behavior.