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 Show Modified Tag Format in Data Manager
    • 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
          • -Database - Plant Project
            • How to Create a new SQL Server Project and Synchronize OpenPlant PID Projects to it?
            • How do I turn on Number Auto Incrementation of Components on placement?
            • How to Associate an OpenPlant PID Drawing with Another Project
            • How to Change OPPID and Plant Project's Names
            • How to Configure Particular Project to Work in Offline Mode By Default
            • How to Create Custom Border and Map Custom Property with Database
            • How to Get Related Valve Tag in Instrument List in Data Manager
            • How to Map Custom Properties with Database
            • How to Map Input/Output Signal of Instrument in OpenPlant PID
            • How to Select Field Value from External Database PickList
            • How to Setup a Batch Routine to Sync all Drawings in my Project to the Database at one time
            • How To Show Modified Tag Format in Data Manager
            • Importing Data into the Plant Project Database from an Excel Spreadsheet
            • Mapping Plant Project Extended Data Fields to OpenPlant PowerPID
            • OPPID - How to use the Class Editor Mapping Extension for the Plant Project Database
            • OPPID- How to add custom properties to specific piece of equipment or sub class and link to a database
            • Plant Project Database - Class Mapping
            • Plant Project Database - Operations with Schema Mapping and Mapping Add-in panel
            • Plant Project Database - Oracle Install notes
            • Plant Project Database - Relationship Mapping
            • Plant Project Database Tag Format - Tag Codes
            • Setting OpenPlant PowerPID Project with Plant Database Project
            • To Import Modified Tags from Excel in Data Manager
            • Error: "Connection Test Failed" While Mapping SQL Database to Plant Project
            • Calculated EC Property Shows Failure Value in Data Manager
            • "{SERVICE_IS_RELATED_TO_EQUIPMENT(VG.0000003279)} belongs to the ECSchema {ECSchema: PlantProjectSchema.01.04} which is not supported in this connection" Error on Synchronizing from Database to Drawing
            • "Project ID 'XXXX' not found in AT_PROJ.DB3"
            • How to Move a Project Database from One Directory to Another For OPPID
            • Troubleshooting Synchronization issues using Component Selection Tool
          • +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
        • How to Create a Custom Joint in OpenPlant Modeler Connect
      • +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 Show Modified Tag Format in Data Manager

    Applies To 
    Product(s): OpenPlant PID
    Version(s): 08.11.10.xxx (SS5) | 08.11.11.xxx(SS6)
    Environment:  Windows 7/8.1/10 (64 bit)
    Area:  Customization
    Subarea:  Data Manager
    Original Author: Nikhil Salunkhe, Bentley Product Advantage Group

    Background

    In OpenPlant PID, user wants specific tag format for Fluid regulator class and have it populated in Data Manager. In this article, steps are defined on How to show Modified Tag Format in Data Manager.
    For example, tag Format (805HV0001) whereas, 805 is UNIT, HV is DEVICE TYPE CODE and 0001 is NUMBER

    Step to Accomplish

    1. Launch Class editor.

    2. Load OpenPlant.01.07.ecschema



    3. Supplement with OpenPlant_Supplemental_Tagging.01.07.ecschema



    4. Navigate to Fluid Regulator, switch to Properties tab , go to Name and change EC expression and parser regular expression as follows.

      EC Expression: this.UNIT & this.DEVICE_TYPE_CODE & this.NUMBER
      Parser Regular Expression: ^(?<UNIT>[?\w]{3})(?<DEVICE_TYPE_CODE>[?\D]{2})(?<NUMBER>.*)



      Note: Ensure that properties which are mentioned in EC Expression (UNIT, DEVICE TYPE CODE & NUMBER) are overridden. If not, then override all the properties.

    5. Save all the changes.

    6. Launch Project Administrator, expand Project node,, expand Database, select databases then PROJDATA and click on Edit Tables



    7. Select Valve from the list, click on Edit and select Table Design





    8. Add VUNIT in Database, save the file, click OK and close the dialog box.



    9. Open Class editor, click on Database Mapping and select PlantProjectSchema.01.07 from dropdown.




    10. Now, click on edit database structure, Remove old mapping and click on Load.







    11. Fill below data, browse to Plant Project Database folder in data source -> Test and Click OK.



    12. Verify new Table and close the dialog.



    13. Select Valve from Right pane, switch to properties tab, select Unit property and map it with VUNIT



    14. Save the Database mapping and schemas.

    15. Relaunch Project Administrator, expand your projectà Database à Tag Types à Define Tag Code for AT_HVALVE 
      AT_HVALVE : Z-C-N
      Z – UNIT
      C – DEVICE TYPE CODE
      N – NUMBER



    16. Close Project Administrator.

    17. Launch OpenPlant PID, create new file, place pipeline, pumps and few valves and synchronize the drawing.





    18. Open Data Manager and Check Valve List.

    See Also:


    • 08.11.11.xxx
    • PID
    • Tagging Schema
    • P&ID
    • OPPID
    • Class Editor
    • Customization
    • Bentley Project Administrator
    • OpenPLANT PowerPID
    • Database
    • Openplant
    • workspace schema
    • DataManager
    • Tag Format
    • Share
    • History
    • More
    • Cancel
    • Nikhil Salunkhe Created by Nikhil Salunkhe
    • When: Fri, Jul 13 2018 5:31 AM
    • Kestutis Mitkus Last revision by Bentley Colleague Kestutis Mitkus
    • When: Wed, Mar 6 2019 3:27 PM
    • Revisions: 3
    • 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