Page 1 of 1

Need Help in how to add missing Data

Posted: Fri Sep 29, 2017 1:40 pm
by Reinhard
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?

Re: Need Help in how to add missing Data

Posted: Fri Sep 29, 2017 1:46 pm
by Jachym
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.

Re: Need Help in how to add missing Data

Posted: Fri Sep 29, 2017 2:05 pm
by BlueBear
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

Re: Need Help in how to add missing Data

Posted: Fri Sep 29, 2017 2:07 pm
by Jachym
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

Re: Need Help in how to add missing Data

Posted: Fri Sep 29, 2017 2:17 pm
by Reinhard
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?

Re: Need Help in how to add missing Data

Posted: Fri Sep 29, 2017 3:06 pm
by Jachym
Reinhard there is a detailed step-by-step guide, including a videotutorial for this.

See the "Data import" section in the wiki

Re: Need Help in how to add missing Data

Posted: Fri Sep 29, 2017 5:01 pm
by Reinhard
Image

Re: Need Help in how to add missing Data

Posted: Fri Sep 29, 2017 6:48 pm
by Luc
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

Re: Need Help in how to add missing Data

Posted: Fri Sep 29, 2017 6:52 pm
by BlueBear
Thanks Luc, I will wait patiently :D