Lab: Detail Text (PDMS_D.DAT) - Intergraph Smart Reference Data - Version 10.0 - Training - Hexagon

Login to SRD application.

Navigate to Integration > PDMS > PDMS Configuration.

To configure data tables, select Data Table Configurations tab and do the following:

1. Right-click the existing Data Table Configuration and select Duplicate. A duplicate Data Table Configuration is created.

   We are duplicating the configuration to edit some of the standard data.

   

2. Right-click the configuration and rename it as PDMS_CONFIG_SHEET.

3. Double-click PDMS_CONFIG_SHEET.

4. To add Data Table to the configuration, do the following:

   1. Click Edit grid.

   2. Click Add.

   3. Double-click in the Data Table column and select PDMS_D data table from the LOV.

      

   4. Modify and review the Retrieval Method or Retrieval Source as required.

   5. (Optional) Enter Alternate Name as Detail Text.

   6. Click Save.

   7. Click Read-only grid.

5. To add Attributes to the Data Table, do the following:

   1. Double-click the PDMS_CONFIG_SHEET or click the plus sign next to the configuration to expand.

   2. In the PDMS_CONFIG_SHEET, double-click the PDMS_D data table.

   3. In the PDMS Data Table Config Attributes grid, click Edit grid.

   4. Click Add.

   5. Double-click the Attribute Name grid and select the following attributes from the LOV.

      - CATA

      - SECT

      - CATE

      - SDTE

      - PDMS_SKEY

      - RTEXT

      - STEXT

      - TTEXT

      

   6. Click ADD. The selected list of attributes will be added to the PDMS Data Table Config Attributes grid for the table PDMS_D.

   7. (Optional) Modify the Retrieval Method or Retrieval Source as required by selecting them from the LOV.

   8. Click Save.

   9. Click Read-only grid.

To add Data Table Mappings, do the following:

1. Navigate to Data Table Mappings tab.

2. Right-click the existing PDMS_ITEM_MAPPING configuration and select Duplicate. A new configuration is created.

   We are duplicating the configuration to edit some of the standard data.

3. Right-click the new configuration and rename it to PDMS_ITEM_MAPS.

4. Double-click the PDMS_ITEM_MAPS or click the plus sign next to the configuration to expand.

5. In the PDMS_ITEM_MAPS configuration, do the following:

   1. Click Edit grid.

   2. Click Add.

   3. Double-click Data Table and select the PDMS_D.

   4. Click Save.

   5. Click Read-only grid.

   6. Double-click the PDMS_D data table in the PDMS_ITEM_MAPS.

   7. In the PDMS Data Table Mappings grid, select Edit grid.

   8. Select Add.

   9. Select the following details to add 2 rows respectively.

      1) Group: F, H;

      2) Part: BL, FR;

      3) Commodity Code: FBLABGDFFAH9ZZZZ, HFRABLDJTACGZZZZ.

      

      4) Click Save.

      5) Click Read-only grid.

To add Attribute Mappings, do the following:

1. Select Attribute Mappings tab.

2. Right-click the existing PDMS_ITEM_MAPPING configuration and select Duplicate. A new configuration is created.

   We are duplicating the configuration to edit some of the standard data.

3. Right-click the new configuration and rename it to PDMS_ITEM_MAPS.

4. Double-click the PDMS_ITEM_MAPS.

5. In the Component Mappings tab, select Edit grid.

6. Click Add and select the following values:

   1. Attribute: BDIAMETER, BITEM

   2. Value/Source: STUD

   3. Group: I, B

   4. Part: JY, E11

      

   5. Click Save.

   6. Click Read-only grid.

To add Templates, do the following:

1. Select the Templates tab.

2. Click Add in PDMS Templates.

3. Enter the Template name as PDMS_TEMPLATE_DEF.

4. Select the Data Table Configuration as PDMS_CONFIG_SHEET.

   

5. Click Save.

6. Double-click PDMS_TEMPLATE_DEF.

7. In the PDMS Data Tables, click Edit grid.

8. Click Add.

9. Double-click the Data Table column and select PDMS_D.

10. Click Read-only grid.

    

To add PDMS General Configurations, do the following:

1. Navigate to Integration > PDMS > PDMS Transfer Jobs > General Configurations.

2. In the PDMS General Configuration grid, click Add.

3. Enter the General Configuration name as PDMS_DTLS.

4. Click Save.

   

5. In the PDMS General Configuration Item Value grid, click Edit grid.

6. Click Add and select the following values:

   1. Item: NLS_RTEXT_XTEXT; Value: 1

   2. Item: NLS_STEXT_YTEXT; Value:1

   3. Item: NLS_TTEXT_ZTEXT; Value: 1

7. Click Save.

8. Click Read-only grid.

Navigate to Integration > PDMS > PDMS Transfer Jobs > Transfer Jobs

1. In the PDMS Job Definition grid, click Add and enter/select the following details.

   

2. In Job, enter the job name as PDMS_Detail.

3. In Job Goal, select Write-to-file.

4. In General Config, select PDMS_DTLS.

5. In Transfer Type, select PDMS_TRANSFER.

6. In Destination, select PDMS.

7. In Item Mappings, select PDMS_ITEM_MAPS.

8. In Template, select PDMS_TMPLATE_DEF.

9. Click Save. The PDMS Transfer Jobs: Data Tables tab appears.

In the PDMS Transfer Jobs: Data Tables tab, click Edit grid.

Click Add and add the following tables shown in the screenshot.

Click Save.

Click Read-only grid.

Navigate to Specifications Items tab.

In the PDMS Transfer Jobs: Specification Items tab, click Edit grid.

Double-click the Spec Code and select 1CA1S01.

Click Save.

Click Read-only grid.

In the PDMS Job Definition, click Start Job. The status of the job is shown as the following screenshot.

In the Transfer Jobs tab, navigate to Transfer Files tab. You can view the generated Data, Delete, Error, and Excel files. You can double-click any files to view the details in it.

Double-click the C:\Download\PDMS_EJ_00000007769_PDMS_D.dat file to view the output. The data is displayed in the Notepad file format.

Method: 2

Navigate to Transfer Job Results.

Select PDMS_D data table. The results will be displayed in the Job Results grid.

To export the PDMS_D file to PDMS interface, do the following:

1. In the PDMS Job Definitions grid, for Job Goal, select the Complete Job option.

2. Click Start Job and wait for the job to complete.

   

Navigate to Destinations tab to view the data that is transferred to the PDMS interface.

In the PDMS Destinations grid, select the Destination as PDMS.

Click Save. PDMS Catalog will appear.

Search and double-click PDMS_D data table. The data that is transferred to PDMS will be displayed.