You can list component properties in a basic format, a detailed format, or both.
Under the Basic Listing Format, component data exports much the same way it lists in the Specification Editor's Component list. A single record exports for each component item in the specification, representing the full size range for that component as listed in the specification.
When you import updates from the Excel specification details into the same target specification using Import Update From Excel in the Specification Editor, the updates made to the items in the Basic Listing Format import only the updated data.
Basic Listing Format
The following table lists available Component Properties with the associated Cell Name references for the Basic Listing Format export. You can export these single-value component properties to an Excel file. The Cell Name reference listed beside each Component Property indicates the same Excel cell name used to export each associated Component Property using the Basic Listing Format. An X in the Export and Import columns designates the available properties for export and import.
If you include any of the listed Component Property Cell Names in the selected Excel template, then those names populate with the associated Component Property value. For example, if you include the Component ID in the Excel template that you create, then the value of the Component ID in the Specification Editor exports to the Excel file.
The location of the Cell Name in the Excel template represents the position of the exported Component Property value.
If you exclude any of the listed Component Property Cell Names from the selected Excel template, then those names remove the associated Component Property value from export. For example, if you do not include the Component ID in the Excel template that you create, then the Component ID does not export to the Excel file.
Component Property |
Cell Name – Basic Listing Format |
Export |
Import |
Component ID |
COMP_ID |
X |
- |
Component Group Single |
COMP_GROUP_GRP |
X |
- |
Component Group Repeat |
COMP_GROUP_RPT |
X |
- |
Type |
COMP_TYPE |
X |
- |
Data Table |
COMP_DATA_TBL |
X |
- |
Size Range |
COMP_SIZE_RANGE |
X |
X |
BOM Type |
COMP_BOM |
X |
X |
Layer Name |
COMP_LAYER_NAME |
X |
X |
Color Index |
COMP_COLOR_INDEX |
X |
X |
IndexCode |
COMP_INDEXCODE |
X |
X |
Optional Component |
COMP_OPTIONAL |
X |
X |
Start End Type |
COMP_START_END_TYPE |
X |
X |
Start Isogen Symbol |
COMP_START_ISOGEN_SYM |
X |
X |
Start Component Class |
COMP_START_COMPONENT_CLASS |
X |
X |
Start Temperature Rating |
COMP_START_TEMPERATURE_RATING |
X |
X |
Start Pressure Rating |
COMP_START_PRESSURE_RATING |
X |
X |
End End Type |
COMP_END_END_TYPE |
X |
X |
End Isogen Symbol |
COMP_END_ISOGEN_SYM |
X |
X |
End Component Class |
COMP_END_COMPONENT_CLASS |
X |
X |
End Temperature Rating |
COMP_END_TEMPERATURE_RATING |
X |
X |
End Pressure Rating |
COMP_END_PRESSURE_RATING |
X |
X |
Branch1 End Type |
COMP_BRANCH1_END_TYPE |
X |
X |
Branch1 Isogen Symbol |
COMP_BRANCH1_ISOGEN_SYM |
X |
X |
Branch1 Component Class |
COMP_BRANCH1_COMPONENT_CLASS |
X |
X |
Branch1 Temperature Rating |
COMP_BRANCH1_TEMPERATURE_RATING |
X |
X |
Branch1 Pressure Rating |
COMP_BRANCH1_PRESSURE_RATING |
X |
X |
Branch2 End Type |
COMP_BRANCH2_END_TYPE |
X |
X |
Branch2 Isogen Symbol |
COMP_BRANCH2_ISOGEN_SYM |
X |
X |
Branch2 Component Class |
COMP_BRANCH2_COMPONENT_CLASS |
X |
X |
Branch2 Temperature Rating |
COMP_BRANCH2_TEMPERATURE_RATING |
X |
X |
Branch2 Pressure Rating |
COMP_BRANCH2_PRESSURE_RATING |
X |
X |
Apply same end type |
COMP_SAME_ENDTYPE |
X |
X |
Apply same rating to all ends |
COMP_SAME_RATING |
X |
X |
Isogen Identifier |
COMP_ISOGEN_IDENTIFIER |
X |
X |
Isogen SKEY |
COMP_ISOGEN_SKEY |
X |
X |
Topworks Data Table |
COMP_TOPWORK_TBL |
X |
X |
Main Schedule |
COMP_MAIN_SCH |
X |
X |
Reduction Schedule |
COMP_RED_SCH |
X |
X |
Material |
COMP_MAT |
X |
X |
Sort Sequence |
COMP_SORT_SEQUENCE |
X |
X |
Long Description |
COMP_LONG_DESC |
X |
X |
Short Description |
COMP_SHORT_DESC |
X |
X |
Tag |
COMP_TAG |
X |
X |
Part Number |
COMP_PART_NUMBER |
X |
X |
Notes |
COMP_NOTES |
X |
X |
Custom Field ‘ABC’ |
COMP_FIELD_ABC |
X |
- |
The values for component properties listed under the Basic Listing Format column export with the property settings assigned to each component in the Specification Editor. The Long Description, Short Description, Part Number, and Tag schemas export as their respective schema strings. The Use Specification Schedule, Use Specification Material, and other component setting options export as Use Specification Schedule, Use Specification Material, and so on.
Detailed Listing Format
Under the Detailed Listing Format, component data exports by component item size. A single record exports for each component item size available across the specification components.
When you import updates from the Excel specification into the target specification using Import From Excel Update in the Specification Editor, only updates made to the Component Basic Listing import. Any updates you make to the Detailed Listing Formats do not import, because the Component Properties are managed at the component item level specification not at the component item size level.
The following table lists available Component Properties with associated Cell Name references for Detailed Listing Format export. The Detailed Listing Format Cell Names are identical to the Basic Listing Format Cell Names, with the exception of a _D suffix attached to the Detailed Listing Format. You can export these single-value component properties to an Excel export. The Cell Name reference listed beside each Component Property indicates the Excel cell name used to export each associated Component Property using the Detailed Listing Format. An X in the Export column designates the properties available for export. You cannot import detailed listed format items.
If you include any of the listed Component Property Cell Names in the selected Excel template, then those names populate with the associated Component Property value. For example, if you include the Type in the Excel template that you create, then the value of the Type in the Specification Editor exports to the Excel file.
The location of the Cell Name in the Excel template represents the position of the exported Component Property value.
If you exclude any of the listed Component Property Cell Names from the selected Excel template, then those names remove the associated Component Property value from export. For example, if you do not include the Type in the Excel template that you create, then the Type does not export to the Excel file.
Component Property |
Cell Name – Detailed Listing Format |
Export |
Import |
Component Group Single |
COMP_GROUP_GRP_D |
X |
- |
Component Group Repeat |
COMP_GROUP_RPT_D |
X |
- |
Type |
COMP_TYPE_D |
X |
- |
Data Table |
COMP_DATA_TBL_D |
X |
- |
Size Range |
COMP_SIZE_EACH |
X |
- |
BOM Type |
COMP_BOM_D |
X |
- |
Layer Name |
COMP_LAYER_NAME_D |
X |
- |
Color Index |
COMP_COLOR_INDEX_D |
X |
- |
IndexCode |
COMP_INDEXCODE_D |
X |
- |
Optional Component |
COMP_OPTIONAL_D |
X |
- |
Start End Type |
COMP_START_END_TYPE_D |
X |
- |
Start Isogen Symbol |
COMP_START_ISOGEN_SYM_D |
X |
- |
Start Component Class |
COMP_START_COMPONENT_CLASS_D |
X |
- |
Start Temperature Rating |
COMP_START_TEMPERATURE_RATING_D |
X |
- |
Start Pressure Rating |
COMP_START_PRESSURE_RATING_D |
X |
- |
End End Type |
COMP_END_END_TYPE_D |
X |
- |
End Isogen Symbol |
COMP_END_ISOGEN_SYM_D |
X |
- |
End Component Class |
COMP_END_COMPONENT_CLASS_D |
X |
- |
End Temperature Rating |
COMP_END_TEMPERATURE_RATING_D |
X |
- |
End Pressure Rating |
COMP_END_PRESSURE_RATING_D |
X |
- |
Branch1 End Type |
COMP_BRANCH1_END_TYPE_D |
X |
- |
Branch1 Isogen Symbol |
COMP_BRANCH1_ISOGEN_SYM_D |
X |
- |
Branch1 Component Class |
COMP_BRANCH1_COMPONENT_CLASS_D |
X |
- |
Branch1 Temperature Rating |
COMP_BRANCH1_TEMPERATURE_RATING_D |
X |
- |
Branch1 Pressure Rating |
COMP_BRANCH1_PRESSURE_RATING_D |
X |
- |
Branch2 End Type |
COMP_BRANCH2_END_TYPE_D |
X |
- |
Branch2 Isogen Symbol |
COMP_BRANCH2_ISOGEN_SYM_D |
X |
- |
Branch2 Component Class |
COMP_BRANCH2_COMPONENT_CLASS_D |
X |
- |
Branch2 Temperature Rating |
COMP_BRANCH2_TEMPERATURE_RATING_D |
X |
- |
Branch2 Pressure Rating |
COMP_BRANCH2_PRESSURE_RATING_D |
X |
- |
Apply same end type |
COMP_SAME_ENDTYPE_D |
X |
- |
Apply same rating to all ends |
COMP_SAME_RATING_D |
X |
- |
Isogen Identifier |
COMP_ISOGEN_IDENTIFIER_D |
X |
- |
Isogen SKEY |
COMP_ISOGEN_SKEY_D |
X |
- |
Topworks Data Table |
COMP_TOPWORK_TBL_D |
X |
- |
Main Schedule |
COMP_MAIN_SCH_D |
X |
- |
Reduction Schedule |
COMP_RED_SCH_D |
X |
- |
Material |
COMP_MAT_D |
X |
- |
Sort Sequence |
COMP_SORT_SEQUENCE_D |
X |
- |
Long Description |
COMP_LONG_DESC_D |
X |
- |
Short Description |
COMP_SHORT_DESC_D |
X |
- |
Tag |
COMP_TAG_D |
X |
- |
Part Number |
COMP_PART_NUMBER_D |
X |
- |
Notes |
COMP_NOTES_D |
X |
- |
Custom Field ‘ABC’ |
COMP_FIELD_ABC_D |
X |
- |
Under the Detailed Listing Format column, the values for the component properties list the actual values assigned to each component's size when placed in the model. The Long Description, Short Description, Part Number, and Tag schemas translate into the actual descriptions, part numbers, and tags assigned to each component size when placed in the model. The Use Specification Schedule, Use Specification Material, and other component setting options translate into the actual Schedule, Material, and other values assigned to each component size when placed in the model.