Importing Company Contact Data


To import company phonebook data, first use the .CSV template and populate with the information required for import


Ensure each of the Parameters are within the type and character limit

ParameterImportanceRestriction
First NameAt lease one is requiredThe maximum character length is 127 (63 for first name and 63 for last name).
Last Name
Company NameOptionalThe maximum character length is 127.
EmailOptional

Only numbers, letters, and characters @ _ - . ' are allowed. Must start with a number, letter, or character _ and follow the email address format XXX@XXX.XX.

The maximum character length is 255.

Business NumberAt lease one is requiredNumbers, letters, and characters ( ) . - + * # are allowed.

The maximum character length is 31.

Business Number 2Numbers, letters, and characters ( ) . - + * # are allowed.

The maximum character length is 31.

Business FaxNumbers, letters, and characters ( ) . - + * # are allowed.

The maximum character length is 31.

MobileNumbers, letters, and characters ( ) . - + * # are allowed.

The maximum character length is 31.

Mobile 2Numbers, letters, and characters ( ) . - + * # are allowed.

The maximum character length is 31.

HomeNumbers, letters, and characters ( ) . - + * # are allowed.

The maximum character length is 31.

Home 2Numbers, letters, and characters ( ) . - + * # are allowed.

The maximum character length is 31.

Home FaxNumbers, letters, and characters ( ) . - + * # are allowed.

The maximum character length is 31.

OtherNumbers, letters, and characters ( ) . - + * # are allowed.

The maximum character length is 31.

ZIP CodeOptionalThe maximum character length is 255.
StreetOptionalThe maximum character length is 255.
CityOptionalThe maximum character length is 255.
StateOptionalThe maximum character length is 255.
CountryOptionalThe maximum character length is 255.
RemarkOptionalThe maximum character length is 1024.
PhonebookOptionalPermitted value: One or more phoneb


Leading Zero's are usually removed in spreadsheets when adding data, to mitigate this set each number column to text, this will treat Zero's as characters.


When complete, ensure you resave in .CSV format.


Import the contact data, if this errors, make sure no existing contact information has been entered.