Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
AutoPIPE
  • Product Communities
  • More
AutoPIPE
AutoPIPE Wiki SQLite Report Manager - AutoPIPE Technology Preview
    • Sign in
    • -Pipe and Vessel Stress Analysis - Wiki
      • +ADL PIPE
      • -Bentley AutoPIPE
        • ++Table Of Contents - AutoPIPE Wiki page
        • +- General Information about AutoPIPE
        • +-NEW User Guide - TIPs - FAQ - RSS Newsfeed - AutoPIPE
        • +ATS and Batch Processing - 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..)
          • +01.Critical and High issues logged in AutoPIPE:
          • -02. Enhancements Requests and Logged Defects 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...
        • +Libraries - AutoPIPE
        • +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
        • +Settings - AutoPIPE
        • +Stress Isometrics - AutoPIPE
        • +Technology Productivity Capabilities
        • +Warnings, Errors, Crashed, Confirm, etc.. messages in AutoPIPE
        • +~ Technical Support - AutoPIPE
      • +Bentley AutoPIPE Nozzle (WinNOZL)
      • +Bentley AutoPIPE Vessel (powered by Microprotol)
      • +Bentley PlantFLOW
      • +Bentley PULS
    • Multi-lingual announcement from BENTLEY TECHNICAL SUPPORT.
    • +Training - Webinar - Help
    • Working at Home with AutoPIPE
    • +~ Attend a live meeting with an AutoPIPE Analyst

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

    SQLite Report Manager - AutoPIPE Technology Preview

    Applies To
    Product(s): AutoPIPE
    Version(s): CONNECT
    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: Tools > Report Manager > Report Manager  command

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

    AutoPIPE Report Manager

    Overview:

    Users now have more power to create data reports with the information that is important to their teams with the new SQLite DB export capability and the AutoPIPE Report Manager.

    Limitations

    The following are the limitations associated with this Technology Preview.

    • On the Create Report tab, the < filter is not available.

    • All default supports reports require at least one un-designed hanger selection result to be available.

    • Unit labels are missing for same tables.

    • No aggregate functions like Max, Min, and AVG are available on the Create Report tab and can be defined only by direct SQL input.

    • No Group By or Sort By options are available on the Create Report tab and can be defined only by direct SQL input.

    • Only a single filter per column is available on the Create Report tab; however, users can define additional filters only in direct SQL input.

    Sample Workflow

    1. Select File > Import/Export > Export > SQLITE Database (*.db) to display the Export to SQLITE Database dialog.



    2. Enable the Select All check-box to select all data to be exported. Enabling this check-box automatically enables the Input, Output, and Hanger Selection check-boxes.

    3. Enable the Input check-box to export input data only.

    4. Enable the Output check-box to export output data only.

    5. Enable the Hanger Selection check-box to export the selected hanger data only.

    6. Disable the Open Database in AutoPIPE Report Manager check-box.

      NOTE: Enabling the Open Database in AutoPIPE Report Manager check-box automatically opens the AutoPIPE Report Manager when the export is completed. If you have enabled this option, continue with Step 9.

    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).



    8. Select Tools > Report Manager > Report Manager to display the AutoPIPE Report Manager.



    9. Press the Browse button adjacent to the Source File field to display the Open dialog.



    10. Select the appropriate database file (*.db), then press Open.

    11. Select the Default Reports tab to display a list of fixed (read-only) reports.

      NOTE: All reports require that an un-designed hanger is present in the system and hanger selection is performed.



    12. Select the Custom Reports tab to display a list of custom reports (saved SQL queries).



    13. Select the SQL tab to enter a custom SQL query.



    14. Select the Create Report tab to create a custom report. For this sample workflow, you will create a custom report for Gravity displacement < -0.1.



    15. Select Displacement Data from the Choose Tables/Columns list, then press Add Table to next selection for report generation.



    16. Expand the Displacement Data column within the Selected Tables/Columns list, then select the Translation_X table and press Remove Table/Column from this selection .

    17. Repeat this process and remove the Translation_Z, Rotation_X, Rotation_Y, and Rotation_Z tables.



    18. Select Load_Combination from the Selected Tables/Columns list, then press Add/Modify Filter to display the Filter Condition dialog.



    19. Select LIKE from the drop-down pick-list, then type GR in the adjacent field, then press OK.



    20. Select Translation_Y from the Selected Tables/Columns list, then press Add/Modify Filter to display the Filter Condition dialog.

    21. Select <= from the drop-down pick-list, then type 0.1 in the adjacent field, then press OK.



    22. Press Generate Report. Once the report generation has completed, a status message is displayed within the status bar.



    23. The custom report (.xlsx) is exported to the same directory as the current model file and uses the name of the model file (e.g. MODELNAME_JoinsReport.xlsx).



    To watch the on-demand webinar "Maximizing AutoPIPE Standard and Custom Reporting Capabilities", click here.

    See Also

    AutoPIPE Technology Previews

    Bentley AutoPIPE

    • Technology Preview
    • Report Manager
    • AutoPIPE
    • Share
    • History
    • More
    • Cancel
    • Mike Dattilio Created by Bentley Colleague Mike Dattilio
    • When: Wed, Mar 15 2017 12:19 PM
    • JamieP Last revision by Bentley Colleague JamieP
    • When: Fri, Sep 18 2020 12:15 PM
    • Revisions: 9
    • 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

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