no data and wrong averages

[Trix]

Hi, i had a problem with my weather station sensor and i am waiting the new sensor. Actually only the pressure and the rainfall work.
I would like to know if it is possible to remove the averages of the last few days, because since the station no longer works it is always marking me temperature, humidity, wind always at 0 so every day it mark a new record in 2021.
Also the variations are wrong.
Thank you

[davidefa]

1) to filter out these values for the next days you can set a limit in the meteotemplate control panel -> main setup, limits section ( don't considers the arrows, set appropriated limits for temperature, humidity and wind, you'll have to revert this once you'll receive the new sensor ).
2) for past data, you have to delete all the past wrong data in the database ( averages are not stored, but calculated on the fly ), I'm not aware of a tool that can do this in meteotemplate, but you can do this in phpmyadmin ( I mean in the database administration tool supplied by your provider, if you choose this way make a backup copy of the db before proceeding ):

The sql command should look like the following ( change the starting and ending date/time as requested )

Code: Select all

UPDATE  `alldata` SET T=NULL, Tmax=NULL, Tmin=NULL, H=NULL, D=NULL, W=NULL, G=NULL, B=NULL, A=NULL WHERE `DateTime` >= '2021-11-24 10:00:00' and `DateTime` <= '2021-11-25 11:10:00'

the above example will delete all temperature, humidity, dewpoint, wind and apparent temperature data from 24th november 10 o'clock ( inclusive ) to 25th november 11:10 ( inclusive )
As this is a 'destructive' command always double ( end even triple ) check what you are writing before proceeding.

P.S.
I think I already said it is a good practice to make backup copy, this is only to remember ; - )

P.P.S.
You have to change the starting and ending date/time in the above example

P.P.P.S.
Please add a link to your site

rain.png (118.11 KiB) Viewed 5127 times

[Trix]

Thank you for the answer, I already changed the limits but now i modify also the temperature at 5 minimum.
I tried to view in altervista my phpmyadmin but I don't know where i must put these values and I'm afraid of making a mess!!
However my website is http://tricse.altervista.org/template/index.php so you can see better.

[davidefa]

1) select the alldata table
2) select the sql tab
3) paste the sql command
3a) modify the date/time
3b) verify everything is correct
4) press go

P.S.
To backup the database select the export tab

phpmyadmin1.png (162.39 KiB) Viewed 5114 times

[Trix]

I did it but it's always like before

[davidefa]

I think a few blocks need an update ( I think they don't cope well with missing primary sensor data, not sure, need to verify )

[davidefa]

@Trix
Not sure my message was correctly sent ( it is still in my outbox ) so I'll ad here too:

Si, l'edit dei dati tramite pannello di controllo va bene per correggere solo alcuni valori.
Per correggere molti valori 'di fila' puoi fare come ti ho spiegato nel post di alcuni giorni fa ( cioè tramite phpmyadmin, impostando le date di inizio/fine opportune ).
Con i seguenti comandi:
( per eliminare i dati del vento e temperatura apparente )
UPDATE `alldata` SET W=NULL, G=NULL, B=NULL, A=NULL WHERE `DateTime` >= '2021-11-24 10:00:00' and `DateTime` <= '2021-11-25 11:10:00'

( per eliminare i dati dell'umidità, dewpoint e temperatura apparente )
UPDATE `alldata` SET H=NULL, D=NULL, A=NULL WHERE `DateTime` >= '2021-11-24 10:00:00' and `DateTime` <= '2021-11-25 11:10:00'

( per eliminare i dati della temperatura, dewpoint e temperatura apparente )
UPDATE `alldata` SET T=NULL, Tmax=NULL, Tmin=NULL, D=NULL, A=NULL WHERE `DateTime` >= '2021-11-24 10:00:00' and `DateTime` <= '2021-11-25 11:10:00'