Export data to CADWorx - Intergraph Smart Reference Data - Version 10.2 - Training - Hexagon

In this section, you will learn how to export the spec from SRD.

Create TRAINING_SHT_CONFIG

1. Navigate to Integration > CADWorx > CADWorx Configuration.

2. Click the Data Table Configurations tab.

3. In the tree view, right-click SDB_CDWRx_SHT_CONFIG and click Duplicate. A duplicate for SDB_CDWRx_SHT_CONFIG will be created.

   

4. Right-click the duplicate copy of SDB_CDWRx_SHT_CONFIG and rename it to TRAINING_SHT_CONFIG.

Creae TRAINING_TEMPLATE

1. Navigate to Integration > CADWorx > CADWorx Configuration.

2. Click the Templates tab.

   

3. In the tree view, right click SDB_CDWRx_TEMPLATE and select Duplicate. A duplicate for SDB_CDWRx_TEMPLATE will be created.

   

4. Right click the duplicate copy of SDB_CDWRx_TEMPLATE and rename it to TRAINING_TEMPLATE.

5. Right click TRAINING_TEMPLATE and click Edit.

6. In the Data Table Configuration select TRAINING_SHT_CONFIG and click Save .

   

Create TRAINING_ITEM_MAPPING

1. Navigate to Integration > CADWorx > CADWorx Configuration.

2. Click the Attributes Mapping tab.

   

3. In the tree view, right-click SDB_CADWorx_ITEM_MAP and select Duplicate option. SDB_CADWorx_ITEM_MAP gets duplicated to SDB_CADWorx_ITEM_MAP_XXXX.

4. Rename SDB_CADWorx_ITEM_MAP_XXXX to TRAINING_ITEM_MAPPIN.

5. Right click TRAINING_ITEM_MAPPIN and click Edit.

6. In the template, select TRAINING_TEMPLATE and click Save .

   

Create TRAINING_CDWRX transfer type

1. Go to Integration > CADWorx > CADWorx Configuration.

2. Select Data Tables tab.

3. Click on to open list of available transfer types.

4. In the tree view, right click SDB_CDWRX_SHEETS and select Duplicate option. SDB_CADWorx _SHEETS gets duplicated to SDB_CADWorx _SHEETS_XXXX.

5. Rename SDB_CADWorx _SHEETS_XXXX to TRAINING_CDWRX.

6. Double-click the TRAINING_CDWRX. The CADWorx Transfer Type Data Tables appear in the grid on the right.

   

7. In the grid on the right, do the following:

   1. Click Edit .

   2. Click Add to add a new row.

   3. Double click the new row. The List of Values window appear.

   4. Select all the available data tables and click ADD.

      

8. Click Save .

9. Click Read-only Grid .

   

Export of Spec from SRD

To export the spec from SRD, do the following:

1. Navigate to Integration > CADWorx > CADWorx Transfer Jobs.

2. Click Add to create a new job and specify the job name and details as shown below.

   • Job: CC-150

   • Job Comments: CADWorx Export

   • Job Goal: Complete Job

   • General Config: SDB_CONFIG

   • Transfer Type: TRAINING_CDWRX

   • Destination: TRAINING_DEST

   • Item Mapping: TRAINING_ITEM_MAPPING

   • Template: TRAINING_TEMPLATE

   • Data table config: TRAINING_SHT_CONFIG

   • Verification Set: VSet1

   • General Config: The general configs consist of a set of parameters that must be set to control the behavior of the reference data transfer to CADWorx.

   • Transfer Type: Transfer types are pre-defined sets of sheets that exported to CADWorx. The setup of transfer types allows the definition of multiple sets of sheets for different purposes such as codelists, generic sheets, or catalog data sheets

   • Item mapping: Item mapping is a pre-defined and named set of relations between:

     • Sheets and assigned groups/parts/commodity codes/idents

     • Sheet attributes and those values that should appear on distinct parts/commodity codes/idents or specs/spec items

   • Template: A template is a named set of sheets that can be used by the transfer procedure to fill the data sheets by simply copying the data from the template. These sheets must be configured with the retrieval method TEMPLATE_COPY.

   • Data table config: Data table configs or Sheet configs are pre-defined sets of sheet configurations with attribute mappings and retrieval methods. With the retrieval method, you define how the sheet or the sheet column is populated with data. You might need multiple sheet configs when working with different versions of CADWorx.

   • Destination: Smart Reference Data can be used to serve multiple CADWorx catalog databases. To keep track of what was transferred to which CADWorx instance, and to enable incremental (delta) transfers, each transfer job is assigned to a particular destination. These destinations represent the CADWorx catalog databases with their specific connection information, like the catalog server, catalog schema server, catalog database, and the catalog schema database.

     

3. Click Save .

4. Click Yes in the below message.

   

5. Click the Specification Items tab. Do the following:

   1. Add the new spec as shown below.

      

   2. Click Save .

   3. Click Read Only Grid .

6. Now click Start Job and click Yes in the below message.

   

7. When the job processing is done, click the Log Files tab to open the log files and review the log file for any errors or warnings.

8. In the Transfer Files tab to view the files generated by the transfer job. Double-click an entry to view or download the file to your computer.