Standard Template - Intergraph Smart Materials - Version 10.1 - Administration & Configuration - Hexagon

Intergraph Smart Materials Integration (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Administration & Configuration
Smart Construction Version
8
Smart Materials/Smart Reference Data Version
10.1

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.