Page 1 of 1
Correct DATAS
Posted: Thu 09 Dec 2021 6:35 am
by courtil
Hello everyone,
My rain gauge seems out of use (probably ILS ..)
The display of the rain is false on my cumulusmx
I want to correct this error, where to start in the datas?
Thank you for your information
Regards
Michel says Courtil
Re: Correct DATAS
Posted: Sat 11 Dec 2021 6:38 pm
by Gyvate
You can only change past data. There different places where data is written.
All are in .../CumulusMX/data
1. cumulusmx.db - a sqlite3 database
for making changes you need a tool like sqlitebrowser which, depending on the operation system of your CMX installation, will need to be run with administrative rights (Windows) or with root right (linux; either # or sudo). Then, inside the tool you can make changes to the data fields of the affected records either manually or via SQL commands
2. log files:
CMX has to two monthly changing log files: mmmYYlog.txt for the basic sensors and ExtraLogYYYYMM.txt for the extra sensors: for December 2021 that would be (depending on your locale) Dec21log.txt and ExtraLog202112.txt (be aware that under Linux the file names are case sensitive, where under Windows it doesn't matter)
An entry into cumulusmx.db and the log files is written depending on the logging interval you have chosen in your settings.
3. initial files and record files
there are also initial files which usually contain maximum values and time stamps for the time span they stand for: today.ini, yesterday.ini, month.ini etc. which might need to be changed too - as especially today.ini is updated regularly while CMX is running, changes to them will only work when made while CMX is down.*
Of course you'll have to restart CMX asap not to lose records.
4. depending on your situation you might have to change the summary file entries in dayfile.txt (one summary entry per day).
For the structure of the logging files, see their header description in the CumulusMX folder: monthlyfileheader.txt, dayfileheader.txt, extrafieheader.txt
Regarding the sensor logging files,
single changes can be made from within the CMX administration interface (menu item data logs), for a bigger amount of data you need a text editor (notepad, notepad++ for Windows, nano or geany or vi for Linux).
* make sure you restart before the next logging interval or you will have missing records (which you can later too - but you have to save the file before the next update which always occurs on the full minute - you can also prepare the changes in a separate file and and the new ones by copy and paste in between the logging intervl and then save before the next update occurs - either on the minute or on the 5th minute etc. depending on the interval chosen.
changes made to cumulusmx.db with the sqlitebrowser can be done any time once the database is loaded. CMX doesn't need to be down. Make sure you save changes not in parallel with CMX updating the databaseon the top of the minute. Nothing bad should happen, only sqlitebrowser might not save the changes you made because the database is locked by CMX - and you have to wait for this lock to be released (usually after a few seconds).
Hope that gives you some indication where and how to do what to correct your wrong data.
especially for the rain data, have a look into the MXdiags files (logging switched on !) - then you can see how and from where CMX decides to take the rain count information at startup. The dayfile rain sum will be added for the monthly and yearly sums - so corrections may also be needed there as already generally mentioned earlier.
Re: Correct DATAS
Posted: Sun 12 Dec 2021 7:18 am
by courtil
Hello,
A big thank you for your information that has to represent a long work of research.
cordially
Michel says Courtil