Create Smart 3D import configuration
-
Click Integration > XI20 Smart 3D > XI2040 S3D Import
-
To add a new import configuration, click Add Import Configuration .
You can select an existing configuration by clicking .
-
Set the Smart 3D Import Configurations properties to import Smart 3D data to the defined configuration.
The catalog structure is created based on the Catalog Structure property you have set. For more information on catalog structures, see Catalog Structures.
-
Click Save , and then close the dialog box.
-
By default, the Import Option is set to AddOrModify. This option appends new data or modifies the existing data in the staging area. To delete and replace the selected sheet data in the staging area, select DeleteAndReplace.
-
By default, for the DefaultProjectOptions sheet, the Import option is always DeleteandReplace.
Create a staging area
-
On the Staging Area section, click .
-
Type the staging area name and description in the Staging Area and Description boxes.
-
Click Save , and then close the dialog box.
Load Smart 3D data from Microsoft Excel workbooks
-
You can only import Smart 3D bulk load supported format Microsoft Excel workbooks. Please refer Smart 3D bulk Microsoft Excel workbook sample files that are delivered with the Smart 3D software. The files are located in the following location [installation location]\Program Files (x86)\Smart3D\CatalogData\BulkLoad\DataFiles.
-
Some of the sheets names that are delivered with the software may not have unique keys defined. For these sheets, all the attributes in that sheet are considered to define the uniqueness of the data. For example, if the Import option for such a sheet is set as AddOrModify, and an attribute value is modified in the sheet, the software loads the modified attribute value as a new entry.
-
If you modify the structure of an existing sheet and load it into the software, the software overwrites the existing sheet with the modified sheet.
-
On the Staging Area section, click .
-
Import Smart 3D bulkload Microsoft Excel workbooks that you need:
-
To import Microsoft Excel workbooks, select the Read from Bulkload Excel option, click , and then select one or more workbooks.
-
To import commodity code rules, and then map to commodity characters, click to select an Industry Commodity Code Rule workbook.
To map the commodity characters, you must first load the codelist sheet in the staging area, and then map the codelist sheet using the industry commodity code rule workbook.
-
You can multi-select Microsoft Excel workbooks.
-
You can also drag the Microsoft Excel workbooks from your computer to the File Name area.
-
-
Click Next. The imported Microsoft Excel workbook appear along with its corresponding sheet in a tree view.
-
-
Map the commodity code rules and corresponding code list values:
-
Select one or more sheets, the required codelist values, and then click Next. The selected sheet names and the codelist values are displayed under Data Table and Codelist Table columns, respectively.
-
Select a codelist value from Codelist Table list. This creates a mapping between commodity code rules and corresponding code list values.
-
-
To start loading the selected sheets, click Read. The status of each sheet is displayed in the Status column.
-
To exit the loading process, click Finish.
To view the loaded Smart 3D data, select the sheet name from the Select Data Table list.