When using the “name” as a duplicate control when importing accounts it seems that there are just a certain number of spaces in the field of the account name that are checked toward beeing a duplicate. We have many companies with long names and often for companies with many outlets or departments they have the same “long” name, but in addition they might have the location name added in the company name. So when importing I get a long list of duplicates because it seem that only the first part of the company name is checked. This duplicate function should check against all spaces/characters in the complete company name. The way it is now I can not import all branches/outlets of aa company since.
If I choose not to have this security check for duplicates the system makes duplicates of any company listed in the importfile if the company is in the list. I just made a misstake today and imported 17.000+ accounts/companies from a list I actually imported yesterday! So now I spendt 4 hours deleting them again.
Hi Egil,
You would need to modify the way the import script runs to accommodate your requirements.
Thanks,
Will.