Reply To: CSV Import – Blank Page result

03/30/2015 at 9:28 am #330012
Steven Zahm
Keymaster

@ Reshma

I did reply yesterday as promised… a long post too and it seems to gone. It seems like WP does that to me once a month and always on a long reply too, frustrating!

Any way, what I determined was that this is definitely a PHP memory resource issue. I was able to replicate the exact issue on my dev site as you are experiencing on your site.

I estimate about 80%+ of your CSV file is empty… all that empty is going to take up the same amount of memory as actually having data in those fields. It’s just the way PHP works.

You have two options.

The first, remove all those empty columns. This is probably the easiest and is what I did in testing. After I remove all the empty columns, I was able to do a test import just fine.

The second solution. I created a copy of the CSV file with only 5K rows and I was able to get to the mapping step just fine, but I didn’t actually do the import. I suspect it’ll import just fine.

Lastly, WPLocalPlus does mess up the styling of the mapping step, so I highly recommend deactivating the plugin while you do the import. If you notice any admin inconsistencies with styling or broken functionality with any plugin, my suggestion would to be first to try deactivating that plugin to see if the issue goes away. Seeing as how much stuff it loads on every admin page, it is bounds to interfere with other plugins too.

Hope that helps!