Hi Richard, Can you please share with us your script to export data frrom weewx to meteotemplate? I don't like reinventing the wheel! -:)
Luc On Monday, 11 April 2016 03:58:01 UTC-3, Richard Sears wrote: > > hank you both, it is clear to me now. I wrote a script that exports data > from weewx to meteotemplate and today was the first time it has rained > since I wrote it and no rain was showing up...now I understand why! > > Thanks Again > > On Sunday, April 10, 2016 at 11:46:46 PM UTC-7, gjr80 wrote: >> >> Yes, drop the 'highest'. wsum holds the running sum for the observation >> concerned. It is updated every archive period. So for archive_day_rain, >> wsum holds sum of the rain seen in all the archive records for that day. >> The dateTime values used in the archive_day_xxxx tables is the dateTime of >> midnight at the start of the day concerned. If you select the 'greatest' >> dateTime value in the table then you have today's rainfall since midnight. >> If you select some other dateTime then you have the total rainfall for the >> day that started at dateTime. wsum for archive_day_rain is useful as it is, >> but wsum for say archive_day_outTemp usually requires something like count >> to work out an average outTemp for the day etc (ie wsum for outTemp is a >> fairlly meaningless number by itself). >> >> Gary >> >> On Monday, 11 April 2016 15:54:49 UTC+10, Richard Sears wrote: >>> >>> humm...maybe I should not say highest, but instead this would give me >>> the total daily rainfall since midnight... >>> >>> On Sunday, April 10, 2016 at 10:49:16 PM UTC-7, Richard Sears wrote: >>>> >>>> Andrew - >>>> >>>> Thanks! I got it now.... >>>> >>>> so this would always give me the highest rainfall since midnight: >>>> >>>> >>>> mysql> SELECT wsum FROM weemx_archive_day_rain ORDER by dateTime DESC >>>> LIMIT 1; >>>> >>>> >>>> >>>> >>>> Correct? >>>> >>> -- 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.