importing csv

[Allan]

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

[mark1million]

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

[Allan]

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

[simpilot]

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.

[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.

Awesome will give it a go, Simpilot

Regards,

Allan

[Allan]

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

Regards,

Allan

[simpilot]

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?

[Guest lorathon]

my 2 cents....

I have had the same problem and it turned out to be geonames acting slow. Apparently I was missing an airport and when phpVMS went to look it up at geonames it would stall. I figured it out and then waited a day or so and then it was fine. Not sure if this is the same issue but just thought I would throw it out there.

[simpilot]

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.

[Guest lorathon]

Don't be sad . I am not sure if he importing DB side or Admin side.

Maybe Allan can tell us LOL

[Allan]

I was trying to import it the the phpvms admin section

Regards,

Allan

[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

[Guest lorathon]

See this....

http://forum.phpvms.net/topic/3998-memory-on-server-issues/

[Allan]

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

Regards,

Allan

[Guest lorathon]

its the config file in phpvms

core/local.config.php

[Allan]

Can you point me in the right directions please

Regards,

Allan

[Guest lorathon]

Add this to the bottom of the local.config.php file located in core/

ini_set("memory_limit","16M");

[Allan]

thanks will give it a try

Regards, Allan