For 14 records, you can probably delete them directly in SQlite Browser, manually one at a time. Heck for 14 records the laziest way to fix it might be to type them in ;-)
I use DB Browser for SQLite on Windows and it can do manual deletes or imports from a CSV file. I imagine your browser can do the same. On Mon, Mar 28, 2022 at 3:23 PM 'Rory Gillies' via weewx-user < [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/c16f90a6-be69-4345-b8b2-0a7d55c40affn%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/c16f90a6-be69-4345-b8b2-0a7d55c40affn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Peter Quinn (415)794-2264 -- 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/CAA1SM23%3DN19wRTdv_PUyjdrQgsUogdAz6btbMrQiHTpTPFA2PQ%40mail.gmail.com.
