Knowledge Base

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

We use cookies to personalize and enhance your experience on our site. Visit our Privacy Policy. to learn more. By using our site, you are agree to our use of cookies. Accept and Close