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 Plant Project Database - Property Mapping
    • 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
            • How to Sync the Valve End Condition with Project DB
            • Importing Data into the Plant Project Database from an Excel Spreadsheet
            • Mapping Plant Project Extended Data Fields to OpenPlant PowerPID
            • OPPID - All drawings have same GUID. Drawings update database incorrectly
            • OPPID - Database Mapping Tips
            • OPPID - Document and their component Links
            • OPPID - Guidelines to ensure OPPID to APPID database field integrity
            • OPPID - How to determine Database Connection and Sync issues
            • OPPID - How To Get Motor Related to Equipment Sync to Database
            • OPPID - How to use the Class Editor Mapping Extension for the Plant Project Database
            • OPPID - Import of Associated Items
            • OPPID - YStrainer Database populate
            • OPPID Pipeline To-From SQL
            • OPPID- How to add custom properties to specific piece of equipment or sub class and link to a database
            • OPPID- SQL Logging
            • Plant Project Database - Class Mapping
            • Plant Project Database - Mappings
            • Plant Project Database - OpenPlant Validation and Repairing a Database Mapping
            • Plant Project Database - Operations with Schema Mapping and Mapping Add-in panel
            • +Plant Project Database - Oracle Install notes
            • Plant Project Database - Property Mapping
            • Plant Project Database - Relationship Mapping
            • Plant Project Database - Schema Mapping Custom Attributes
            • Plant Project Database Tag Format - Tag Codes
            • Setting OpenPlant PowerPID Project with Plant Database Project
            • SQL Server 2008 and Database to Schema Connection
            • 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. 

    Plant Project Database - Property Mapping

    Properties can be mapped on a single column as well as on several columns. In the 2nd case a special column processor should be defined.

    Editing Property Mapping

    To map a property it is necessary to do the following:

    • Select the property in Class Editor's "Properties" panel on the right pane and click the "Edit" button. The mapping for the class should be created in advance. Let's do it for the "COMMENT" property of class "EQUIPMENT". The Edit Property mapping dialog box is displayed

    • Select the table and the column where the value of the property is stored (see Fig.33):
      • Select "EQUIPMENT" in Left combo box (this is table).
      • Select "COMMENT1" in right combo box (this is column).
    • If the property is intended to be read only check the "Read Only" check box in right top corner of the dialog box.
    • Click "OK. The property mapping info will appear in the summary panel.
    • Use the "Edit" and "Remove" buttons (see Fig.34) to edit or remove existing property mappings.

    Note: The scope of tables available for a property mapping is restricted by the tables associated with the class (see Class Tables).

    Multi-Column Property Mapping

    The creation of a multi-column mapping is performed in same dialog box.
    Let's modify the "COMMENT" property and make it multi-column:

    • Open the property edit dialog by clicking the "Edit" button.
    • Click the "+" button in the list and select an additional column: "EQUIP.COMMENT2"
      ("-" button is used for removing a column mapping)
    • The "OK" button is disabled and the exclamation icon is blinking. This is because it is necessary to select a processor for that property. A Processor is a class that will merge the column values into a single value of a property while reading the data and it will parse them back while writing.

     

    • Select the Processor in the combo box. The list of processors is dynamic. For information about the creation of your own custom processor see below. By default the following processors are supported:
      • Upper Layer Plug-in - Aggregating and parsing will be performed by ECPlugin layered over SqlDd ECPlugin.
      • Bentley.EC.SQLAdapter.SeparatorProcessor - Built-in processor that concatenates values with a specified separating character
      • Bentley.EC.SQLAdapter.OptionalUnitsProcessor - Sample processor that does almost the same as above one and concatenates values as follows: <FirstColumnValue> [<SecondColumnValue>]. Second column value is considered as units of value in the first column. In our case select Bentley.EC.SQLAdapter.SeparatorProcessor.
    • Next define ";" as separator

    Defining your own processor requires similar actions as for defining primary key generators (see Primary Keys Generators), i.e. implement interface defined in Bentley.EC.SQLAdapter.dll assembly:
    Bentley.EC.SQLAdapter.ITableColumnProcessor
    An Assembly with a class implementing the interface should be placed in to the same folder as Bentley.EC.SQLAdapter.dll. Usually this is the "Extensions" folder of the installation folder

    Note: in the same manner it is possible to map custom processers for InstanceID, Name and Label. The Extension interface is identical.

     

    ⇐Back to Plant Project Database - Relationship Mapping

    ⇑Main OPPID - How to use the Class Editor Mapping Extension for the Plant Project Database

     

    • Share
    • History
    • More
    • Cancel
    • Gerd.Eichler Created by Bentley Colleague Gerd.Eichler
    • When: Thu, Jan 21 2010 5:56 AM
    • Kestutis Mitkus Last revision by Bentley Colleague Kestutis Mitkus
    • When: Wed, Mar 6 2019 3:27 PM
    • Revisions: 9
    • 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