Configuring User Accounts › LDAP Directory Data › Batch Import Contacts Using LDAP Data › Batch Import Contacts by Date and Time

Batch Import Contacts by Date and Time

You can configure the pdm_ldap_import utility to import LDAP records that were created before or after a specified date and time. To enable this functionality, create an ldap.mod file with the following content:

OBJECT ldap {
  ATTRIBUTES LDAP_Entry {
    whenCreated whenCreated STRING ;
  };
};

This adds the whenCreated attribute to the LDAP object.

The rules for filtering records using the whenCreated attribute are as follows:

• Use only the >= or <= operator.
• Specify all characters for the date/time value, including the Z. Place a 0 in any location you do not wish to explicitly state (for example, the time of day).
• Place the date/time specification at the beginning of the filter; do not use leading 0s at the beginning of the string.
• Do not include the leading century. For example, to specify the year 2008, use 08.

Note: Single quotation marks must surround the date/time value.

Example: Using the whenCreated Attribute to Import LDAP Entries

The following example uses the whenCreated attribute to import LDAP entries created after 3/11/2008.

Pdm_ldap_import -l "whenCreated >= '080312000000Z'"

Example: Using the whenCreated Attribute to Search for LDAP Records

The following example uses the whenCreated attribute with pdm_ldap_test to search for LDAP records created after 3/11/2008.

pdm_ldap_test.exe -f "whenCreated>=080312000000Z" -a whenCreated
Starting ldap_test.exe...
LDAP Directory Type	: active directory
Service Desk Platform	: windows
Search Base	: DC=kirklandsd,DC=ca,DC=com
Search Filter	: (&(objectClass=person)(whenCreated>=080312000000Z))
Administrator Username	: CN=Administrator,CN=Users,DC=kirklandsd,DC=ca,DC=com
Administrator Password	: **********
LDAP Host	: gecko.kirklandsd.ca.com
LDAP Port	: 389
LDAP API Version	: 3
DN: CN=aixmail,CN=Users,DC=kirklandsd,DC=ca,DC=com
        whenCreated(17)(0): 20080312035327.0Z
DN: CN=hpmail,CN=Users,DC=kirklandsd,DC=ca,DC=com
        whenCreated(17)(0): 20080312035425.0Z
DN: CN=sunmail,CN=Users,DC=kirklandsd,DC=ca,DC=com
        whenCreated(17)(0): 20080312035726.0Z
3 Total LDAP records found...