not all contacts imported

  • 1
  • Problem
  • Updated 1 year ago
Uploaded new contact sheet and not all contacts have imported. When you count the updates (1558) and new contacts (732), it does not equal the total count on the spreadsheet (2925). It is not showing any duplicates or skipped rows. 
Photo of Imperial Sugar Company

Imperial Sugar Company

  • 9 Posts
  • 0 Reply Likes

Posted 1 year ago

  • 1
Photo of Grey Stepp

Grey Stepp, Support Team Manager

  • 1695 Posts
  • 135 Reply Likes
Hi there!  The numbers that show on the Imports screen don't necessarily add up to the grand total that was on your sheet.  It's possible that there were contacts on your sheet that did not fit any of the criteria showed there.  

They weren't new, updated, duplicated, or skipped.   

So long as your spreadsheet fits these criteria, it's imported everyone:

1. Your spreadsheet is only one PAGE
2. The email addresses you're importing are only on one column of the spreadsheet (you can have other addresses in the sheet, but you can only import one column of email addresses) 
3. The import doesn't show ERROR after import

Let me know if you have any questions about this!  

- Grey 
Photo of Imperial Sugar Company

Imperial Sugar Company

  • 9 Posts
  • 0 Reply Likes
None of those are applicable here. Only one page. Only one column. No error after import. They have always matched before. I've used My Emma for years. This is the first time they have not matched.  I cannot take it at face value that they all imported when the system is showing me otherwise. 
Photo of Grey Stepp

Grey Stepp, Support Team Manager

  • 1695 Posts
  • 135 Reply Likes
Hey there!  

If those numbers have matched for you in the past it's been purely coincidental.  The numbers there have never been intended to be a full count of contacts on the spreadsheet. 

If you would like to double-check, I'd suggest uploading the list again and putting the contacts into a brand new Group.  You should see that the import numbers will read zero across the board, but all of the contacts will be added into the group that you assigned in the process.

Here's an example from my account where I uploaded the same list twice in a row:



You'll see the first time I uploaded, it added 9 new contacts, and the 2nd time it didn't add any.  But still the contacts were put into the group that I selected in the import process.  It just shows 0 because there were no NEW contacts on the list, and none of the contact information was updated, but they were added to the Group that I specified. 

Let me know if you have any questions about that.  

- Grey