Format of csv file to import historical data

Discussion about upload/download of data, import/export of foreign formats, etc.
Post Reply
schitho
Posts: 12
Joined: Sun Sep 08, 2013 5:30 am

Format of csv file to import historical data

Post by schitho » 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

skyewright
Posts: 69
Joined: Tue Mar 16, 2010 12:05 pm
Location: Isle of Skye
Contact:

Re: Format of csv file to import historical data

Post by skyewright » Wed Oct 09, 2013 9:53 am

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

schitho
Posts: 12
Joined: Sun Sep 08, 2013 5:30 am

Re: Format of csv file to import historical data

Post by schitho » Wed Oct 09, 2013 6:40 pm

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
Posts: 12
Joined: Sun Sep 08, 2013 5:30 am

Re: Format of csv file to import historical data

Post by schitho » Sun Oct 20, 2013 12:10 pm

Program works, I could import my historical data.

Jhenry
Posts: 1
Joined: Thu Apr 23, 2015 6:42 am

Re: Format of csv file to import historical data

Post by Jhenry » Thu Apr 23, 2015 6:43 am

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

Post Reply