On Wednesday, August 29, 2018 at 2:18:11 PM UTC-7, Eric Gammeter wrote: > > OK Thanks Pat and Tom! I got the sdb file migrated over from the old PC > onto my RPi PC- it is working and recording new data just fine: HOWEVER > (you knew that was coming didn't you?) I am *not* seeing any of the > weather data for January 2018 thru July 2018. Curious. I have no idea > what is up (or down). When I look at the yearly summary (at bottom of ) > index.html file from the 'old' pc all the data for the year is there! When > I look at the same summary index file on the Rpi- only August appears. > This is certainly no big deal mind you- I'm just hoping I can access all > the data in the sdb file for the year 2018. > > >
You might want to query your database to see if there are archive records for that range. Jan-03-2018 is 1515000000 seconds since the time epoch Jul-30-2018 is 1533000000 seconds since the time epoch To see if there are records in between those ranges to do a quick test.... echo "select datetime(dateTime,'unixepoch','localtime'),dateTime from archive where dateTime > 1535574000 and dateTime < 1535580000 limit 10" ; | sqlite3 weewx.sdb Hopefully it prints out 10 lines that look something like the following (I used different dates in my test below).... 2018-08-29 13:25:00|1535574300 2018-08-29 13:30:00|1535574600 2018-08-29 13:35:00|1535574900 2018-08-29 13:40:00|1535575200 2018-08-29 13:45:00|1535575500 2018-08-29 13:50:00|1535575800 2018-08-29 13:55:00|1535576100 2018-08-29 14:00:00|1535576400 -- 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.
