Ok that line of code was far better to establish the error, thanking you. ,, I have performed the guide from " Clean Up Old Bad Data" and finger crossed that when it recycles the update it will be repaired,, Toes crossed too....
On Tuesday, 25 September 2018 23:30:11 UTC+12, Thomas Keffer wrote: > > It's hard to read, but that's probably right. You can confirm my just > selecting the most relevant columns. Try this for your SELECT statement: > > echo "SELECT dateTime, datetime(dateTime,'unixepoch','localtime'), > rainRate from archive where rainRate > 100;" | sqlite3 > /var/tmp/datbasebu/weewx.sdb > > This print out just timestamps, the local time, and rain rates. Easier to > read. > > -tk > > On Tue, Sep 25, 2018 at 3:12 AM Glenn F <[email protected] <javascript:>> > wrote: > >> >> 1. Cheers Thomas,.... if you have time to view the attched imge and >> see if I'm in the right direction,.. I got swamped in numbers,, love a >> little clarification... >> >> >> On Monday, 24 September 2018 23:30:50 UTC+12, Thomas Keffer wrote: >>> >>> Hello, Glenn >>> >>> See the Wiki entry Clean up old "bad" data >>> <https://github.com/weewx/weewx/wiki/Cleaning-up-old-'bad'-data> and >>> see if that doesn't answer your question. If not, come back and we'll dig >>> in deeper. >>> >>> -tk >>> >>> On Mon, Sep 24, 2018 at 12:38 AM Glenn F <[email protected]> wrote: >>> >>>> It has probably been asked, and if so point me in the direction >>>> please. I'd love to delete this record, I never built an ark nor got >>>> flooded out, so would love this to show the actual , real, value.. >>>> >>>> Running a FineOffsetUSB system . >>>> >>>> Glenn.. >>>> >>>> -- >>>> 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] <javascript:>. >> 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.
