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
WeeWX-SQLITE to Meteotemplate, UNIX-timestamps
-
- Observer
- Posts: 18
- Joined: Sat Sep 09, 2017 6:20 pm
- Location: Bavaria
- Station model: FineOffset WH1080
- Software: WeeWX
WeeWX-SQLITE to Meteotemplate, UNIX-timestamps
Regards from Bavaria
- Luc
- Developer
- Posts: 168
- Joined: Mon Aug 21, 2017 6:40 am
- Location: Paramaribo, Suriname
- Station model: Davis Pro 2 (2x)
- Software: WeeWX
- Contact:
Re: WeeWX-SQLITE to Meteotemplate, UNIX-timestamps
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
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
-
- Observer
- Posts: 18
- Joined: Sat Sep 09, 2017 6:20 pm
- Location: Bavaria
- Station model: FineOffset WH1080
- Software: WeeWX
Re: WeeWX-SQLITE to Meteotemplate, UNIX-timestamps
Hi Luc,
thanks for your reply and your tools you wrote for WeeWX. Have a great party with your grandson.
Best regards
Joachim
thanks for your reply and your tools you wrote for WeeWX. Have a great party with your grandson.
Best regards
Joachim
Regards from Bavaria
Re: WeeWX-SQLITE to Meteotemplate, UNIX-timestamps
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 ?
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
- Developer
- Posts: 168
- Joined: Mon Aug 21, 2017 6:40 am
- Location: Paramaribo, Suriname
- Station model: Davis Pro 2 (2x)
- Software: WeeWX
- Contact:
Re: WeeWX-SQLITE to Meteotemplate, UNIX-timestamps
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.
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.
-
- Newbie
- Posts: 7
- Joined: Mon Nov 13, 2017 11:07 am
- Location: Madrid, Spain
- Station model: Davis Pro 2
- Software: WeeWx
- Contact:
Re: WeeWX-SQLITE to Meteotemplate, UNIX-timestamps
Hi.
Is this utility already available?
Thank you.
Mario
Is this utility already available?
Thank you.
Mario
Mariete's Weather Station at: https://emariete.com/meteo
-
- Newbie
- Posts: 7
- Joined: Mon Nov 13, 2017 11:07 am
- Location: Madrid, Spain
- Station model: Davis Pro 2
- Software: WeeWx
- Contact:
Re: WeeWX-SQLITE to Meteotemplate, UNIX-timestamps
Found it! Just sent an email to Luc!
Thank you
Thank you
Mariete's Weather Station at: https://emariete.com/meteo
- Luc
- Developer
- Posts: 168
- Joined: Mon Aug 21, 2017 6:40 am
- Location: Paramaribo, Suriname
- Station model: Davis Pro 2 (2x)
- Software: WeeWX
- Contact:
Re: WeeWX-SQLITE to Meteotemplate, UNIX-timestamps
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
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