Tus neeg siv phau ntawv

10/2021 · User Manual Version 1.0 · valid from firmware version 3.1.22
41
WEBLOG 250
You can install the Firefox plugin “SQLite Manager” to get a first overview of the log database. The plugin can
be started from the firefox menu “Addons”. The next step is to connect to the downloaded database file
“log.sqlite”. The table “logentries” shows the logged meter data in the table “Browse”. You can jump to older
or newer values in the table by using the navigation buttons below the table.
The last column “unix_timestamp” contains the time point of logging in the Unix time format. The column
“sequence” numbers the postion of a data record within the reply telegram of one meter.
The value of a data record is located in the column “quantity“.
The tab “Execute SQL” allows the input of individual SQL queries. For example the query „SELECT
datetime(unix_timestamp,’unixepoch’,’localtime’),quantity FROM logentries where identifier=32700
and sequence=1“ generates a table with all log time points (date / clock local) and the respective values of
the meter with the ID “00032700” from position 1 (record 1) of its data telegram. From the menu “actions” the
generated table can be exported to a CSV file. Then you have for example the possibility to import the file
into Excel and create a graphical presentation of the values.