Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
AutoPIPE
  • Product Communities
  • More
AutoPIPE
AutoPIPE Wiki How to report Export component GUIDs to SQLite database in AutoPIPE?
    • 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"
            • -01. Reporting enhancement & defects requests for AutoPIPE
              • How to report Export component GUIDs to SQLite database in 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. 

    How to report Export component GUIDs to SQLite database in AutoPIPE?

    Applies To
    Product(s): AutoPIPE
    Version(s): ALL;
    Area:
    Date Logged
    & Current Version
    Jan. 2018
    11.02.00.08

    Problem:

    How to report Export component GUIDs to SQLite database in AutoPIPE?

    Solution:

    At the moment, Jan 2018, the program does not export the Component GUIDs to the SQLite database or output reports. This enhancement was  logged under:

    Enhancement 808544:Export component guids to SQLite database

    One workaround would be copy the support grid to MS Excel, remove all the un-necessary columns and only leave point id, support id and component guids.

    Procedure:

    1. Select Tools> Settings> Grids> 

    2. Open the input grids, choose any component tab (example support) and select everything

    2. Copy (CTL+A, CTL+C)
    3. Open MS Excel, and Paste Special (Values in excel)

    4. Remove any un-necessary columns

    5. Now you can take advantage of excel by copying this data to a different sheet on your report and then picking this up on the report column using the value of support id. You may use the VLOOKUP function or INDEX MATCH Combination

    https://support.office.com/en-us/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1

    https://stackoverflow.com/questions/35735276/excel-formula-get-value-from-another-excel-sheet-based-on-column-in-current-sh

    See Also

    Reporting enhancement & defects

    Bentley AutoPIPE

    • GUIDs
    • AutoPIPE
    • Report
    • Input Listing
    • Share
    • History
    • More
    • Cancel
    • Mike Dattilio Created by Bentley Colleague Mike Dattilio
    • When: Mon, Jan 22 2018 2:22 PM
    • Mike Dattilio Last revision by Bentley Colleague Mike Dattilio
    • When: Mon, Jan 22 2018 2:33 PM
    • Revisions: 2
    • 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