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 - Schema Mapping Custom Attributes
    • 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 - Schema Mapping Custom Attributes

    There are some custom attributes defined for the Plant Project Database Mapping Plug-in which need to be applied before we use this plug-in. These are defined in the schema OpenPlant_Supplemental_Mapping_OPPID.08.11.ecschema.xml. The different types of custom attribute and their purpose are defined below:

    OpenPlant_Supplemental_Mapping_OPPID.08.11 : BusinessKeyValueFormatSpecification

    Applies To: ECClasses (Associated Items: AREA, SERVICE, UNIT, PROJECT etc.)

    Properties:

    Format Expression: A regular expression

    Description

    The associated Items behave differently in the Project Database. The BusinessKey of the associated item is used as the Primary Key (OPPID_Area, OPPID_Service) and the Foreign Key (EQUIP.EAREA, PROCESS.PAREA). In the Project Database, these values are automatically converted to uppercase. If these values are specified in lower case in OPPID then a case sensitive comparison would fail to synchronize. Therefore a format validation is implemented in OPPID which validates the BusinessKey of an associated item against a given format expression.

    OpenPlant_Supplemental_Mapping_OPPID.08.11 : MappingInheritanceConflictResolution

    Applies To ECClasses

    Description
    In the Plant Project Database SQLECPlugin, a database mapping is expected to be on higher level classes (e.g. from the OpenPlant schema). Child classes derived from such classes automatically use the mapping of a mapped base class. In case a child class has multiple mapped base classes; the base class closest in hierarchy is used. In case there is a conflict that multiple mapped base classes are available at the same level, one of them is arbitrarily used. This arbitrary behavior is controlled by the order of the base classes suggested by the EC Framework. If this default behavior is not accepted, any of the base classes can be given priority by adding this custom attribute.

    OpenPlant_Supplemental_Mapping_OPPID.08.11 : PropertyTypeConverterSpecification

    Applied to ECProperties

    Properties

    Prefix : Constant at the start of a value

    Suffix : Constant at the end of a value

    Type : The type of a value (DECIMAL / FRACTION / GUID)

    Default Value : The value to use by default

    Description

    Some values from the ProjectDB are not directly compatible with the respective mapped ECProperties. For example, NOMINAL LENGTH is a fraction value in the ProjectDB and a decimal value in OpenPlant. This custom attribute helps to guide the type conversion process.

    1. Suffix and Prefix are stripped off from the values when dataflow is from PojectDB to OPPID and are appended to values for dataflow OPPID to ProjectDB.
    2. Default value is used if Database has a DbNull value or if a conversion failure occurs.
    3. Depending on the Type of the value a different process is performed.
      1. DECIMAL, the value is type-casted to a double value regardless of the direction of dataflow
      2. GUID, the value is converted to uppercase if data flow is from OPPID to ProjectDB and to lowercase if the data flow is from ProjectDB to OPPID. This is required to match the different GUID format standards in OPPID and the ProjectDB.
      3. FRACTION, the value is resolved from a fraction to a decimal value if the data flow is from ProjectDB to OPPID. If the data flow is from OPPID to ProjectDB, the provided double value is converted to fractions using a Base64 encoding.

    OpenPlant_Supplemental_Mapping_OPPID.08.11: ReferenceTypeRelationship

    Applied To Relationship Classes in OpenPlant.08.11 schema that are themselves mapped or have any child class mapped

    Description

    Exchange uses Synchronization ID (specified using SyncIDSpecfication Custom Attribute) to compare and synchronize an OpenPlant drawing with the Plant Project Database. This synchronization id is only applied to ECClasses that are not relationship classes. Exchange needs the ReferenceTypeRelationship custom attribute on a relationship class so that it can be compared based on the Synchronization ID of its source and target classes.

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

     

     

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