Data import woes

[RochesterWeather]

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!

[MonyMony]

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

Screen Shot 2019-11-07 at 7.44.01 AM.png (689.02 KiB) Viewed 7127 times

[RochesterWeather]

Hi!

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

R

[MonyMony]

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.

[dmgould]

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.

[RochesterWeather]

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

[RochesterWeather]

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