USB-logging Manual - this example is for Clotho
It is possible to log essential data in a SQLite file. To do that there are the following prerequisites
- The time after switch on has to be set.
- Plug in a FAT32 formatted USB-flash. After max 10 seconds the logging will start on an internal file.
Every hour a copy of the internal file "clothbk.sqlite" will be copied to the USB flash. A logging file which maybe already is there will be moved to "cloth1bk.sqlite", if such also is present it will be overwritten.
When the internal logging file reach 150Mb (It takes days) the log file added a suffix will be copied to the USB flash. Then the logging will be reset and restarted. The suffix is a serial number which is increased every time the logging file reach 150Mb.
The order of the files is:
|
clothbk2.sqlite |
The newest logfile for the last 150Mb created |
|
clothbk1.sqlite |
Logfile for the first 150Bb created |
|
clothbk.sqlite |
Log for the last hour completed, can be newer than clothbk2.sqlite |
To stop the go to the logging screen press stop and follow the instructions until you can eject and remove the USB flash. During the stop process a copy similar to the hourly backup is made to the USB-flash.
All the essential data is logged at least once at the beginning, here after only when the data has changed and the scheduled time has passed. We have 2 tables scheduled like this:
|
Positions |
Everery second |
|
main |
Every 10 seconds |
Table main
All data has PRG as prefix
supplyP : REAL (32bit) R
Supply pressure
Unit: mbar
vacuum : REAL(32 bit) R
Supply vacuum
Unit: mbar
For the 2 channels pc[1] is left channel and pc[2] is right. Only values for channel 1 is shown.
pc[1].AI.running_min : REAL(32 bit) R
Count of running min. How long time the device has been switched on.
Unit : minutes.
pc[1].Flow_Visualisation_0.avg_flow10min_visu : REAL (32 bit)
Average flow measured over 10 min
Unit: ml/min
pc[1].Flow_Visualisation_0.volume_visu :REAL (32 bit)
Total volume conveyed
Unit : ml
pc[1].RepCONT.RepTotal :DINT (32bit)
Positive number counts the amount of cycles
Unit: none
pc[1].RepCONT_1.RepTotal :DINT (32bit)
Not in use
Unit: none
pc[1].RepCONT1.RepTotal :DINT (32bit)
Not in use
Unit: none
pc[1].RepCONT.RepBeforeCleaning: INT (16 bit)
Positive number. Shows how many cycles are left before next cleaning.
Unit: none
pc[1].RepCONT1.RepBeforeCleaning: INT (16 bit)
Not in use
Unit: none
pc[1].RepCONT1.RepBeforeCleaning: INT (16 bit)
Not in use
Unit: none
pc[1].RepMin_visu :REAL(32bit)
Pump cycles per min.
Unit : minutes
pc[1].Velocity_0.LastCleaningMeterSec:REAL (32 bit)
The velocity for last cleaning.
Unit: meters/sec
pc[1].Velocity_0.LastHarwestMeterSec: REAL (32 bit)
The velocity for last harwest
Unit: meters/sec
Table Positions
pc[1].AI1.pos : REAL (32 bit)
The position of the membrane
Unit : no unit.
pc[1].Flow_Visualisation_0.speed_ml_min_visu : REAL (32 bit)
Real time volume
Unit: ml/min
pc[1].POS_CONT.OUT : REAL (32bit)
Position of membrane
Unit : mm
pc[1].scaled :REAL (32 bit)
Working pressure. Drive gas
Unit: mbar
The below photo illustrate the use of DB Browser for SQLite file data interpretation
