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 Create Custom Border and Map Custom Property with Database
    • 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
      • +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 Create Custom Border and Map Custom Property with Database



    Applies To 

    Product(s):

    OpenPlant PID

    Version(s):

    08.11.10.XXX & Higher

    Environment: 

    Windows 7/8 (64 bit)

    Area: 

    Customization

    Subarea: 

    Custom Component

    Original Author:

    Nikhil Salunkhe, Bentley Product Advantage Group


    Background


    In OpenPlant PID, sometimes user wanted to create new custom border and map custom property for their project need. In below Wiki article, we have defined the steps on how to create Custom border and Mapping of custom property.

    1. Add New Border Class
    2. Create new Border in Miscellaneous cell library
    3. Add new property to the custom border
    4. Add Tag sets to the Custom Border
    5. Map added property to the Database

    Step to Accomplish 

    1. Add New Border Class
    2. Launch Bentley Class editor.

    3. Open OpenPlant_PID.01.07.ecschema.xml schema and Supplement OpenPlant_PID_Supplemental_Imperial.01.07.ecschema.xml schema







    4. Expand Classes, Go to Border Class , right click, 'Add Derived Class' and fill below data





    5. Right click on new Border 'METRIC_BORDER' class , Add custom attribute, Select Schematic CAD Custom Attribute and see below image with highlighted steps.







    6. Go to Metric Border List, right click on Items, click on 'Add elements', fill below data and save all the changes.





    7. Create New Border in Miscellaneous cell library

    8. Open Miscellaneous.cel, Go to Tools , navigate to Cells and then define cell origin

    9. Place the cell origin in lower left corner of sheet and Select all the elements in title block



    10. Go to Elements, navigate to Cells, Go to 'File', click on 'Attach file' then Select Miscellaneous.cel 







    11. Create new border sheet and fill below data [ MyBorderSheet ]







    12. Launch OPPID and see title sheets.



    13. Add new property to the custom border

    14. Launch Bentley Class editor

    15. Open OpenPlant_PID.01.07.ecschema.xml schema and Supplement OpenPlant_PID_Supplemental_Imperial.01.07.ecschema.xml schema

    16. Expand the Classes node, Search for PID_DOCUMENT , Click on 'Add New Property' (PID CODE), Add 'Category and Hide property' Custom attributes and fill below data.









    17. Save all changes

    18. Launch OpenPlant PID and notice PID_CODE as new property.

    19. Add Tag sets to the Custom Border
    20. Launch OPPID, Open Miscellaneous.cel, Go to Elements, navigate to Tags, select 'Define', Add PID_CODE as tag set and Click Ok









    21. Again, go to Elements, navigate to cells, Select ‘MyBorderSheet’, right click and select 'Open for editing' 





    22. Go to Tools, navigate to 'Text', then go to 'Tags' and Select 'Attach tags'



    23. Attach PID_CODE as tag set in Title sheet 

    24. Map added property to the Database

    25. Go to Project Administrator, navigate to Sample Metric, go to 'Database', click on 'Edit Tables'





    26. Navigate to DOC_REG, click on 'Edit', go to 'Table design' and add PID_CODE Column in DOC_REG







    27. Close all dialog boxes.

    28. Open Class editor, go to Database Mapping, browse to PlantProjectSchema.01.07_AutoPlant_PIW_01.07  and click 'OK'





    29. Go to 'Edit Database Structure', 'Remove' existing database, click on 'Load', fill below data, Define 'Data source' then do 'Test' and click Ok







    30. Go to PID DOCUMENT, navigate to PID_CODE Property, go to Property mapping and click on 'Edit' 





    31. Select DOC_REG and PID_CODE from list.

    32. Launch OPPID, open New Metric Project, Fill PID Document and synchronize 'Drawing to Database' 
       
    33. Launch Data Manager.

    34. Navigate to Tables and notice DOC_REG has new mapped property PID_CODE

      See Also

      Comments or Corrections

      Bentley's Product Advantage Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!

    • Schema Changes
    • Custom Borders
    • schema customization
    • OpenPlant PID
    • 08.11.11.309
    • Custom Property
    • Miscellaneous.cel
    • 08.11.09.XXX
    • Mapping
    • Database Mapping
    • OPPID
    • Class Editor
    • Tag Set
    • Customization
    • SS6 Refresh 2
    • OpenPLANT PowerPID
    • Project Administrator
    • schema
    • DataManager
    • Share
    • History
    • More
    • Cancel
    • Nikhil Salunkhe Created by Nikhil Salunkhe
    • When: Mon, Mar 19 2018 3:04 PM
    • Kestutis Mitkus Last revision by Bentley Colleague Kestutis Mitkus
    • When: Wed, Mar 6 2019 3:27 PM
    • 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