CSV data migration for contacts
Column list
| Name | Description | Type | Required |
|---|---|---|---|
| EXTERNAL_ID | Unique identifier of the contact | string of max 255 characters | ✅ |
| LASTNAME | Contact's last name | string of max 255 characters | ✅ |
| FIRSTNAME | Contact's first name | string of max 255 characters | |
| TITLE | Contact's title | undefined by default | |
| POSITION | Contact's job title | string of max 255 characters | |
| BIRTHDATE | Contact's date of birth | datetime in YYYY-MM-DD format | |
| MANAGER_EXTERNAL_ID | Unique identifier of the contact manager | string of max 255 characters | |
| SKYPEUSERNAME | Contact's Skype username | string of max 255 characters | |
| LINKEDINUSERNAME | Contact's LinkedIn username | string of max 255 characters | |
| FACEBOOKUSERNAME | Contact's Facebook username | string of max 255 characters | |
| TWITTERUSERNAME | Contact's Twitter username | string of max 255 characters | |
| ACCEPTBIRTHDAYREMINDER | Agrees to be contacted on their birthday | boolean | |
| ACCEPTUNSOLICITEDCALLS | Accepts unsolicited calls | boolean | |
| ACCEPTUNSOLICITEDEMAILS | Accepts unsolicited emails | boolean | |
| ACCEPTUNSOLICITEDSMS | Accepts unsolicited text messages | boolean | |
| ADDR1TYPE | Address 1 type (0 = office, 1 = home, 2 = other) | integer | ✅ if address 1 is filled in |
| ADDR1STREETLINE1 | Address 1 street line 1 | string of max 255 characters | |
| ADDR1STREETLINE2 | Address 1 street line 2 | string of max 255 characters | |
| ADDR1ZIPCODE | Address 1 postal code | string of max 255 characters | |
| ADDR1CITY | Address 1 city | string of max 255 characters | |
| ADDR1STATE | Address 1 region | string of max 255 characters | |
| ADDR1COUNTRY | Address 1 country | string of max 255 characters | |
| ADDR2TYPE | Address 2 type (0 = office, 1 = home, 2 = other) | integer | ✅ if address 2 is filled in |
| ADDR2STREETLINE1 | Address 2 street line 1 | string of max 255 characters | |
| ADDR2STREETLINE2 | Address 2 street line 2 | string of max 255 characters | |
| ADDR2ZIPCODE | Address 2 postal code | string of max 255 characters | |
| ADDR2CITY | Address 2 city | string of max 255 characters | |
| ADDR2STATE | Address 2 region | string of max 255 characters | |
| ADDR2COUNTRY | Address 2 country | string of max 255 characters | |
| PHONE1TYPE | Phone 1 type (0 = office, 1 = home, 2 = mobile, 3 = other, 4 = fax) | integer | ✅ if PHONE1VALUE is filled in |
| PHONE1VALUE | Phone number 1 | string of max 255 characters | |
| PHONE2TYPE | Phone 2 type (0 = office, 1 = home, 2 = mobile, 3 = other, 4 = fax) | integer | ✅ if a PHONE2VALUE is filled in |
| PHONE2VALUE | Phone number 2 | string of max 255 characters | |
| PROFESSIONALEMAIL | Business email | string of max 255 characters | |
| PERSONALEMAIL | Personal email | string of max 255 characters | |
| NOTE | Notes on the contact | string of max 4000 characters | |
| ACCOUNT_EXTERNAL_ID | External identifier of the associated account | string of max 255 characters | |
| PERSONA | Account persona | string of max 255 characters | |
| ACCEPTNEWSLETTER | Accepts newsletters | boolean | |
| EMAIL3 | Accepts newsletters | string of max 255 characters | |
| EMAIL4 | Accepts newsletters | string of max 255 characters | |
| EMAIL5 | Accepts newsletters | string of max 255 characters | |
| SALESNAVIGATORID | Sales Navigator identifier | string of max 255 characters | |
| MOBICRM_ID | MobiCRM internal identifier | string of max 255 characters |
