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.

• Related Articles

• Configure User Additional Fields

  Based on your requirements, the default user record can be customized using different types of additional fields. This is useful to capture user-related additional information. Role Required: SDAdmin Go to Admin > Organizational Details > Roles. ...

• View, Edit, or Delete User Additional Fields

  You can view all user additional fields and perform various actions under Admin > Organizational Details > Roles. Role Required: SDAdmin To edit a field, click the icon. Make necessary changes and click Save. To delete a field, click the icon against ...

• Contract - Additional Fields

  Additional fields are used to capture extra information related to contracts. Based on your requirements, the default add contract form can be customized to include different types of additional fields. To configure additional fields, go to Admin > ...

• Purchase - Additional Fields

  Additional fields can be used to capture extra information necessary for request resolution.Based on your requirements, you can add these additional fields into the default purchase order template. To configure additional fields, go to Admin > ...

• Purchase Request - Additional Fields

  Additional fields are used to capture extra information related to purchase requests. Based on your requirements, the default purchase request template can be customized to include different types of additional fields. To configure additional fields, ...