To Include Equipment Name when Importing from Excel
Bentley Raceway and Cable Management has the functionality to import
Equipment from an Excel spreadsheet by utilizing X,Y,Z coordinates and
equipment IDs. You can also add a column to the spreadsheet to specify the
Equipment Name instead of using generic junction boxes for all imported
equipment. The Equipment name as defined in the
EQP_Equipment_name.XML files is used to define which
equipment will be automatically placed using X,Y,Z coordinates with Equipment
ID defined in the import file.
- To import specific equipment list, add an additional attribute (column) in the equipment list to define the Equipment Name.
- Adjust the Equipment_Import.XML file to include a column with Equipment name and save changes. In the example below Equipment name is defined in column E, so Equipment Name property is mapped to column E.
- Run the Equipment Import process.
- elect the Equipment import files.
- In the Review Differences dialog accept the import all of the new equipment.
- (Optional) - To resolve any issues with invalid equipment names, make changes to the Equipment name (use equipment name available in the dataset) and repeat the Equipment Import procedure. The equipment is now automatically placed in DGN file according to coordinates, equipment IDs and equipment names defined in the import files.