Using the Specon file, you can transfer the specifications from Smart Reference Data to PDMS/ E3D. The Specon file contains information about specifications, ident details for various components, identity of new or old specification, list of specification headers, and so on. The information which is extracted into the Specon file will be in the format that PDMS/ E3D interface can interpret.
Prerequisite: Before you transfer the Specon file to PDMS/ E3D, you must first transfer the relevant ident files. For example, if you are transferring the Piping specification which contains information about the bolt and flange components, then you must first transfer the Flange-Bolt-Point and Single-Bolt-Ident files, so that PDMS/ E3D can refer to the ident information from these files during the transfer process.
The following image is a glimpse of the attributes and other details available in the Data Table Configuration section for PDMS/ E3D, which are extracted into the Specon file.
Smart Reference Data supports the following 3 types of Specon files:
-
Insert: When you extract the data for a specification for the first time, all the extracted data is sent to the Insert Specon file.
-
Modify: When you modify the data available in a specification that is already exported, that data is sent to the Modify Specon file. For this, you must set the Export settings as Add, Modify, and Delete.
When you modify the existing data, the Name and Type columns change the positions in the output file of Modify.
-
Delete: When you delete or replace the data available in a specification that is already exported, that data is sent to the Delete Specon file and the newly added data goes to the Insert Specon file. For this, you must set the Export settings as Delete or Replace.
After you extract data from Smart Reference Data in to PDMS/ E3D Specon file, you can view the generated output in the Notepad as follows.
If you are extracting data from multiple specifications into PDMS/ E3D Specon file, you can view the generated output in the Notepad as follows.
The sections are as follows:
-
General Information: General details about the specification such as Smart Reference Data version number, Job ID, Job Code, number of times the job was run, Units for Bore and Distance, and so on.
-
Specification Headers: The header information which is common for all the components that are available in the Specon file.
-
Body: The data in this section is generated based on the attributes defined for the components/Gtypes Data table in the data table configuration. The values of these attributes are fetched based on the retrieval method and source defined for the attributes inside the same Data Table. The Attributes, Retrieval Method, and Source are configured in the Data Table Configuration.
-
Attribute Names: These attribute names are extracted from the Alternate Names column. PDMS/ E3D cannot interpret the Attribute Names that are defined in Smart Reference Data. To address this, you can customize the attribute names in the Data Table Configuration page under the Alternate Name column so that PDMS/ E3D can interpret them when you export the file.
If no alternate name is defined for an attribute, the attribute name which is delivered as part of the standard is considered.
-
Default Values: For any attribute, if the retrieval source is mentioned as PDMS Default, then the system will extract the values that are defined in the Default column of the Specon file under the data table configuration. No data is extracted if the Default column is empty.
The following table has list of attributes and other related details about the Specon file.
SPCOM |
|
PDMS_VERSION |
|
FLUREF |
|
LINETYPE |
|
BLTM |
|
BSPEC |
|
RATI |
|
PDMS_DESCRIPTION |
|
NOMREF |
|
BRREF |
|
REDREF |
|
FINPUT |
|
DISC_TEXT |
|
PDMS_TYPE |
|
PDMS_NAME |
|
PBOR0 |
|
PBOR1 |
|
PBOR2 |
|
PBOR3 |
|
PBOR4 |
|
STYP |
|
PDMS_ANGLE |
|
SHOP |
|
CATREF |
|
DETAIL |
|
MATXT |
|
CMPREF |
|
BLTREF |
|
TMPREF |
|
PDAREF |
|
PRTREF |
|
SUFF |
|
CONX |
|
BDIAMETER |
|
BTYP |
|
BSEL |
|
In the SPCOM file, the retrieval source for PBOR0, PBOR1, PBOR2, PBOR3, PBOR4 values are set in such a way that the values are fetched from Input1, Input2, Input3, Input4, Input5 of the ident respectively. If users want to customize the values fetched in the PBOR attribute for any G-Type, attached procedure must be created for the SPCOM Data table such that the values are fetched from the desired Input attributes from the ident.
Below is a case shown for fetching the PBOR0 and PBOR3 values for TEE components. The latter can either be a Normal TEE or a reducing TEE. For a normal TEE, PBOR0 and PBOR3 values must be same. As seen in the below snapshots, the standard retrieval source for PBOR0 and PBOR3 fetches the values from Input1 and Input4 from the ident. This cannot be achieved by the standard retrieval sources present in the SPCOM Data table. Hence, an attached procedure must be created, which fetches PBOR0 and PBOR3 values from the first size of the ident for a Normal TEE component and first and second size respectively for a Reducing TEE component.
Sample attached procedure: