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 Map Spec Data for Double Type Property in OpenPlant Modeler
    • 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
          • -Component - OpenPlant Modeler
            • Add or Remove Fields from Spec Selection Dialog
            • Delete/Replace the Flange Assembly in OpenPlant Modeler
            • +How are Bolt Lengths Calculated in OpenPlant Modeler
            • How to Add Component as a Tool in Piping Task
            • How To Add Custom Valves in Schema
            • How to Auto-Place Victaulic coupling on pipe to pipe connection
            • How to Calculate the Property Value With Help of EC Expression
            • +How to Cascade Properties from Pipeline to Associated Supports
            • How to Change the graphics of Pipe Union from Hexagonal to Circular
            • How to Change the Precision Level of Dimensions on Components
            • How to Change Weld Size in OpenPlant Modeler
            • How to Configure OpenPlant to Allow Flange Connection with Different Facings
            • How to Copy Components from One Model to Another Model in Standalone Mode
            • How to Create a Steam Trap Component in OpenPlant Modeler
            • How to Create Custom BW Valves with Nipples in OpenPlant Modeler
            • How to Create Custom Component's Tool Button in OpenPlant Modeler Task Panel
            • How to Create Custom Components from Cell
            • How to Create Four Ports Component with Different Sizes in OpenPlant Modeler
            • How to Create Multiport Custom Valve
            • How to Create NipoFlange in OpenPlant Modeler
            • How To Create PDF using Dynamic Views with Bookmark.
            • How to Create Search Criteria to Include Properties from Fluid Port in OpenPlant Modeler
            • How to Create Welding Boss Component in OpenPlant Modeler
            • How to Differentiate Between Multiple Records for Topworks in Spec.
            • How to Display Referenced Pipelines in Pipeline Manager Dialog
            • How to Fix Disconnects by Picking Seal and Fastener from Spec Grid
            • How to Generate Equipment Tag Name With & Without Null Value in OpenPlant Modeler
            • How to Get Inside Diameter Calculated in OpenPlant Modeler
            • -How to Map Spec Data for Double Type Property in OpenPlant Modeler
              • How To Map Custom Double Type Property in OpenPlant Modeler
            • How to Map Spec Table for Placement of Missing Component
            • How to Modify Hand Wheel Stem Thickness
            • How to Modify Support Tag by Including Unit, Service and LineNumber Properties
            • How to Move Components to a Different Pipeline
            • How To Pick Nozzle Length From Spec Database in OpenPlant Modeler
            • How to Place a Spec driven welded Spool Piece in OpenPlant Modeler
            • How to Place an Isometric Break Point in OpenPlant Modeler
            • How to Place Components by Actual Pipe Size Instead of Nominal Diameter
            • How to Place Flexible Hose with Flanged Ends
            • How to Place Multiple Welds in Straight Piece of Pipe at Equal Distance
            • How to Place Three Way Control Valve in OpenPlant Modeler
            • How to Place Various Types of Flanges Automatically for Component Assembly in OpenPlant Modeler
            • How to Place Wafer Check Valve in OpenPlant
            • How to Reorder Iso Sheet Numbering Using Pipeline Start Note in OpenPlant Modeler
            • How To Set Inlet-Outlet Ratings on Relief Valve
            • How to Set the Order of the Properties in Spec Selection Grid
            • How To Show Active Model File Name to Piping Components in OpenPlant Modeler
            • How to Show Weld Symbol on Threaded Joint
            • How to Show/Hide Bolts and Gaskets in OpenPlant Modeler
            • How to Turn on Centerline Visibility of Pipelines
            • How to Update Graphics & Property When Spec Value Change
            • How to update graphics of custom equipment in OpenPlant Modeler
            • How to use Different Facing Instead of Default Raised/Flat Face Facings
            • How to use Existing Class as Custom Component
            • Issue with placement of Isometric Break Point on Mating Flange Assembly in OpenPlant Modeler
            • Not able to place 90 Degree Long/Short Radius reducing elbows
            • Nozzle Manager Overview
            • Olet\Tee Doesn't Place Automatically on Small Piece of Header Pipe
            • Piping Components Not Fetching Facing Value From Spec
            • Rating Value Map Issue in OpenPlant Modeler
            • To Add Custom Cell for Supports in OpenPlant Modeler
            • To Apply Slopes on Pipe with a Socket Weld Type Fittings
            • To Assign Shop-Field Value to Components Present in OpenPlant Modeler
            • To Cascade Pipeline Property Value to Fasteners
            • To Create Elbow Fitting with Clamp Length in OpenPlant Modeler
            • +To Define Spool ID start point in OpenPlant Modeler
            • To Fix Welds on Olets in OpenPlant Modeler
            • +To Not Include Gasket as a Joint for Flanged Components in OpenPlant Modeler
            • To Place an Elbow with Trimmed Angle using Intelligent Line Manager
            • To Place Eccentric Reducer with AutoFitting
            • To Place Tap Port on Blind Flange in OpenPlant Modeler
            • To Query the Mating Components Based on Auto-Match
            • To Remove Plant Area Property from Tag of Gauge Class
            • To show Isolation Gasket in Isometrics generated from i-models created from 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
          • +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
      • +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 Map Spec Data for Double Type Property in OpenPlant Modeler


    Applies To 
    Product(s): OpenPlant Modeler
    Version(s):

    08.11.09.XXX (SS5) | 08.11.11.XX (SS6)

    Environment:  Windows 7/8.1/10 (64-bit)
    Area:  Settings
    Subarea:  -
    Original Author: Deepak Singh,Bentley Product Advantage Group

    Background

    In OpenPlant Modeler, user’s requirement is to calculate property value from specification database with help of EC Expression. For example, to calculate Length whose data type is double for PIPE_ELBOW_TRIMMED class. Below wiki article will explain on fetching of calculated data from specification for a double type property.

    Steps to Accomplish

    1. Using Bentley Class Editor, open OpenPlant_3D_XX.XX.ecschema.
    2. Supplement it with OpenPlant_3D_Supplemental_Modeling.XX.XX.ecschema & OpenPlant_3D_Supplemental_ModelingViews.XX.XX.ecschema schemas.
      For More information on supplementing schema click here>>>>
    3. Search for PIPE_ELBOW_TRIMMED class, switch to Properties tab & search LENGTH property
    4. Click on Override to localize this property.

    5. Click on Custom Attributes > Add/Remove to add a custom attribute.

    6. From Add/Remove Custom Attributes window, select OpenPlant_Physical_Catalogue_Property_Map custom attribute. Using drop arrow add selected custom attribute > Change Schema location to OpenPlant_3D_Supplemental_Modeling.XX.XX > OK. Refer below image.



    7. Under OpenPlant_Physical_Catalogue_Property_Map custom attribute, right click on ECExpression > Add Element



    8. Below are the possible cases to describe calculated length for Pipe Elbow trimmed class

    Case 1: To Fetch Calculated Length for Pipe Elbow Trimmed Class from Specification Database when CTR_END_M property is available.

    Sample Specification database

    Calculated length for Pipe Elbow Trimmed class is sum of CTR_END_M & CTR_END_R or twice CTR_END_M or CTR_END_R. This calculation can be achieved by using arithmetic operator in ECExpression as shown below.

    Using “+” operator

    COMPONENT_TABLE.CTR_END_M+CTR_END_M


    Using “*” operator

    COMPONENT_TABLE.CTR_END_M*2

    Case 2: With different available properties value for CTR_END_M & CTR_END_R, conditional operator can also be used for calculating calculated length.

    When CTR_END_R is 0 & CTR_END_M is available.

    Sample Specification database

    Using Conditional Operator

    IIF(COMPONENT_TABLE.CTR_END_R = 0, COMPONENT_TABLE.CTR_END_M*2, COMPONENT_TABLE.CTR_END_R*2)

    Note: In specification database snapshot, EC_CLASS_NAME is showing as LONG_RADIUS_90_DEGREE_PIPE_ELBOW because in schema for PIPE_ELBOW_TRIMMED class Use EC Class as LONG_RADIUS_90_DEGREE_PIPE_ELBOW, PIPE_ELBOW_90_DEGREE_SHORT_RADIUS & PIPE_ELBOW_90_DEGREE_3R is defined. Refer image below.

    1. Implementing any of above EC_Expression will result same result.
    2. Save the changes & verify result as shown below.

    See Also

    See Video

    • OpenPlant Modeler
    • OPM
    • Length for Pipe Elbow Trimmed in OpenPlant Modeler
    • Spec Database Property Map
    • ECExpression Property Mapping
    • Fetching Data using EC Expression
    • Length for Trimmed Elbow
    • Property Mapping For Double Property
    • Share
    • History
    • More
    • Cancel
    • Deepak Singh Created by Bentley Colleague Deepak Singh
    • When: Wed, May 2 2018 12:07 PM
    • Deepak Singh Last revision by Bentley Colleague Deepak Singh
    • When: Wed, Jun 27 2018 10:26 AM
    • 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