Page 1 of 1

WeeWX-SQLITE to Meteotemplate, UNIX-timestamps

Posted: Tue Oct 10, 2017 3:59 pm
by mmir
I have a FineOffset WH1080 Station, which is running since 2015 under WeeWX. I have all the data in a sqlite database (about 25 MB).

Now I need help to convert it or to import it to Meteotemplate to use the huge possibilities of this great program. WeeWX uses as time stamps UNIX-time which I cannot import that way to Meteotemplate, I think.

How can I convert the time stamps to dd-mm-yy-hh-mm or a format which is offered by Meteotemplate?

I´m more a user than a software engineer so I ask you for your help.

Thanks

Re: WeeWX-SQLITE to Meteotemplate, UNIX-timestamps

Posted: Tue Oct 10, 2017 9:31 pm
by Luc
Hi,
I have written an export data utility for weewx which produces csv files to be used as meteotemplate import files.
I promised to publish this here for testing but I didn't found time yet.
(My grandson turned seven today).
Be patient, I will work on it this or the coming week.
Cheers, Luc

Re: WeeWX-SQLITE to Meteotemplate, UNIX-timestamps

Posted: Wed Oct 11, 2017 7:38 am
by mmir
Hi Luc,

thanks for your reply and your tools you wrote for WeeWX. Have a great party with your grandson. :D

Best regards
Joachim

Re: WeeWX-SQLITE to Meteotemplate, UNIX-timestamps

Posted: Sun Oct 22, 2017 9:54 am
by Cyril
Hi,

I am interested in that utility as well.
To import old data, and to import data when there is an Internet outage.
What would happen if we import data that are already in meteotemplate ?

Re: WeeWX-SQLITE to Meteotemplate, UNIX-timestamps

Posted: Sun Oct 22, 2017 11:24 am
by Luc
You will have a choice.
By default this new data will be skipped when there is an existing record with the same time stamp.
You can choose to set an option to replace (overwrite) the old data with the new one.
To fill outages and adding old data the default option is the best one. You then won't change data you might have changed/corrected earlier manually.

Re: WeeWX-SQLITE to Meteotemplate, UNIX-timestamps

Posted: Tue Jan 23, 2018 6:59 am
by Mariete
Hi.

Is this utility already available?

Thank you.

Mario

Re: WeeWX-SQLITE to Meteotemplate, UNIX-timestamps

Posted: Tue Jan 23, 2018 8:28 am
by Mariete
Found it! Just sent an email to Luc!

Thank you :)

Re: WeeWX-SQLITE to Meteotemplate, UNIX-timestamps

Posted: Tue Jan 23, 2018 10:03 am
by Luc
To all weewx users,

Currently a general upload utility for 'missed' data is developed by Matthew Wall.
The idea is you select a begin and end date in weewx and then this utility will send all available data to the selected programs. This utility will also support Meteotemplate.

The data will be send directly to the meteotemplate api and stored in the meteotemplate database when such a record does not exist.
This utility would make my export utility superfluous. The plan is beta testing will start within a month. Any volunteers? Send a email to ljm.heijst@gmail.com when you want to participate in testing.

Luc