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

communities.bentley.com/.../properties-openplant-modeler

See Video

communities.bentley.com/.../273173