Need Help in how to add missing Data

Post Reply
User avatar
Reinhard
Advisor
Advisor
Posts: 84
Joined: Fri Aug 25, 2017 9:42 am
Location: Prägraten am Großvenediger
Station model: Davis VP2 Pro wireless
Software: WeatherCat
Contact:

Need Help in how to add missing Data

Post by Reinhard » Fri Sep 29, 2017 1:40 pm

The situation:
Software update (operation system) on my Mac (= the computer that is running the weather software WheaterCat, collecting the data from VantagePro2, sending it via API to Meteotemplate's MySQL Database). System offline for one hour or more during the update.

The problem:
After the update process all systems are back, WeatherCat (or whatever software you are using) collects the missing data from the Davis Data Logger, so with my homeoffice Mac I am back in business - all data available. Not so with Meteotemplate.

How to:
Is there an easy way to add this missing data to MySQL - coolest way would be automatical 8-) ? What to do on my side?

I think this issue is not only happening to me, some hours of offline data transfer will happen to everyone some day. So what do you folks think about this one?
Image

User avatar
Jachym
Site Admin
Site Admin
Posts: 1686
Joined: Fri Aug 18, 2017 10:12 pm
Location: Brno, Czech Republic
Station model: WH1080
Software: Meteobridge
Contact:

Re: Need Help in how to add missing Data

Post by Jachym » Fri Sep 29, 2017 1:46 pm

Hi,

solution is relatively simple, use the corresponding monthly log file and in the import check "skip existing", it will fill the gap and then reformat the db.

BlueBear
Forecaster
Forecaster
Posts: 101
Joined: Sun Aug 20, 2017 1:04 pm
Location: Sanford, Manitoba, Canada
Station model: Davis VP2
Software: WeeWx
Contact:

Re: Need Help in how to add missing Data

Post by BlueBear » Fri Sep 29, 2017 2:05 pm

I have the same need but WeeWx doesn't generate monthly logs! Only a monthly summary.
I seem to recall that someone (Luc maybe) wrote and extension to the WeeWx - Meteotemplate driver that could do it, but I've never been able to find it!

The last upgrade my hosting company did cause me a 40 hour outage of my site.

Bill

User avatar
Jachym
Site Admin
Site Admin
Posts: 1686
Joined: Fri Aug 18, 2017 10:12 pm
Location: Brno, Czech Republic
Station model: WH1080
Software: Meteobridge
Contact:

Re: Need Help in how to add missing Data

Post by Jachym » Fri Sep 29, 2017 2:07 pm

I cannot tell about WeeWx, I never used this SW, but there should be a way given people use the data import feature with WeeWx

User avatar
Reinhard
Advisor
Advisor
Posts: 84
Joined: Fri Aug 25, 2017 9:42 am
Location: Prägraten am Großvenediger
Station model: Davis VP2 Pro wireless
Software: WeatherCat
Contact:

Re: Need Help in how to add missing Data

Post by Reinhard » Fri Sep 29, 2017 2:17 pm

Slow...

Where to find the corresponding monthly log file (there must be two, otherwise they can't correspond)? Within Meteoteplate? And if I find the file - where to click "Import" and how to reformat the database? The solution is not relatively simple, at least not for me. :oops:

I think for things like this there should be a step-by-step manual available. Or am I alone the stupid one?
Image

User avatar
Jachym
Site Admin
Site Admin
Posts: 1686
Joined: Fri Aug 18, 2017 10:12 pm
Location: Brno, Czech Republic
Station model: WH1080
Software: Meteobridge
Contact:

Re: Need Help in how to add missing Data

Post by Jachym » Fri Sep 29, 2017 3:06 pm

Reinhard there is a detailed step-by-step guide, including a videotutorial for this.

See the "Data import" section in the wiki

User avatar
Reinhard
Advisor
Advisor
Posts: 84
Joined: Fri Aug 25, 2017 9:42 am
Location: Prägraten am Großvenediger
Station model: Davis VP2 Pro wireless
Software: WeatherCat
Contact:

Re: Need Help in how to add missing Data

Post by Reinhard » Fri Sep 29, 2017 5:01 pm

Image
Image

User avatar
Luc
Developer
Developer
Posts: 168
Joined: Mon Aug 21, 2017 6:40 am
Location: Paramaribo, Suriname
Station model: Davis Pro 2 (2x)
Software: WeeWX
Contact:

Re: Need Help in how to add missing Data

Post by Luc » Fri Sep 29, 2017 6:48 pm

BlueBear wrote: Fri Sep 29, 2017 2:05 pm I have the same need but WeeWx doesn't generate monthly logs! Only a monthly summary.
I seem to recall that someone (Luc maybe) wrote and extension to the WeeWx - Meteotemplate driver that could do it, but I've never been able to find it!

The last upgrade my hosting company did cause me a 40 hour outage of my site.

Bill
I wrote a data export utility for weewx which produces (year) csv files to import in MT.
The project got on hold because Matthew Wall was very busy that period. I will have a look at it the coming weeks.
Luc
Image

BlueBear
Forecaster
Forecaster
Posts: 101
Joined: Sun Aug 20, 2017 1:04 pm
Location: Sanford, Manitoba, Canada
Station model: Davis VP2
Software: WeeWx
Contact:

Re: Need Help in how to add missing Data

Post by BlueBear » Fri Sep 29, 2017 6:52 pm

Thanks Luc, I will wait patiently :D

Post Reply