Importing Data using LDAP

Summary:

This article describes how to import data from a LDAP Database into OrgPlus to
build a chart. LDAP sources can include but are not limited to Microsoft’s
Active Directory and Exchange server.

In order to import using LDAP you must create a data connection file and then
use the Import Wizard to select that file.

Procedure:

To create a Connection to LDAP:

Select Import Data from the File Menu

Select “My employee data is ready to be imported“

Click Get Started

Select the Data Source – LDAP

Click the Next button

To create a data configuration file:

Create a file, of the extension type “.ldap”. Use the following parameters to
create your LDAP connection file:

Parameter	Description
server	LDAP server address (example – server = server.domain.domainext)
Protocol	Protocol specifies version 2 or 3 of LDAP (example – protocol = 3)
user	Login name (example – user = username)
rememberpassword	Keep encrypted password in LDAP config file (0 = no, 1 = yes)
skiplogin	Skips login dialog (0 = no, 1 = yes)
password	Encrypted LDAP server password is created by using the login screen at least once
filter	LDAP search filter string
base	The name of the entry to begin the search from (example – base = domain, dc = domainext)
acceptedfields	Indicates which attributes to return for each matching entry
multivalued	For multivalued attributes, choose to take only the first value (first), create new columns for each value (clone), or append each value in a single field (append)
lowercase	List of fields which should be forced into a lowercase. Useful for Position and ReportsTo fields

[logon]

server=server.domain.domainExt

protocol=3

user=username

password=password

rememberpassword=1

skiplogon=0

[config]

filter=(objectClass=organizationalPerson)

base=dc=domain,dc=domainExt

acceptedfields=dn,manager,cn,mail,telephoneNumber,PhotoURL,title,ou

Multivalued=append

lowercase=dn,manager

LDAP data connection file contents screenshot

To import data using LDAP:

Select Import Data from the File menu.

Select .ldap file you just created and click Open.

Use the import wizard in OrgPlus Professional to finish the import process.

Note: You may need to enter the Username and Password to access the LDAP
server:

LDAP Server Login dialog box

Return to OrgPlus Knowledge Base Articles

Knowledge Base