E M S A D A

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, GivenName, Surname, TelephoneNumber, MobilePhone, Mail, Description

Once you have prepared your CSV file please do the following:

  1. Open the Emsada Console and open Customers from the Main Menu
  2. Double-click the customer you want to import into
  3. Click Import in the Contact section of the Ribbon
  4. 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:

  1. On the Domain Controller open Active Directory Module for Windows PowerShell
  2. 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.

Note:

We recommend checking the output of the csv file for any entries you do not want imported, for example system accounts.

Related Post