Format of csv file to import historical data

[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

[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)?

[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

[schitho]

Program works, I could import my historical data.

[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..);