OrgPlus 7 - Importing Data using LDAP
OP-0700-S1122
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 (1=no, 0=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:
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 7 Professional finish the import process.
Note: You may need to enter the Username and Password to access the LDAP
server:
Return to OrgPlus 7 Knowledge Base Articles