Create and Export on the fly Instrument - Intergraph Smart Reference Data - Version 10.0 - Training - Hexagon

Intergraph Smart Reference Data Training (2020)
Language
English
Product
Intergraph Smart Reference Data
Search by Category
Training
Smart Materials/Smart Reference Data Version
2020 (10.0)

In this section, you will learn how to

  • Add an on the fly Instrument

  • Create an on the fly flow meter called F-101

This flowmeter will use the symbol called SP3DCoriolisFlowMeterTy1.CCFMeterTy1.

Configure occurrence properties for on the fly instrument:

  1. Navigate to CMS > Manage Class Systems> Create Class Systems.

  2. Right-click the SDB_ENTERPRISE_CONTENT and select Bulk Edit > Classes.

  3. Click Edit grid Edit grid.

  4. Click Add Row Add icon.

  5. Create a new class called FLOW METER. Assign Parent Class Name as INSTRUMENTS.

  6. Click Save grid Save grid icon.

  7. Click Read-only grid Read-only grid and close the window.

    Create and Export on the fly Instrument 1

  8. Navigate to CMS > CMS Component Manager

  9. Expand SDB_ENTERPRISE CONTENT and navigate to FLOW METER class.

  10. Right-click the class and select Manage properties > Assign Properties.

  11. Go to CMS Class Dependent Properties tab.

    Create and Export on the fly Instrument 2

  12. Click Edit grid Edit grid.

  13. Click Add Row Add icon.

  14. Open the On-the-fly Instruments.xls Excel Workbook. The workbook can be found in <SP3D Installation Folder>\CatalogData\BulkLoad\Datafiles.

    For example: C:\Program Files (x86)\SmartPlant\3D\CatalogData\BulkLoad\Datafiles

  15. Select ICM1 sheet.

  16. Select all the part class properties as shown below and then select Ctrl+C to copy the attributes.

    Create and Export on the fly Instrument 3

  17. Go back to Assign Properties window and select Paste (Transpose*) from the right mouse click menu to paste the attributes.

    Create and Export on the fly Instrument 4

  18. Select Attribute in the below prompt.

    Create and Export on the fly Instrument 5

  19. Copy the attributes from Attribute column to Smart 3D Attribute column as shown below.

    Create and Export on the fly Instrument 6

  20. Delete the blank row.

  21. Click Save grid Save grid icon, and click Read-only grid Read-only grid.

  22. Right-click on Flow Meter class and go to Manage Properties > Assign Properties.

  23. Click CMS Class Properties.

    Properties assigned with parent class are displayed.

  24. Select all and Delete these properties.

    Create and Export on the fly Instrument 7

  25. Open the ICM1 worksheet and copy below Commodity Part Attributes.

    Create and Export on the fly Instrument 8

  26. Go back to Assign Properties > CMS Class Properties window and select “Paste (Transpose*)” from the right mouse click menu to paste the attributes.

  27. Select the Attributes button in order to paste as Attributes.

  28. Delete the blank row.

  29. Click Save grid Save grid icon, and click Read-only grid Read-only grid to set the grid back to read-only mode.

    Create and Export on the fly Instrument 9

  30. Close Assign Properties window.

Assign commodity code to CMS class

  1. Navigate to SRD > Component Manager > Commodity/Ident Management, and click All Commodity Groups/Commodity Group/Part/Commodity Code in data explorer and add IO group.

  2. Open All Commodity Groups/Commodity Group/Part/Commodity Code, and double-click IO group.

  3. Add part F and assign CUSTOM rule in the Rule column.

    Create and Export on the fly Instrument 10

  4. Click Save grid Save grid icon, and then click Read-Only grid Read-only grid to set the grid back to read-only mode.

  5. In the tree view, click Refresh Refresh icon.

  6. Double-click part F and create commodity code FLOWMETERONTHEFLY.

    Create and Export on the fly Instrument 11

  7. Click Save grid Save grid icon, and click Read-only grid Read-only grid to set the grid back to read-only mode.

  8. Go to CMS > CMS Component Manager.

  9. Expand SDB_ENTERPRISE CONTENT and navigate to FLOW METER class.

  10. Right click the FLOW METER class and select Manage Class > Update Class.

  11. Create the following SPRD commodity to map to this CMS class and click Save button.

    CMS Update Class

Create Idents for CMS class

  1. Double-click FLOW METER class to open its grid view.

  2. Click Edit Grid Edit grid and enter the following data:

    Create and Export on the fly Instrument 13

    Create and Export on the fly Instrument 14

  3. Click Save grid Save grid icon, and click Read-only grid Read-only grid to set the grid back to read-only mode.

    CMS ident is created.

