Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
AutoPIPE
  • Product Communities
AutoPIPE
AutoPIPE Wiki 04. How to create a small material database for a few select list of materials and merge it to another database?
    • Sign In
    • -Pipe and Vessel Stress Analysis - Wiki
      • +.Bentley AutoPIPE
      • -.Bentley AutoPIPE Vessel (powered by Microprotol)
        • +Features and Bugs
        • +General Information
        • -Support Solutions and FAQ's
          • +Air Coolers
          • Boilers
          • +Calculations
          • +Coils
          • +Cost Estimation
          • +Drawings
          • +Expansion Joints
          • +Import / Export
          • +Interface
          • +Lifting Lugs
          • +Loads and Load Combinations
          • -Material, Material Database, and Default Libraries
            • 01. "Not a valid Material Database load it manually" message appears when using AutoPIPE Vessel, why and how to avoid?
            • 02. How are nominal design stresses calculates in AutoPIPE for a material?
            • +03. How to add a new material into AutoPIPE Vessel
            • 04. How to create a small material database for a few select list of materials and merge it to another database?
            • 05. How to delete an existing material from the database?
            • 06. How to Input user defined material factor of safety for changing design allowable stress as per various codes in AutoPIPE Vessel?
            • 07. How to make modification to existing standard flange material ?
            • 08. What resources does fixed heat exchangers use for EN 13445 thermal expansion coefficient?
            • 09. Why is the does a model have this Impact Test error message being displayed in AutoPIPE Vessel?
            • 10. On selecting a shell component and in the materials tab when clicking on OK, the length becomes 0. How do I resolve this?
            • 11. Why does not the materials window> design tab show the properties for the actual computed thickness in AutoPIPE Vessel?
            • 12. How does AutoPIPE Vessel handle entry in the "Clad / Overlay Thk" field?
            • 13. Why component Material selection does not populate properties for ambient or design fields in AutoPIPE Vessel?
            • 14. Software is crashing while changing the material using multiple selection of elements.
            • 15. Can we use material which has allowable stress values in code but yield strength and tensile strength values are not available?
            • 16. When printing data for a material, young's modulus values printed are not same as input values, Why?
          • +Nozzles and Flanges
          • +Pressure Vessels
          • +Report
          • +Shell and Tube Heat Exchangers
          • +Shells
          • +Soil
          • +Tanks
          • +Units
          • +Vortex Shedding
          • +Weld Joints
        • +System Messages
        • +Video Gallery
      • +ADL PIPE
      • +Bentley AutoPIPE Nozzle
      • +Bentley PlantFLOW
      • +Bentley PULS
    • +AutoPIPE Brand Learning Resources
    • +Attend a live meeting with an AutoPIPE Analyst

     
     Questions about this article, topic, or product? Click here. 

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

    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

    • AutoPIPE Vessel
    • Merge
    • Library
    • material
    • Database
    • Share
    • History
    • More
    • Cancel
    • Mike Dattilio Created by Bentley Colleague Mike Dattilio
    • When: Mon, Mar 9 2020 11:08 AM
    • JamieP Last revision by Bentley Colleague JamieP
    • When: Tue, Aug 18 2020 9:45 AM
    • Revisions: 4
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies