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.

If you have additional information in your cable list that you need to import into the software you can do so by defining a custom UDA and mapping your information to this UDA in your cable list import file.

If you want to import any custom cable UDA while importing the cable list, you can do that by using the Cable list import tool in Bentley Raceway and Cabe Management.

This Document will provide you step by step procedure to import the cable list with a custom cable UDA.

Steps to Accomplish

1. First, you need to create your custom UDA.
   Open the BRCM project and a DGN file registered as 3D Model Equipment.
   
   
   1. Navigate to the Manage ribbon tab and click on Options. (1,2)
   2. Options Wizard will open, Click on UDA settings, and Cable UDAs (3,4)
   3. Add the desired Cable UDA by clicking Provide the Name, id, and the details as follows. (5,6)
   4. Click Apply and OK to save the changes. (7,8)
   
   
   
   The settings are:

• id: This is the id of the UDA which will be used to identify the UDA in the XML files.
  UDA ID should only contain 0-9, a-z, A-Z, and ‘_’, and should not start with a number.
• Name: You can define the name of the UDA as you would like it to be displayed in the cable manager.
• Mandatory: If set to 0 then this UDA is not compulsory to import.
• Default value: This is the default value of the UDA, this value will be taken if you did not define any value for this UDA in the cable list.
• Include in Cable Manager: UDA will be displayed in Cable Manager.
• Include in Status Manager: UDA will be displayed in the Status Manager.
  
  Close the application and navigate to BRCM standard dataset folder.
  The Added UDA data will be populated in the CFG_GUIClasses.xml file located at the metadata folder of the BRCM standard dataset. As follows:
  
  
  

2. Open the Cale list import excel sheet and include the newly created UDA as follows:
   
   
   
   
3. Also, modify the XML import file for cable list as follows:
   Make sure to use the same mandatory value as defined while creating the UDA.
   
   
4. You can also include the UDA into two files located in the Program files
   To modify these files you will need administrator access.
   
   1. Electrical_RCM_Import.01.00.ecschema.xml: Including UDA to this file will add the UDA to ‘Review Difference’ Dialog while importing the cable list. Property name field is the UDA ID and that value must be entered as UPPER case format.
   
   
   
   This allows BRCM to perform the differencing on the UDA value. See the following example of the Review Differences dialog. Here you can see the new value is compared with the old value in the database and displayed.
   
   
   
   2. BRCM_OptionsDataConfig.xml: Including your UDA to this file will add the UDA in the Configuration dialog where you can map the fields in the excel sheet, and generate the XML file.
   
   
   Note: While making entry for the new UDA, do not forget to edit the tag value in the xmlpath="/XLImportSheet/Values/Value[@tree='2' and @h_level='3' and @tag='AssetNumber']".
   
   See the Configuration Dialog populated with the UDA added.
   
   
   
   
5. Launch the application again and open the DGN file registered as 3D Model Equipment from the same workspace and workset.
   Navigate to Equipment and Cable ribbon tab and click on the Cable List Import
   Select the Cable list excel file and XML file and click OK.
   
   
6. After processing the XLS import dialog will open which shows the mapped rows and columns according to the XML file. You should see your new custom UDA listed with the values specified in your Excel cable list.
   Review the data and click
   
   
   
   
7. In the Collaboration Manager, you will see the lock is requested for defined voltage levels. Press Ok
   
   
8. The Review Differences wizard will open which will show the details of the data imported.
   This wizard will show the differences between the existing cable list and the newly imported cable list.
   You can also see the imported data for the cable at the Properties tab by selecting the cable checkbox.
   Select all the cables, click Accept and then Update.
   
   
9. This will successfully import the cable list into the database.
   You can review the imported data from the Cable manager.
   1. Open the Routing DGN file or the file which is registered as Routing Model.
   2. In the Equipment and Cable ribbon tab open Cable Manager. Select the cable and on the right-side panel, you can see the properties of the cable.
   3. The newly added UDA is listed at the end of the property list.
      
      

See Also

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!