Background

User-defined attributes(UDA) are additional information about an element in the project that can provide more details about the design elements which is helpful in design analysis. UDAs can be very useful information to add to reports.

If you want to include UDA into reports, then it is possible using the Bentley Raceway and Cable Management Output Manager tool. The ability to add a UDA in the Reports can be a highly useful thing.

This article will guide you to add UDA into reports.

Steps to Accomplish

1. Please have a look at these articles for more details about adding the UDAs.
2. 1. How to Create a Cable UDA in Bentley Raceway and Cable Management CONNECT Edition.
   2. How to Create Equipment UDA in Bentley Raceway and Cable Management CONNECT Edition.
   3. How to Create Raceway UDA in Bentley Raceway and Cable Management CONNECT Edition.
3. Navigate to the standard dataset and open the DB_DataDictionary.xml file from the metadata folder.
   
   
   
   
4. This file lists the database tables. For adding the UDAs to the reports you need to edit the EXT
   The table names are defined in the XML file as follows:
   
   
   
   
5. See the following examples to add the UDAs to report tables.
   
   In this example, we are adding a Cable UDA named ‘AssetNumber’. Following are the settings:
   name: In this field provide the ID of the UDA but it should be in the CAPITAL letter
   format: Data format of the UDA value.
   len: Character length of the UDA value
   repfieldclass: Class of this field, defined as a macro
   repfieldparl1: Field parameter value to be set as ($0,UDA ID)
   repfieldpar2: The value of this parameter is set as ‘cable’ as we are adding cable UDA.
   
   For the Cable Schedule report: table EXT_CABLES
   
   
   
   For the Cable route report: Table EXT_CABLEROUTE
   
   
   
   Also if you want to add the UDA to BOQ reports you can add it using the following tables.
   For the BOQ report: Table EXT_BOQENVELOP
   
   
   
   For the BOQ raceway report: Table EXT_BOQRW
   
   
   
   
6. In the article ‘How to import Cable UDA using Cable list import tool’ you ware able to import the Cable UDA. Here we have added the same UDA (AssetNumber) to the above report's tables. Now we will add the same UDA in the Cable report.
   Launch the application and open the DGN file. Navigate to the Output ribbon tab and click on Output Manager.
   Select the desired Cable report and click on Select Resources.
   
   
   
   
7. Collaboration Manager will open.
   Select the required resources for the reports and click OK.
   
   

7. In the Output Manager dialog select the report and click on the Edit Report Templet at the top.
   
   
   
   
8. Report Designer will open. Navigate to field list and in the ReportInformation tab, you can see the added cable UDA.
   Drag and drop the UDA to the report templet ‘Details’
   
   
   
   
9. You can save this report templet as follows:
   
   
   
   
10. Back to Output Manager, select the report and click
    
    
    
    
11. Review the report.
    
    

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!