Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
OpenPlant | AutoPLANT
  • Product Communities
  • More
OpenPlant | AutoPLANT
OpenPlant | AutoPLANT Wiki How to Map Spec Field with OpenPlant Modeler Property
    • Sign in
    • -OpenPlant | AutoPLANT 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
          • +Component - OpenPlant Modeler
          • +Drawing Generation- OpenPlant Modeler
          • +Errors, Logs, Messages, Crashes - OpenPlant Modeler
          • +Import/Export- OpenPlant Modeler
          • +Installation - OpenPlant Modeler
          • OpenPlant HVAC-OpenPlant Modeler
          • OpenPlant Modeler [FAQ]
          • +OpenPlant Specification Generator
          • +ProjectWise - OpenPlant Modeler
          • -Properties - OpenPlant Modeler
            • +Fundamentals of External Database Query in OpenPlant Modeler
            • How to Add Component's Facing Property in Element Information dialog
            • How to Add Inch Sign with Nominal Diameter in Pipeline Tag
            • How to Add New/Existing Property to Nozzle Manager Dialog in OpenPlant Modeler
            • How to Add/Remove Properties in Flyover Hints
            • How to Associate the Specification Based on Service
            • How To Change Attributes of Pipe Based on Component State Using Named Expression
            • How to Change the Units of Measurement for ECProperty in OPM
            • How To Create and Populate Service Description Property on Piping Component Element Information
            • How to Exclude Plant Area Property From Consistency Checker
            • How to get Joint Type Information on Gaskets
            • How to Identify Inconsistency of Component Data with Consistency Checker
            • How to Map Spec Field with OpenPlant Modeler Property
            • How to Modify Supports in Bulk in OpenPlant Modeler
            • How to Move Properties Between Categories
            • How to Populate Header Nominal Diameter for Tap Connection in OpenPlant Modeler
            • How to Prefix 'DN' with Pipe Size in OPM
            • How to Set Default Value on EC Property
            • How to Show Nominal Diameter in Three-Digit Format for Support Tag Name
            • How to Update Bolts and Gaskets in OpenPlant Modeler
            • How to Update Pipeline Tag Name or Component Property After any Changes in Schema
            • To Modify Equipment Tag For FreeForm Nozzle in OpenPlant Modeler
            • To Modify Pipeline Tag Name in OpenPlant Modeler
            • To Obtain Arc Length for Pipe Bends in OpenPlant Modeler
          • +Release Notes - OpenPlant Modeler
          • +Schema - OpenPlant Modeler
          • +Settings/Attributes - OpenPlant Modeler
          • +Structural Modeling Components (SMC)- OpenPlant Modeler
          • +Tasks - OpenPlant Modeler
          • +Training - OpenPlant Modeler
        • +OpenPlant Isometrics Manager v8i
        • +OpenPlant Project Administrator v8i
        • +OpenPlant PID v8i
        • +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 get list of installed applications/programs on Windows Machine using Command Prompt.
        • How to get list of Windows Updates installed on the machine using Command Prompt.
      • +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
      • Your Feedback is important to us!

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

    How to Map Spec Field with OpenPlant Modeler Property

    Applies To
    Product(s): OpenPlant Modeler
    Version(s): 08.11.09.XXX(SS5) | 08.11.11.XXX (SS6)
    Environment: Windows 7/8.1/10 (64 bit)
    Area: Properties
    Subarea:
    Original Author: Harpreet Singh, Bentley Product Advantage Group

    Background

    In order to pull the values from the spec for a component to have it populated in the corresponding property, that property needs to be mapped to spec field. This article will explain how to map the spec field with properties. We will take two examples;
    CASE 1: We will take PIPE_OD_M field from PIPE table and map it with Outside Diameter property on PIPE class;
    CASE 2: We will take HANDLE_OFFSET field from TOPWORKS table and map it with HANDLE_OFFSET property on GEARBOX_OPERATOR class

    CASE 1: Mapping PIPE_OD_M column from spec with Outside Diameter property of pipe

    Steps to Accomplish

    1. Open class editor and load OpenPlant_CustomAttributes schema from \\Workspace\OPModeler\Schemas folder.
    2. Load OpenPlant_3D schema from your project dataset and supplement it with OpenPlant_3D_Supplemental_Modeling schema.
    3. Go to PIPE class and switch to properties tab.
    4. Select OUTSIDE_DIAMETER property and add 'OpenPlant_Physical_Catalogue_Property_Map' custom attribute.



    5. Add 'PIPE_OD_M' in the property name field of the custom attribute.



    6. Save the changes in the schema and verify the result.



    CASE 2: Mapping HANDLE_OFFSET column from spec with HANDLE_OFFSET property of Gearbox Operator

    Steps to Accomplish

    1. Open Bentley Class editor from OpenPlant Project Administrator application
    2. Open OpenPlant_3D.01.07.ecschema from C:\ProgramData\Bentley\OpenPlantModeler V8i\WorkSpace\Projects\OPModeler_Metric\DataSet\Schemas
    3. Right Click on Opened OpenPlant_3D schema on the left pane and  supplement it with the following Schemas

      1. OpenPlant_3D_Supplemental_Information_3DComponent.01.07.ecschema.xml
      2. OpenPlant_3D_Supplemental_Metric_DefaultValues.01.07.ecschema.xml
      3. OpenPlant_3D_Supplemental_Modeling.01.07.ecschema.xml

    4. Go to GEARBOX_OPERATOR class and switch to properties tab
    5. Select HANDLE_OFFSET
    6. Scroll down in the Attributes and find OpenPlant_Physical_Catalogue_Property_Map and insert the value HANDLE_OFFSET in the PropertyName field

    7. Save the schema and exit
    8. Use Windows File Explorer and browse to the folder where the specs are stored
    9. Open the spec with MS_ACCESS
    10. Browse to TOP_WORKS table
    11. Insert a field named “HANDLE_OFFSET

      Sample Image
    12. Find the row with EC_CLASS_NAME “GEARBOX_OPERATOR”
    13. Insert the value of offset you want in the HANDLE_OFFSET fields;
      For example, we have given an offset of 25 for a gearbox of MAIN_SIZE(Nominal diameter) – 150mm

      Sample Image
    14. Save the Spec and Exit
    15. Launch OpenPlant Modeler and the select the spec just edited
    16. Place a Butterfly Valve for Nominal Diameter 150mm
    17. Place a Gearbox operator
    18. In Place Component box, the default Handwheel offset is 25, taken from Spec

      Sample Image

    See Also

    See Video

    • OpenPlant Modeler
    • OPM
    • Outside Diameter
    • Spec Mapping
    • 08.11.09.XXX
    • HandWheel
    • Properties
    • Handle Offset
    • Gearbox operator
    • Share
    • History
    • More
    • Cancel
    • Harpreet Singh Created by Bentley Colleague Harpreet Singh
    • When: Thu, Dec 31 2015 7:56 AM
    • Deepak Singh Last revision by Bentley Colleague Deepak Singh
    • When: Wed, Jun 27 2018 10:44 AM
    • Revisions: 8
    • 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