Cell Name Reference - Component Properties - CADWorx

Cell Name Reference - Component Properties - CADWorx - Reference Data

CADWorx Spec Editor

Language

English

Product

CADWorx

Subproduct

Plant

Search by Category

Reference Data

CADWorx Version

20.2

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.