Symptom
Is it possible to apply a default value to a user field through connector?
Environment
SAP SuccessFactors Learning
Reproducing the Issue
- 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" >
- 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 >
- 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:
- At Learning Administration > System Administration > Configuration > System Configuration >
- Open the CONNECTORS configuration in the edit mode >
- Add the setting for the required field (for ex., sfuser.field.transform.data.PHON_NUM1_DESC.@DEFAULT@=TEST) > hit 'Apply Changes' >
- 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
- 2569693 - Connector DefaultValue configuration logic
- Engage Certified Partner to Import Data to SAP SuccessFactors Learning
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