Address Book Format
Downloads includes an example.
To be valid, a CSV import file must include the following database columns as file headers in any order:
Database Name | Data Type | Nullable? |
---|---|---|
CustomerReference | string(100) | Yes |
AttentionTo | string(100) | Yes |
Organization | string(100) | Yes |
Address1 | string(200) | No |
Address2 | string(200) | Yes |
Address3 | string(200) | Yes |
City | string(50) | No |
Region | string(50) | Yes |
PostalCode | string(50) | Yes |
Country | string(50) | No |
Phone | string(50) | Yes |
AlternatePhone | string(50) | Yes |
string(100) | Yes | |
Notes | string(200) | Yes |
Residential | boolean (true/false) | Yes |
DUNS | string(200) | Yes |
LocationIdentifier | string(200) | Yes |
ExternalContactId | string(200) | Yes |
OutputItemPath | string(200) | Yes |
AddressValidated | boolean (true/false) | Yes |
UserName | string(200) | Yes |
Not all columns are mandatory. Leave an empty space (,,) for any not required in a row.
The Address Book CSV file is case insensitive, and will accept numerous variations of values, such as True, true, Y, y, Null, etc.
On encountering a duplicate, provided the user opted to remove duplicates and UserName is valid, the existing row is overwritten. Otherwise a new contact is added.
Article last edited 24 March 2017