WeeWX-SQLITE to Meteotemplate, UNIX-timestamps

[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

[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

[mmir]

Hi Luc,

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

Best regards
Joachim

[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 ?

[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.

[Mariete]

Hi.

Is this utility already available?

Thank you.

Mario

[Mariete]

Found it! Just sent an email to Luc!

Thank you

[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