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.
To display this dialog box, do one of the following:
-
Click , and click Covering Library Wizard
.
-
From the Windows Start menu, click
.
|
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.
|