3. Follow the procedure given in the Wiki *Cleaning up old 'bad' data <https://github.com/weewx/weewx/wiki/Cleaning-up-old-'bad'-data>*. Be sure to work off a copy of your data!
To zero out all rain values for the day 21-04-2017 in your time zone, the SQL statement for SQLITE would be: cd /var/lib/weewx echo "UPDATE archive set rain = 0 WHERE dateTime > 1492725600 and dateTime <= 1492812000;" | sqlite3 /var/tmp/backup.sdb If you wish to change only large values (how large?), say over .1, then use echo "UPDATE archive set rain = 0 WHERE dateTime > 1492725600 and dateTime <= 1492812000 AND rain > 0.1;" | sqlite3 /var/tmp/backup.sdb If you are using MySQL, the procedure is similar. If you can't figure it out, then you should stick with SQLITE, which is easier to administer. 4. I like https://www.epochconverter.com/ -tk On Sat, Apr 22, 2017 at 4:08 AM, Massimiliano Neri <[email protected]> wrote: > > Hi thomas, 1) The time zone for this season is UTC + 02:00 2) First > installed the dependency packages autonomously, then installed weewx from > the .DEB repository. I installed both, Sqlite3 and MySQL. 3) I would like > to know how to reset the value of rain all day long, and how to change a > single value. 4) Also the 'datetime' I see is UNIX time? Do you know of an > online portal to calculate it? > > 2017-04-22 0:29 GMT+02:00 Thomas Keffer <[email protected]>: > >> We need more information than that. >> >> What time zone? UTC+02:00? >> >> How did you install? Using setup.py, or Debian? Or, something else? >> >> Do you want to zero out all rain data for the day? Or, is there just one >> bad value? If just one value, roughly how big is the value? >> >> Try this and tell me what you get >> >> cd /var/lib/weewx >> echo "SELECT dateTime, rain FROM archive WHERE dateTime > 1492725600 and >> dateTime <= 1492812000 AND rain > 0;" | sqlite3 weewx.sdb >> >> (NB: 1492725600 is midnight 21-04-2017, and 1492812000 is midnight >> 22-04-2017 in the time zone UTC+02:00.) >> >> -tk >> >> >> -tk >> >> >> On Fri, Apr 21, 2017 at 3:09 PM, Massimiliano Neri <[email protected]> >> wrote: >> >>> >>> Hello Thomas, I would like to reset the content of the rain of the day >>> on 21-04-2017, how can I make the SQL statement? >>> >>> >>> Il giorno venerdì 21 aprile 2017 21:00:32 UTC+2, Massimiliano Neri ha >>> scritto: >>>> >>>> I am using Weewx for 2 weeks, I need to correct the amount of rain fall, >>>> either daily, monthly and annually. You can tell me the procedure for >>>> making these fixes. 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]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "weewx-user" group. >> To unsubscribe from this topic, visit https://groups.google.com/d/to >> pic/weewx-user/EQ3Cuyxx7Mg/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> [email protected]. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > *Massimiliano Neri * > Via del Castello 4 - 05015 Fabro (TR) - ITALY. > > Phone: +39 339 1997334 <+39%20339%20199%207334> > Fax: +39 0763 831347 <+39%200763%20831347> > > E-mail PEC: [email protected] > > Visita il sito: > > http://meteofabro.altervista.org > <http://meteofabro.altervista.org/plugins/stickers/sticker800_170.php?parameter=T&text=Hello&color1=grey&color2=teal> > > > -- > 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]. > For more options, visit https://groups.google.com/d/optout. > -- 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]. For more options, visit https://groups.google.com/d/optout.
