Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenPlant | AutoPLANT
  • Product Communities
OpenPlant | AutoPLANT
OpenPlant | AutoPLANT Wiki How to Export Custom Cable UDAs in Cable Route List report
    • Sign In
    • -OpenPlant | AutoPLANT Wiki
      • +OpenPlant
      • +Bentley AutoPLANT
      • +Bentley Navigator
      • +Bentley PlantSpace
      • +Plant Project Tools
      • -Bentley Raceway and Cable Management
        • How to Download Bentley Raceway and Cable Management
        • Bentley Raceway and Cable Management Product Compatibility
        • -CONNECT Edition - Bentley Raceway and Cable Management
          • +Resolved issues in Bentley Raceway and Cable Management Releases
          • +What's New in Bentley Raceway and Cable Management Releases
          • +Manufacturer Based Raceway Content in Bentley Raceway and Cable Management
          • +AutoPlace Conduit tool - BRCM CONNECT Edition
          • +Cable Reports- Cable Pull Cards and Cable Drums-Bentley Raceway and Cable Management CONNECT Edition
          • +Cable Routing-Bentley Raceway and Cable Management CONNECT Edition.
          • +Drawing generation - Bentley Raceway and Cable Management CONNECT Edition
          • +i-Model - Bentley Raceway and Cable Management CONNECT Edition
          • +Installation_Configuration - BRCM CONNECT
          • +Power Platform Support - BRCM CONNECT Edition
          • +Project Setup- Bentley Raceway and Cable Management
          • +ProjectWise Integration - Bentley Raceway and Cable Management CONNECT
          • +Raceway Design Tools - Bentley Raceway & Cable Management
          • +Raceway IDs - Bentley Raceway and Cable Management CONNECT
          • -Reports - Output Manager - BRCM CONNECT Edition
            • Functions and Operators list for Report Designer in Bentley Raceway and Cable Management
            • How to add Calculated Field in Reports
            • How to Add Equipment UDAs in BOQ Reports
            • How to add the User Defined Attributes into Reports
            • How to apply filters to the Columns of the Output Reports
            • How to Configure Equipment Product Codes
            • How to Export Custom Cable UDAs in Cable Route List report
            • How to generate Isometric Cable Report.
            • How to Include Raceway Accessories in the BOQ Report
            • How to Insert Page Break in BRCM report templates
            • How to Perform Calculations on Product Code (PCode) values
            • How to Utilize Equipment UDAs in BOQ report for Product codes and Descriptions
          • +Underground System - Bentley Raceway and Cable Management CONNECT Edition
          • +User Defined Attributes (UDA) Settings - Bentley Raceway and Cable Management CONNECT Edition
          • +Components Center - Bentley Raceway and Cable Management CONNECT Edition
          • +i-Twin Services-Bentley Raceway and Cable Management CONNECT Edition.
          • +Equipment & Cable List Import-Bentley Raceway and Cable Management CONNECT.
          • +Interoperability
        • +V8i - 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 Export Custom Cable UDAs in Cable Route List report

      Product(s): Bentley Raceway & Cable Management
      Version(s): CONNECT Edition (10.xx.00.xx)
      Environment: N/A
      Area: Reports
      Subarea: N/A
      Original Author: Aadarsh Tale

    Background

    In Bentley Raceway and Cable Management, it is possible to export the custom cable UDAs by using Detail_Cable_Route_List report template. But If you want to export the UDAs along with other cable data in cable route list report templates like Detail_Cable_Route_List II, III and IV, some manual changes to the SQL query in the report template is needed.

    You can follow this article to know how you can export custom cable UDAs in Cable Route List reports.

    Steps to Accomplish

    1. Launch BRCM and open any file from the example project.

    2. Open Output Manager from Output ribbon menu.



    3. Open Cable Route List IV and Select Resources.


    4. Click on Edit Report Template to launch the Report Designer.


    5. In Report Designer’s Field List section, you can see that the imported UDA is not in the Report Information list.|


    6. Now, look for SQL Query in the Property Grid section and copy it.


    7. Open any preferred text editor and paste the SQL Query.


    8. Make an entry for the Cable UDA as $(P)_$(S)_ext_Cables.UDANAME in SELECT and GROUP BY.
      For Example: $(P)_$(S)_ext_Cables.ASSETNUMBER.


    9. Now go back to BRCM, paste the edited SQL query, and save the report.


    10. Close and reopen the Report Designer and you will find the Cable UDA in the Field list.
      Drag and drop the new field list in your report as shown in the image below.


    11. Preview the report and you will get the Cable UDA values under the header.

    See Also

    How to import Cable UDA using Cable list import tool
    Product(s): Bentley Raceway & Cable Management Version(s): CONNECT Edition (10.04.00.25) Environment: N/A Area: User Defined Attributes (UDA) Subarea: Cable UDA …
    Last edited over 1 year ago in OpenPlant | AutoPLANT > OpenPlant | AutoPLANT Wiki

    Still a Problem?

    If above problem still persists, 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!

    • BRCM CONNECT Edition
    • English
    • Cable UDAs
    • Reports - Output Manager
    • how to
    • Share
    • History
    • More
    • Cancel
    • Aadarsh Tale Created by Bentley Colleague Aadarsh Tale
    • When: Mon, Jan 3 2022 6:37 AM
    • Revisions: 1
    • 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

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies