KNOWLEDGE BASE ARTICLE

Umango Extract Fixed Index Lookups

Note: Only available in versions after and including 5.1.50

Many values not provided in the default system indexes can be retrieved through the use of Fixed Index Lookups without having to build Zone scripts. Lookups are mainly used for LDAP property values relating to the user that created the batch or date and time related values. We create references to these properties as follows:

In the job properties area, select the Indexes > Fixed Indexes tab. You can create fixed indexes of any name and use a lookup in the value field.

LDAP Properties

Active Directory values (based on the user who is the batch creator) can be used by referencing LDAP property names as shown in the examples below:

• LDAP(homeDirectory) - The home directory of the batch creator
• LDAP(mail) - The email address of the batch creator
• LDAP(givenName) - The first name of the batch creator

A full listing of LDAP properties can be found here. Most of the properties relating to users can be used.

Date and Time Properties

Date and time related values (based on batch export time) can be used as shown in the examples below:

• DateTime(dddd) - The full name of the day of the week
• DateTime(ddd) - The abbreviated name of the day of the week eg. Mon Tue etc
• DateTime(HH) - The hour, using a 24-hour clock from 00 to 23
• DateTime(MMMM) - The full name of the month
• DateTime(\T\o\d\a\y\ \I\s\ dddd) - The full name of the day of the week preceded by some text. The result would be Today Is Friday

A full listing of the date and time segments that can be used can be found here.

A more detailed article on Umango data lookups can be found at http://umango.com/KB?article=80.

Link to this article http://umango.com/KB?article=72