Meteotemplate Forum

Hi all (again - sorry! I'm a teacher on half-term at the moment; I'll be back to work and leaving you in peace next week!)

I am having issues importing data from an edited WeatherCat Export csv into MT.

I think I've done everything correctly but I'm getting date & pressure issues.

If anyone can shed some light on it I'd be most grateful.

I'm attaching screen shots to help.

Thank you in advance for your time!

Cheers,

Rich

http://rochesterweather.org.uk

http://rochesterweather.org.uk/WeatherCatData.txt This has 4 digit years

http://rochesterweather.org.uk/WeatherCatData.csv This has 2 digit years - neither work!

When I import data from WeatherCat, I typically will use the format WC generates but just strip out the "T" between the Date and Time. For the date/format within Meteotemplate I use this:

Y-m-d H:i:s

Hopefully that gets you a little closer to making this work.

Jay

Hi!

Thanks - I'll give it a try and come back to you.

R

Oh, I forgot.... I always strip the header information too. Not needed for the import but optional. Also, check your field numbers. They do not look right. See my previous screenshot for an example.

This exact thing is happening to me, the exact same time error and pressure error. I finally gave up and quit trying. I'm thinking there is a bug in the import code.

Thanks - that is interesting as I tried it again without header row and it hung.

When I did it with, trying all different combinations of the possible variablesI still kept getting the same error codes.

I might try and re-import my old MT data which doesn't go as far back as my WeatherCat data and see if I have more joy!

R

Right! Success!

I have imported my old backed-up MT database. I needed to enclose the date format in the import.php page in double quotes (") - this is what they were enclosed in in the alldata.csv file.

I am now going to try to turn the WeatherCat exported data file dates into the same using find and replace in Word and I'll let you know how it goes!

R