Importing User-Defined Fields

Importing User-Defined Fields


Role Required: SDAdmin

You can import default user attributes such as the login name, distinguished name, and domain name fields. Other user attributes such as phone, mobile, department, office, jobTitle, and email are mapped to LDAP attributes in the sdldapfieldmap table.

For example, to map the field Emp ID to the employeeID attribute of your directory, such as AD or openLDAP, you'll need to do the following:

Insert a row in the sdldapfieldmap table by executing the following insert query in your database server:
  1. insert into sdldapfieldmap values (7, null, 'employeeid', 'employeeID', true);
Note that the ID column is 7, because there are 6 entries, by default. 

To import any more additional fields, such as user defined fields, the SDAdmin or users with database access can map the API Field Name to the corresponding LDAP attributes in the sdldapfieldmap table.

For example, to map the user defined field, Company to the Company attribute of your directory, you must insert a row in the sdldapfieldmap table using the following insert query:
  1. insert into sdldapfieldmap values (8, null, 'udf_pick_1', 'company', true);

The API Field Name will be listed under the corresponding column under Admin > Organizational Details > User Additional Fields.

Restart the server after executing the queries. Then, import your users to the LDAP server.