Bulk Import : the LDAP Users into AgileApps

Overview

This article shows you how to import the existing users present in an LDAP server into the AgileApps platform, without forcing each user to access and login to the AgileApps system. Assign tasks or records to the users which can be picked up and worked upon when they login to the AgileApps platform.

Actors

Any user who has the User Management and Import and Export Data administrative permissions can perform the required operations to import the LDAP users through a data import. For more information on permissions, see Administrative Permissions.

Before you begin

Ensure to configure the required tenant capabilities for the tenant using the ISV login. For more information on capabilities, see Manage Tenant Capabilities.

Import LDAP Users to AgileApps

To import the LDAP users to the AgileApps platform, you have to perform the following:

1. Install the application package.

2. Import the CSV file into the object available in the installed application.

Install the application package 

1. Click ldapuserimport10.11.zip to download the application package.
2. Navigate to Settings new ui.png > Administration > Account Management > Packages.
3. Click Install from File.
4. Select the application package zip file ldapuserimport10.11.zip and click on Next.
5. In the Install Package screen, For ROLES in the package section, select Merge roles.
Note: This section may not be visible if you are installing the package for the first time.
6. Share the resource, a) LDAPUserImporter object and LDAPUserImporter custom class to any existing application, for example - ServiceDesk application, by navigating to Settings new ui.png > Customization > Resource Sharing.

Import the CSV file into the Object

1. Click LDAPUsers.csv to download the sample CSV file.
2. Insert the LDAP users' basic information into the CSV file as follows:
a) First Name
b) Last Name
c) Email Address (present in LDAP server)
d) Username (present in LDAP server)
e) Access Profile Id (same as the LDAP configuration in AgileApps)
f) Team Id (same as the LDAP configuration in AgileApps)
g) Applications Access (support for multiple applications with their associated roles)
 Syntax:App_1_Id:App_1_Role_1_Id,App_1_Role_2_Id,App_1_Role_3_Id_::_App_2_Id:App_2_Role_1_Id,App_2_Role_2_Id,App_2_Role_3_Id
 Example:27df9a485b1141b1bae84089c5fe47d1:a19362ffe33b4635a0bcd761d4c54b07,ca008895bc65498f929799d8ce680b99_::_1:dfff7507ad7d4347816552a44dad455c,49a47b32804c4932a252c7c36c95999e
h) Record ID (any unique number)
i) Owner ID (3 - the System user, however, you can also mention any valid user id present in AgileApps)
2. Navigate to Settings new ui.png > Administration > Data Management > Import Data.
3. In the Import Data screen, In the Choose the Target Object drop-down list, select LDAPUserImporter.
4. In the Upload CSV File tab, select Choose File and then select the LDAPUsers.csv file. set the Encoding Type
    as UTF-8 and click Next.
5. In the Map Columns tab, map the corresponding columns from the CSV file to the object fields and click Next.
6. In the Confirmation screen, verify your mapping and click Ok.
7. In the Set Attributes tab, let the fields be as is.
8. Click Start Import.
    Note: Once the user creation is successful, the records from the LDAPUserImporter object are deleted. 

Logs

You can view the log messages for user creation or failures in Debug Log screen by navigating to  Settings new ui.png > Customization > Developer Resources > Debug Log.

Conclusion

All the LDAP users mentioned in the CSV file are created in the AgileApps platform. You can now select these users from the User Lookups to assign any tasks or records.

However, the synchronization of users' information with the LDAP server happens only when the respective user logs into AgileApps with his or her valid credentials.

ldapuserimport.zip (54.3 KB)

LDAPUsers.csv (470 Bytes)

ldapuserimport10.11.zip (9.93 KB)