Use this dialog box to import an Excel spreadsheet for a library. You can also map the Excel column names to the column names used in Routing.
This dialog box appears only if you selected Import a library in Excel format.
You can also open either wizard from the Windows Start menu. Click
Cable Wire Library Wizard
The following items apply to the Cable Wire Library Wizard.
Excel File path |
Lets you browse to the Excel file to import. |
Library type |
Sets the type of library: Cable Library, Wire Library, or Ribbon Cable Library. The libraries have different sets of attributes, so you need to select the Library type that corresponds with your data. |
Cables Column List, Wires Column List, or Ribbon Cables Column List |
Library type Column Name
|
Displays the column names that are used in the library you are creating or editing.
|
Excel Column Name
|
Displays the column names that are used in the Excel file. You can double-click any item in this column to map it to the appropriate item in Library type Column Name.
|
|
Cores Column List |
This appears if you set Library type to Cable Library.
Core Column Name
|
Displays the core column names that are used in the library you are creating or editing.
|
Excel Column Name
|
Displays the column names that are used in the Excel file. You can double-click any item in this column to map it to the appropriate item in Core Column Name.
|
|
Component Library Wizard
The following items apply to the Component Library Wizard.
Excel File path |
Lets you browse to the Excel file to import. |
Component Column List |
Component Library Column Name
|
Displays the column names that are used in the library you are creating or editing.
|
Excel Column Name
|
Displays the column names that are used in the Excel file. You can double-click any item in this column to map it to the appropriate item in Component Library Column Name.
|
|
Covering Library Wizard
Excel File path |
Lets you browse to the Excel file to import. |
Library type |
Sets the type of library: Piping & Tubing or Electrical. The libraries have different sets of attributes, so you need to select the Library type that corresponds with your data. |
Covering Column List |
Covering Library Column Name
|
Displays the column names that are used in the library you are creating or editing:
- Covering ID: Unique identifying number for the covering type
- Covering Name: Name that appears in the Coverings PropertyManager and the FeatureManager design tree
- Covering Type: Used to categorize the coverings into different subtypes and filter items in the Coverings PropertyManager
- Width: Outer diameter or range of diameters that are valid for this part
- Thickness: Cross-sectional thickness of the covering
- Packing: Form in which the covering is supplied
- Part Number: Unique value for each covering
- Application: Where the covering can be used
- Voltage Breakdown: Minimum allowable voltage to cause the covering to become electrically conductive
- Shape: Cross-sectional profile of the covering
|
Excel Column Name
|
Displays the column names that are used in the Excel file. You can double-click any item in this column to map it to the appropriate item in Covering Library Column Name.
|
|
Material Column List |
This appears if you set Library type to Piping & Tubing.
Material Library Column Name
|
Displays the material column names that are used in the library you are creating or editing.
|
Excel Column Name
|
Displays the column names that are used in the Excel file. You can double-click any item in this column to map it to the appropriate item in Material Library Column Name.
|
|