problem exporting wview data to weewx

[William Webb]

Like many on this forum, I am plotting the transition to weewx.  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 replace 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

[Jonathan Ryshpan]

There may be small differences in format between different versions of the SQLite libraries. I had similar difficulties importing data into a new compilation of wview. The sqlite3 utility seems to be able to handle all versions. Try the attached conversion script (which is hardly tested, use with care.)

jon

[William Webb]

Thanks.  I will keep the script in my back pocket.  Turned out the 'problem' was impatience. The yearly graph does not update at the archive period.  It updates daily.  The next day all was well.

Thanks AB6OR

[Tom Keffer]

Just for the record, all weeWX plots update as often as their aggregation interval. By default, yearly plots use a one day aggregation, so they get updated daily.

-tk