Analysing ThermIQ data

Shop Forums Thermiq webinterface Analysing ThermIQ data

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #8005
    Jutzi
    Participant

    ThermIQ database is located in /var/sqlite/thermiq.db. There are many tools which can be used to analyze Sqlite3 databases. I have used HeidiSQL which currently runs only in Windows. So, first you have to copy the database to a Windows machine. For that, you have to have ThermIQ and the Windows in the same network. Then mount Windows shared drive or folder to Linux folder and copy the database file to Windows folder. Instructions for instance here: https://linuxize.com/post/how-to-mount-cifs-windows-share-on-linux/
    Then you need to download HeidiSQL. I have used portable version without installing, works fine. To get access to sqlite3 databases, you need to download sqlite3 plugin, either 32 of 64-bit version from here: https://www.sqlite.org/download.html. After downloading, copy the dll and def files to HeidiSQL plugin folder.
    With HeidiSQL you can do pretty much all SQL operations and analyze the data. I have also copied data to excel for easier analysis.
    First you have to get access to the database using session manager from File menu.

    Example view of RAW data:

    To get this, first look at the Table tab to see the field names. In the Data tab you can select with right mouse button which fields are visible. Filtering the data is easy by using the filter command. Copying data to excel is done with right mouse button in the data area. Select “Export grid” and the export directly to a .csv file or clipboard.
    Notice the there is a limit how many rows can be selected to the grid. There is a “Show all” button which can extend the amount of rows to defined maximum. You can change the default from settings (Tools – Preferences – Grid formatting – Rows per pages and maximum).
    There is also limit how many lines can be imported to Excel. Csv file contain them all, but Excel cuts extra off.
    I have also used python for more advanced analysis. I will post some examples later.

    4

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.