Overview

This article shares the process of importing user accounts in Kerio Connect from CSV files or Directory Services.

Prerequisites

Access to the Kerio Connect administration console

Creating CSV Files for User Accounts
Importing User Accounts From CSV Files
Importing User Accounts From Directory Services

Creating CSV Files for User Accounts

The CSV files must have column headings that correspond to the Kerio Connect categories. Additionally, the individual fields of user account information must be separated using either of the following schemes:

Semicolons (;) with multiple values of a field separated by commas (,), as seen in the example below:

Name;Password;FullName;Description;MailAddress;Groups abird;VbD66op1;Alexandra Bird;Development;abird;read,all abird;Ahdpppu4;Edward Wood;Sales;ewood,wood;sales,all mtaylor;SpoiuS158;Michael Taylor;Assistant;mtaylor,michael.taylor;all

Commas (,) with multiple values of a field enclosed in quotations marks (" ") and separated by commas (,), as seen in the example below:

Name;Password;FullName;Description;MailAddress;Groups abird,VbD66op1,Alexandra Bird,Development,abird,"read,all" ewood,Ahdpppu4,Edward Wood,Sales,"awood,wood","sales,all" mtaylor,SpoiuS158,Michael Taylor,Assistant,"mtaylor,michael.taylor",all

Note: The Name (username) column is mandatory while there is no rule about the order of the columns.

Back to top

Importing User Accounts From CSV Files

Follow these steps to import the files:

Go to Accounts > Users.
Select a domain for importing users.
Click on Import and Export > Import from a CSV File.
Select the CSV file (Browse button) and confirm. This displays the list of users in the CSV file.
Select the users you want to import (you can use a template) and confirm.

Back to top

Importing User Accounts From Directory Services

Important: Secure your communication with SSL encryption to protect sensitive data (such as user passwords). To log information about the import, enable the Directory Service Lookup option in the Debug log before the import.

Windows NT Domain

Note: For this import, Kerio Connect must be installed on Microsoft Windows and must belong to the same domain.

Go to Accounts > Users.
Select a domain for importing users.
Click on Import and Export > Import from a Directory Service.
Enter the name of the Windows NT domain and confirm to view the list of users.
Select the users you want to import (you can use a template) and confirm.

Microsoft Active Directory

Go to Accounts > Users.
Select a domain for importing users.
Click on Import and Export > Import from a Directory Service.
Enter the following details and click confirm to view the list of users:
- Microsoft® Active Directory® domain name: Name of the Microsoft Active Directory domain.
- Import from server: Name of the server with Active Directory.
- Login as user / Password: Username and Password of an Active Directory user who has at least read rights.
- LDAP filter: custom LDAP filter settings. To enable it, click Advanced.
Select the users you want to import (you can use a template) and confirm.

Novell eDirectory

Go to Accounts > Users.
Select a domain for importing users.
Click on Import and Export > Import from a Directory Service.
Enter the following details and click confirm to view the list of users:
- NDS organization: Organization name.
- Import from server: Name or IP address of the server on which the service for the domain is running.
- Login as user / Password: Username and password of a user in this domain who has at least read rights.
- Custom LDAP filter settings. Click Advanced to enable it.
Select the users you want to import (you can use a template) and confirm.