Format of csv file to import historical data
Posted: Sun Sep 08, 2013 7:31 am
Hi,
I used weathercat on my mac to process the data from my vantage vue. Two days ago I activated meteoplug. I exported the old data out of weathercat as csv files, but I wasn’t able to import it into meteoplug. I modified the file in different ways but I always found in the server log the message: RAWIMPORTLOOP : processing failed and file deleted...
I found the docu concerning wswin, but it didn’t help me much. I need information about the exact rules how the data records must be formated (e.g. column headings required, date and time format, sequence oft he data..);
The original export out of weathercat looks like:
Datum, Wetterlage, Ext. Temperatur,Taupunkt,Windkühle,Luftdruck,Windgeschwindigkeit (10 Min. Schnitt),Windrichtung Durchschnitt,Niederschlag pro Stunde,Niederschlag gesamt,Ext. Luftfeuchtigkeit,Int. Luftfeuchtigkeit,Int. Temperatur,Windspitze (10 Min),Leaf Wetness 4,Regenmenge Monat,Regenmenge Jahr,Tägl. Verdunstung (E.T.),Monatl. Verdunstung (E.T.)
2013-09-06T00:01:00,N/A,18.3,14.8,18.3,1012.05,0.0,156,0.00,0.00,80,52.0,25.8,0.0,0,0.00,606.40,0.00,0.00,
2013-09-06T00:11:00,N/A,18.2,14.9,18.2,1012.05,0.0,156,0.00,0.00,81,52.0,25.8,0.0,0,0.00,606.40,0.00,0.00,
2013-09-06T00:21:00,N/A,18.1,14.8,18.1,1012.02,0.0,156,0.00,0.00,81,52.0,25.8,0.0,0,0.00,606.40,0.00,0.00,
I modified it to something like that and many others e.g.:
Datum;Zeit;Temp. A.;Luft. A;Temp. I.;Luft. I;Druck;wind;windricht.;rain0
06.09.13;00:01:00;18.3;80;25.8;52;1012.05;0;156;0
06.09.13;00:11:00;18.2;81;25.8;52;1012.05;0;156;0
Thanks for any help.
Kind regards, Thomas
I used weathercat on my mac to process the data from my vantage vue. Two days ago I activated meteoplug. I exported the old data out of weathercat as csv files, but I wasn’t able to import it into meteoplug. I modified the file in different ways but I always found in the server log the message: RAWIMPORTLOOP : processing failed and file deleted...
I found the docu concerning wswin, but it didn’t help me much. I need information about the exact rules how the data records must be formated (e.g. column headings required, date and time format, sequence oft he data..);
The original export out of weathercat looks like:
Datum, Wetterlage, Ext. Temperatur,Taupunkt,Windkühle,Luftdruck,Windgeschwindigkeit (10 Min. Schnitt),Windrichtung Durchschnitt,Niederschlag pro Stunde,Niederschlag gesamt,Ext. Luftfeuchtigkeit,Int. Luftfeuchtigkeit,Int. Temperatur,Windspitze (10 Min),Leaf Wetness 4,Regenmenge Monat,Regenmenge Jahr,Tägl. Verdunstung (E.T.),Monatl. Verdunstung (E.T.)
2013-09-06T00:01:00,N/A,18.3,14.8,18.3,1012.05,0.0,156,0.00,0.00,80,52.0,25.8,0.0,0,0.00,606.40,0.00,0.00,
2013-09-06T00:11:00,N/A,18.2,14.9,18.2,1012.05,0.0,156,0.00,0.00,81,52.0,25.8,0.0,0,0.00,606.40,0.00,0.00,
2013-09-06T00:21:00,N/A,18.1,14.8,18.1,1012.02,0.0,156,0.00,0.00,81,52.0,25.8,0.0,0,0.00,606.40,0.00,0.00,
I modified it to something like that and many others e.g.:
Datum;Zeit;Temp. A.;Luft. A;Temp. I.;Luft. I;Druck;wind;windricht.;rain0
06.09.13;00:01:00;18.3;80;25.8;52;1012.05;0;156;0
06.09.13;00:11:00;18.2;81;25.8;52;1012.05;0;156;0
Thanks for any help.
Kind regards, Thomas