SAP Knowledge Base Article - Public

2469848 - How to apply a default value to a user field through connector using the @DEFAULT@ property

Symptom

Is it possible to apply a default value to a user field through connector?

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. While trying to run the User Connector - SF to update a particular user field for all the users (for ex., the Phone number description, which is already populated as "TESTDESC"), the expectation is to update the field with the value "TEST" >
  2. At the connector's input file, under the column "PHON_NUM1_DESC" there is no value provided and at the CONNECTORS configuration file there is this setting sfuser.connector.defaultValue.PHON_NUM1_DESC=TEST >
  3. After the connector runs, is possible to observe that the field's value was not updated to "TEST".

Cause

Please note that the configuration sfuser.connector.defaultValue 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.

Once the record already exists with any value at any point of time, then the defaultValue setting cannot be used to update entities with a default value.

Resolution

For situattions where it's required to to apply a default value to all the users when the defaultValue setting cannot be used, it's possible to use the @DEFAULT@ property:

  1. At Learning Administration > System Administration > Configuration > System Configuration >
  2. Open the CONNECTORS configuration in the edit mode >
  3. Add the setting for the required field (for ex., sfuser.field.transform.data.PHON_NUM1_DESC.@DEFAULT@=TEST) > hit 'Apply Changes' >
  4. After the User Connector - SF is executed, the users' records should have their Phone number description updated to "TEST".

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

IMPORTANT: Learning connectors can import thousands of entities in the system, so we highly recommend that customers engage with our Professional Services organization or a certified Learning implementation partner before attempting to use connectors or any data import. Additionally, it's recommended to always test in a Stage/Preview tenant first.

See Also

Keywords

sf, sfsf, lms, learning, admin, administration, connector, update, configuration, null, default, setting, property, defaultValue, user, connector, value , KBA , LOD-SF-LMS-CON , Connectors , How To

Product

SAP SuccessFactors Learning all versions