Format of csv file to import historical data

Discussion about upload/download of data, import/export of foreign formats, etc.

Format of csv file to import historical data

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

Re: Format of csv file to import historical data

Postby 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
skyewright
 
Posts: 69
Joined: Tue Mar 16, 2010 12:05 pm
Location: Isle of Skye

Re: Format of csv file to import historical data

Postby 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

Postby schitho » Sun Oct 20, 2013 12:10 pm

Program works, I could import my historical data.
schitho
 
Posts: 12
Joined: Sun Sep 08, 2013 5:30 am

Re: Format of csv file to import historical data

Postby 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..);
Jhenry
 
Posts: 1
Joined: Thu Apr 23, 2015 6:42 am


Return to Handling Data

Who is online

Users browsing this forum: No registered users and 3 guests

cron