This procedure will focus on adding new materials to be used in AutoPIPE’s EN1591 Flange Analysis module. Anyone making modifications to this library needs to be focused and meticulous. Like other database files, this one organizes data across multiple structured tables starting with the Materials table, where each material is listed in the MaterialName column (e.g., P235GH). Related data for each material is linked to other tables using reference values found in adjacent columns—such as GRP_1-5.2 in the MaterialsGroup table. Before making any changes, take time to review the tables to understand their general structure and flow of data between tables.

All modifications must be performed with an application capable of opening, editing, and saving *.DB files (ex. DB Browser for SQLite – free to download and use without licensing).

Steps:

1. Launch DB Browser (SQLite).

2. Open the MaterialsCatalog.db  file from AutoPIPE’s installation folder.

+++Important+++ Make a backup of this file before making any modifications

Default location: C:\Program Files\Bentley\AutoPIPE xxxx\

3. To review data in this database file:

• • • Navigate to the "Browse Data" tab.
    • In the "Table" dropdown menu, select a table, and start browsing the data.

 

Table of Contents

• Required information to add a new Material
• Step 1: Add a New Material to the MaterialsGroups table
• Step 2: Add New Material to the Materials table
• Step 3: Adding Temperature Range(s) for the Newly Added Material
• Step 4: Adding Material Products for the Newly Created Material Specification
  • • Step 4.1: Update SeamlessTube table
    • Step 4.2: Update SeamlessTubeThickness table
• Step 5: Close the Loop, link SeamlessTubeThicknessID records to the MaterialID
• Step 6: Finished

---

Required Information to add a new Material

The first step to adding a new material is to gather all of the data required by this database. Suggest to research the following data and add in to an Excel sheet for easier reference when using the steps below.

• Material Name: SS2301-22
• Ref Number:  1.1111
• Ref Group:  SW-FE1
• Composition:  Ferritic Steel
• Description:  Steel
• Temperature Range: 0 - 20 - 50 - 100 - 200 - 300   (6 entries)
  • Corresponding values per Temp Range: 
    • Thermal Expansion: -0.22....  (6 entries)
    • Modulus of Elasticity: 22700....  (6 entries)
• Product Data: Seamless
  • Corresponding values per Temp. Range: 
    • Minimum Proof Strength  (6 entries)
    • Tensile Strength  (6 entries)
  • Thickness ranges: 0 - 16mm and 16-40mm  (2 entries)
  • Corresponding values per Temp. Range and per thickness range:
    • Minimum Proof Strength 02: @0 deg C, 0-16mm = 250....; @0 deg C, 16-40mm = 250....   (12 entries)
    • Minimum Tensile: 440   (12 entries)
    • Elongation: 20  (12 entries)

---

Step 1: Add New Material to the MaterialsGroups table

If you can see the "MaterialGroup" you want to use for adding the new material specification, you may skip this step. Otherwise, follow the steps below to add a new "MaterialGroup".

Example: Add “SW-FE1” Material Group

Steps:

1. With MaterialsCatalog.db  opened, select the Browse Data tab, in the "Table" dropdown menu, and select MaterialsGroups.

2. Determine the number of temperature ranges needed for the new material

a. For example, material with the following ranges:

• • • • • 0 to 50
        • 50 to 100
        • 100 to 200
        • 200 to 300
        • 300 to 400

b. This would count as 6 ranges, therefore, insert 6 new rows to the table.

3. Use Insert new records command(), add six records corresponding to the temperature ranges mentioned above.

4. Assign a unique MaterialGroupID to each of the new records. These IDs must not duplicate any existing IDs in the table (suggest using the row number).

5. For each new record, set the MaterialGroup field to “SW-FE1”.

6. In the Composition  and Description fields, enter “Ferritic Steels” and “Steel”, respectively.

7. For each record, enter the Thermal Expansion and Modulus of Elasticity corresponding with the Temperature.Ç

8. After completing all entries, click File> “Write Changes” (Cntl+S) to save your changes to the database.

Back to Top

---

Step 2: Add New Material to the Materials table

Example: Add new material called “SS2301-22 “ and link to newly added “SW-FE1” Material Group from Step #1 above.

Steps:

1. With MaterialsCatalog.db  opened, select the Browse Data tab, In the "Table" dropdown menu, and select Materials.

2. Use Insert a new record command with the following details:

a. A unique MaterialID (make sure it does not duplicate an existing ID).

b. A MaterialName (e.g., SS2301-22).

c. A MaterialNumber as per your internal or standard numbering system. (e.g., 1.1111).

d. A valid MaterialGroup name — either one defined earlier (e.g., SW-FE1) or an existing entry already present in the MaterialGroups table.

e. The corresponding MaterialGroupID,  go to the MaterialsGroups table, scroll down to identify the ID used in the first record classifying the new “SW-FE1” MaterialGroup, from Step #1 (e.g., 270).

3. After completing all entries, click File> “Write Changes” (Cntl+S) to save your changes to the database.

Back to Top

---

Step 3: Adding Temperature Range(s) for the Newly Added Material

For each new material name added to the Materials table, must define a temperature range that will be used to store temperature-dependent data.

Example: Add new temperature range for newly added material “SS2301-22 “ and link to the Materials table added in Step #2 above.

Steps:

