Thanks for the rapid response Tom, as usual you are bang on the money! john@pikodi:/home/weewx/archive $ sqlite3 weewx.sdb SQLite version 3.8.7.1 2014-10-29 13:59:56 Enter ".help" for usage hints. sqlite> select count(outTemp) from archive where dateTime >1470009600 and dateTime <= 1472688000; 0 sqlite> select count(outTemp) from archive where dateTime >1470009600 and dateTime <= 1472688000 and outTemp not null; 0 sqlite>
However: john@beast-ubuntu:~/Desktop/Weewx Data Import$ sqlite3 weewxB4Reinstal.sdb SQLite version 3.11.0 2016-02-15 17:29:24 Enter ".help" for usage hints. sqlite> select count(outTemp) from archive where dateTime >1470009600 and dateTime <= 1472688000 and outTemp not null; 8936 It seems i did something foolish whilst copying the database back to the Rpi. How can i insert the missing data from the weewxB4Reinstal.sdb into the current database on the RPi? Regards John -- 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]. For more options, visit https://groups.google.com/d/optout.
