Applies To
Product(s):	AutoPIPE Vessel
Version(s):	ALL
Area:
Date Logged & Current Version	March 2020 41.04.00.013

Problem:

How to create a small material database for a few select list of materials and merge it to another database?

Solution:

Creating a small material database is very useful since it can be easily transmitted by email and also be conveniently loaded or merged to an existing database, which is explained below.

 As an example we would create a material database for ONLY SA 738 materials grades A, B and C.

1. Open the “Material Database Dialog” (Execute>Manage Material Database)

2. Modify the norm of the applicable materials eg. SA 738 Grade A

• • • • Edit the new SA738GRA (follow Item #1 for instructions on how to add, edit material in database)

      • Change the Norm “ASME II” into “ASME 2” (or something else, it’s just to differentiate with the other materials so that they can be separately queried)

      • Apply Change

      • Do the same for the other grades ie. SA 738 grades B and C.

3. Make a query to select your materials:

• • • • Sort by Norm

      • Include All

      • Where Norm

      • Is = to ASME 2

      • And Norm

      • Is = to ASME 2

      • Create the Report as shown in the image below:

This would query only the SA 738 materials since ONLY they have Norm ASME 2 and not ASME II

 4.  Create a new material database file including your materials (eg. SA 738) only:

• • • • Click on “Move Found”

      • Choose a name for your file, Save

 5.  Load your new database file and restore the correct Norm:

• • • • Click on “Load Database (.emdm)” and select the database that was created in Step 4 above

      • Check that there are only 3 materials loaded.

      • Edit SA738GRA

      • Change the Norm “ASME 2” into “ASME II”

      • Apply Change

      • Do the same for the other grades B and C.

 6. Save your changes

• • • • Click on “Write database (.emdm)” to make these changes in the database

      • Select your material file

7. Merge this new small database with existing one

• • • • Click on "Load Database (.emdm)" and select the main database where you want to add the smaller database

• • • • Then click on "Load Database (.emdm) and Add to opened" and select the database that you want to merge

• • • • Observe that the small database now merged with the main database

See Also

AutoPIPE Vessel

Bentley LEARN Server