Thanks everyone, I appreciate the info. I may dump the databases with sqlite3 and verify what I have and what I'm missing.
I took another look this morning and I may only be missing the days when the system was down after the initial failure. The only way to get that data back would be if the Vantage weather station had it. I see that weewx has been able to go back a ways and get most of the missing data, but I don't know what triggers that and whether or not there is any more data in the weather station that has not already been restored. I see a "dump" option in wee_device to move all the data in the weather station to the archive, perhaps that would do the trick. Its not overly relevant at this point, but since I confused folks with my post, let me explain again "for the record" my recent hardware/system-building fun: - Production system in place 12/2018->9/9/2019, died on 9/9 - Got to site on 9/12, the production system would not power up. Installed the old system I had replaced in 12/2018; it had an old weewx.sdb on it (referred to as "interim" in my original post) - Later in the month, I moved the production disk into "replacement system 1;" it had the production weewx.sdb file. Took system to the site on 9/22 and it ran for a few hours. But it had troubles mounting sysroot, making me suspicious of the disk drive. I reverted to the interim system. - Built "replacement system 2" (new computer and disk) with the former production weewx.sdb on it (with data from 12/2018 through 9/9/2019 and some that was evidently added by "replacement system 1" on 9/22) - On 9/24 took "replacement system 2" to site and brought it up; message in the log indicated weewx added records to weewx.sdb that came from 9/22 until present I believe most of the other data was placed in the production database during the short period using "replacement system 1" on 9/22. So, this is why I am not missing as much data as I thought. I am only missing data from 9/9 until 9/12 when no system was up. Weewx is pretty smart! Sorry for confusing everyone. I hope my luck in hardware improves and the new system stays up for awhile. Dana On Wednesday, September 25, 2019 at 8:43:01 AM UTC-7, vince wrote: > > On Wednesday, September 25, 2019 at 4:41:54 AM UTC-7, Greg Troxel wrote: >> >> Dana Roode <[email protected]> writes: >> >> > Is there a way to extract archive records from one weewx.sdb file and >> > import then into another? I see there is a utility that allows >> importing >> > of CSV data files. >> > >> > >> > > Yes - there are many ways. > > Simplest is probably to do a sqlite3 dump of all the database archive > tables, then restore from 'each' of them into your aggregate database. > It'll whine when it inevitably finds duplicate records, but nothing bad > will happen. The result should be the union of all the databases. Weewx > should handle the summary tables, but you could always rebuild them > manually too if you wanted. > > -- 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/3d62be2e-a902-465f-ab36-a67129b6b7ae%40googlegroups.com.
