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.
Perform Specification driven Import
You can use Specification driven import to import only selected specifications from Smart 3D to Smart Reference Data.
You must load PipingMatericalClassData sheet to the staging area for using the Specification driven import option.
-
Click Integration > XI20 Smart 3D > XI2040 S3D Import.
-
Create a new import configuration or select an existing one by clicking .
-
Create a staging area or select an existing staging area.
-
Select Specification driven option from the Import Type options.
Staging data shows the PipingMaterialClassData sheet details in the grid.
-
Click Edit grid .
-
Select the specifications you want to import, by selecting the Select for Import check-box corresponding to each specification.
-
Click Save grid.
-
Click Read-Only Grid .
You will be able to view the details of only the specifications that you have selected here, in the subsequent screens. For example: In the Codelists Mappings screen, you will now be able to see only codelists related to the specifications you have selected in the Specification driven import.