Importing Potential Duplicate Records

I want to import a spreadsheet of contact records, including an email for each record, into my CC environment. I suspect there might be existing records in CC for some of the records I want to import. The existing data in CC is MORE accurate and up-to-date that the data in the spreadsheet that I want to import. Thus if one of the records I import matches an existing record in CC I want the data in CC to persist and I want the data I am importing for that record to be tossed out. Can I set this up in CC? If not I can probably find a hack to do this in XLS and a massive export of all the records in my CC environment but that might be a big pain in the you-know-what. Thoughts?

1 reply
Best reply by William A

HelloĀ @BristolycĀ ,

Ā 

Anytime you import a file into your CTCT account, our system will treat that as the most up-to-date info - including for re-imports. Therefore, if you're wanting to not have your file import overwrite the information in place for already-imported contacts, you'll need to make sure they're not in that file.Ā 

Ā 

One potential way this canĀ easier is if you:

  1. Export your current CTCT contacts andĀ allĀ info
  2. Import the new list of contacts
  3. Import the exported CTCT contacts to overwrite that new list's changes to the pre-existing contacts

Ā 

For more info regarding contact file imports:

Format contact files for import

Duplicate contact removal suggestions

View original

šŸ—“ļø February 26th, 2:00 PM ET

Ready to master the ins and outs of getting your emails delivered? Join our experts for this free, one-hour webinar. You'll walk away with actionable strategies and tips.

Popular Posts: