import data from WU

Post Reply
Weerstationwoerden
Observer
Observer
Posts: 11
Joined: Sun Jan 27, 2019 2:36 pm
Location: Woerden
Station model: Davis Pro 2
Software: Weather Display
Contact:

import data from WU

Post by Weerstationwoerden » Sun Jan 14, 2024 10:43 am

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

FSC830
Forecaster
Forecaster
Posts: 191
Joined: Thu Aug 02, 2018 11:40 am
Station model: Davis Vantage Pro2
Software: Meteobridge

Re: import data from WU

Post by FSC830 » Mon Jan 15, 2024 6:28 am

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
Image

Weerstationwoerden
Observer
Observer
Posts: 11
Joined: Sun Jan 27, 2019 2:36 pm
Location: Woerden
Station model: Davis Pro 2
Software: Weather Display
Contact:

Re: import data from WU

Post by Weerstationwoerden » Mon Jan 15, 2024 5:20 pm

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
Image

El_Viejo
Forecaster
Forecaster
Posts: 105
Joined: Wed Sep 11, 2019 3:56 pm
Location: Derio - Bizkaia - Spain
Station model: Ecowitt - Netatmo

Re: import data from WU

Post by El_Viejo » Tue Jan 16, 2024 12:22 pm

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,

Post Reply