I would dump the db and restore the pertinent records using sqlite3. On Monday, March 28, 2022 at 3:23:49 PM UTC-7 [email protected] wrote:
> I use WeatherLink Live to collect data from my Davis Vantage 2 Pro Plus > and pull it in to Weewx using the WeatherlinkliveUDP driver. For some > reason my WLL lost connection to the weather station for an hour this > afternoon. The WLL provides pressure and indoor temp / humidity data, so > weewx created records but missing all the outside and derived values. > > I thought wee_import would fix this, but have discovered it only adds new > records, not update existing ones. When trying to import I get archive: > unable to add record [..] to database 'weewx.sdb': UNIQUE constraint > failed: archive.dateTime errors for each record. > > I have looked at a copy of the db using SQlite Browser on my Mac, and can > see the records with missing values, Is there a simple way to add them? > Although I am very IT literate I have little experience with SQLite. Is it > possible to delete the records then use wee_import to pull them back in? > It’s only 14 records. > -- 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/22ee9387-5764-4288-818c-d28fd454c967n%40googlegroups.com.