Assign occurrence attributes to data table (FlowMeter) for export to Smart 3D

  1. Go to Integration > Smart 3D > Smart 3D Configuration, go to Data Table Configurations tab, expand TRAINING_SHT_CONFIG and add the FlowMeter worksheet.

    CMS Assign Occurance

  2. Save the record and click Yes in below screen to create missing tables.

    CMS Assign Occurance 2

  3. Double-click the FlowSwitch sheet and copy data from Physical Attribute column and paste in a worksheet to reuse in FlowMeter sheet later.

    CMS Assign Occurance 3

  4. Double-click the FlowMeter worksheet, and go to Attributes tab.

  5. Open the On-the-fly Instruments.xls Microsoft Excel Workbook. The workbook is located in <SP3D Installation Folder>\CatalogData\BulkLoad\Datafiles.

    For example: C:\Program Files (x86)\SmartPlant\3D\CatalogData\BulkLoad\Datafiles

    . CMS ICM sheet

  6. Select ICM1 sheet and copy the below attributes

  7. Use Excel paste special transpose option and switch the attributes from row into column.

    CMS Excel

  8. Paste the attributes in Attribute Name column.

  9. Copy the Physical Attribute column from excel workbook and paste in the FlowMeter sheet.

    CMS Physical attribute

  10. Copy all the attributes from the Attribute Name column and paste in word document.

  11. Select all attributes and use Shift+F3 to change to upper case.

  12. Copy upper case attribute name in CMS Source column.

  13. Click Save grid Save grid icon, and then click Read-Only grid Read-only grid to set the grid back to read-only mode.

    CMS Save Record

  14. Open the ICM1 sheet and copy the below attributes.

    CMS ICM1

  15. Use Excel paste special transpose option and switch the attributes from row into column.

  16. Open Definition Attributes tab and paste the attributes in Attribute Name column.

    CMS Def Attr

  17. Save the changes and insert a blank row at the end.

  18. Select all the occurrence properties as shown below and then select Ctrl+C to copy the attributes.

    Create and Export On the fly Instrument 20

  19. Use Excel paste special transpose option, switch the attributes from row into column as shown below.

    Create and Export On the fly Instrument 21

  20. Copy the transposed properties and paste them into a note pad to remove ‘OA:’ present in front of all the attributes.

    Create and Export On the fly Instrument 22

  21. Copy the attributes from notepad and paste them into Definition Attributes block as shown below:

    Create and Export On the fly Instrument 23

  22. Make sure that you check Occurrence for all the attributes that are copied above.

    Create and Export On the fly Instrument 25

  23. Click Save grid Save grid icon, and then click Read-Only grid Read-only grid to set the grid back to read-only mode.

Create catalog hierarchy

  1. Navigate to Integration > Smart 3D > Smart 3D Configuration.

  2. Go to Templates tab, expand TRAINING_TEMPLATE and add the R-ClassNodeDescribes worksheet using the list.

    Create and Export On the fly Instrument 26

  3. Click Save grid Save grid icon, and then click Read-Only grid Read-only grid to set the grid back to read-only mode.

  4. In the tree view, click Refresh Refresh icon and expand TRAINING_TEMPLATE.

  5. Double-click the R-ClassNodeDescribes and click Edit Grid Edit grid to create the following record.

    Create and Export On the fly Instrument 27

  6. Click Save grid Save grid icon, and then click Read-Only grid Read-only grid to set the grid back to read-only mode.

Export instrument data from SRD

  1. Navigate to Integration > Smart3D > Smart 3D Configuration > Data Table Mapping tab.

  2. Double-click the TRAINING_ITEM_MAPPING and add FlowMeter sheet.

    Create and Export On the fly Instrument 28

  3. Click Save grid Save grid icon, and then click Read-Only grid Read-only grid to set the grid back to read-only mode.

  4. In the tree view, click Refresh Refresh icon and expand TRAINING_ITEM_MAPPING.

  5. Double-click on FlowMeter sheet and add Group IO and Part F.

  6. Click Save grid Save grid icon, and then click Read-Only grid Read-only grid to set the grid back to read-only mode.

  7. Go to Data Tables tab and add FlowMeter sheet in TRAINING_INSTRUMENTS transfer type.

    Create and Export On the fly Instrument 29

  8. Click Save grid Save grid icon, and then click Read-Only grid Read-only grid to set the grid back to read-only mode.

  9. Navigate to Integration > Smart3D > Smart3D Transfer Jobs.

  10. Select the job INSTRUMENTS and create a new run.

  11. Click Open for edit in S3D Job Definition, select Training_Template, and click Save .

  12. Click the CMS Idents tab and delete the old entries.

  13. Enter the class details that must be exported.

    Do not export the class details using the Idents tab.

  14. Click Save grid Save grid icon, and then click Read-Only grid Read-only grid to set the grid back to read-only mode.

    cms idents

  15. Now click Start Job and click Start.