Cell Name Reference - Specification Properties - CADWorx - Help

CADWorx Spec Editor

PPMProduct
CADWorx
PPMCategory_custom
Help
Version_CADWorx
20.1 (2020 R1)

The table below lists available Specification Properties. You can export these single-value specification properties to an Excel file. The Cell Name reference listed beside each Specification Property indicates the same Excel cell name used to export each associated Specification Property. An X in the Export and Import columns designates the available properties for export and import.

If you include any of the listed Specification Property Cell Names in the selected Excel template, then those names populate with the associated Specification Property value. For example, if you include the Specification ID in the Excel template that you create, then the value of the Specification 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 Specification Property value.

If you exclude any of the listed Specification Property Cell Names from the selected Excel template, then those names remove the associated Specification Property value from the export. For example, if you do not include the Specification ID in the Excel template that you create, then the Specification ID does not export to the Excel file.

Specification Property

Cell Name

Export

Import

Specification ID

SPEC_GUID

X

-

Specification Name

SPEC_NAME

X

X

Catalog Name

SPEC_CAT_NAME

X

-

Catalog Path

SPEC_CAT_PATH

X

-

Specification Units

SPEC_UNIT

X

-

Size Table Name

SPEC_SIZE_TBL

X

-

DBCode Table Name

SPEC_DBCODE_TBL

X

X

Thickness Table Name

SPEC_THK_TBL

X

X

Material Table Name

SPEC_MAT_TBL

X

X

Bolt Diameter Table Name

SPEC_BOLT_DIA_TBL

X

X

Bolt Length Table Name

SPEC_BOLT_LEN_TBL

X

X

End Prep Table Name

SPEC_ENDPREP_TBL

X

X

Weight Factor

SPEC_WEIGHT_FACTOR

X

X

Component Class

SPEC_COMPONENT_CLASS

X

X

Temperature Rating

SPEC_TEMPERATURE_RATING

X

X

Pressure Rating

SPEC_PRESSURE_RATING

X

X

Spec Level Layer Name

SPEC_LAYER_NAME

X

X

CAD Color Index

SPEC_COLOR_INDEX

X

X

Limit Spec Size Range To

SPEC_SIZE_RANGE

X

X

Default Flange Type

SPEC_DEFAULT_FLANGE

X

X

Reducing Component Selection

SPEC_REDUCING_SELECTION

X

X

Version

SPEC_VERSION

X

-

Created By

SPEC_CREATED_BY

X

X

Edited By

SPEC_EDITED_BY

X

X

Spec Description

SPEC_DESCRIPTION

X

X

Default OTAP SKEY

SPEC_DEFAULT_OTAP_SKEY

X

X

Export Date

EXPORT_DATE

X

-

The following table lists available Specification Schedule Properties. A specification schedule setup displays a range of schedule values with one value for each pipe size. The Cell Name reference listed beside each Specification Schedule Property indicates the Excel cell name used to export each associated Specification Schedule Property. An X in the Export and Import columns designates the available properties for export and import.

If you include any of the listed Specification Schedule Property Cell Names in the selected Excel template, then those names populate with the associated Specification Schedule Property value. For example, if you include the Schedule Size in the Excel template that you create, then the value of the Schedule Size in the Specification Editor exports to the Excel file.

The location of the Cell Name in the Excel template represents the top row of the exported Specification Schedule range. Subsequent rows in the exported Specification Schedule range insert directly below the top row.

If you exclude any of the listed Specification Schedule Property Cell Names from the selected Excel template, then those names remove the associated Specification Schedule Property value from the export. For example, if you do not include the Schedule Size in the Excel template that you create, then the Schedule Size does not export to the Excel file.

Specification Schedule Property

Cell Name

Export

Import

Schedule Size

SCH_SIZE

X

-

Schedule Value

SCH_VALUE

X

X

The following table lists available Specification Custom Field Properties. A specification custom field setup displays a range-type setup with each custom field value listed for each specification custom field. The Cell Name reference listed beside each Specification Custom Field Property indicates the Excel cell name used to export each associated Specification Custom Field Property. An X in the Export and Import columns designates the available properties for export and import.

If you include any of the listed Specification Custom Field Property Cell Names in the selected Excel template, then those names populate with the associated Specification Custom Field Property value. For example, if you include the Title in the Excel template that you create, then the value of the Title in the Specification Editor exports to the Excel file.

The location of the Cell Name in the Excel template represents the top row of the exported Specification Custom Field range. Subsequent rows in the exported Specification Custom Field range insert directly below the top row.

If you exclude any of the listed Specification Custom Field Property Cell Names from the selected Excel template, then those names remove the associated Specification Custom Field Property Cell Names value from the export. For example, if you do not include the Title in the Excel template that you create, then the Title does not export to the Excel file.

Specification Custom Field Property

Cell Name

Export

Import

Name

FIELD_NAME

X

-

Title

FIELD_TITLE

X

X

Description

FIELD_DESCRIPTION

X

X

Data Type

FIELD_DATA_TYPE

X

-

Required Input

FIELD_REQUIRED_INPUT

X

X

Default

FIELD_DEFAULT_VALUE

X

X

Attach to Component

FIELD_ATTACH

X

X

The following table lists available Specification Branch Table Properties. A specification branch table setup displays a table-type setup listing Main by Reduction size values. The Cell Name reference listed beside each Specification Branch Table Property indicates the Excel cell name used to export each associated Specification Branch Table Property. An X in the Export and Import columns designates the available properties for export and import.

If you include any of the listed Specification Branch Table Property Cell Names in the selected Excel template, then those names populate with the associated Specification Branch Table Property value. For example, if you include the Branch Table in the Excel template that you create, then the value of the Branch Table in the Specification Editor exports to the Excel file.

The location of the BRANCH_TABLE Cell in the Excel template represents the top-left intersection of the Main Size and Branch Size headers for the exported Specification Branch Table. All Branch Table values populate consistent with the Branch Table setup in the Specification Editor respective to this Cell Name header intersection location.

The location of the BRANCH_LEGEND Cell in the Excel template represents the top row of the exported Specification Branch Table Legend. Subsequent rows in the exported Specification Branch Table Legend insert directly below the top row.

If you exclude any of the listed Specification Branch Table Property Cell Names from the selected Excel template, then those names remove the associated Specification Branch Table Property Cell Names value from the export. For example, if you do not include the Branch Table in the Excel template that you create, then the Branch Table does not export to the Excel file.

Specification Branch Table Property

Cell Name

Export

Import

Branch Table

BRANCH_TABLE

X

X

Branch Table Legend

BRANCH_LEGEND

X

-