And if you are looking for a sample SQL command, the following, when run from
the command line, will output dateTime, outTemp and outHumidity to
yesterday.csv for all rows > 2020/11/09 00:00:00 and <= 2020/11/10 00:00:00.
You will need to adjust the paths for sqlite3 and weewx.sdb.
/usr/bin/sqlite3 /home/weewx/archive/weewx.sdb ".mode csv" ".output
yesterday.csv" "select dateTime, outTemp, outHumidity from archive where
dateTime > strftime('%s','2020-11-09 00:00:00') and dateTime <=
strftime('%s','2020-11-10 00:00:00')"
> On Nov 10, 2020, at 6:51 AM, Tom Keffer <[email protected]> wrote:
>
>
> The WeeWX database consists of two parts: a main "archive" database table,
> and a bunch of "daily summaries," one for each type.
>
> The main archive table is identical to wview's, so just use whatever tool you
> used before on it. Ignore the daily summaries.
>
> -tk
>
>> On Tue, Nov 10, 2020 at 6:41 AM David Bach <[email protected]> wrote:
>> In wview I regularly exported all archiver records for one day to csv. I
>> don't see a way to do this in weewx.
>>
>> I have looked at the database schema for weewx.sdb but I don't know enough
>> to make sense of all the tables, etc.
>>
>> Does anyone have a sample sql command to write one day's archive data
>> (selecting only certain fields) to a local cvs file?
>>
>> With wview I used such an export to match outside temperatures, humidity,
>> solar radiation and ET to corresponding values from a data logger inside a
>> greenhouse. I haven't found a way to export weewx data for this purpose.
>> --
>> 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/2dbf1f97-2bf1-42b3-90fe-3b6292fdc55fn%40googlegroups.com.
>
> --
> 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/CAPq0zEB7dmL%2Ba-70GMQMeQRgt9OR5CHu_f6t-iPN1bDB%3DQ2F3A%40mail.gmail.com.
--
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/FCFEF6C5-466C-4AB8-A6B4-34DA7EFAF34E%40johnkline.com.
