What the manual says and what is available on my system don't quite jive. The ONLY wview-archive.sdb that I can find was last updated 5 years ago.
It has been running for the past 5 years WITHOUT generating this file. Unless the file has been rendered invisible, it does NOT exist on my current system. I would LOVE to try to extract the data from the existing SDB file, but as I indicated, I do not know ANYTHING about SQL databases (or how to manipulate them). If you can suggest the correct commands or operations, I will be more than happy to give it a shot. BTW, I finished my script last night. Took about 10 seconds to create the CSV file, and about 10 minutes to import everything. So far, it looks like most of my info got imported. As expected, some information (such as inside temp/console voltage/etc) is not there, but I can live with that. Thanx. Richard Rosa On Wednesday, July 31, 2019 at 9:52:03 PM UTC-4, Andrew Milner wrote: > > I don't think you have an alternative, you have something different. > > From wview manual: > *Day history Table (wview-history.sdb)* > > *Overview* > > This table is generated internally by wview to avoid having to compute the > daily summary records used for the yearly charts every time wview starts. > This was not a time concern with the flat WLK files but became more costly > when we started storing data in SQLite3. The external use or utility of > this table is limited at best. > > *Regeneration* > > To regenerate the NOAA database: > > ---------------------------------- > > I think you need to double check with wview, but the manual CLEARLY says > the wview archive is wview-archive.sdb and that wview-history.sdb is an > internal database used by wview for the yearly reports. > > > > On Thursday, 1 August 2019 01:45:27 UTC+3, vince wrote: >> >> On Wednesday, July 31, 2019 at 3:31:01 PM UTC-7, Richard Rosa wrote: >>> >>> It looks like I have an alternative: >>> >>> Thankfully, WVIEW saved a bunch of .txt files for every logged day >>> (almost 4k). Although I know very little about SQL databases, I am pretty >>> decent at converting text file formats to CSV files. >>> >>> >>> >> Still think a sqlite dump, a little editing, and a sqlite restore is the >> right move here, but of course do what you think is right for 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/b51a9975-5641-49b5-b845-fc7b48105574%40googlegroups.com.
