importing csv

How do i increase the limit to what ever default is to 10 mb i have over 12,000 routes and i cant upload them,

Kind Regards,

Allan

Easiest way is top spilt the import to 3 or 4 files.

Easiest way is top spilt the import to 3 or 4 files.

I tried that and still errors out I have it split into 8 parts

Regards,

Allan

If you are on VPS or dedicated hosting look for

; Maximum allowed size for uploaded files.
; http://php.net/upload-max-filesize
upload_max_filesize = 2M

in your php.ini file and change it to what you need. Remember to restart the server after the change.

You may have to change the max-execution time temporarily as well, I think default is 30 or 60 seconds depending on the configuration your host uses.

If you are on shared hosting you may have to contact your host.

When I have a file that size I usually import it into a sql database on my local machine then export it as a gzip sql file and import that into the live database, that will sometimes work easier than other methods.

1 Like

If you are on VPS or dedicated hosting look for

; Maximum allowed size for uploaded files.
; http://php.net/upload-max-filesize
upload_max_filesize = 2M

in your php.ini file and change it to what you need. Remember to restart the server after the change.

You may have to change the max-execution time temporarily as well, I think default is 30 or 60 seconds depending on the configuration your host uses.

If you are on shared hosting you may have to contact your host.

When I have a file that size I usually import it into a sql database on my local machine then export it as a gzip sql file and import that into the live database, that will sometimes work easier than other methods.

Awesome will give it a go, Simpilot

Regards,

Allan

I have uploaded in 8 different parts, and only 792 of 12069 are showing any ideas??

Regards,

Allan

What did you do to get to that point? Did you change any settings, or did you try to load it into a local database and then upload it to your web server?

I wasn’t thinking of that… I had it in my head that he was trying to import directly into the db using phpmyadmin or something. It very well could be the geonames server if he is trying to import through the admin panel.

I was trying to import it the the phpvms admin section

Regards,

Allan

hey guys thanks for the response, I have got it working, now, there was airports missing , forget who said that, geo names can be the issue, but its workiing, thanks for helping me out

One issue now lol

Fatal error : Allowed memory size of 18874368 bytes exhausted (tried to allocate 38 bytes) in /hermes/web02/b2669/pow.aj5214/htdocs/core/classes/ezdb/ezdb_mysql.class.php on line 273

Best Regards,

Allan

What config is he talking about? He does not specify.

Regards,

Allan

Can you point me in the right directions please

Regards,

Allan

thanks will give it a try

Regards, Allan