The Emsada Console allows you to import contacts into a Customer record from a csv file.
The CSV file is required to have the following headings in the following order:
Company, FirstName, Surname, Telephone, Mobile, Email, Description, AltTelephone (Optional)
Once you have prepared your CSV file please do the following:
- Open the Emsada Console and open Customers from the Main Menu
- Double-click the customer you want to import into
- Click Import in the Contact section of the Ribbon
- Browse to the CSV file and click Open. The contacts will now import.
Export from Active Directory
If you wish to export contacts based on users in AD you can do the following:
- On the Domain Controller open Active Directory Module for Windows PowerShell
- Run the following command:
Get-ADUser -Properties * -Filter {mail -like '*' -and Enabled -eq $true} | Select-Object Company, GivenName, Surname, TelephoneNumber, MobilePhone, Mail, Description | Export-CSV -Path C:\Temp\Contacts.csv
The file C:\Temp\Contacts.csv will have the required columns for Emsada and can be imported directly into the console.