Topic: Imported Data from Wunderground

[Dal]

Due to a catastrophic hd failure, I lost more than 2 years worth of data. I've now downloaded the data from Wunderground in csv format to import into WD. As I understand it (limited knowledge), WD imports the data into a log file.
What I'm hoping to do is somehow utilise that imported data in order to create comparisons in weather over the past couple of years, using either Brian's new charts or possibly the warming and rainfall scripts from relay Weather.

What I need now, if someone would be kind enough, are the precise steps to be taken to a) import the .csv files into WD and then b) convert that into usuable data.

The very last thing I want to do is screw up all this effort

Any help will be very greatly appreciated.

[Cleofide]

Quite interesting. I almost have the same problem (yes, I know, I DO have a lot of troubles with my weather things): I used to work with WeatherLink but the .WLK archive files contain errors which twist the global results, high/low records, etc. So my question is: how did you download the whole .csv file from wunderground? I have two computers so I will try to figure out how to add these old data to my new ones. If it works, I shall of course describe the comprehensive procedure to you.

By the way, we will never say it enough: do backups!

Thanks,

[Bashy]

There is an option to import from WU in to WD, go to the action menu, then Import log from
 other software, then WU is 2nd from bottom, downside is, if you want detailed data then you
have to do it day by day

[Cleofide]

Thanks Bashy. I tried with a file generated by WU and it screwed up all the June data 
So I don't know if I took the right file, but it didn't work here. Be warned.

[Weather Display]

it should work OK
but note that you will need to download a month at a time,as comma separated, and import just that month at a time
also make sure to back up your data first

(and always a good idea to back up your data regurlarly, as hard drives do fail)

also make sure to be using a recent version of WD to do this routine

[Cleofide]

Where do you download your files? Are you using the Comma Delimited File? Because when I do so, WD doesn't read the file properly:


   Averages\Extremes for day :June 2010
-----------------------------------------------------------------------------------------------------------------------------------
Day     Temp      Wind       Gust       Rain        Max Temp    Min Temp   Av Hum   Av Baro       Av Dir       Wind run   Windchill
----------------------------------------------------------------------------------------------------------------------------------
 30     -6.7°C    30.9kmh    75.9kmh    00.0mm      -4.8°C      -9.5°C     048%     33922.2 hPa     334 ° (NNW)  478.6km   -19.3°C               


And I'm following the procedure you indicated me: Wundergroun combined daily .csv...

[Dal]

What you want is each day's file. At the bottom of each day is a "Comma Delimited File" link. Save each day and then import it one day at a time into WD. Be warned though.... I downloaded over two years of data from WU (1 day at a time), imported it all into WD (1 month at a time), converted it..... and wound up with an unholy mess.

This is what I did:
1) Saved each day's "Comma Delimited File" into a folder titled for that month.
2) Imported each day's file for that month only into WD.
3) Went to the logfile WD had created and converted it.

Now I don't know if it's WU or WD that causes the problems but my results bore no relationship to reality. -140 degrees C, Pressure readings of 33415 hpa.... and so on.

[serowe]

Check the data exported by WU very carefully - it is NOT exporting correctly (for instance I kept getting Daily Rainfall as some ridiculous figure of -2539.7 for every entry and a constant WindSpeed entry of -999.

[Cleofide]

Yes I noticed this too and actually gave up the idea of relying only upon WD. I now use WeatherLink for everything where I need graphics and extensive data reports, and WD for updating the Saratoga script. To me WL is the best way to backup the data of the Vantage.

[Axelvold]

What version of WD are you using?

You will need to use version 50 or higher, because those earlier version did not import metric data as metric.

[Cleofide]

I am running WD 10.37P build 41. The latest version available is 10.37P build 44, therefore I think you meant '40' and not '50', am I right? Thank you anyway, I am still willing to use WD for more tasks if it can decipher the metric data properly.

[Axelvold]

I am running WD 10.37P build 41. The latest version available is 10.37P build 44, therefore I think you meant '40' and not '50', am I right? Thank you anyway, I am still willing to use WD for more tasks if it can decipher the metric data properly.

No I meant 50, see here http://www.weather-watch.com/smf/index.php/topic,46966.0.html

[Cleofide]

Sorry!! The main page of WD isn't up to date. The latest version is indeed 10.37P Build 53. Doing the update right now and let you know.

[Axelvold]

Sorry!! The main page of WD isn't up to date. The latest version is indeed 10.37P Build 53. Doing the update right now and let you know.

Be careful, it's an Beta version.