SAP Knowledge Base Article - Public

2469848 - How to apply a default value to a user field in "User Connector".

Symptom

This tells about how to update a default value for user fields using @DEFAULT@ property in connector configurations.

Environment

LMS - Learning Management System

Reproducing the Issue

Try running user connector to update a particular user field(for ex: Phone number description, which is already having a value in the UI as "TESTDESC") for all the users, with a default value "TEST"

Note:In the feed file, under the column "PHON_NUM1_DESC" now there is no value provided and the below configuration exists in the connector configurations.

sfuser.connector.defaultValue.PHON_NUM1_DESC=TEST

Once the connector is run, you can observe that the value does not update to "TEST".

Cause

Please note that, the below configuration is only applied when the connector is processing the user records for the first time i.e. which do not have any value from the moment they were created in the instance.

sfuser.connector.defaultValue.PHON_NUM1_DESC=

Once, you have the record updated with any value at any point of time, then you cannot use the above default setting, to update with a default value.

Resolution

Now, for such situations, where in you want to apply a default value to all the users, who earlier had some value in the field(PHON_NUM1_DESC, in this example), add the configuration in connector properties, as mentioned below.

user.field.transform.data.PHON_NUM1_DESC.@DEFAULT@=TEST

NOTE: Please make sure that the column mapping is already in place, before adding the above configuration i.e. user.field.mapping.data.PHON_NUM1_DESC=PHON_NUM1_DESC(in this example)

By adding the @DEFAULT@ configuration, it then changes the value of the field from "TESTDESC" to "TEST"

Keywords

@DEFAULT@ User Connector  Default value , KBA , LOD-SF-LMS-CON , Connectors , How To

Product

SAP SuccessFactors Learning all versions