The standard template is used to export a set of files for each attached specification. The following file types belong to a standard template:
-
Specification File
-
Component Information File
-
Function Definition File
-
Catalogue File
-
Connection File
-
Default Choice File
-
Bolting File
For each file type, the standard configuration will be explained by examples.
Specification File (.SPN)
Header
ORDER |
NAME |
VALUE |
COL START |
END |
DEFAULT |
COMMENT |
---|---|---|---|---|---|---|
10 |
! |
2 |
||||
20 |
! |
2 |
||||
30 |
[HEADER] |
17 |
||||
40 |
! |
2 |
||||
50 |
Specification |
SPEC_CODE |
17 |
|||
60 |
Catalogue |
CATALOG_FILENAME |
17 |
ANSI.CAT |
||
70 |
Boreunits |
UNITS_BORE |
17 |
|||
75 |
MaxBores |
MAXBORES |
17 |
|||
80 |
Lengunits |
UNITS_LENGTH |
17 |
|||
90 |
ItemCode |
17 |
ITEM-CODE-IDENTIFIER |
|||
100 |
Choice |
CHOICE_FILENAME |
17 |
|||
110 |
ImpliedMaterial |
IMPLIED_FILENAME |
17 |
|||
120 |
Connection |
CONNECTION_FILENAME |
17 |
|||
130 |
Bolts |
BOLTS_FILENAME |
17 |
|||
140 |
FullBoltCodes |
17 |
FALSE |
|||
150 |
PulledBend |
TRUE |
17 |
|||
160 |
MinTube |
17 |
42 |
|||
170 |
! |
2 |
||||
180 |
[SPECIFICATION] |
17 |
||||
190 |
! |
2 |
||||
195 |
PULLEDBEND |
51 |
346 |
# BENDS PULLED FROM TUBE |
All information of content type HEADER determines the data output in rows.
Example output:
!
!
! Smart Reference Data
! I-Sketch Interface - Specification ASCII Export
! Production Release 2007 (6.2.4) SP 9
! Copyright 1988 - 2007, Intergraph Corporation
! All Rights Reserved
! License Number: 1031F893D37567BD
!
! Export started at 08-FEB-2008 12:23:32
!
!
!
!
[HEADER]
!
Specification SDB_1CS150
Catalogue SDB_1CS150.CAT
Boreunits Inch
MaxBores 48
Lengunits Inch
ItemCode ITEM-CODE-IDENTIFIER
Choice SDB_1CS150.CHO
ImpliedMaterial SDB_1CS150.IML
Connection SDB_1CS150.CON
Bolts SDB_1CS150.BLT
FullBoltCodes FALSE
PulledBend TRUE
MinTube 42
!
[SPECIFICATION]
!
PULLEDBEND 0.5 48 # BENDS PULLED FROM TUBE
PPPABQPEACRAAG 0.5 1.5 # Pipe , B36.10M , PE , A 106 Gr. B , SMLS
PPPABQBEADLAAB 2 24 # Pipe , B36.10M , BE , A 53 Gr. B , Welded
PPPABQBEAEEAAH 26 30 # Pipe , B36.10M , B
The following twelve lines are fixed and will be written to each file of type SPN.
!
!
! Smart Reference Data
! I-Sketch Interface - Specification ASCII Export
! Production Release 2007 (6.2.4) SP 9
! Copyright 1988 - 2007, Intergraph Corporation
! All Rights Reserved
! License Number: xxxxxxxxxxxxxx
!
! Export started at 08-JAN-2008 12:23:32
!
!
The following lines match the configuration lines ORDER SEQ 10, 20, 30, 40 and 170, 180, 190.
Exclamation marks are used to indicate a comment line in Smart Isometrics catalog files. It is possible to add some user information text to such fields. In this case, the value of COL START determines the length of the string here.
The entries [HEADER] and [SPECIFICATION] are needed at those positions and should not be changed.
!
!
[HEADER]
!
..
!
[SPECIFICATION]
!
Lines 50, 60, 100, 110, 120, and 130 are all interpreted in the same way. The value in column NAME will be written to the file and padded with blanks up to the value specified in COL START. The value in column VALUE is a variable and interpreted during run time. Mainly this is the created file name of the appropriate file. If the value column is not set, the value of column DEFAULT will be applied.
Specification SDB_1CS150
Catalogue SDB_1CS150.CAT
..
Choice SDB_1CS150.CHO
ImpliedMaterial SDB_1CS150.IML
Connection SDB_1CS150.CON
Bolts SDB_1CS150.BLT
Lines 70, 75, and 80 are to be interpreted similarly but will be derived from the data collected during processing of the specification.
Boreunits Inch
MaxBores 48
Lengunits Inch
Lines 90, 140, and 160 have no value in column VALUE. Therefore, the value of column DEFAULT will be used. This is a value required by Smart Isometrics.
ItemCode ITEM-CODE-IDENTIFIER
FullBoltCodes FALSE
MinTube 42
Line 150 is used to determine whether to add the PULLEDBEND entry to the specification or not. In column VALUE, only values TRUE or FALSE should be set. If set to TRUE, the minimum and maximum bore are calculated and a corresponding line will be added as a first line of specification data. The value in column COL START sets the position for the string of column DEFAULT accordingly.
PulledBend TRUE
Example output:
PULLEDBEND 0.5 48 # BENDS PULLED FROM TUBE
DATA columns and fixed columns
ORDER |
NAME |
VALUE |
COL START |
END |
DEFAULT |
COMMENT |
---|---|---|---|---|---|---|
200 |
ITEM-CODE-IDENTIFIER |
COMMODITY_CODE |
1 |
32 |
||
210 |
FROM_SIZE |
FROM_SIZE1 |
33 |
41 |
||
220 |
TO_SIZE |
TO_SIZE1 |
42 |
50 |
||
230 |
Hash |
# |
51 |
52 |
||
240 |
DESCRIPTION |
CC_DESCRIPTION |
53 |
346 |
The information of content type DATA COLUMN or FIXED COLUMN determines the data output in columns.
The placing of the values in the file is determined by COL START and END. But, this is not the absolute position in the file; rather, it is the length of the entries. In the standard template, the commodity code takes the first 32 characters. The FROM_SIZE takes the next nine characters (41 – 33 + 1 = 9). If the configuration is changed for the commodity code – for example, column END set to 30 – the column FROM_SIZE will still be 9 characters long but start at position 31.
Line 200, 210, 220, and 240 all have a variable in the VALUE column. The columns will be filled with data according to the variable values derived from the database. For line 230, the ‘#’ is interpreted as a string and will be spooled out as thus.
Line 240 contains the variable CC_DESCRIPTION. The output of this variable can be influenced by changing the database package M_PCK_ISKETCH_CUSTOM. The function GET_CC_DESCRIPTION can be changed according to your needs. By default, this is the commodity code short description.
PPPABQPEACRAAG 0.5 1.5 # Pipe , B36.10M , PE , A 106 Gr. B , SMLS
PPPABQBEADLAAB 2 24 # Pipe , B36.10M , BE , A 53 Gr. B , Welded
PPPABQBEAEEAAH 26 30 # Pipe , B36.10M , B
Component Information File (.CIF)
The configuration of the Component Information File only consists of entries of content type Data Column.
DATA columns
ORDER |
NAME |
VALUE |
COL START |
END |
DEFAULT |
COMMENT |
---|---|---|---|---|---|---|
10 |
INDEX |
INDEX_NUMBER |
1 |
8 |
|
!INDEX |
20 |
ITEM-CODE-IDENTIFIER |
COMMODITY_CODE |
9 |
40 |
|
!ITEM-CODE-IDENTIFIER |
30 |
ITEM-CODE-IDENTIFIER |
IDENT_CODE |
41 |
55 |
|
!OPTIONAL-CODE |
40 |
N.S. |
BORE_A |
56 |
63 |
0 |
!N.S. |
50 |
N.S.SEC |
BORE_B |
64 |
71 |
0 |
!N.S.SEC |
60 |
N.S.THIRD |
BORE_C |
72 |
79 |
0 |
!N.S.THIRD |
70 |
DESCRIPTION |
IDENT_DESCRIPTION |
80 |
325 |
|
!DESCRIPTION |
Example output:
000001 PPPABQPEACRAAG I0128494 0.5 0 0 Pipe , B36.10M , PE , A …
000002 PPPABQPEACRAAG I0128505 0.75 0 0 Pipe , B36.10M , PE , A …
000003 PPPABQPEACRAAG I0128516 1 0 0 Pipe , B36.10M , PE , A …
000004 PPPABQPEACRAAG I0128538 1.5 0 0 Pipe , B36.10M , PE , A …
The configuration of the Component Information File is also written to the Function Definition File. For an example, refer to the section above.
To fill the Component Information File, all lines are processed by interpreting the variables specified in column VALUE. Lines 10 to 60 use variables that extract fixed specification data. Except for the length of the columns specified by COL START and END, it is not necessary for further manipulations by the user.
Line 70 contains the variable IDENT_DESCRIPTION. The output of this variable can be influenced by changing the database package M_PCK_ISKETCH_CUSTOM. The function GET_IDENT_DESCRIPTION can be changed according to your needs. By default, this is a concatenation of the commodity code short description and ident short description.
Function Definition File (.FDF)
The configuration of the Function Definition File consists only of the following header entries. Note that the information of content type HEADER determines the data output in rows.
ORDER |
NAME |
VALUE |
COL START |
END |
DEFAULT |
---|---|---|---|---|---|
10 |
FUNCTION-DEFINITION-FILE |
|
26 |
|
|
20 |
UNITS-DEFINITION |
|
18 |
|
|
30 |
UNITS-BORE |
UNITS_BORE |
11 |
|
|
40 |
UNITS-LENGTH |
UNITS_LENGTH |
13 |
|
|
50 |
UNITS-WEIGHT |
|
13 |
|
LBS |
60 |
COMPONENT-INFORMATION-FILE |
|
27 |
|
|
70 |
COMPONENT-INFORMATION-SELECTION |
|
32 |
|
|
80 |
ITEM-CODE-INPUT |
|
35 |
|
9 |
90 |
ITEM-CODE-OUTPUT |
|
35 |
|
41 |
100 |
DESCRIPTION |
|
35 |
|
80 |
Example output:
FUNCTION-DEFINITION-FILE
UNITS-DEFINITION
UNITS-BORE Inch
UNITS-LENGTH Inch
UNITS-WEIGHT LBS
COMPONENT-INFORMATION-FILE
INDEX 1 8 !INDEX
ITEM-CODE-IDENTIFIER 9 40 !ITEM-CODE-IDENTIFIER
ITEM-CODE-IDENTIFIER 41 55 !OPTIONAL-CODE
N.S. 56 63 !N.S.
N.S.SEC 64 71 !N.S.SEC
N.S.THIRD 72 79 !N.S.THIRD
DESCRIPTION 80 325 !DESCRIPTION
COMPONENT-INFORMATION-SELECTION
ITEM-CODE-INPUT 9
ITEM-CODE-OUTPUT 41
DESCRIPTION 80
Lines 10, 20, 60, and 70 are written to the file as they are without any further logic.
FUNCTION-DEFINITION-FILE
UNITS-DEFINITION
..
COMPONENT-INFORMATION-FILE
..
COMPONENT-INFORMATION-SELECTION
Lines 30 and 40 are processed by interpreting the variables specified in column NAME and the variable in column VALUE.
UNITS-BORE Inch
UNITS-LENGTH Inch
Line 50 results in the output of the text string specified in column NAME and the value of column DEFAULT.
UNITS-WEIGHT LBS
The following lines are copied from the configuration of the Component-Information-File.
INDEX 1 8 !INDEX
ITEM-CODE-IDENTIFIER 9 40 !ITEM-CODE-IDENTIFIER
ITEM-CODE-IDENTIFIER 41 55 !OPTIONAL-CODE
N.S. 56 63 !N.S.
N.S.SEC 64 71 !N.S.SEC
N.S.THIRD 72 79 !N.S.THIRD
DESCRIPTION 80 325 !DESCRIPTION
For lines 80, 90, and 100, the value of column NAME is written to the file, but the values of column DEFAULT must match the values of COL START of the entries for ITEM-CODE-IDENTIFIER, OPTIONAL-CODE, and DESCRIPTION in the Component-Information-File exactly. This is not done automatically.
ITEM-CODE-INPUT 9
ITEM-CODE-OUTPUT 41
DESCRIPTION 80
Catalogue File (.CAT)
Header
ORDER |
NAME |
VALUE |
COL START |
END |
---|---|---|---|---|
10 |
[CAT Units] |
|
11 |
|
20 |
Length |
UNITS_LENGTH |
7 |
|
30 |
[CAT Records] |
|
14 |
The information of content type HEADER determines the data output in rows.
Example output:
[CAT Units]
Length Inch
[CAT Records]
000001 PIPE 0.00 0.00 0.00 0.00 208 101 437 0
000002 PIPE 0.00 0.00 0.00 0.00 208 101 437 0
000003 PIPE 0.00 0.00 0.00 0.00 208 101 437 0
000004 PIPE 0.00 0.00 0.00 0.00 208 101 437 0
..
Lines 10 and 30 are just string output as specified in column NAME. Line 20 will be additionally filled with the value determined by the variable UNITS_LENGTH.
[CAT Units]
Length Inch
[CAT Records]
DATA columns and fixed columns
ORDER |
NAME |
VALUE |
COL START |
END |
---|---|---|---|---|
40 |
INDEX |
INDEX_NUMBER |
1 |
8 |
50 |
SKEY |
SKEY |
9 |
13 |
60 |
Dim A |
DIM_A |
14 |
21 |
70 |
Dim B |
DIM_B |
25 |
32 |
80 |
Dim C |
DIM_C |
31 |
38 |
90 |
Dim D |
DIM_D |
39 |
46 |
100 |
Item Config Number |
CONFIG_NUMBER |
47 |
52 |
110 |
Item Group Code |
GROUP_NUMBER |
53 |
58 |
120 |
PCF Component Type |
PCF_NUMBER |
59 |
64 |
130 |
Flow Depency Code |
FLOW_CODE |
65 |
65 |
The information of content type DATA COLUMN or FIXED COLUMN determines data output in columns.
This configuration creates a valid output format. It should not be necessary to change the format.
..
000001 PIPE 0.00 0.00 0.00 0.00 208 101 437 0
000002 PIPE 0.00 0.00 0.00 0.00 208 101 437 0
000003 PIPE 0.00 0.00 0.00 0.00 208 101 437 0
..
Connection File (.CON)
The configuration of the Connection File directly reflects the lines to be written to the file. There is no further processing logic. The content may be changed according to your needs. For meaningful settings, refer to Smart Isometrics documentation.
ORDER |
NAME |
VALUE |
COL START |
---|---|---|---|
10 |
! |
|
1 |
20 |
! Connection List |
|
17 |
30 |
01HG |
PIPE |
5 |
40 |
**FL |
GASK |
5 |
50 |
FL** |
PIPE |
5 |
55 |
FL** |
GASK |
5 |
60 |
FLWN |
**BW |
5 |
65 |
**BW |
PIPE |
5 |
70 |
**SC |
PIPE |
5 |
75 |
**SW |
PIPE |
5 |
80 |
**CP |
PIPE |
5 |
85 |
BE** |
PIPE |
5 |
90 |
BU** |
PIPE |
5 |
95 |
CR** |
PIPE |
5 |
100 |
PIPE |
OPEN |
5 |
105 |
**BW |
**BW |
5 |
110 |
DR |
GASK |
3 |
115 |
SP |
GASK |
3 |
120 |
SR |
GASK |
3 |
125 |
SB |
GASK |
3 |
130 |
OP |
GASK |
3 |
135 |
PB |
PIPE |
3 |
140 |
PL |
**SC |
3 |
145 |
PR |
GASK |
3 |
150 |
TB |
PIPE |
3 |
155 |
TB** |
PIPE |
5 |
160 |
TE** |
PIPE |
5 |
165 |
W* |
PIPE |
3 |
170 |
W** |
PIPE |
4 |
175 |
W*** |
PIPE |
5 |
180 |
PIPE |
PIPE |
5 |
182 |
RP |
GASK |
3 |
185 |
RD |
GASK |
3 |
190 |
PF |
GASK |
3 |
195 |
PV |
GASK |
3 |
200 |
**BW |
**WN |
5 |
205 |
W* |
**BW |
3 |
210 |
W* |
W* |
3 |
215 |
! |
|
1 |
220 |
! Exclusion List |
|
16 |
225 |
EXCLUDE |
|
7 |
230 |
BOLT |
|
4 |
235 |
AMAT |
|
4 |
240 |
FLOW |
|
4 |
245 |
FLOR |
|
4 |
250 |
GAP |
|
3 |
255 |
IBAL |
|
4 |
260 |
! |
|
1 |
265 |
! End of Connection Table |
|
25 |
Example output:
!
! Connection List
01HG PIPE
**FL GASK
FL** PIPE
FL** GASK
..
Default Choice File (.CHO)
ORDER |
NAME |
VALUE |
COL START |
END |
---|---|---|---|---|
10 |
! Default Choice Table |
|
22 |
|
20 |
! |
|
1 |
|
50 |
group |
GROUP_NUMBER |
1 |
10 |
60 |
configuration |
CONFIG_NUMBER |
11 |
26 |
70 |
minBore |
FROM_SIZE1 |
27 |
36 |
80 |
maxBore |
TO_SIZE1 |
37 |
46 |
90 |
item_code |
COMMODITY_CODE |
47 |
80 |
Example output:
! Default Choice Table
!
102 200 0.5 1.5 OE45AB2SSWACGZZZ
102 200 0.5 1.5 OE90AB2SSWACGZZZ
102 200 2 48 BE4LABMBEACKZZZ
102 200 2 48 BE9LABMBEACKZZZ
..
Lines 10 and 20 of content type HEADER are string output. The lengths are determined by values specified in COL START.
Lines 50 to 90 are needed to call the processing of specification lines that should be selected as the default choice. To apply the default choice logic, the parts must have option code = 1 set as specification items.
Bolting File (.BLT)
ORDER |
NAME |
VALUE |
COL START |
END |
---|---|---|---|---|
10 |
! Material Characters |
|
21 |
|
20 |
MATERIAL |
18 |
10 |
|
30 |
! |
|
2 |
|
40 |
! Assignment List |
|
17 |
|
50 |
ITEM-CODE_IDENTIFIER |
COMMODITY_CODE |
1 |
32 |
60 |
N.S. |
BORE_A |
33 |
42 |
70 |
N.S.SEC |
BORE_B |
43 |
52 |
80 |
N.S.THIRD |
BORE_C |
53 |
62 |
90 |
BOLT-QTY |
BOLT_QUANTITY |
63 |
72 |
100 |
BOLT-ITEM-CODE |
BOLT_COMMODITY_CODE |
73 |
105 |
Example output:
! Material Characters
MATERIAL 18
!
! Assignment List
FBLABLIRFACGZZZ 15 0 0 4 LMBDAZDBZAZZ00012x50
FBLABLIRFACGZZZ 20 0 0 4 LMBDAZDBZAZZ00012x50
FBLABLIRFACGZZZ 25 0 0 4 LMBDAZDBZAZZ00012x50
..
Lines 10, 30, and 40 are just string output as specified in column NAME.
But the value set for line 20 is special. This value is a key value telling SP Isometrics how to interpret the bolt commodity codes regarding the position of the bolt length. When exporting a specification, the bolt commodity codes written to the bolting file are built from a concatenation of the original SP Reference Data commodity code with the bolt diameter, an ‘x’ character. Determined by the value applied for MATERIAL – 18 in the example – the resulting string will be exactly 18 characters long. The bolt commodity codes may be padded with ‘0’ characters or truncated as necessary. Additionally, the bolt length will be concatenated to the found string.
Lines 50 to 100 determine the placing of output columns. Lines 50 to 80 are filled with data belonging to the part to be bolted. Line 90 defines the quantity of the required bolts.
Note that to derive the necessary bolt diameter and bolt length, appropriate geometrics must be available in SP Reference Data.
Line 100 specifies the variable for the bolt commodity code. This value will be filled only if the mapping of bolts for the specification items has been done on S.50.06 Specification Management.