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.