[Reshma Tachkani]

Hi Steven

I am sorry to trouble you but I seem to be having a problem with importing a CSV file into my WP.

On clicking on ‘Map’ it takes me to a blank page
http://uslawyers4u.com/wp-admin/admin.php?page=connections_csv&action=map

I have enclosed the fields of the csv file with double quotes
I have enclosed the file to help you identify if there is a problem with the file itself.
I would really appreciate your help in this matter.
Many thanks
Reshma

[Steven Zahm]

@ Reshma

Which application are you creating your CSV file with?

If you are using Excel or LibreOffice, do not add the quotes in the spreadsheet. The application will add the quotes as needed.

If you are using Excel, save the file as a CSV, not CSV (MSDOS) or CSV (Mac).

Hope that helps, let me know.

[Reshma Tachkani]

Thanks Steven.
1)I have removed the double quotes. I have saved the excel file as a CSV file only.
BUt it doesnt work and at Step 2 still shows blank page.
I am trying to attach the file but the size is larger than the size allowed. Please advice me if you can check the file and how I can send it? By email perhaps?
Thanks. I can also send you the admin details howver I would like to carry out the import process myself if possible.
Thanks
reshma

[Steven Zahm]

@ Reshma

Oh… you’re getting the dreaded white screen of death (WSoD)? You click upload and then get a white screen?

How big is the CSV file? How many rows and actual file size? I see the filename is first10000.csv. If that mean there’s only 10,000… that should not be an issue at all.

Generally the WSoD is cause by two issues. PHP runs out of memory or a function in PHP does not exist or is a duplicate. More often than not, it is a PHP memory issue.

First, try the steps outline in this blog post.

Which method will work depends on your host. I suggest starting at the top and working your way down.

If that does not solve the issue…

Check the PHP error logs. They may reveal the source of the issue. If you do not know where they are, you’ll have to ask the host because where the log is will depend on the host.

While you are working on those items, please send me an admin account login. Use the Contact link at the bottom of the page. Please paste a link to this forum thread so I can relate the two.

You can attach a copy of the CSV file to a reply, just change .csv to .txt first. If that still does not work (it should), I’ll reply to the contact email so you can send it to me.

We’ll get this working really quick, I’m sure.

[Reshma Tachkani]

This reply has been marked as private.

[Steven Zahm]

@ Reshma

Ok, I’m logged in. The first thing that I see is the the WPLocalPlus Intl plugin is slightly misbehaving. It is loading its CSS and JS and a bunch of other third party JS libraries rather than limiting them to its own admin pages. Generally that is considered bad practice. That could cause a problem or not but it is worth trying to deactivate it and giving it a try.

Guess, not, I tried a small 20 row CSV import and it was fine… though that plugins CSS does mess up the mapping step.

Still seems you were not able to upload the CSV file. Odd because uploading as a txt file always works because they are a permitted file type.

I’ll email you in a second and you can send me the CSV file as a reply.

[Steven Zahm]

@ 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!

[Reshma Tachkani]

Hey Steve

I am so sorry your email yesterday did not come through. Thank you very much for diagnosing my data and advising me on to rectify the problem.

I have followed your advice by deleted the blank columns and importing. It worked and I have been able to import (I think I havent counted yet) all thr records from the csv file.

I am very grateful for your help and support. Can I please ask at this stage if I can import a sample image/logo through my csv file. I can see the header row does not include any image field for the csv file. Is there a way I import a sample image for all the records imported?

Thank you for your time and support
Kind Regards
Reshma

[Steven Zahm]

@ Reshma

Great to hear it is working for you!

re: Can I please ask at this stage if I can import a sample image/logo through my csv file.
Sorry, no, this is not possible. Here’s a link to a QuickTip that you might be able to use instead.

[josh901]

Hi Steven,

I am experiencing this same issue on a relatively fresh install at http://visiteldorado2.wpengine.com/. I’ve managed to successfully import Connections data in the past to this site, so I’m a little perplexed why it’s malfunctioning now. I haven’t added any new plugins recently. I followed your guidance above regarding csv page formating, and have increased the PHP memory limit at the host. I’ve attached my csv file for your review. Any additional insight would be much appreciated!

Thanks
Josh

Attachments:

You must be logged in to view attached files.

[Author]

Posts