Thanks I will load sqlite3 so I can audit my data file. I do have one remaining problem. I don't think that it has anything to do with WEEWX but if I find the solution I will post it here because other may be affected.
I am running WEEWX on the latest 3-13-18 Stretch on a new model B+ PI. Every 24 hours I loose my wlan connection with an Expired RA. A static IP is assigned in the router. I use up to three PIs running headless and until now I have never has this problem. There have been no changes to my router or network. I posted the problem on the PI forum. I really hope there is a solution and not a work- around. On Monday, March 26, 2018 at 4:21:59 PM UTC-7, Tom Keffer wrote: > > That's good news. > > To answer your questions: > > - All plots update as often as the aggregation interval used in them. > If the interval is one day (the default for yearly plots), then it will be > once a day. > - Not all systems come with sqlite3 installed. It's a command-line > utility. On Debian systems, apt-get can be used to install it: > > apt-get install sqlite3 > > > -tk > > > On Mon, Mar 26, 2018 at 10:52 AM, William Webb <[email protected] > <javascript:>> wrote: > >> After about 24 hours the data appeared in the yearly page. Does the >> yearly page update every day rather than at the archive interval? >> >> I could not get the command "sqlite3 weewx.sdb". I don't know where >> sqlite3 is located, apparently. >> >> I guess all is well now. I would still like to know about sqlite3 >> however. >> >> On Sunday, March 25, 2018 at 4:21:43 PM UTC-7, Tom Keffer wrote: >>> >>> Welcome, Bill >>> >>> When you say "The yearly page only shows about a month worth," do you >>> mean a year plot only shows back as far as a month? Can you give us an >>> example? >>> >>> Try using sqlite3 to make sure the data that you think is in there, >>> actually is in there. >>> >>> sqlite3 weewx.sdb >>> sqlite> select datetime(min(dateTime), 'unixepoch','localtime') from >>> archive; >>> sqlite> select datetime(max(dateTime), 'unixepoch','localtime') from >>> archive; >>> sqlite> select count(dateTime) from archive; >>> >>> >>> -tk >>> >>> On Sun, Mar 25, 2018 at 1:48 PM, William Webb <[email protected]> >>> wrote: >>> >>>> Like many, I am plotting the transition to weewx from wview. I have >>>> weewx running on a spare PI with a spare weather station ( a hanger queen >>>> whose parts are slowly disappearing). I made a copy of wview-archive.sdb >>>> (35 MB), renamed it weewx.sdb and replaced the existing weewx.sdb with it. >>>> I rebooted weewx and all appeared well, at first. I can see my wview >>>> daily, weekly and monthly data in weewx, but I do not see older data on >>>> the >>>> yearly weewx page. The yearly page only shows about a month worth of >>>> recent >>>> data. Much older data exists. What on earth could be wrong? >>>> >>>> I would add more diagnostic info to this post but I am not sure what >>>> would be helpful. >>>> >>>> Any suggestions? >>>> >>>> Bill - AB6OR >>>> >>>> http://orangecaweather.duckdns.org/weather >>>> >>>> -- >>>> 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.
