How to Add Unit Abbreviations in DGN Reports and in the Databse

Background

User might want to add a unit for Temperature and other measurable quantities in the OpenPlant PID dgn reports and in the database. The steps mentioned in the wiki helps user accomplish this requirement.

Steps to Accomplish

This requirement is accomplished in different stages.

A. Creation of a new Property in the Class Editor.

1. Launch Class Editor and Load OpenPlant PID schema and supplement Imperial Schema.
   
   
   
   
2. Navigate to Valve Class.
   
   
   
   
3. In the Properties Tab, create a new property for the valve temperature as shown below.
   
   
   
   
4. Add Custom Attributes as shown below and change the schema location to supplemental.
   
   
   
   
5. Update the Property as shown in the image below.
   
   
   
   
6. Save schema.
   
   B. Adding this property to DGN reports
   
   
   
7. Launch OpenPlant PID and open BOM.cel file Valve Row model.
   
   
8. Copy Manufacturer column along with the text and paste it alongside as shown below.
   
   
   
   
9. Modify the text as shown below.
   
   
   
   
10. Save settings and close the model.
    
    C. Assignment of the unit and value in OPPID
11. Launch OPPID model and place a valve, in the OPERATING CONDITIONS Valve Design Temperature UOM property will be present select any of the available units and assign a value.
    
    
    
    
12. Now select Utilites->Reports.
    
    
    
    
13. Select the Valve List and Edit.
    
    
    
    
14. Select DGN Templates and click on ellipsis in the Query row.
    
    
    
    
15. The Query dialog will open, check the properties by clicking on the option below.
    
    
    
    
16. Navigate to the property Valve Design Temperature UOM. Select and click on OK.
    
    
    
    
17. A dialog will be prompted to Save the Valve Crystal Template, click on Yes.
    
    
    
    
18. Once the Template has been saved. Click on DGN reports and place it in the model. Confirm, if we can see the value in the report. Or if the report is already placed, one can select and refresh the report for the property to reflect.
    
    
    
    D. Creating a property in the Database.
    
    
19. Launch Bentley Project Administrator.
    
    
    
    
20. Expand Database Node, select Databases and click on Edit Tables.
    
    
    
    
21. Select Valve Table and click on Edit.
    
    
    
    
22. Disable Protected and click on Table Design.
    
    
    
    
23. The Valve Table will launch in Access, add a field name and Data Type as shown below.
    
    
    
    
    
24. Save the file and close.
    
    
25. Close Bentley Project Administrator.
    
    E. Mapping the Database with the field name
    
    
26. Launch Bentley Class Editor, load OpenPlant_Supplemental_Mapping_OPPID schema.
    
    
    
    
27. From the Database Mapping menu click on Open.
    
    
    
    
28. If any mapping is present remove it.
    
    
    
    
29. Select Browse and add a schema path as a mapping location. And select OpenPlant.01.07 schema.
    
    
    
    
30. From the Database Mapping menu, select Edit Database Structure option.
    
    
31. Select Database Mapping and remove.
    
    
    
    
32. Click on Load and type in PLANTPROJECT_DATABASEMAPPING in the Name and Description field. Click on ellipsis in the Data Source row.
    
    
    
    
33. Navigate to the directory where the ProjectDatabase is located.
    
    
    
    
34. Click on OK. The path will be populated in the dialog.
    
    
    
    
35. Test Connection and click on OK.
    
    
    
    
36. Close Database Structure Editor.
    
    
37. In the Class Editor, browse to the Valve class select VALVE_TEMP_UOM property.
    
    
    
    
38. In the Right bottom corner there is Property Mapping Information.
    
    
    
    
39. Select columns as mentioned in the below image and click on OK.
    
    
    
    
40. Click on OK.
    
    
41. Save Database Mapping.
    
    
    
    
42. Now when the drawing is synchronized to the database it will also have the property synced and can be viewed in the database.
    
    
    

See Also

Comments or Corrections?

Bentley's Product Advantage Group requests that you please submit any comments you have on this Wiki article in the "Comments" area below. THANK YOU!