[Alexander Cadman]

After migrating our website to a new server, CSV Import seems not to work properly. The import hangs at “Please Wait…” and only about 35-40 entries get loaded.

What do I need to do?

[Holy Trinity Orthodox Church]

This thread seems to be similar to my issue: http://connections-pro.com/support/topic/partial-loading/

I extended my support license under the account “htoc”

[Steven Zahm]

I highly recommend reading both the CSV File Requirements and Tips sections in the documentation. If all points are followed it nearly always resolves import issue.

The issue in the other thread no longer applies because imports are handled completely differently now. One thing I highly suggest, is making sure you have upgraded to the latest version if you have not already.

Hope this helps, let me know.

[Rosie Taylor]

I’m having the same problem. Went from test server to production and I have lost all my entries. Nothing imports. I’ve tried leaving out Entry ID and using Google doc for the .csv file. Nothing imports. I paid for the CSV import plugin. I also loaded categories and settings using the JSON file.

I have to finish this tonight so I guess I’m going to be manually typing in all 100 records from scratch. Would love to know what happened in case I need to use this again in the future.

[Steven Zahm]

@ Rosie

I have not yet been able to replicate this on any site, even the few that have reported using their own CSV on their own site, so I am uncertain what the solution would be at this time. Like the couple others who have reported, I will be more than happy to take a look. What I’ll need is the CSV file your were trying to import and and temp WordPress admin so I can do test imports. The login details can be posted here as a private reply.

If you have already input the entries manually I would imported into a test category with unlisted entries so it would not affect your like directory.

[Alexander Cadman]

This reply has been marked as private.

[Steven Zahm]

I was able to get the file to import.

The import is done in batches of 100. Quite a while pack after testing on various web hosts I settled on this being a decent value for both shared hosts and more expensive hosts which give more server resources.

I was able to get the whole file to import by changing the value from 100 to 10 (this is a code change, not a setting). I also tried higher values than 10, but, those too, failed. This tells me it is a web host resource limit causing the imports to fail.

I see you have the PHP execution time limit and memory quite high. The thing is, you can actually set these values to anything you want, the host will “hard limit” these so you can not exceed whatever they set. My experience is most hosts do not disclose what exactly those hard limits are. I suspect that your web host has rather low hard limits which prevented even 20 at a time from importing without failing. Perhaps if you look into the PHP error log that might give some clue.

Anyway, I hope this helps!

ps. I left the code changed so it’ll only import 10 at a time.

[Dn. Alexander Cadman]

Thank you!

[Author]

Posts