OrgPlus 9 - Importing Data using LDAP
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.
To create a data configuration file:
Create a file, of the extension type ".ldap". Use the following parameters to create your LDAP connection file:
|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:
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: