07-28-2019 07:03 PM - edited 07-28-2019 07:06 PM
Act! Premium Version 18.104.22.168, Update 2
Windows 10 Home v 1903
I'm importing new contacts from an EXCEL spreadsheet into my desktop version of ACT! Premium. I am also running the cloud version, although it is not open at present. I'm using a test database w/ only 2 contacts just to test the import. It works fine, EXCEPT that it is adding duplicates. This is despite me checking for duplicates and selecting either merge, or replace w/ source, it keeps adding the duplicate data. I now have each of the two records duplicated several times (see images).
Does this have anything to do w/ the fact that I have a cloud database? What am I missing? I have done this several times in the past, but it's been about a year since I last did any major imports.
07-31-2019 02:26 PM
Actually what I found works is Concatenating the First, Middle, and Last names and putting those in a separate "Contact" field, without any prefixes of suffixes. I also reordered the columns so they are in First, Middle, Last name order. I don't remember having to do this in the past, however.