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 To Generate Weld Quantity for Slip On Joints in Weld Reports
    • 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
          • 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 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. 

    To Generate Weld Quantity for Slip On Joints in Weld Reports

    Applies To 
    Product(s): OpenPlant Reporting
    Version(s): 08.11.09.XXX (SS5) | 08.11.11.XX (SS6)
    Environment:  Windows 7/8.1/10 (64 bit)
    Area:  Piping Component
    Subarea:  Weld Reports
    Original Author: Rahul Kumar, Bentley Product Advantage Group

    Overview

    To generate weld reports including slip on joint welds inside OpenPlant Modeler using DGN reporting.

    Problem Description

    In a model various welds can be generated while modeling a pipeline. In case of Slip On flange joint two types of welds are connected and hence weld quantity gets need to report as double. Currently in OpenPlant Modeler, when weld reports generated, it does not display any weld name and quantity to filter out based on Slip on Joint. However, with below customization process by modifying & creating few properties and applying custom attributes will solve the problem.

    In OpenPlant Modeler check item tree browser for welds. Notice its sub nodes has no information about type of welds. 

    Steps to Resolve

    1. In Class Editor, Open “OpenPlant_3D.01.07.ecschema” & supplement it with below schemas.
      OpenPlant_3D_Supplemental_Modeling.01.07.ecschema
      OpenPlant_3D_Supplemental_ModelingViews.01.07.ecschema

      Note - On Adding & Supplementing schema procedure refer this>>>>> Link. 

    2. Navigate to WELD class. Under properties tab, check NAME property and set override. See image below. 



    3. Add custom attribute Calculated ECProperty Specification on NAME property. See below steps
      1. Right click on NAME property, select Add/Remove option. See image below.



      2. From Dialog box shown below, pull desired property & click OK. Select location to correct supplemental schema.



      3. It will get added inside NAME property. 

    4. Add below expression to it & fill other required fields like shown in below image.
      this.GetRelatedInstance("JOINT_HAS_FASTENER:1:JOINT").GetRelatedInstance("PORT_HAS_JOINT:1:PORT").END_PREPARATION



    5. This will display Weld item type attached to end preparation type.



    6. To display total weld quantity including slip on weld, a new property need to be created in schema, say WELD_NO. 
      1. Copy existing property say UNIT. See image below. 



      2. Scroll down in an empty space of property tab and right click, do a paste. See image below.



      3. Rename it to WELD_NO and add custom attribute Calculated ECProperty Specification like explained in point 3 above.

    7. Add expression as mentioned below and enter other data shown in image. 
      IIF(this.GetRelatedInstance("JOINT_HAS_FASTENER:1:JOINT").GetRelatedInstance("PORT_HAS_JOINT:1:PORT").END_PREPARATION="SLIP_ON","2","1")



    8. Save & Close Schema.
    9. Launch OpenPlant Modeler.
    10. Select Item Reports option. See image below. 



    11. Under Piping Components, create new report for welds like shown in image below. 



    12. Enter Name for reports, query for weld class and select OK. See image below. 



    13. Select Grid report template.



    14. Right click on weld report to generate grid template.  



    15. See report generated in grid template, which can also get exported to csv or excel file for further use. 



    16. Notice Slip on weld type with 2 quantity and other weld count. 

    See Also

    Still a Problem?

    If above problem still persist, then please create a Service Request and contact the Bentley Product Advantage group.  Please include a list of all relevant details to get in depth analysis for a solution or workaround. 

    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!

    • Slip-on weld report
    • grid Reports
    • Weld Reports
    • OpenPlant Reporting
    • Share
    • History
    • More
    • Cancel
    • Rahul Kumar Created by Bentley Colleague Rahul Kumar
    • When: Wed, Nov 9 2016 9:57 AM
    • Rahul Kumar Last revision by Bentley Colleague Rahul Kumar
    • When: Mon, Mar 4 2019 8:01 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