Hi all;
I've asked about difficulties with importing data from VWS to Wetterstation a few days ago. I've tried to find the answer and came up with this.
-) On several points in the file “2004dbase.csv” there we’re empty cells.
-) In a few cases the date was not correctly saved by VWS. To give you an example;
The correct way data must be saved in a cell is:
200401010140,112.500,9.251,9.251,41.000,77.000,23.778,0.667,1020.362,8.100,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,-5.907,23.783,2.795,-2.898,1021.039,-59.032,488.887,-602.174,1.168,4.938,-8.766,6.143,3.019,1.088,0.500,0.186,-0.271,187.247,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,-3.925,0.234,-0.235,-0.175,187.449,0.000,0.000,0.000,0.000,3.273,4.441,0.000,8.833,0.000,4.441,0.000,3.273,4.441,0.000,3.273
VWS saved like this:
0401010140,112.500,9.251,9.251,41.000,77.000,23.778,0.667,1020.362,8.100,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,-5.907,23.783,2.795,-2.898,1021.039,-59.032,488.887,-602.174,1.168,4.938,-8.766,6.143,3.019,1.088,0.500,0.186,-0.271,187.247,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,-3.925,0.234,-0.235,-0.175,187.449,0.000,0.000,0.000,0.000,3.273,4.441,0.000,8.833,0.000,4.441,0.000,3.273,4.441,0.000,3.273
The first two numbers are missing.
-) At one time there was only one number in a cell, there was only a “5” and not the whole array of numbers.
-) A lot of time the data is stored double by VWS. This however doesn't seem to affect the import proces by Wetterstation.
I’ve phone another weather amateur that uses VWS and asked him to check his “2004dbase.csv” file. He got the same errors but on different cells. It looks like that this is a bug in VWS. I’ll try to get an answer on the forum of Ambient to get VWS make the correct savings.
After correcting the "2004dbase.csv" file , Wetterstation is importing the data without any difficulties.
Sorry that the answer is in English, my German is more than rusty

. Maybe someone can translate it to German if wanted?
Regards
Dirk
http://www.weerstation-hellevoetsluis.nl