Page 1 of 1

Format of csv file to import historical data

Posted: Sun Sep 08, 2013 7:31 am
by schitho
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

Re: Format of csv file to import historical data

Posted: Wed Oct 09, 2013 9:53 am
by skyewright
http://wiki.meteoplug.com/Inspect_Data states
You can import data from your Meteohub system, WSWIN (EXPMM_YY.CSV files), Meteobase or previously saved Meteoplug data
Have you tried reformatting your data to match the Meteoplug export format (documented on the link at the start of this message)?

Re: Format of csv file to import historical data

Posted: Wed Oct 09, 2013 6:40 pm
by schitho
Thanks for your reply. Yes, I decided to write a program to split the weathercat data from one line to several and reformat it to match the export format.
Regards, Thomas

Re: Format of csv file to import historical data

Posted: Sun Oct 20, 2013 12:10 pm
by schitho
Program works, I could import my historical data.

Re: Format of csv file to import historical data

Posted: Thu Apr 23, 2015 6:43 am
by Jhenry
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..);