I have three years of weather data collected via Ambient Weather’s Virtual Weather Station software courtesy of my Davis Vantage Pro 2 system. Currently the station is still running on VWS, however I am interested in switching to WD. I have installed the latest (trial) version of WD as well as imported three cvs files from VWS. Weather Display has claimed to import them however I do not know how to integrate the data in WD to see trends or past data. Thank you for your help.
AJ
make sure its one month of data being imported
then you should see that data under view, averages/extremes, for the month imported
.zip and email me a sample month data and I will test here
VWS does not export a csv file in monthly format. It is a yearly format which I was able to import, or at least WD did not issue an error. However, I do have TXT files that are in monthly format. Is there a way to utilize(import) those?
Thank you
you need to break down the yearly csv file into separate file months at a time
another way is if you have wunderground data, you can export that to .csv then import that into WD
Brian,
It does not import. I saved the file as a .csv. Tried the import function but it never imported. The software never returned a completed message and I do not see the data in Averages and extremes. What I am doing wrong. Here is a copy of the month of June 2011 in csv format.
Date,TemperatureHighF,TemperatureAvgF,TemperatureLowF,DewpointHighF,DewpointAvgF,DewpointLowF,HumidityHigh,HumidityAvg,HumidityLow,PressureMaxIn,PressureMinIn,WindSpeedMaxMPH,WindSpeedAvgMPH,GustSpeedMaxMPH,PrecipitationSumIn
2011-6-1,90,79,69,76,69,47,91,72,33,30.10,29.75,16,1,20,0.00
2011-6-2,77,66,54,53,46,41,66,48,37,30.00,29.83,20,1,23,0.00
2011-6-3,76,58,50,45,41,34,73,56,25,30.08,29.96,16,0,18,0.00
2011-6-4,74,61,46,54,48,42,90,65,39,30.10,29.95,15,1,15,0.00
2011-6-5,70,62,51,60,55,49,95,78,64,30.06,29.96,7,0,7,0.00
2011-6-6,62,62,62,58,58,58,87,87,87,29.98,29.98,0,0,0,0.00
2011-6-7,62,62,62,58,58,58,87,87,87,29.98,29.98,0,0,0,0.00
2011-6-8,95,76,62,75,66,58,89,73,41,29.98,29.76,6,0,12,0.00
2011-6-9,95,82,67,76,71,62,96,72,49,29.87,29.66,14,1,14,0.12
2011-6-10,84,74,66,70,66,63,97,78,54,29.97,29.83,6,0,6,0.01
2011-6-11,70,65,61,66,62,59,96,88,79,29.98,29.91,12,0,12,0.07
2011-6-12,71,64,58,66,61,57,97,91,81,29.92,29.77,4,0,4,0.85
2011-6-13,69,63,57,62,58,52,98,85,59,29.88,29.81,10,0,10,0.02
2011-6-14,66,60,52,61,56,50,100,85,70,29.92,29.81,7,0,7,0.01
2011-6-15,84,66,51,59,55,49,96,70,37,29.91,29.80,11,0,11,0.00
2011-6-16,80,68,53,64,58,52,97,74,46,29.91,29.85,12,0,12,0.00
2011-6-17,77,67,61,68,64,58,98,89,62,29.88,29.78,11,0,11,1.50
2011-6-18,82,66,60,68,62,59,99,88,51,29.86,29.74,12,0,12,0.00
2011-6-19,80,69,60,65,60,54,98,74,48,29.84,29.77,6,0,7,0.00
2011-6-20,83,70,55,64,58,54,97,68,39,29.90,29.80,8,0,8,0.00
2011-6-21,82,73,61,74,67,59,97,82,64,29.89,29.82,3,0,5,0.04
2011-6-22,78,70,66,72,68,65,98,96,80,29.91,29.75,12,0,14,0.94
2011-6-23,72,70,67,72,68,65,99,95,85,29.77,29.68,9,0,9,0.48
2011-6-24,72,69,64,68,66,63,98,91,84,29.72,29.65,10,0,12,0.09
2011-6-25,81,72,64,67,64,61,98,78,55,29.86,29.70,14,1,14,0.01
2011-6-26,78,70,61,65,62,59,95,77,55,29.96,29.84,8,0,8,0.00
2011-6-27,84,72,58,68,63,57,98,75,52,30.03,29.90,8,0,11,0.00
2011-6-28,83,76,66,71,68,63,94,77,60,29.94,29.75,9,0,12,0.00
2011-6-29,77,71,65,70,62,57,98,76,55,29.90,29.76,14,1,17,0.56
2011-6-30,81,70,59,62,58,54,92,67,43,29.95,29.86,12,1,12,0.00
WD expects every 1 minute data
you only have 1 data point recorded for each day (very limited data )
Could that be the wrong logfile? It doesn’t even have a time field :?
This is what Wunderground produced for a monthly cvs file. My other cvs file from Ambient Weather is a minute by minute file. However, it does not export the data on a monthly basis. It only does it for the whole year.
OK, per windy’s post above, that year file is the one you need, you just need to separate out each month into a separate file by opening it in notepad or other text editor.
Do I then save is as month-year.cvs or does WD require a specific format?
Here is a sample of a portion of May 2009. Is this syntax correct for WD?
05 02 2009 00 00 12.6 53.000 -1.3 30.2 3 6 254.000 0 0.0 0.3 33.5 13.7
05 02 2009 00 01 12.6 53.000 -1.3 30.2 0 3 250.000 0 0.0 0.3 33.5 13.7
05 02 2009 00 02 12.6 53.000 -1.3 30.2 0 1 280.000 0 0.0 0.3 33.5 13.7
05 02 2009 00 03 12.5 53.000 -1.4 30.2 2 5 271.000 0 0.0 0.3 33.5 13.6
05 02 2009 00 04 12.5 53.000 -1.4 30.2 0 4 281.000 0 0.0 0.3 33.5 13.6
05 02 2009 00 05 12.4 54.000 -1.1 30.2 1 4 285.000 0 0.0 0.3 33.5 13.6
05 02 2009 00 06 12.4 53.000 -1.5 30.2 1 2 285.000 0 0.0 0.3 33.5 13.5
05 02 2009 00 07 12.3 53.000 -1.6 30.2 2 4 239.000 0 0.0 0.3 33.5 13.4
05 02 2009 00 08 12.3 54.000 -1.2 30.2 1 3 225.000 0 0.0 0.3 33.5 13.5
05 02 2009 00 09 12.3 54.000 -1.2 30.2 3 3 253.000 0 0.0 0.3 33.5 13.5
05 02 2009 00 10 12.2 54.000 -1.3 30.2 3 5 267.000 0 0.0 0.3 33.5 13.4
05 02 2009 00 11 12.2 54.000 -1.3 30.2 1 3 268.000 0 0.0 0.3 33.5 13.4
05 02 2009 00 12 12.1 54.000 -1.3 30.2 0 1 268.000 0 0.0 0.3 33.5 13.3
05 02 2009 00 13 12.1 54.000 -1.3 30.2 2 3 263.000 0 0.0 0.3 33.5 13.3
05 02 2009 00 14 12.1 54.000 -1.3 30.2 1 3 268.000 0 0.0 0.3 33.5 13.3
05 02 2009 00 15 12.0 54.000 -1.4 30.2 2 4 277.000 0 0.0 0.3 33.5 13.2
05 02 2009 00 16 12.0 54.000 -1.4 30.2 4 5 293.000 0 0.0 0.3 33.5 13.2
05 02 2009 00 17 12.0 54.000 -1.4 30.2 5 5 255.000 0 0.0 0.3 33.5 13.2
05 02 2009 00 18 11.9 54.000 -1.5 30.2 2 6 250.000 0 0.0 0.3 33.5 13.1
05 02 2009 00 19 11.9 54.000 -1.5 30.2 6 6 225.000 0 0.0 0.3 33.5 13.1
05 02 2009 00 20 11.9 54.000 -1.5 30.2 5 8 275.000 0 0.0 0.3 33.5 13.1
05 02 2009 00 21 11.9 54.000 -1.5 30.2 5 6 286.000 0 0.0 0.3 33.5 13.1
05 02 2009 00 22 11.9 54.000 -1.5 30.2 0 5 250.000 0 0.0 0.3 33.5 13.1
05 02 2009 00 23 11.8 54.000 -1.6 30.2 2 4 284.000 0 0.0 0.3 33.5 13.0
05 02 2009 00 24 11.8 54.000 -1.6 30.2 1 4 271.000 0 0.0 0.3 33.5 13.0
05 02 2009 00 25 11.8 54.000 -1.6 30.2 1 1 271.000 0 0.0 0.3 33.5 13.0
05 02 2009 00 26 11.8 54.000 -1.6 30.2 2 4 276.000 0 0.0 0.3 33.5 13.0
05 02 2009 00 27 11.7 54.000 -1.7 30.2 2 4 273.000 0 0.0 0.3 33.5 12.9
05 02 2009 00 28 11.7 54.000 -1.7 30.2 2 2 246.000 0 0.0 0.3 33.5 12.9
05 02 2009 00 29 11.7 54.000 -1.7 30.2 2 2 246.000 0 0.0 0.3 33.5 12.9
05 02 2009 00 30 11.7 54.000 -1.7 30.2 1 4 265.000 0 0.0 0.3 33.5 12.9
05 02 2009 00 31 11.6 54.000 -1.8 30.2 2 4 279.000 0 0.0 0.3 33.5 12.8
05 02 2009 00 32 11.6 54.000 -1.8 30.2 5 6 280.000 0 0.0 0.3 33.5 12.8
05 02 2009 00 33 11.6 54.000 -1.8 30.2 0 5 281.000 0 0.0 0.3 33.5 12.8
05 02 2009 00 34 11.5 54.000 -1.9 30.2 2 2 256.000 0 0.0 0.3 33.5 12.7
05 02 2009 00 35 11.5 55.000 -1.5 30.2 2 3 254.000 0 0.0 0.3 33.5 12.8
are we talking wunderground csv file format now, or still vws csv file?
This is not working. I have separated out a couple of months from the CSV file and created a new CSV file to import. It does not import. So what am I missing here?
This is becoming entirely to complicated to do a simple import of archived data. WD should be able to handle any CSV file regardless of how its time frame break up. Maybe the software writer
will add this to the “to do list”? 30 days on a trial is certainly looking to be to short of a time frame to experiment and make the switch.
I’d like to purchase the software, but this situation leads me to think of what else may be a hidden problem.
You never get a second chance to make a first impression.
Windy,
I separated out a couple of months of a VWS CVS file because you say WD can only handle monthly time frame.
I created a new VWS CVS file (by cutting and pasting from the origianl CVS file to the new file) and called it Jan2009.cvs. I tried to import it via WD and the software does NOTHING. No import. So whats the deal? Spending way too much time for what should be a simple procedure.
Any help at this point is a plus.
the import does in fact work if the data to import is in the expected format
its then a simple 1 click task for each month of data
your data obviously is not in the correct needed expected format
if you could .zip and email me the data you are trying to import , I will test/check here
I will see what I can do. The files are huge and I don’t think the ISP will support such a large file.
By the way I am using the 1 click approach in WD (Import VWS file) to import but, again, the limitations of WD expecting it to be in a monthly format seems to be the road block here, yes?
not sure why you call that a limitation
WD stores the data monthly, not as yearly files
and so to import the data , it needs to be aligned that way
others have done this VWS csv file import with no problems
I will check /test with the file you have sent me
there seems to be some confusion here
the files you have sent me, the monthly files, are already converted to WD logfile format logfiles
so the final step now is to convert those logfiles to data file, via, action, convert WD logfiles to data files
(select each logfile in turn and click on convert)
I tested that with one of the logfiles you had sent me, and that worked
Brian. Yes there was an important part of the instructions not mentioned. Thank you for clearing that up. All the data appears to be converted and is now visible. A payment is forthcoming!
glad you got it sorted, and thanks for purchasing 