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 Include XYZ Coordinates in Reports for Piping Components
    • 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
        • +OpenPlant Orthographics Manager v8i
        • +OpenPlant Support Engineering v8i
        • +OpenPlant ModelServer v8i
        • -OpenPlant Reporting v8i
          • Error "No default report template is defined for this report" Appears While Report Generation
          • How to Add/Remove HVAC Component Classes in Grid Report
          • How To Cascade Pipeline Properties to Bolt Report in OpenPlant Modeler
          • How to create Cable Tray Material GRID Report
          • How to Exclude Existing Components from OpenPlant Modeler Reports
          • How to Export Grid Reports in OpenPlant Modeler
          • How to Extract Reports for Multiple Component Class in OpenPlant Modeler
          • How to Generate Consolidated BOM for Components using Pivot Table
          • How to Include Equipment Origin in DGN reports
          • How to Include XYZ Coordinates in Reports for Piping Components
          • How to Insert Report into Drawing in OpenPlant Modeler
          • +How to Show Branch Diameter In Piping Reports
          • How to Show Nozzle Elevation in Report
          • OpenPlant Reporting [FAQ]
          • To Add Pipe Allowances as Field Fit Length in Grid Report
          • To Create BOM for Single Pipeline Using Query Option in OpenPlant Modeler
          • To Generate Weld Quantity for Slip On Joints in Weld Reports
          • To Obtain Bend Angle For Pipe Bends/Mitered Bends in reports, Query by Piping Components
          • To Save BOM Template for Multiple Query in OpenPlant Reporting
          • To Show EC_CLASS_NAME Property for Supports in OpenPlant Modeler Reports
          • To Trim Piping BOM Reports Template Fields in OpenPlant Modeler
        • 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 Include XYZ Coordinates in Reports for Piping Components

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

    Background

    This article will explain how X, Y, Z coordinates can be included in reports for each component in OpenPlant Modeler. By default, coordinates do not show up in the reports but with the help of changes in schema this can be achieved.

    Steps to Accomplish

    1. Launch class editor.

    2. Load OpenPlant_3D schema and supplement it with OpenPlant_3D_Supplemental_Modeling schema.

    3. Go to PIPING_COMPONENT class and add property X_POSITION as shown below:



    4. Add “Calculated ECProperty Specification” custom attribute on this and add below expression.

      this.TRANSFORMATION_MATRIX.M03/1000



    5. Now add another property, Y_POSITION.



    6. Add “Calculated ECProperty Specification” custom attribute and write below expression in EC expression field.

      this.TRANSFORMATION_MATRIX.M07/1000



    7. Similarly, for Z coordinate create new property Z_POSITION and add below expression in “Calculated ECProperty Specification” custom attribute.

      this.TRANSFORMATION_MATRIX.M11/1000



    8. Save the changes in schema and re-open the model.

    9. Right click on ‘BOM by Line Number’ report and select EDIT option.



    10. Edit the query by clicking on the Ellipse button on the query field in the dialog as shown below:



    11. Click on “Include these properties” option in this dialog.



    12. Scroll down on the properties tab and check these highlighted properties on and click OK on subsequent dialogs.



    13. Generate the reports and you should see the coordinates in the grid report window.



    14. You can also export the report in an excel format and check.

    NOTE: If you are working in Imperial projects, then expressions to calculate the X, Y, Z values would be different.

    For X it would be this.TRANSFORMATION_MATRIX.M03/304800
    For Y it would be this.TRANSFORMATION_MATRIX.M07/304800
    For Z it would be this.TRANSFORMATION_MATRIX.M11/304800 assuming that UOR is 304800.

    See Also

    http://communities.bentley.com/products/plant/design___engineering/w/plant_design_and_engineering__wiki/19975.to-show-ec-class-name-property-for-supports-in-openplant-modeler-reports

    http://communities.bentley.com/products/plant/design___engineering/w/plant_design_and_engineering__wiki/19972.how-to-extract-reports-for-multiple-component-class-in-openplant-modeler

    Comments or Corrections?

    Bentley's Product Advantage Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!

    • OpenPlant Modeler
    • Grid Report
    • XYZ
    • OPR
    • 08.11.09.XXX
    • Reporting
    • Coordinates
    • Share
    • History
    • More
    • Cancel
    • Harpreet Singh Created by Bentley Colleague Harpreet Singh
    • When: Mon, Feb 1 2016 9:38 AM
    • Harpreet Singh Last revision by Bentley Colleague Harpreet Singh
    • When: Tue, Dec 13 2016 1:30 AM
    • Revisions: 5
    • Comments: 3
    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