When importing contacts from CSV data, you may want to import more than one email into a contact. The default SugarCRM CE supports the import of two email addresses: a primary email address and one tertiary email address. More can be added manually later.
The primary email address is imported from column “Email Address” and the tertiary email address is imported from column “Other Email”. The “Email Address” will be marked as the primary in SugarCRM.
It is important to note that when importing email addresses into existing contact records, i.e. when updating contacts with new emails, all existing emails are deleted from the contact records. So a contact may start with five email addresses, but importing one email address will replace all five and not simply add to the list. This is not ideal behaviour, and is something I would hope to see improved in future versions of SugarCRM.
A Worked Example
This is the file I’m importing:
id,”Last Name”,”Email Address”,”Other Email”
Even though I know the ID of the contact I’m updating, the last name still needs to be provided to prevent the importer complaining that a mandatory field is missing. IMO that needs to to be fixed in SugarCRM – if an ID is provided and you are merging (i.e. updating) then the last name should not be required.
Here is the first stage presented when importing. The mappings are all automatic; I have not needed to adjust what field each column gets mapped to.
After importing, here is the contact record, with the two email addresses on:
This is SugarCRM 6.2.0 which is a few versions behind the latest now.