Hi to all,
is it possible to edit rain data on rain block?
If yes, how to?
Thanks in advance.
Regards,
Alessandro
How to edit rain data block
- i_fiorentino
- Language Admin
- Posts: 81
- Joined: Sun Aug 27, 2017 11:31 pm
- Location: Pistoia, Tuscany, IT
- Station model: Davis Vantage Vue
- Software: Weather Display
- Contact:
-
- Expert
- Posts: 862
- Joined: Tue Jan 12, 2021 8:03 am
- Location: Italy
- Station model: WH2650
- Software: WH2650 (direct upload)
- Contact:
Re: How to edit rain data block
Not sure to understand your question, but values shown in the rain block are calculated from the records stored in the database.
So altering the database you can modify these values ( for example using the database -> edit data from the meteotemplate control panel, but it could be a quite long task ).
What are you trying to do?
So altering the database you can modify these values ( for example using the database -> edit data from the meteotemplate control panel, but it could be a quite long task ).
What are you trying to do?
- i_fiorentino
- Language Admin
- Posts: 81
- Joined: Sun Aug 27, 2017 11:31 pm
- Location: Pistoia, Tuscany, IT
- Station model: Davis Vantage Vue
- Software: Weather Display
- Contact:
Re: How to edit rain data block
Hi Davide,
thanks for reply.
I would edit month (and year) rain because that data is wrong.
It shown much more rain than real because a bird (tortora) nested on main rain gauge all summer
I've tried to edit last line of db but without success.
Would i use phpmyadmin?
Regards,
Alessandro
thanks for reply.
I would edit month (and year) rain because that data is wrong.
It shown much more rain than real because a bird (tortora) nested on main rain gauge all summer
I've tried to edit last line of db but without success.
Would i use phpmyadmin?
Regards,
Alessandro
-
- Expert
- Posts: 862
- Joined: Tue Jan 12, 2021 8:03 am
- Location: Italy
- Station model: WH2650
- Software: WH2650 (direct upload)
- Contact:
Re: How to edit rain data block
In these cases phpmyadmin is your friend.
You may try something like this ( substitute the appropriate starting and ending dates ):
P.S.
It is always a good idea to make a backup copy of the database
You may also try the 'Simulate query' button ( before the 'Go button ) to verify that results are reasonable (i.e. you should have roughly 288 results/day )
You may try something like this ( substitute the appropriate starting and ending dates ):
Code: Select all
UPDATE alldata SET RR=0,R=0 WHERE DateTime >= '2022-08-08 00:00:00' AND DateTime <= '2022-08-08 23:55:00'
It is always a good idea to make a backup copy of the database
You may also try the 'Simulate query' button ( before the 'Go button ) to verify that results are reasonable (i.e. you should have roughly 288 results/day )