at first glance looks ok to me -
but what I would do is:
download and install sqlitebrowser (suso apt-get install sqlitebrowser)
start it in update mode
sudo sqlitebrowser /var/weewx/weewx.sdb
and then go to your time stamp and add the values manually in the database
(don't forget to move the cursor to another field once you have filled
in your new data before pressing the write changes button in the menu:
File --> write changes)
also, check your database entries for rain, they may be in inches, so
the 12.6 mm need to be divided by 25.4 before entering into the database
field)
afterwards run wee_database (between the archiving times !)
sudo wee_database --rebuild-daily --date=2023-06-17
after the next archiving cycle the rain data should show (in the weekly
and monthly view)
you may have to delete the weekly and monthly pictures from your
reporting folder as weewx creates new entries only every half-day or
daily for the longer periods beyond daily.
Maybe your update worked but only the weekly/monthly pictures and
high/low data were not updated in the report yet
a restart of weewx should not be needed
On 20.06.2023 08:04, Δημήτρης Βήχος wrote:
here is me commands in terminal . trying to plus 12.1 missing mm in
17 july total rainfall
metfm@metfm:~$ sudo sqlite3 /var/weewx/weewx.sdb
[sudo] password for metfm:
SQLite version 3.34.1 2021-01-20 14:10:07
Enter ".help" for usage hints.
sqlite> select datetime, datetime(dateTime, 'unixepoch','localtime'),
rain from archive where dateTime > 1686881600 and dateTime <= 1686981600
...> update archive set rain=12.6 where dateTime = 1686975900
...> .quit
...>
metfm@metfm:~$ sudo wee_database --rebuild-daily --from=2023-06-17
--to=2023-06-17
[sudo] password for metfm:
Using configuration file /etc/weewx/weewx.conf
Using database binding 'wx_binding', which is bound to database
'archive_sqlite'
Daily summary for 2023-06-17 will be rebuilt.
Proceed (y/n)? y
Rebuilding daily summaries in database 'weewx.sdb' ...
Processed 276 records to rebuild 1 daily summary in 0.12 seconds
Rebuild of daily summaries in database 'weewx.sdb' complete
metfm@metfm:~$ sudo /etc/init.d/weewx start
Starting weewx (via systemctl): weewx.service.
metfm@metfm:~$
something missing? something im doing wrong? the exetra mm never shows
in weewx restarting and updating.
Στις Σάββατο 17 Ιουνίου 2023 στις 12:11:40 μ.μ. UTC+3, ο χρήστης
Stefanos Kalaitzis έγραψε:
First find the range of time(epoch) that you want to add the rain
Enter to weeex.sdb
sudo sqlite3 /home/weewx/archive/weewx.sdb
Then check what values your station recorded
select datetime, datetime(dateTime, 'unixepoch','localtime'),
rain from archive where dateTime > 1686881600 and dateTime <=
1686981600;
Then correct the time you want
For example
update archive set rain=1.0 where dateTime = 1686975900;
Then exit the db
.quit
Stop weewx
After all corrections rebuild the data base for that day
sudo /home/weewx/bin/wee_database --rebuild-daily
--from=2023-06-17 --to=2023-06-17
Start weewx
Thats what i am doing when i have to add some missing mm in my db
Στις Σάβ, 17 Ιουν 2023, 11:42 ο χρήστης Δημήτρης Βήχος
<[email protected]> έγραψε:
i want like to add some mm to my daily rainfall beacuse after
power loss , my console (fine offset) have 10mm above the
weewx after the power on again.
i had loss 10mm in my daily rain.
thank you!
--
You received this message because you are subscribed to the
Google Groups "weewx-user" group.
To unsubscribe from this group and stop receiving emails from
it, send an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/e96ce7e9-1085-46f6-adf4-b82275bf4df4n%40googlegroups.com
<https://groups.google.com/d/msgid/weewx-user/e96ce7e9-1085-46f6-adf4-b82275bf4df4n%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
You received this message because you are subscribed to the Google
Groups "weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/1f9b1e17-6df0-4bc5-93b6-159f33bd1d12n%40googlegroups.com
<https://groups.google.com/d/msgid/weewx-user/1f9b1e17-6df0-4bc5-93b6-159f33bd1d12n%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
You received this message because you are subscribed to the Google Groups
"weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/a553e788-a0c1-9796-8fb4-ca77e7c3e035%40gmail.com.
