Page 1 of 1

import data from WU

Posted: Sun Jan 14, 2024 10:43 am
by Weerstationwoerden
Hi to you all
I want to import all data from my weather station to the database from this template
Only I lost all data from the weather display some time ago
But I see all my data is on weather underground
Is there a way for download all data from weather underground to the data base from the template

I see into the screen from DATA IMPORT
( If you have the possibility to choose, then only use the WU option if absolutely necessary. It is the least reliable and also takes the longest time. Use data import from a file if possible.)
so it there a way for import the data from weather underground ore not ??

Re: import data from WU

Posted: Mon Jan 15, 2024 6:28 am
by FSC830
Hi,

dont know if WU provides a possibilty to export data (may be as a SQLdump?), but if you find a way to export the data from WU into a .txt or csv, you can import the data into Meteo-Template.
I did importing data from a .txt into my environment some months ago.
What you need to check (and most likely to adjust) is the order of the values.
You have at least the possibility in MT to set an individual order, i.e. field 1 contains the date, field 2 contains the temperature, field 3 the rain rate, etc. etc.
But at least you should check how to export the data from WU, this is the first step.

Regards

Re: import data from WU

Posted: Mon Jan 15, 2024 5:20 pm
by Weerstationwoerden
Hi Thanks for info

I have found this on YouTube ( https://youtu.be/PBYeFYxyzhs?si=0f8Z5gwoOwvFIaoB )
This is a way only a very slow one it's day for day
And a must do +_ 14 year
Now looking for a faster way for do this

Re: import data from WU

Posted: Tue Jan 16, 2024 12:22 pm
by El_Viejo
If you have hosted the template on a server that supports phpMyAdmin and the WU database is in SQL format, try using the phpMyAdmin import option.

To avoid disasters make a backup of your current database,