Background

Bentley Raceway and Cable Management has a pre-defined set of Cable Type properties inside the Options, which consists of some fundamental properties like Name, Units, Diameter and Weight along with other additional properties.

If you want to Import custom cable type properties through Excel and review them directly from the Options, you can follow this article to know how you can edit the column headers and populate the values for custom properties and review them from inside the Options.

Steps to Accomplish

1. Launch BRCM and open any design file.
   
   
2. Select Options from the Manage ribbon tab.
   
   
   
3. Select Cable Types from the Cable Data and you can see the pre-defined properties column in the image below.
   
   
   
4. To edit the column headers for the Cable Types in Options, locate BRCM_OptionsDataConfig.xml at the installation location and open the file in a text editor.
   
   
   
5. In the Cable Type properties node, you can add new columns, delete the unwanted columns, and control the order of the columns as shown in the image below.
   
   
   
6. Open Options and you can see the changes applied to the columns that you have made in the above steps.
   
   
   
7. In order to map the new properties to their respective columns defined in the Excel sheet, again open BRCM_OptionsDataConfig.xml and search for <Properties> name=”ImportFIleCableType” />  .
   Now, edit the entries in this node as we did in the Step 5.
   
   
   
8. While importing the Cable Types you will see the new properties present in the Configuration dialog mapped correctly to the columns defined in the Excel sheet.
   
   
   
9. To populate the imported values for the new properties’ columns in the Options, we have to make changes to the Electrical_RCM_Import.01.00.ecschema.xml located at the installation location.
   Open Electrical_RCM_Import.01.00.ecschema.xml in a text editor.
   
   
   
10. Search for the CableType ECClass and edit the properties to match up with the properties we configured in the earlier steps.
    
    
    
11. After importing the Cable Types, you will be able to review the new properties and their respective values as shown in the image below.
    

See Also

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!