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 |
- |