Thank you Thomas, that did the trick - working like a charm. Thank you
again!
Am Donnerstag, 18. Oktober 2018 02:36:35 UTC+2 schrieb Thomas Keffer:
>
> This is very easy to do in WeeWX. You certainly do not need to write SQL
> statements.
>
> Create a file called mydata.txt.tmpl in the skins/Standard directory.
> Inside it, put
>
> $current.dateTime.format("%Y-%m-%d
> %H:%M:%S"):$current.barometer.mbar:$current.outTemp.degree_C
>
> In your skin configuration file, skin.conf, under the [[ToDate]] section,
> include the template file name. It should look something like this:
>
> [[ToDate]]
> # Reports that show statistics "to date", such as day-to-date,
> # week-to-date, month-to-date, etc.
> [[[mytemplate]]]
> template = mydata.txt.tmpl
>
> [[[day]]]
> template = index.html.tmpl
>
> ... (as before)
>
> When WeeWX runs it will fill out the template and put it in your HTML
> directory.
>
> -tk
>
> On Wed, Oct 17, 2018 at 8:03 AM <[email protected] <javascript:>> wrote:
>
>>
>>
>> On Wednesday, October 17, 2018 at 8:40:55 AM UTC-4, Herwig Diessner wrote:
>>>
>>> Hello all,
>>>
>>> I need to export only 3 pieces of data from weewx into a file.
>>> The file should contain a single line of text in the following format:
>>> date;pressure;temperature
>>>
>>> The date is in the format "yyyy-MM-dd HH:mm:ss".
>>> The pressure and temperature are expressed in hPa and °C, respectively
>>>
>>> I tried to use the CSV extension and succeeded in
>>> - single line
>>> - time-format
>>>
>>> However, all sensor data is exported and the delimiter is fixed to ,
>>> instead of the required ;
>>>
>>> Is there any chance to succeed using the CSV extension (e.g. options to
>>> define the delimiter as ; instead of , - and options which sensor data is
>>> to be exported)?
>>> Or do I need another extension, or is there even another way?
>>>
>>> My searches on "export" and "csv" didn't bring any clues.
>>>
>>> In case of interest, this is my use case:
>>> I want to use temperature and pressure data to calculate "refraction"
>>> data for astrophotography using a 10micron telescope mount.
>>> This mount allows to calculate refraction data automatically if fed with
>>> a text file with the specifications above.
>>> Probably there are more users who might make use of this.
>>>
>>> Thank you for any hint,
>>>
>>> Herwig
>>>
>>
>>
>> The following mysql select statement gave me the results you wanted.
>> 2016-02-21 19:10:24;29.92;52.34
>> My database isn't metric but you can convert if necessary. If you use
>> sqllite i'm sure someone will convert for you.
>>
>> select timestampadd(second, dateTime, '1970-01-01'),barometer,outTemp
>> into outfile 'test.csv' fields terminated by ';' from archive limit 5;
>>
>> --
>> 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] <javascript:>.
>> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
