Import Electrical Data PropertyManager

In the Import Electrical Data PropertyManager, you import electrical connection and component data from an Excel spreadsheet called a from-to list.

File Names

Routing subassembly Specify the routing subassembly to import.
Routing template Specify the routing template to import.

Import From-To List

From-to list file Specify the Excel file to import.
Start a new assembly Import the from-to data into a new route subassembly.
Use existing assembly Import the from-to data into an existing route subassembly.
  • Overwrite data. Overwrite the existing from-to data in the route subassembly.
  • Insert data. Add new data to the existing data.
  • Update data. Updates the data of an individual, existing component with new data without resetting the data of other components.
Update Options Remove the unused sketch segments and connectors from the route assembly.
  • Delete segments with no data. Deletes unused sketch segments.
  • Delete connector. Deletes unused connectors.
  • Replace component. Replaces the modified components and keeps the existing ones.
  • Delete existing segments and create new guidelines. Deletes the existing routes connected to the replaced component and creates new guidelines.
Search all subassemblies Searches the current assembly and all its subassemblies for preplaced connectors that match the component reference in the from-to list. Otherwise, the software searches only the assembly.

Set Libraries

Component library file Specify the component library .xml file.
Cable/Wire library file Specify the cable library .xml file.

Header Definitions (Excel)

Type the header text from the Excel file into the corresponding header definition field. For example, if you use PartNo as the header for the part number column in the Excel file, then enter PartNo in Part number.

You can enter multiple Excel headers, separated by semicolons (no spaces), in a header definition field. For example, if you sometimes import an Excel file with a header PartNo, and at other times an Excel file with a header PN, then type PartNo;PN in Part number. The next time you import an Excel file, the software displays and recognizes both entries.