Link the Geometrics to the Commodity Code - Intergraph Smart Reference Data - Version 10.1 - Customization & Programming - Hexagon

Intergraph Smart Reference Data Integration (10.1)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
10.1

Geometrics must be linked to the commodity code.

  1. Open the S.30.01 Commodity Codes screen.

  2. Select the new commodity code you have created in the previous topic.

  3. Select the Commodity Geometric Relations tab.

  4. Click List of values (or press F9) in the Geometric box to select P_BI_1NPS.

  5. In the Input_1 box, enter size range limits .5 to 8 (to limit the idents to the available range).

  6. Click Save (or press F10) to save the changes.

Face to Face

Further geometrics are needed for the Smart 3D symbol: Face to Face and Glass Diameter.

  1. Open the A.50.01 Attributes screen.

  2. Select GEOM ATTRS from the LOV in the Group box, and click Run query (or press F8) to display the geometric attributes.

  3. Identify the attributes to be used for Face to Face.

    • For most items in SDB, face to face is stored as P_F_TO_F (with unit in).

    • There is a face to face. but with unit -. It cannot be converted to other units on export to Smart 3D; therefore, use P_F_TO_F.

    • For the glass tube diameter, P_BODY_DIA attribute (whose unit is in) can be used.

  4. Open the A.50.02 Tables screen, where the table structure can be created using these attributes.

  5. Select GEOM_S4010 from the Type drop-down list, and click Run query .

  6. Click in the Name box in the second block, and click New record (or press F6) to create a new table.

  7. Type P_SIGHT_GLASS in the Name box.

  8. Type Sight Glass in the Short Desc and Description boxes.

  9. Open the A.50.03 Tables/Attributes screen.

  10. Query for the new table P-SIGHT_GLASS.

  11. In the Attributes block, add records for these attributes (as displayed in the picture above):

    Attr Name

    Physical Attribute

    Kind of Attribute

    NPS1

    GD.IN1

    1. Nominal Size

    P_F_TO_F

    GD.OUT1

    Others

    B_BODY_DIA

    GD.OUT2

    Others

    The attributes must have units of measure assigned to enable the conversions to take place on exports.

  12. Click Save (or press F10) to save the changes.

    This creates a table layout that can be used to create geometrics tables of the same structure.

  13. Open the S.40.10 Standard Geometrics screen.

  14. Type P_SIGHT_GLSAA_PF in the Geometric box.

  15. Click List of values (or press F9) in the Tablename box, and select P_SIGHT_GLASS from the list.

  16. Click List of values (or press F9) in the Standard box, and select ANSI.

  17. Click Save (or press F10) to save the new geometric.

  18. Click Go to next block to open Window 2 where you can enter the geometric details.

  19. Type .5 in the NPS1 box, and click Save to save this dummy record.

  20. Click Print to File to export a blank workbook to Excel that can be modified and then re-imported.

  21. Click Select in the Blocks to Write section.

  22. Select Geom Details as shown below.

  23. Click OK.

  24. Select the Re-Importable check box.

  25. Click OK.

    A message prompts you to open the Excel workbook.

    Make sure you have NPS1, P_F_TO_ F, and P_BODY_DIA in the correct columns. Do not overwrite the [ ] and data within [ ].

  26. Copy the IMP/MET to all rows you want to edit.

  27. Type proper values in the NPS1, P_F_TO, and P_BODY_DIA cells.

  28. Type 1 in the Ctrl cells.

  29. Save the workbook in csv format and close Excel.

  30. To re-import the geometric, make sure S.40.10 is opened and the correct geometric is selected.

  31. Click Print to File .

  32. Select the Import tab.

  33. Click Browse.

  34. On the browser page, click Browse to find the import file.

  35. Select the file and click Open.

  36. On the browser page, click Submit Query to upload the file from the selected source folder to the application server for loading.

  37. Select Insert, Update, and Ignore Error, and click OK.

  38. Re-query to view the imported data.

  39. Open the S.30.01 Commodity Codes screen, where you link this geometric to the commodity code.

  40. Select the Geometric tab.

  41. Clear the Ident? check box.

  42. Click List of values (or press F9) in the Geometric box, and select P_SIGHT_GLASS_PF from the list.

  43. Click Save (or press F10) to save the new record.

    The details of the geometric appear in the Geom Details block.