[weewx-user] Re: Data from imported db not showing up

2017-01-13 Thread Ξ
Ah, nice, that was an easy one, thanks a lot! :)

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[weewx-user] Re: Data from imported db not showing up

2017-01-13 Thread Andrew Milner
Stop weewx, backup (just in case) and delete ALL your NOAA files, restart 
weewx and the old ones from 2014 together with the later ones will be 
recreated



On Friday, 13 January 2017 14:21:37 UTC+2, Ξ wrote:

> Hello,
>
> I had an separate weewx.sdb with some data from 2014, I imported it in my 
> current weewx.sdb the following way:
> 1. stopped weewx
>
> 2.1. sqlite> .output weewx.sql
> 2.2. sqlite> .dump
> 2.3. sqlite> .read weewx.sql
>
> 3. Just in case (wasn't sure if necessary) I dropped and rebuilt the 
> daily summaries.
>
> When I query the current db I see that the data from 2014 is there:
> sqlite> select * from archive where dateTime >=1413983100 and dateTime <= 
> 1418033700;
>
> 1413983100|17|5|1016.28791671632|1006.6|1017.04448274591|14.5|19.0|62.0|65.0|2.1000168|67.0|3.1000248|67.0||0.0|12.2664431411618|19.0|19.0|
>
> 1413983400|17|5|1016.28791671632|1006.6|1017.04448274591|14.5|19.0|62.0|64.0|0.756|157.0|1.8000144|157.0||0.0|12.0306771978198|19.0|19.0|
>
> 1413983700|17|5|1016.18214153765|1006.5|1016.93974200736|14.5|19.0|62.0|64.0|0.972|247.0|1.296|247.0||0.0|12.0306771978198|19.0|19.0|
>
> 1413984000|17|5|1016.18214153765|1006.5|1016.93974200736|14.6|19.0|62.0|64.0|1.188|202.0|1.8000144|202.0||0.0|12.0306771978198|19.0|19.0|
>
> 1413984300|17|5|1016.07636635897|1006.4|1016.83500117321|14.5|19.0|62.0|64.0|0.864|337.0|1.8000144|337.0||0.0|12.0306771978198|19.0|19.0|
>
> [.]
>
> 1418032800|17|15|1022.65069022701|1010.7037037037|1021.34264997858|8.21|9.05185185185185|69.0|86.7037037037037|0.60740740789|333.939464968401|1.8000144|292.0|0.0|0.0|6.95351969435926|9.03829467906817|9.05185185185185|99.8148148148148|0.0|0.0|0.0|1.0
>
> 1418033700|17|15|1022.41118044111|1010.48|1021.10834967871|8.20|9.06|69.0|86.0|0.46333704|334.922637326266|1.8000144|270.0|0.0|0.0|6.84622281651449|9.047413980332|9.06|100.0|0.0|0.0|0.0|1.0
> sqlite>
>
> However, in the generated reports there's nothing: 
> http://wwx.oe.ftp.sh/NOAA/NOAA-2014-10.txt 
> Same for Nov-2014 and Dec-2014.
>
> I'm running weewx3.6.2, on Arch Linux, R-Pi.
>
> Have I done something terribly wrong? Am I missing something obvious?! How 
> do I make the data show up?
>
>

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.