Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
AutoPIPE
  • Product Communities
AutoPIPE
AutoPIPE Wiki 05a. What are the following Database files used for in the AutoPIPE folder?
    • Sign In
    • -Pipe and Vessel Stress Analysis - Wiki
      • +ADL PIPE
      • -Bentley AutoPIPE
        • +- General Information about AutoPIPE
        • +- NEW User Guide for AutoPIPE
        • +- Technical Support - AutoPIPE
        • +Batch Processing, ITS, and ATS using AutoPIPE
        • AutoPIPE QA&R program
        • +Download - Install - Release Notes - AutoPIPE
        • +File / Model Management using AutoPIPE
        • +General - AutoPIPE
        • +Graphics - AutoPIPE
        • +Grids (Input & Results) - AutoPIPE
        • +Import and Export - AutoPIPE
        • +Known Issues in AutoPIPE (Enhancements, defects, etc..)
        • -Libraries - AutoPIPE
          • 0. Library Editor
          • 01.j How to refresh AutoPIPE's material library information?
          • +01b. Does AutoPIPE have my material?
          • +01c. i. Add New Material to Existing Library, AutoPIPE V8i v.9.0 and higher
          • 01c. ii. How to add a new material to AutoPIPE v6.2
          • 01d. How to review a material library default values in AutoPIPE?
          • 01e. What references were used to create AutoPIPE's code and non-code material libraries?
          • 01f. How can I compare and see the difference between 2 different material libraries?
          • +01g. Explain why default material values (ex. Thermal Expansion) do NOT match code reference values in AutoPIPE?
          • 01h. How to import Material from one AutoPIPE library (ex. En13480) into a model that has a different material library (ex. B313-16)?
          • +01i. Material library has 0.00 values, what value should be used in AutoPIPE?
          • 01k. Cannot open a Material SRC file in AutoPIPE, why?
          • 01l. How to control number of decimal places used in AutoPIPE's library SRC files?
          • 02a. How to make changes to Unit files in AutoPIPE?
          • 02b. What conversion factors are used when updating a Library file from English to Metric in AutoPIPE?
          • 02c. What to do when value entered exceeds program's maximum number?
          • 03a. How can I make updates to AutoPIPE's default component library?
          • +04a. How to add a new spring library to AutoPIPE?
          • 05a. What are the following Database files used for in the AutoPIPE folder?
        • +License AutoPIPE -
        • +Loads and Load Sets - AutoPIPE
        • +Localization (Non-English Language) - AutoPIPE
        • +Modeling Approaches in AutoPIPE
        • +Modules (i.e. Flange Analysis, Spring Hanger Selection, Rotating Equip, TTA) in AutoPIPE
        • +Piping codes - AutoPIPE
        • +Post Processing - AutoPIPE
        • +Printing - AutoPIPE
        • +Reports - AutoPIPE
        • Security
        • +Settings - AutoPIPE
        • +Stress Isometrics - AutoPIPE
        • +Technology Productivity Capabilities
        • +Warnings, Errors, Crashed, Confirm, etc.. messages in AutoPIPE
      • +Bentley AutoPIPE Nozzle (WinNOZL)
      • +Bentley AutoPIPE Vessel (powered by Microprotol)
      • +Bentley PlantFLOW
      • +Bentley PULS
    • Multi-lingual announcement from BENTLEY TECHNICAL SUPPORT.
    • Working at Home with AutoPIPE
    • +AutoPIPE Brand Learning Resources
    • +Attend a live meeting with an AutoPIPE Analyst

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

    05a. What are the following Database files used for in the AutoPIPE folder?

    Applies To
    Product(s): AutoPIPE,
    Version(s): ALL
    Area: Library
    Original Author: Bentley Technical Support Group

    Problem:

    What are the following Database files used for in the AutoPIPE folder

    asme2010.mdb, Flange_User_Data.mdb, FlangeDimLib.mdb, PipeLink.mdb, tempinp.mdb, tempres4.mdb, tempres5.mdb, tempres6.mdb, tempres7.mdb, USMapSsS1.mdb

    Also, I would like to know which of the mdb data files within the Autopipe\Templates directors is used as a template for the result database used by the export routine.

    Solution:

    Program files and definitions:

    File name Definition / Usage
     asme2010.mdb Flange analysis material library file which contains the following data for the standard ANSI B16.5 and 16.47 flanges:
     FlangeDimLib.mdb
     Flange_User_Data.mdb The ANSI Check Pressure Data dialog can be used to define and/or modify user-defined Pmax data when accessed using the "User Pmax" button on the Flange Analysis dialog
     PipeLink.mdb Information used during Exporting/ Importing model with STAAD.
     tempinp.mdb
     tempres4.mdb The Code Stresses grid below uses a specific style sheet. The results for this grid Group 1 -  15 is based on the Stress table defined in these MDB files.
     tempres5.mdb
     tempres6.mdb
     tempres7.mdb
     USMapSsS1.mdb The Static Seismic ASCE-7 2010 code library look up table for spectral accelerations based on map location 

    As mentioned in the online help:

    The results grid data is stored in an MS Access 97 database MDB file. The MDB file is organized into six database tables equivalent to the result grid Tabs of Displacement, Force/Moment, Anchor, Support, and Code Stresses. An additional database table called Result Info stores company name, piping code and revision information.

    To enable the user to save a "snap shot" of the current model results to a specified filename with file extension "MDB", an option "Results Database(*.mdb)" has been added to the File > Export menu. When this command is executed, the result data for all five results types shall be written to the MDB file. 

    Furthermore:

    A. The formatting of the result grids is controlled by the following style sheets:

    Displacement - stored in the "autopipe.diq" file.

    Force/Moment - stored in the "autopipe.fmq" file.

    Anchor - stored in the "autopipe.req" file.

    Support - stored in the "autopipe.suq" file.

    Stresses - stored in the "autopipe.st1" to "autopipe.st10" files.

    B. The Results MDB file is derived from one of three template files - Tempres4.mdb, Tempres5.mdb, or Tempres6.mdb. The difference between these MDB files is the field definitions for the Stress Table corresponding to three groups of piping codes. Tempres4.mdb will be used for all piping codes except BS 7159 and the General piping codes. Tempres5.mdb will be used for the BS 7159 piping code only. Tempres6.mdb will be used for the General piping code only.

    The Code Stresses Grid is formatted based on one of nine different style sheet files depending on the piping code - "autopipe.st1", to "autopipe.st10". The different style sheets are required because of code dependent column titles and copied to the working code style sheet "autopipe.stq".

    Note, in the next version of AutoPIPE (v09.06.02.xx and higher) there will be major changes to the output report format and creating custom reports. 

    See Also

    Libraries - AutoPIPE

    Bentley AutoPIPE

    • AutoPIPE
    • Library
    • material
    • Share
    • History
    • More
    • Cancel
    • Mike Dattilio Created by Bentley Colleague Mike Dattilio
    • When: Wed, Dec 3 2014 6:21 PM
    • Mike Dattilio Last revision by Bentley Colleague Mike Dattilio
    • When: Thu, Aug 2 2018 12:31 PM
    • Revisions: 3
    • 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