Add missing data to records

[Rory Gillies]

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.

[p q]

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.

--
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 weewx-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/c16f90a6-be69-4345-b8b2-0a7d55c40affn%40googlegroups.com.

--

Peter Quinn
(415)794-2264

[vince]

I would dump the db and restore the pertinent records using sqlite3.

[Andrea]

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.