Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
RAM | STAAD | ADINA
  • Product Communities
RAM | STAAD | ADINA
RAM | STAAD | ADINA Wiki Appendix B: RAM Structural System data available through SQLite - Technology Preview
    • Sign In
    • -RAM | STAAD | ADINA Wiki
      • +ADINA
      • +iTwin Analytical Synchronizer_
      • +Structural Analysis Support Solutions
      • +RAM Concept
      • +RAM Connection
      • +RAM Elements
      • +RAM SBeam
      • -RAM Structural System
        • +RAM Structural System - Feature Articles
        • RAM Structural System V17.0 License Consolidation
        • -RAM Structural System Release Notes
          • RAM SS 2023 Minor Update 1 Release Notes
          • RAM SS 2023 Release Notes
          • RAM SS V13.0 Release Notes
          • RAM SS V13.0.2 Release Notes
          • RAM SS V13.0.3 Release Notes
          • RAM SS V13.0.4 Release Notes
          • RAM SS V14.00 Release Notes
          • RAM SS V14.00.01 Release Notes
          • RAM SS V14.00.02 Release Notes
          • RAM SS V14.00.03 Release Notes
          • RAM SS V14.00.04 Release Notes
          • RAM SS V14.02 Release Notes
          • RAM SS V14.02.02 Release Notes
          • RAM SS V14.03 Release Notes
          • RAM SS V14.03.01 Release Notes
          • RAM SS V14.03.02 Release Notes
          • RAM SS V14.03.03 Release Notes
          • +RAM SS V14.04 Release Notes
          • RAM SS V14.04.01 Release Notes
          • RAM SS V14.04.02 Release Notes
          • RAM SS V14.04.03 Release Notes
          • RAM SS V14.04.05 Release Notes
          • RAM SS V14.04.06 Release Notes
          • RAM SS V14.04.07 Release Notes
          • RAM SS V14.05.00 Release Notes
          • RAM SS V14.05.01 Release Notes
          • RAM SS V14.05.02 Release Notes
          • RAM SS V14.05.03 Release Notes
          • RAM SS V14.05.04 Release Notes
          • RAM SS V14.06.00 Release Notes
          • RAM SS V14.06.01 Release Notes
          • RAM SS V14.06.02 Release Notes
          • RAM SS V14.07.00 Release Notes
          • RAM SS V14.07.01 Release Notes
          • RAM SS V15.00 Release Notes
          • RAM SS V15.01 Release Notes
          • RAM SS V15.02 Release Notes
          • RAM SS V15.03 Release Notes
          • -RAM SS V15.04 Release Notes
            • Appendix A: Analytical Insights - Technology Preview
            • Appendix B: RAM Structural System data available through SQLite - Technology Preview
            • Appendix C: Product Licensing FAQ
          • RAM SS V15.05 Release Notes
          • RAM SS V15.06 Release Notes
          • RAM SS V15.07 Release Notes
          • RAM SS V15.08 Release Notes
          • RAM SS V15.09 Release Notes
          • RAM SS V15.11 Release Notes
          • RAM SS V16.00 Release Notes
          • RAM SS V16.00.01 Release Notes
          • RAM SS V16.01 Release Notes
          • RAM SS V17.00 Release Notes
          • RAM SS V17.00.01 Release Notes
          • RAM SS V17.01 Release Notes
          • RAM SS V17.01.01 Release Notes
          • RAM SS V17.02 Release Notes
          • RAM SS V17.02.01 Release Notes
          • RAM SS v17.03 Release Notes
          • RAM SS v17.03.01 Release Notes
          • RAM SS v17.04 Release Notes
          • RAM SS v17.04.01 Release Notes
          • RAM SS v17.04.02 Release Notes
          • RAM SS v17.04.03 Release Notes
        • +RAM Structural System Support Solutions
        • +Known Issues in Ram Structural System
        • +Recordings from past RAM webinars
      • +STAAD.Pro
      • +STAAD Foundation Advanced
      • +STAAD Advanced Concrete Design (RCDC)
      • +STAAD.building
      • +STAAD RCDC FE
      • +Scenario Services
      • +STAAD.offshore
      • +Limcon
      • +Microstran
      • +MStower
      • +Structural Dashboard
      • +Structural WorkSuite
    • +RAM | STAAD Learning Resources
    • Simplifications to Bentley's Engineering Simulation Software Licenses

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

    Appendix B: RAM Structural System data available through SQLite - Technology Preview

    The RAM Data Extractor is now a fully released feature in the program. For details refer to the RamManager.pdf documentation, Appendix D.

    The information below is maintained for users of v 15.04. Technology Preview – RAM Structural System data available through SQLite

     

    Enabling the Feature

    In order to make the Data Extractor feature available for use you must edit the ramis.ini file. The file is located in the RAM Structural System directory; for normal installations this can be found at:

    C:\ProgramData\Bentley\Engineering\RAM Structural System.

     

    In the ramis.ini file there is a line in the [Testing] section that looks like:

     

    WriteDataToExternalDatabase=0

    or

    WriteDataToExternalDatabase=1

     

    A value of 0 indicates that the feature is not available; a value of 1 means the feature is available. With an editor such as Notepad modify the line so that it says WriteDataToExternalDatabase=1. This will allow data to be saved to an SQLite database which can be accessed with the report generator. If necessary the feature can be disabled by editing the ramis.ini file and modifying the line to say WriteDataToExternalDatabase=0.

     

    Description

    Two SQLite files are generated by the RAM Structural System. The first file with geometric data will be created when you exit the RAM Modeler. The second file is created in RAM Frame as part of the Analysis. To write the analysis results to SQLite, select the check box at the bottom of the dialog, "Write Results to SQLite database...":

     

     

    These files are part of the model. They are initially written to the working directory and then saved into the .rss file.

     

    A report generator that reads the SQLite database tables and creates reports in Excel has been added to the RAM Manager. The commands to run the viewer are located under the Post-Processing menu. The report generator can be run in two different ways:

    • View SQLite Report command will automatically generate a report using all the data in all the tables in the SQLite files. The report opens in Excel with one tab per table in the SQLite files.

    • SQLite Report Generator… command will launch the report generation tool providing the user with control over the generated report.

     

    When the Report manager opens, the

    available SQLite tables are listed to the left.

     

    All tables can be selected for inclusion in the report by clicking the double arrow button below the list.

     

    This will result in all table names being moved to the window on the right indicating that they will be included in the report.

     

     

     

    Tables can be added individually to a report by selecting the table and then clicking the single arrow button below the list.

     

    This will result in the single table being listed in the right-hand window indicating it will be included in the report.

     

     

     

    A report can be further refined by selected only certain fields from a table.

     

    In the left-hand window, click the + beside the table name to expose the field names.

     

    Select a field and click the single arrow button below the list.

     

    The result will be that the table name and only that field will be moved to the window on the right. Additional fields can be added.

     

    When the report is generated for this table, only the selected fields will be included.

     

     

     

    To generate a report, select the green Lightning button from the toolbar. An Excel report will be generated from the data in the selected SQLite database tables.

     

     

     

    To view the report in Excel format, select the Excel button beside the Generate button. One tab is created for each table selected from the database.

     

     

    Note, some users have experienced a slight delay or slowness when closing the Ram Modeler or other module whenever the SQLite export is activated through the ramis.ini file settings. If this becomes problematic, the option can be turned off (set WriteDataToExternalDatabase=0) and then reactivated only when needed.

    • RAM Frame
    • RAM Structural System
    • Export
    • release notes
    • 15.04
    • SQL
    • SQLite
    • Report
    • Share
    • History
    • More
    • Cancel
    • Allen Adams Created by Bentley Colleague Allen Adams
    • When: Thu, Feb 23 2017 6:55 PM
    • Seth Guthrie Last revision by Bentley Colleague Seth Guthrie
    • When: Thu, Jun 10 2021 3:26 PM
    • Revisions: 7
    • Comments: 1
    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