Thanks Andrew,
What I need is a dump of the total database to a .txt or other useful format.
To be used once to input historical weewx data in meteotemplate via a data
import.
I know how to program it, but don't know if there is a mysql statement which
can do the same. The problem is the aggregation of rain data for local time
zone 'since midnight'.
Luc
Verstuurd vanaf mijn iPad
> Op 17 mrt. 2017 om 02:46 heeft Andrew Milner <andrew.s.r.mil...@gmail.com>
> het volgende geschreven:
>
> Rain since midnight = latest daily rain "sum" + sum of ("rain" in looprecords
> where looptime > time of latest archive)
> or change rain field in loop raw table to be interarchive running total
> rather than loop value and then
> Rain since midnight = latest daily rain "sum" + loop interarchive running
> total
>
>
>
>> On Friday, 17 March 2017 05:52:01 UTC+2, Luc Heijst wrote:
>> The import is not a problem, Jachym. It is the export of the data. We need a
>> query to sum the rain values since midnight (local time). i don't know how
>> to do that.
>> Luc
>
> --
> You received this message because you are subscribed to a topic in the Google
> Groups "weewx-user" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/weewx-user/YL75lkTpi6Y/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> weewx-user+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
--
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.
