Aurora Corporate documentation

Importing contacts

Aurora Corporate lets users import contacts from comma-separated CSV files as well as from standard contact lists in vCard format (VCF files).

VCF format is preferred as it's standardized (while CSV is not). In case if you cannot use VCF, you'll need to make sure the CSV you'll use for data exchange has the columns with certain names and values.

CSV file (comma-separated values) is technically a plaintext file with one database record per line. The first line of the file usually contains table headers. Aurora Corporate supports the following headers and columns of the following kind (headers are case-insensitive, unrecognized headers are ignored):

Aurora Corporate contacts field Supported CSV file headers
First Name FirstName
First Name
First
Last Name LastName
Last Name
Last
Full Name FullName
Full Name
EmailDisplayName
Email Display Name
DisplayName
Display Name
Name
Nick Name NickName
Nick Name
Title Title
Business Company Company
Business Department Department
Business Job Title Job Title
Business Email Business Email
Business E-mail
Business Web Site Business Web
Business Web Page
Business Website
Business Office Location Office Location
Business Street Business Street
Business City Business City
Business State Business State
Business Zip Code Business Postal Code
Business Country Business Country
Business Fax Business Fax
Business Phone Business Phone
Home Street Home Street
Home Address
Home City Home City
Home State Home State
Home Zip Code Home Postal Code
Home Country Home Country
Home Fax Home Fax
Home Phone Home Phone
Home Mobile Mobile Phone
Home Email Email
E-mail
E-mail Address
Email Address
EmailAddress
Home Web Site Web Page
Web-Page
WebPage
Personal Website
Notes Notes
Other Email Other Email
Other E-mail
Birthday Birthday
Date of birth


Aurora Corporate uses full name only, and if it is not available in CSV content, it is composed from First Name and Last Name.

In Aurora Corporate database, birthday is actually split into 3 fields for day, month and year. Various separators are recognized, any of the following formats should work: DD.MM.YYYY or DD/MM/YYYY or DD-MM-YYYY. Notations which start from year (e.g. YYYY.MM.DD) are handled properly as well.

As you can see, only English versions of Outlook are currently supported. If you use the product in other language, we suggest to modify CSV file manually and amend the headers using patterns from the above table.

You can download sample CSV file, it contains 2 entries, one of those has basic information supplied while the other entry has most of the fields filled.