OrgPlus 9 - 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 too 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 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 (for example, server=someserver.somenet)
Protocol Protocol specifies version 2 or 3 of LDAP. (for example, protocol=3)
user Login name (for example, user=cn=some_dn
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
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

Example LDAP data connection file:

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 9 Professional 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 9 Knowledge Base Articles

 

Validate TRUSTe privacy certification