Weather diary log time
Posted: Sat 27 Nov 2021 4:09 pm
Hi Mark,
We're now into snow season so got a chance to look in the dairy.db with the SQLite browser and see that the log time is always at 19:00:00 of the day before the entry
The first line was added yesterday morning (2021-11-26) at about 9:00 am covering the 24 hour period ending at 8:00 am, and shows in the Diary calendar as November 26
The second line was added today (2021-11-27) at about 9:00 am covering the 24 hour period ending at 8:00 am, and shows in the Diary calendar as November 27
I use midnight roller - RolloverHour=0
The Cumulus.ini setting is now - SnowDepthHour=8
I use 8 as the actual CoCoRaHS snow readings and SWE are taken at 8:00 am each day for the previous 24 hours
Where does the 19:00:00 logged time on the previous day come from?
I remember that last year we had some discussion and testing to have the diary calendar post on the correct date and from what I had seen that was working fine, but hadn't noticed the DB logging date. Not a big issue or priority as I haven't added the snowfall to the current CumulusMX web template, and the 24 hour 8:00 to 8:00 details are posted on the CoCoRaHS site https://maps.cocorahs.org/?maptype=prec ... 81.4380555 but wanted to see if there are any settings to have the diary.db have the correct date if ever I learn how to extract data from the DB.
Thanks,
Paul
We're now into snow season so got a chance to look in the dairy.db with the SQLite browser and see that the log time is always at 19:00:00 of the day before the entry
Code: Select all
2021-11-25 19:00:00 Rain most of the day with snow fall after 6:00 am. Snow on the board and ground = 2.2 cm = 1.9 mm SWE 1 1 2.2
2021-11-26 19:00:00 2 cm new snow = 2.0 mm SWE 1 1 5.0The second line was added today (2021-11-27) at about 9:00 am covering the 24 hour period ending at 8:00 am, and shows in the Diary calendar as November 27
I use midnight roller - RolloverHour=0
The Cumulus.ini setting is now - SnowDepthHour=8
I use 8 as the actual CoCoRaHS snow readings and SWE are taken at 8:00 am each day for the previous 24 hours
Where does the 19:00:00 logged time on the previous day come from?
I remember that last year we had some discussion and testing to have the diary calendar post on the correct date and from what I had seen that was working fine, but hadn't noticed the DB logging date. Not a big issue or priority as I haven't added the snowfall to the current CumulusMX web template, and the 24 hour 8:00 to 8:00 details are posted on the CoCoRaHS site https://maps.cocorahs.org/?maptype=prec ... 81.4380555 but wanted to see if there are any settings to have the diary.db have the correct date if ever I learn how to extract data from the DB.
Thanks,
Paul