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 [email protected] wrote: > That all looks normal. What is in the NOAA subdirectory? Still blank lines? > > On Sat, Apr 3, 2021 at 10:19 AM Alastair <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 [email protected]. >>>>>>>> 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 [email protected]. >>>>>>> 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 [email protected]. >>>>>> 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 [email protected]. >>>>> 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 [email protected]. >>>> 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 [email protected]. >>> 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 [email protected]. >> > 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/228d6907-945c-43dd-aa48-d3141ed04f13n%40googlegroups.com.
