and what data is in the daily summary table eg archive_day_outTemp for dates in say december 2017 ??? select * from archive_day_outTemp where dateTime < 1514764799; or something like that
On Sunday, 19 April 2020 16:58:26 UTC+3, Meteo Oberwallis wrote: > > Yes it was all newly created. Years 2017 - 2020 are available. But based on > the kb size you can see that the files are empty > > > > Am Sonntag, 19. April 2020 15:55:32 UTC+2 schrieb Andrew Milner: >> >> The extract you showed was only for 2019 and 2020 >> >> are there also new files for the other years / months, or are they >> missing from the directory. >> >> >> >> On Sunday, 19 April 2020 16:38:13 UTC+3, Meteo Oberwallis wrote: >>> >>> Yes. The Data in the Folder are new (Screenshot) >>> >>> Am Sonntag, 19. April 2020 15:28:19 UTC+2 schrieb Andrew Milner: >>>> >>>> can you confirm that the noaa files beng displayed are the regenerated >>>> files? Do a directory listing and check the creation date of the files. >>>> >>>> did you dropped daily and rebuilt the daily tables? >>>> >>>> do the daily tables appear to contain the correct data (not the main >>>> archive table but the daily summary tables)? >>>> >>>> >>>> >>>> On Sunday, 19 April 2020 16:16:41 UTC+3, Meteo Oberwallis wrote: >>>>> >>>>> Thx for the Answer. I've tried it a few times now. However, this does >>>>> not work. The columns remain empty and no data is displayed >>>>> >>>>> You can see here: >>>>> https://www.meteo-oberwallis.ch/wetter/bettmeralp/user/reports/ >>>>> >>>>> >>>>> >>>>> >>>>> Am Sonntag, 19. April 2020 15:13:10 UTC+2 schrieb Andrew Milner: >>>>>> >>>>>> if you delete the NOAA reports in /home/weewx/public_html/NOAA(or >>>>>> /var/www/html/NOAA) they will be regenerated on the next report cycle. >>>>>> >>>>>> >>>>>> >>>>>> On Sunday, 19 April 2020 16:02:02 UTC+3, Meteo Oberwallis wrote: >>>>>>> >>>>>>> Hello. >>>>>>> >>>>>>> Who i can found the Reports? Folder? >>>>>>> >>>>>>> Thanks >>>>>>> >>>>>>> Am Samstag, 26. Mai 2018 16:00:58 UTC+2 schrieb bdf0506: >>>>>>>> >>>>>>>> I just imported about a year's worth of data from >>>>>>>> WeatherUnderground into my database. Now, I would like to show the >>>>>>>> reports. >>>>>>>> >>>>>>>> I ran "wee_database --drop-daily" and "wee_database >>>>>>>> --rebuild-daily", followed by "wee_reports" in an attempt to generate >>>>>>>> everything. >>>>>>>> >>>>>>>> At this point, the daily, weekly reports are fine. The monthly >>>>>>>> report for May is fine. The yearly report for 2018 is fine. >>>>>>>> >>>>>>>> I am missing: >>>>>>>> All months other than May 2018 >>>>>>>> The year 2017. >>>>>>>> >>>>>>>> I know that I have data in my database for these, but it seems like >>>>>>>> I need to force these reports to be generated. How can I go about this? >>>>>>>> >>>>>>> -- 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/c3be5918-96f9-4ee9-a48f-712adc23a82b%40googlegroups.com.
