Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
AutoPIPE
  • Product Communities
AutoPIPE
AutoPIPE Wiki Export SQLite Database - AutoPIPE Technology Preview
    • Sign In
    • -Pipe and Vessel Stress Analysis - Wiki
      • -.Bentley AutoPIPE
        • +a. General Information about AutoPIPE
        • +b. NEW User Guide for AutoPIPE
        • +c. Technical Support - AutoPIPE
        • +d. Download - Install - Release Notes - AutoPIPE
        • -e. Features and Bugs in AutoPIPE
          • +01.Critical and High issues logged in AutoPIPE:
          • -02. Featured and Bugs Logged for AutoPIPE
            • -"AutoPIPE Technology Previews"
              • ASME B31J (R23) - AutoPIPE Technology Preview
              • Consider Upheaval Buckling - AutoPIPE Technology Preview
              • Export SACS SQLite Database(*.db) - AutoPIPE Technology Preview
              • Export SQLite Database - AutoPIPE Technology Preview
              • Input and output reports are available in the SQLite DB format - AutoPIPE Technology Preview
              • Microsoft Word Input Data Listing - AutoPIPE Technology Preview
              • Microsoft Word Results Reports - AutoPIPE Technology Preview
              • SQLite Report Manager - AutoPIPE Technology Preview
              • Support Optimization - AutoPIPE Technology Preview
              • Two-way interoperability between SACS and AutoPIPE with change management by using Structural Synchronizer (aka ISM). - AutoPIPE Technology Preview
              • Valve database - Technology Preview
            • +01. Reporting enhancement & defects requests for AutoPIPE
            • 02. Wind Enhancements and Defects for AutoPIPE
            • +03. Piping Codes Enhancements & Defects for AutoPIPE
            • 04. Wave Enhancements & Defects for AutoPIPE
            • 05. Export Enhancements & Defects for AutoPIPE
            • 06. Import Enhancements & Defects for AutoPIPE
            • +07. Flange Analysis Enhancements & Defects for AutoPIPE
            • 08. Toolbars and Menu Enhancements & Defects for AutoPIPE
            • 09. Dynamic Analysis Enhancements & Defects for AutoPIPE
            • 10. Static Analysis Enhancements & Defects for AutoPIPE
            • 11. Pipe and Piping Components Enhancements & Defects for AutoPIPE
            • 12. Soil Load Enhancements & Defects for AutoPIPE
            • 13. Settings Enhancements & Defects for AutoPIPE
            • 14. "View" command Enhancement & Defects requests for AutoPIPE
            • 15. "Edit" Commands Enhancements & Defects for AutoPIPE
            • 16. Grids (Input & Results) Enhancements & Defects requests for AutoPIPE
            • 17. AutoPIPE Operating System Software Enhancements & Defects
            • 18. Support Enhancements & Defects in AutoPIPE
            • 19. Library Enhancements & Defects in AutoPIPE
            • 20. Rotating Equipment enhancements & Defects requests in AutoPIPE
            • 21. Combinations Dialog Enhancements & Defects in AutoPIPE
            • 22. Stress Isometric - Enhancements & Defects for AutoPIPE
            • 23. "TTA Analysis" Enhancements & Defects logged for AutoPIPE
            • 24. "Graphic" Enhancements & Defects for AutoPIPE
            • 25. "X-tra Data" command Enhancement & Defects requests for AutoPIPE
            • 26. Beams Codes Enhancements & Defects for AutoPIPE
            • 28. Hydrotest Enhancements & Defects for AutoPIPE
          • 03. QA Error Reports for AutoPIPE
          • 04. AutoPIPE's Most Wanted...
        • +f. License AutoPIPE -
        • +g. System Messages: Warnings, Errors, Crashed, Confirm, etc.. in AutoPIPE
        • h. QA&R program for AutoPIPE
        • i. Security
        • +❤︎ Support Solutions and FAQ's in AutoPIPE
      • +.Bentley AutoPIPE Vessel (powered by Microprotol)
      • +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. 

    Export SQLite Database - AutoPIPE Technology Preview

    Applies To
    Product(s): AutoPIPE
    Version(s): CONNECT
    Environment: N/A
    Area: Technology Preview
    Original Author: Bentley Technical Support Group
    Date Logged
    & Current Version
    March. 2017
    11.00.00.22


    Notes:

    a. If using AutoPIPE CONNECT 11.00.00.10 or higher, this feature is already available in the program: File> Import/Export> Export> SQlite database (*.db)

    b. If using AutoPIPE CONNECT 10.x log a service request asking for instructions to enable this feature. 

    Export SQLite Database

    Overview:

    The Export SQLite Database Technology Preview enables users to export input, output and hanger selection data to an SQLite database.

    Limitations

    The following are the limitations associated with this Technology Preview.

        • Soil Properties, Load Summary, and Extended Component input reports are not exported.

        • Code Compliance, Stress Summary, Equipment, and Stress Indices output reports are not exported.

        • Options are not provided to open recent exported databases.

    Sample Workflow

    1. Select File > Export > SQLITE Database (*.db) [Technology Preview] to display the Export to SQLITE Database dialog 

    2. Enable the Select All checkbox to select all data to be exported. Enabling this checkbox automatically enables the Input, Output, and Hanger Selection checkboxes.

    3. Enable the Input checkbox to export input data only.

    4. Enable the Output checkbox to export output data only.

    5. Enable the Hanger Selection checkbox to export the selected hanger data only.

    6. Enable the Open Database in AutoPIPE Report Manager checkbox to automatically open the AutoPIPE Report Manager when the export is completed.

    7. Press OK. The SQLite database file is exported to the same directory as the current model file and uses the name of the model file (e.g. MODELNAME.DB). 

    Additional Information

    Please see the following AutoPIPE help section:

    Help > Contents> Contents Tab> Bentley AutoPIPE> Command Reference> File Commands> Import/Export Group> Export t SQLITE Database (*.db)

     

    See Also

    AutoPIPE Technology Previews

    Bentley AutoPIPE

    • Technology Preview
    • Export
    • AutoPIPE
    • Database
    • SQLite
    • Share
    • History
    • More
    • Cancel
    • Mike Dattilio Created by Bentley Colleague Mike Dattilio
    • When: Wed, Mar 15 2017 2:32 PM
    • Mike Dattilio Last revision by Bentley Colleague Mike Dattilio
    • When: Thu, Nov 1 2018 11:23 AM
    • Revisions: 6
    • 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