Why am I getting format errors for my contacts?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
When I import a list (CSV with just email field) it shows each contact as having a format error. I checked the contacts and all look good. This previously worked without issue.

Why did this happen?

Should I manually change the status on all contacts to active?
Photo of Carilion Clinic

Carilion Clinic

  • 5 Posts
  • 1 Reply Like

Posted 4 years ago

  • 0
  • 1
Photo of Emily Hollingsworth

Emily Hollingsworth, Alum

  • 2203 Posts
  • 158 Reply Likes
Hi there! I'm sorry for the trouble. If you don't mind uploading that file to your documents library (on the Campaigns page), I can download it and take a look! Just let me know the file name when it's all uploaded. We'll first identify why the import is acting up, then we can address the status of those email addresses. Thanks!
Photo of Emily Hollingsworth

Emily Hollingsworth, Alum

  • 2203 Posts
  • 158 Reply Likes
Hello again! I was able to isolate the problem here. You're addresses are going straight to zero because Emma is recognizing those spaces at the end of your email addresses. A simple find and replace to locate those spaces and delete them (those steps are outlined below in my reply to Carilion) will get your file in tip top shape. You will want to be sure to delete all of the addresses that imported into error status first. Then reimport your file after cleaning up those spaces. 

Let me know if you have any trouble with this process!
Photo of NorthBay EA

NorthBay EA

  • 3 Posts
  • 0 Reply Likes
Thanks, Emily. I saw your post yesterday which suggested this fix and tried it out. After removing all of the spaces, the addresses still imported with formatting errors. Any other suggestions?
Photo of Emily Hollingsworth

Emily Hollingsworth, Alum

  • 2203 Posts
  • 158 Reply Likes
I failed to mention in that original reply that you need to delete the error contacts first that imported originally. Did you include that step before you reimported the file?
Photo of NorthBay EA

NorthBay EA

  • 3 Posts
  • 0 Reply Likes
Thanks, just did that and it worked!
Photo of Landrum Human Resources

Landrum Human Resources

  • 3 Posts
  • 2 Reply Likes
I had the same error and was getting so frustrated!!!  The Find and Replace worked perfectly!!!!  Thank you so much.
Photo of Emily Hollingsworth

Emily Hollingsworth, Alum

  • 2203 Posts
  • 158 Reply Likes
Hey there Carilion - I have a theory on why those email address are importing as error. You can do a find and replace search on your email column in the import file to see if there are any extra spaces at the end of those email addresses. Just put a space in the find field and leave the replace field blank. If it finds and replaces any spaces, you should be able to import that file seamlessly. 

Let me know if that works for you!
Photo of Carilion Clinic

Carilion Clinic

  • 5 Posts
  • 1 Reply Like
Yes, it seems as though the extra spaces are the problem. Thanks for your help.
Photo of Florence-Lauderdale Public Library

Florence-Lauderdale Public Library

  • 25 Posts
  • 1 Reply Like
Hi, I'm new to Emma. I'm having the same problem, but the find and replace didn't fix the issue (and I did delete the contacts first). Any other ideas for fixes?
Photo of Florence-Lauderdale Public Library

Florence-Lauderdale Public Library

  • 25 Posts
  • 1 Reply Like
From what I've researched, it sounds like these are non-breaking spaces used in the code, and that's searching for a regular space doesn't work. But all the suggestions I've found haven't been working, either. Anyone else had this issue? I'd rather not have to delete spaces on 5000 fields.
Photo of Florence-Lauderdale Public Library

Florence-Lauderdale Public Library

  • 25 Posts
  • 1 Reply Like
Your file worked! I have no idea what the difference was, but I'll take it. I have two more files to upload. I'll see if I have better luck with those.
Photo of Emily Hollingsworth

Emily Hollingsworth, Alum

  • 2203 Posts
  • 158 Reply Likes
So strange! You might try copying the email addresses into a new excel file and then doing the find and replace. I think something about your originally exported file is causing the problem!
Photo of Florence-Lauderdale Public Library

Florence-Lauderdale Public Library

  • 25 Posts
  • 1 Reply Like
I found a solution! One of my coworkers suggested actually copying and pasting one of the spaces that were showing up and doing a "find" for that. It worked! I had found suggestions for different keystrokes to search for a non-breaking space, but none of them worked. Copying and pasting the space did.  The second file imported just find after doing that. So if you ever have someone else with spaces that won't go away, have them copy and paste that space into the find field. 

I was using the list in Excel for Mac (which doesn't always work quite right), so I wonder if that somehow created the problem. Thank you for sticking it out with me.
Photo of Emily Hollingsworth

Emily Hollingsworth, Alum

  • 2203 Posts
  • 158 Reply Likes
Of course! I'm glad to hear you found a solution. I'll remember that one for next time. :)