Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
AutoPLANT | OpenPlant | PlantWise
  • Product Communities
  • More
AutoPLANT | OpenPlant | PlantWise
AutoPLANT | OpenPlant | PlantWise Wiki How to Add Unit Abbreviations in DGN Reports and in the Databse
    • Sign in
    • -AutoPLANT | Bentley Raceway and Cable Management | OpenPlant | PlantWise Wiki
      • -OpenPlant
        • +CONNECT Services - OpenPlant
        • +Example Configuration - CONNECT Edition
        • +Installations - OpenPlant CONNECT Edition Applications
        • +OpenPlant Download Links & Videos
        • OpenPlant Product Compatibility
        • +OpenPlant Modeler CONNECT
        • +OpenPlant PID CONNECT
        • +OpenPlant Isometrics Manager CONNECT
        • +OpenPlant Orthographics Manager CONNECT
        • +OpenPlant Support Engineering CONNECT
        • +OpenPlant Project Administrator CONNECT
        • +OpenPlant CONNECT Edition-PlantSight Integration
        • +OpenPlant Modeler v8i
        • +OpenPlant Isometrics Manager v8i
        • +OpenPlant Project Administrator v8i
        • -OpenPlant PID v8i
          • +Application Solutions - OPPID
          • +Class Editor - OpenPlant PID
          • -Customization - OpenPlant PID
            • +Customize Tag or Annotation
            • +How do Modify the Component Flow Arrow?
            • How To Add & Write New Pipeline Size in OpenPlant PID
            • How to Add Custom Border in OpenPlant PID
            • How to Add Unit Abbreviations in DGN Reports and in the Databse
            • How to Add Units of Measurement on Property in OpenPlant PID
            • How to add “DN” prefix to valve size annotation in OpenPlant PID CONNECT Edition.
            • How to Add/Remove Tools in Main Task of OpenPlant PID
            • How to Assign Color by Service to the Pipeline
            • How to Assign Color to Equipment, Nozzle & Instrument by Service.
            • How to Break Multiple Properties on Spec Break
            • How to by pass the default line break and have a pipeline place on top of equipment.
            • How to Calculate and Customize the PID Text Style Size for Components
            • How to Cascade the Property Values from Pipe Run to Connected Valves
            • How to Change Pipeline Color and Line Weight in OpenPlant PID
            • How to Change the Date Format for Properties in OpenPlant PID
            • How to change the Date format for properties in OpenPlant PID CONNECT Edition.
            • How to Change the Order of Properties in Element Info and Component Dialog
            • How to Change the Priority of Pipe run Breaks
            • How to Configure OpenPlant PID to Show Imperial & Metric sizes in the Same Project
            • How To Create a Capsule Symbol for Instrument Winterization
            • How to create a pick list on EC Property using External Datasource definition
            • How to Create Battery Limit Symbol with Mirroring Capability in OpenPlant PID
            • How to Create Custom Angle Valve in OPPID
            • How to Create Custom Icon in OPPID
            • How to Create Custom Instrument and Custom Property Annotation.
            • How to Create Custom Spec Break with Extended Leader Line in OpenPlant PID
            • How to Create Custom Valve End Conditions using Existing Graphics
            • How to create Custom Valve Tag annotation which contains Custom Property that has a Drop-down option
            • How to Create Drop Down list on EC Property in OpenPlant PID
            • How to Create Jacketed Pipelines in OPPID
            • How to Create Multi-line Style Pipeline with Different Line Weights
            • How to customize Border Attribute Fonts?
            • How to customize Chemical Seal components so they do not prompt or create a Tag Number?
            • How to Format number property on Equipment and Pipelines in OpenPlant PID
            • How to get Association Property of One Project to Another Project
            • How to Get Drop Down List in Number Property of Instrument
            • How to get Line Tag Info for PRV in Data Manager
            • How to Hide Unused Properties on EC Class
            • How to Hide Valve Flange Line for Flanged End Condition
            • How to Implement a Secondary Instrument Database Table
            • How to Increase Gap Length Between Valve and Flange
            • How to Make a Valve Replaceable in OpenPlant PID
            • How to Make Off-Page Connector Rotatable to Place in Vertical Direction
            • How to make Page Connector Orientable
            • How to Make Pressure Reducing Valve Orient to Bigger Size
            • How to Make Revision Property Allow Alpha-Numeric Characters
            • How to Mirror or Rotate a Custom Equipment or Component while Placement
            • How to Modify Default Value for Device Type Code to a Specific Component Class
            • How to modify Specialty item
            • How to Notify Property Value Change From Pipe Run to Series of Instruments
            • How to place pipeline Tag to pipe run automatically in OpenPlant PID CONNECT Edition.
            • How to Populate Class Name on Components
            • How to Populate Component Class Name in Element information for OpenPlant PID
            • How to Propagate Property Value From Pipe Run to Pipeline to Update Pipeline Tag and Annotation
            • How to Pull Properties from Pipe Run to Annotate on Off-Page Connectors
            • How to Resize the Control Valve Actuators in OpenPlant PID
            • How to Set Any Component to Repeat the Insertion After Placement
            • How to Set Same Level to Major & Minor Pipeline but Different Line weight
            • How to Turn of PID Document Settings Dialog at OpenPlant PID Starting
            • How To Use Page Connectors to Show Information Between Two DGNs
            • Open Plant PID Grid and lock settings
            • OPPID: How do I Add a Custom Logo to a Border?
            • Placing Custom Component Leaves Gap in Component and Pipe Run
            • To Exclude Pipe Run using Line List in Data Manager for OPPID
          • +Database - Plant Project
          • +Properties - OpenPlant PID
          • +Release Notes - OpenPlant PID
          • +Training - OpenPlant PID
          • +White Papers/Guidelines - OPPID
        • +OpenPlant Orthographics Manager v8i
        • +OpenPlant Support Engineering v8i
        • +OpenPlant ModelServer v8i
        • +OpenPlant Reporting v8i
        • How to Connect with Bentley Technical Support Team using Microsoft Teams
        • How to Connect with Bentley Technical Support Team using Microsoft Teams via Browser
      • +Bentley AutoPLANT
      • +Bentley Navigator
      • +Bentley PlantSpace
      • +Plant Project Tools
      • +Bentley Raceway and Cable Management
      • i-model Composition Service for S3D
      • Working from home with OpenPlant
      • Working from home with Bentley Raceway and Cable Management
      • Working from home with AutoPLANT Modeler
    • How to Associate the Specification Based on Service in OpenPlant Modeler Connect

     
     Questions about this article, topic, or product? Click here. 

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

    Applies To
    Product(s): OpenPlant PID
    Version(s): 08.11.10.XXX
    Environment: Windows 7/8.1/10 (64 bit)
    Area: Customization
    Subarea: Reports
    Original Author: Swapnil Joshi, Bentley Product Advantage Group

    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!

    • abbreviations
    • PID
    • DGN Reports
    • Property Mapping
    • reports
    • schema customization
    • OpenPlant PID
    • Database Mapping
    • Data Manager
    • uom
    • Class Editor
    • Units of measure
    • UOM abbreviations
    • Database
    • schema
    • Share
    • History
    • More
    • Cancel
    • Swapnil Joshi Created by Bentley Colleague Swapnil Joshi
    • When: Tue, Jun 18 2019 10:57 AM
    • Swapnil Joshi Last revision by Bentley Colleague Swapnil Joshi
    • When: Tue, Jun 18 2019 10:59 AM
    • Revisions: 2
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2021 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies