Good point. Make sure you delete the files first (as per post a couple
messages up this thread).
On Sat, Apr 3, 2021 at 10:53 AM gjr80 <gjroder...@gmail.com> wrote:
> Perhaps I have misread the log extract but there seems to be some seven
> odd years of data in the db yet only eight files were generated in the
> first report cycle. If the NOAA files were deleted and re-generated I would
> have expected to see some 97 odd files being produced. Are you sure the
> NOAA reports were indeed deleted?
>
> Gary
>
> On Sunday, 4 April 2021 at 03:27:54 UTC+10 tke...@gmail.com wrote:
>
>> That all looks normal. What is in the NOAA subdirectory? Still blank
>> lines?
>>
>> On Sat, Apr 3, 2021 at 10:19 AM Alastair <ajan...@gmail.com> wrote:
>>
>>> Hi. Log attached. Hope I got this right and it's what you need .
>>> Yes, I saw the 3 months missing data. This weather station is in
>>> Scotland - it's pretty well guaranteed to rain at least every other day.
>>> The missing data must have been during one of the many occasions where the
>>> old weather station was acting up : (
>>> Thanks again.
>>>
>>> On Sat, 3 Apr 2021 at 13:44, Tom Keffer <tke...@gmail.com> wrote:
>>>
>>>> That looks OK. I assume your site did not have rain for 3 months?
>>>>
>>>> We will need to see the log.
>>>>
>>>> Stop weewx
>>>> Delete all the NOAA files
>>>> Set debug=1 in weewx.conf
>>>> Restart weewxd
>>>> Post the log from startup through the first reporting cycle.
>>>>
>>>> -tk
>>>>
>>>> On Fri, Apr 2, 2021 at 11:40 PM Alastair <ajan...@gmail.com> wrote:
>>>>
>>>>> Here's the data from the query you sent.
>>>>>
>>>>> sqlite> select datetime(min(dateTime),'unixepoch','localtime'),
>>>>> sum(count), sum(sum) from archive_day_rain where
>>>>> strftime("%Y",dateTime,'unixepoch','localtime')='2014' group by
>>>>> strftime("%Y-%m",dateTime,'unixepoch','localtime');
>>>>> 2014-01-01 00:00:00|2941|5.858267927
>>>>> 2014-02-01 00:00:00|2685|10.110236633
>>>>> 2014-03-01 00:00:00|7364|24.838583605
>>>>> 2014-04-01 00:00:00|2974|0.0
>>>>> 2014-05-01 00:00:00|2564|0.0
>>>>> 2014-06-01 00:00:00|2562|0.0
>>>>> 2014-07-01 00:00:00|2778|2.78740166
>>>>> 2014-08-01 00:00:00|2082|24.307087427
>>>>> 2014-09-01 00:00:00|2873|10.759842921
>>>>> 2014-10-01 00:00:00|2972|27.248032548
>>>>> 2014-11-01 00:00:00|2875|4.110236407
>>>>> 2014-12-01 00:00:00|2974|2.964567051
>>>>>
>>>>> Thanks
>>>>>
>>>>>
>>>>> On Fri, 2 Apr 2021 at 18:20, Tom Keffer <tke...@gmail.com> wrote:
>>>>>
>>>>>> Whether or not something appears in the yearly summaries depends on
>>>>>> 'count', not 'sum'. Try this query for 2014
>>>>>>
>>>>>> sqlite> *select datetime(min(dateTime),'unixepoch','localtime'),
>>>>>> sum(count), sum(sum) from archive_day_rain where
>>>>>> strftime("%Y",dateTime,'unixepoch','localtime')='2014' group by
>>>>>> strftime("%Y-%m",dateTime,'unixepoch','localtime');*
>>>>>>
>>>>>> Please cut and paste, rather than use screen shots. They take less
>>>>>> space, are easier to read, and can be searched.
>>>>>>
>>>>>> On Fri, Apr 2, 2021 at 9:44 AM Alastair <ajan...@gmail.com> wrote:
>>>>>>
>>>>>>> Hi Tom, many thanks for your response, apologies it wasn’t too
>>>>>>> clear.
>>>>>>>
>>>>>>> Yes I deleted and regenerated the reports after adding my old WS
>>>>>>> data.
>>>>>>>
>>>>>>> For info, I started using weewx with my new WS on dateTime =
>>>>>>> 1588201200 / 29-Apr-20. Before that date is the imported data from my
>>>>>>> old
>>>>>>> WS. Here is a screenshot showing some data either side of that date
>>>>>>> (*select
>>>>>>> datetime(dateTime,'unixepoch','localtime'), sum from archive_day_rain;)*
>>>>>>>
>>>>>>>
>>>>>>> [image: image.png]
>>>>>>>
>>>>>>>
>>>>>>> And here is the result of the second query (*select
>>>>>>> datetime(min(dateTime),'unixepoch','localtime'), sum(sum) from
>>>>>>> archive_day_rain group by
>>>>>>> strftime("%Y",dateTime,'unixepoch','localtime')*
>>>>>>>
>>>>>>>
>>>>>>> [image: image.png]
>>>>>>>
>>>>>>>
>>>>>>> So thankfully it looks like my imported rain data has been processed.
>>>>>>>
>>>>>>> However, here's a screenshot of an example annual summary for 2014
>>>>>>> with the precipitation summary blank. (Note that the wind and
>>>>>>> temperature
>>>>>>> summary is summarised)
>>>>>>> [image: image.png]
>>>>>>>
>>>>>>> Any thoughts would be very welcome.
>>>>>>>
>>>>>>> Thanks again.
>>>>>>>
>>>>>>> Alastair
>>>>>>>
>>>>>>> On Fri, 2 Apr 2021 at 13:22, Tom Keffer <tke...@gmail.com> wrote:
>>>>>>>
>>>>>>>> Hello,
>>>>>>>>
>>>>>>>> If I understand correctly, you deleted, then regenerated all of the
>>>>>>>> NOAA monthly and yearly reports.
>>>>>>>>
>>>>>>>> When you say "precipitation summary data remains blank," do you
>>>>>>>> mean each line in one of the summaries? Or, do you mean the totals at
>>>>>>>> the
>>>>>>>> bottom of the page? And, is it every line? Or, only an occasional line?
>>>>>>>>
>>>>>>>> It's worth looking at what is in the daily summary database. This
>>>>>>>> should do it:
>>>>>>>>
>>>>>>>> *sqlite3 weewx.sdb*
>>>>>>>> sqlite> *select datetime(dateTime,'unixepoch','localtime'), sum
>>>>>>>> from archive_day_rain;*
>>>>>>>> sqlite> *select datetime(min(dateTime),'unixepoch','localtime'),
>>>>>>>> sum(sum) from archive_day_rain group by
>>>>>>>> strftime("%Y",dateTime,'unixepoch','localtime');*
>>>>>>>>
>>>>>>>> The first select statement will give the rain for each day. It may
>>>>>>>> be quite voluminous, depending on how big your database is.
>>>>>>>>
>>>>>>>> The second will give the total rain for each year.
>>>>>>>>
>>>>>>>> See if they look reasonable, then we can take it from there.
>>>>>>>>
>>>>>>>> -tk
>>>>>>>>
>>>>>>>> On Fri, Apr 2, 2021 at 3:24 AM Alastair L <ajan...@gmail.com>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Hi. Help needed please. I have imported several years of data
>>>>>>>>> from my old weather station into weewx.sdb. In particular, I imported
>>>>>>>>> the
>>>>>>>>> rain data into the [rain] field in the archive table and left the
>>>>>>>>> [rainRate] field blank.
>>>>>>>>>
>>>>>>>>> I then ran ‘sudo wee_database --drop-daily’ followed by ‘sudo
>>>>>>>>> wee_database --rebuild-daily’ and both ran ok without error. The
>>>>>>>>> monthly
>>>>>>>>> and yearly summary reports generated for the imported temperature and
>>>>>>>>> wind
>>>>>>>>> data summarised ok but the precipitation summary data remains blank
>>>>>>>>> for
>>>>>>>>> some reason.
>>>>>>>>>
>>>>>>>>> Any idea how I get the rain data summaries would be appreciated.
>>>>>>>>> Thanks.
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> 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/1fdb99af-6e6b-4a72-ac15-5389c6f27eb0n%40googlegroups.com
>>>>>>>>> <https://groups.google.com/d/msgid/weewx-user/1fdb99af-6e6b-4a72-ac15-5389c6f27eb0n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>>>>>>> .
>>>>>>>>>
>>>>>>>> --
>>>>>>>> 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/CAPq0zEBf39Zc3xcpgMnRxodFyHB%3D7hTikPvxC4XibinTomR2KA%40mail.gmail.com
>>>>>>>> <https://groups.google.com/d/msgid/weewx-user/CAPq0zEBf39Zc3xcpgMnRxodFyHB%3D7hTikPvxC4XibinTomR2KA%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>>>>>> .
>>>>>>>>
>>>>>>> --
>>>>>>> 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/CAKvi5dS-QQxtDEbr-wqoBCjPAJDU7s0Y10d97EVWx3bBdXUfGw%40mail.gmail.com
>>>>>>> <https://groups.google.com/d/msgid/weewx-user/CAKvi5dS-QQxtDEbr-wqoBCjPAJDU7s0Y10d97EVWx3bBdXUfGw%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>>>>> .
>>>>>>>
>>>>>> --
>>>>>> 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/CAPq0zEAnFbwmjiFM2_iJa_20LgXnCUxfpXNejEWqR_QEnThFEQ%40mail.gmail.com
>>>>>> <https://groups.google.com/d/msgid/weewx-user/CAPq0zEAnFbwmjiFM2_iJa_20LgXnCUxfpXNejEWqR_QEnThFEQ%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>>>> .
>>>>>>
>>>>> --
>>>>> 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/CAKvi5dS4%2BeqHLpgqW7UzaDRNOPp-gT4ObK0qOBzidwsS69enOQ%40mail.gmail.com
>>>>> <https://groups.google.com/d/msgid/weewx-user/CAKvi5dS4%2BeqHLpgqW7UzaDRNOPp-gT4ObK0qOBzidwsS69enOQ%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>>> .
>>>>>
>>>> --
>>>> 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/CAPq0zECio9tahrEeq2JY%3DEF-Nty%2B3AZtVRwQMi5u3WWxzwHTXQ%40mail.gmail.com
>>>> <https://groups.google.com/d/msgid/weewx-user/CAPq0zECio9tahrEeq2JY%3DEF-Nty%2B3AZtVRwQMi5u3WWxzwHTXQ%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>> --
>>> 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/CAKvi5dQ-vs8jPoizoFpHq6cd%2BwQLrWOqc908GWgyauw5oyyGzA%40mail.gmail.com
>>> <https://groups.google.com/d/msgid/weewx-user/CAKvi5dQ-vs8jPoizoFpHq6cd%2BwQLrWOqc908GWgyauw5oyyGzA%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/weewx-user/228d6907-945c-43dd-aa48-d3141ed04f13n%40googlegroups.com
> <https://groups.google.com/d/msgid/weewx-user/228d6907-945c-43dd-aa48-d3141ed04f13n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/CAPq0zED3eadhLJ9u9Zm1OUgOiORWkdo9OnWA%2BJcg1newb0e7iA%40mail.gmail.com.
