I just put the file in a subdirectory and call it from a root cronjob: */1 * * * * /usr/bin/php /scripts/weewx_to_meteo-zeus.php > /dev/null 2>&1
On Thursday, March 16, 2017 at 9:17:22 AM UTC-7, Luc Heijst wrote: > > Thanks a lot Richard for the script, > > I can use your script to work at the following: > > Because the weewx and meteotempalte databases are not on the same computer. > Either I update the meteotemplate database on the webserver remotely or I > send the data via http to a self-written updateApi.php which will be > derived from the meteotemplates api to store the data. > I also can use that aupdateApi to: > > 1. Request for the most recent record in meteotemplates database > 2. Send a timestamp to the update api and get a true/false status when > such meteotemplate record exists or not. > Or... just send all weewx records newer than a given date and let the > uploadApi discard info of already stored meteotemplate records. > The latter method might be faster. > > Richard, where did you put your weewx_to_meteo_zeus.php script and how (by > whom) is it called? > > Luc > > > > On Thursday, 16 March 2017 12:48:01 UTC-3, Richard Sears wrote: >> >> You Bet - See Attached..... >> >> >> >> On Thursday, March 16, 2017 at 7:29:20 AM UTC-7, Luc Heijst wrote: >>> >>> 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.