How to create a small material database for a few select list of materials and merge it to another database?
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
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”
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
AutoPIPE Vessel
Bentley LEARN Server