We have a list of thousands of prospects to import. An important field in the account information is the e-mail address, but the import fails and display error for all accounts that have either an error in the e.mail address e.g name@domain. (her the .com is missing as an excample). also the import list can display just a “-” or any other character or sign, if so the import fails and the account will not be imported! On the other hand if the e-mail address field(cell) in the import list has no information and totaly blanc, the import is successful.
so, even if our account list for import (excel CSV) has some error in the e-mail cell/field we ned to have the account imported.
This is critical for us and wwe have not yet been able to import our 20.000 prospects due to this issue.
I apreciate your help on this.
SECONDLY: When importing the any list duplicates are made no matter selection of “Create new records only” or " create new records and update existing records"
(Should this issue be a separate Topic maybe?)