Cell Name Reference - Component Properties - CADWorx - Help

CADWorx Spec Editor

PPMProduct
CADWorx
PPMCategory_custom
Help
Version_CADWorx
20.1 (2020 R1)

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.