1. With MaterialsCatalog.db  opened, complete steps above, select the Browse Data tab, In the "Table" dropdown menu, and select MaterialsTemperatures.

2. Determine the number of temperature ranges needed for the new material.

a. For example, material with the following ranges:

• • • • • 0 to 20
        • 20 to 50
        • 50 to 100
        • 100 to 200
        • 200 to 300

b. This would count as 6 ranges, therefore, insert 6 new rows to the table.

3. Assign a unique MaterialTemperatureID to each record and confirm no duplicate values.

4. Link each record to the relevant MaterialID defined earlier. Enter corresponding MaterialID matching to the new Material name. Go to the Materials table, scroll down to identify the new MaterialName and related Material ID (eg. SS2301-22  parallels 35)  from Step #3.

5. After completing all entries, click File> “Write Changes” (Cntl+S) to save your changes to the database.

Back to Top

---

Step 4: Adding Material Products for the Newly Created Material Specification

To define a material product (e.g., Seamless Tube, Welded Pipe, etc.) for the material specification created in Step 2, must update a minimum of two specific tables:

1. 1. 1. SeamlessTube table - temp. and non-thickness-dependent properties.
      2. SeamlessTubeThickness table – temp. and thickness-dependent properties.

Example: Add a Seamless tube product for Material Specification SS2301-22 with data based on 2 thickness bands:  ≤16mm and 16–40mm.

Note: if the material is intended for components fabricated by Forged or Welded Tubes, apply the same method as described for Seamless Tubes below. However, be sure to select the correct tables from the Table dropdown menu. 

 

Step 4.1: Update SeamlessTube table:

Recalling this table is used for material data that is independent of thickness range.

Steps:

1. With MaterialsCatalog.db  opened, complete steps above, select the Browse Data tab, In the "Table" dropdown menu, and select SealessTubes.

2. Number of Records to be added into the table.

a. Must add one record for each new temperature range defined earlier in the MaterialTemperatures table (Step #3 above).

For example, 6 temperature ranges were added in Step #3, thus add 6 records to the SeamlessTubes table.

3.Update table with corresponding MaterialTemperatureID values for each new record added in Step #2 above.

4. Update table with corresponding material data, MinimumProofStrength1, and TensilStrength.

5. After completing all entries, click File> “Write Changes” (Cntl+S) to save your changes to the database.

Back to Top

Step 4.2: Update SeamlessTubeThickness table:

Recall this table is used for material data that is dependent on thickness range.

Steps:

1. With MaterialsCatalog.db  opened, complete steps above, select the Browse Data tab, In the "Table" dropdown menu, and select SeamlessTubeThickness

2. Number of Records to be added into the table.

a. Calculate A x B:

A = number of SeamlessTub records add in Step 4.1# above (eg. 6).

B = number of thickness ranges to be added. (note, from example information above 2 thickness ranges have been identified)

b. Number of Records to be added = A x B

c. 6 x 2 = add 12 new records to the SeamlessTubeThickness table.

3. Update SeamlessTubeID column

a. For each newly created SeamlessTubeThicknessID, enter the appropriate SeamlessTubeID added in Step 4.1 above.

b. Since 2 thickness ranges have been identified, use the same SeamlessTubeID for two consecutive records (note, if 3 thickness ranges had been identified, then repeat SeamlessTubeID 3x).

c. This links both thickness entries to a single SeamlesstubeID and MaterialtemperatureID record.

4. Enter corresponding ThicknessFrom and ThicknessTo data for each SeamlessTubeID:

a. From Example information above, 2 thickness band ranges are:  

• • • • • 0 mm to 16mm
        • 16mm to 40mm

5. Update table with corresponding material data, MinimumProofStrength02, MiniumuTensile, and Elongation.

6. After completing all entries, click File> “Write Changes” (Cntl+S) to save your changes to the database.

Back to Top

---

Step 5: Close the Loop, link SeamlessTubeThicknessID records to the MaterialID

To complete the setup and close the loop for the newly added material specification, must confirm that all data in the SeamlessTubeThickness table is correctly linked to the corresponding MaterialID created in Step 2.

Steps:

1. With MaterialsCatalog.db  opened, complete steps above, select the Browse Data tab, In the "Table" dropdown menu, and select MaterialProducts table

2. Number of Records to be added into the table.

• • • • Add 12 new records, matching the number of entries added in the SeamlessTubeThickness table in Step 4.2 (note A x B).

3. For each new record, enter the MaterialID that was generated in Step 2 for the material specification (e.g., MaterialID = 35 for SS2301-22).

4. Update SeamlessTubeThicknessID column,

• • • • Reopen the select SeamlessTubeThickness table
      • Copy / paste the 12 new SeamlessTubeThicknessIDs added in Step 4.2.
      • Each record in MaterialProducts should link one SeamlessTubeThicknessID with the corresponding MaterialID.

5. This establishes the final mapping between:

• • • • Material specification (MaterialID)
      • Product type (Seamless Tube)
      • Thickness-specific data (SeamlessTubeThicknessID)

Back to Top

---

Step 6: Finished

Once all of the steps above are completed, the new material and its properties are fully integrated and ready for use in analysis.

+++Important+++ Back up this file to a safe location outside of AutoPIPE’s installation folder, and AutoPIPE’s Profile folders.

Back to Top