Problem solved, I copied the DB to my Mac then deleted the records with the missing data using DB Browser, copied it back in then used wee_import to restore the data and calculate the derived values. Although only an hour of data I like to have a complete set of observations for each day. I use Neowx-Materal for my web page and the missing data showed up as a very annoying gap: www.360shetland.co.uk/weather
Thanks for the help, the weewx database turns out to be a very simple flat file so easy to work with. On Tuesday, March 29, 2022 at 8:57:28 AM UTC+1 Andrea wrote: > The problem is a NO PROBLEM in terms of statistic and any other calculated > values. The question is " it's so important to have only 14 more records in > the DB?" > I have hundreds of missing value in the DB for any reason and the > statistic value are perfect. In any case if you need of that records, you > can try to write a little python program or SQL statement and import the > records. > > Il giorno martedì 29 marzo 2022 alle 00:23:49 UTC+2 > [email protected] ha scritto: > >> 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/2391fae2-5239-481e-ac26-fff95d3561b1n%40googlegroups.com.
