SAP Knowledge Base Article - Public

2266821 - Nullifying custom columns via User Connector

Symptom

Able to nullify default user columns as mapped in the User Connector HelpGuide, but unable to update on null any custom column(s) mapped in the connector configuration file.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Go to System Administration > Configuration > System Configuration > Connectors > Edit
  2. Map the custom column(s) desired to one of the user connector i.e. user.field.mapping.data.COL_NUM8_VAL=Cust_Col_Name (where 'Cust_Col_Name' is the name of the custom column as referenced in input file)
  3. Map the update on null property to the custom column i.e. user.connector.updateOnNull=Cust_Col_Name (where 'Cust_Col_Name' is the name of the custom column as referenced in input file)
  4. Apply changes
  5. Upload the input file containing the null values for custom column field(s).
  6. Run the User connector.

Cause

  • The issue lies with the way the custom column(s) has been mapped in the Connector Configuration file. The custom column(s) concerned need to be remapped and the update on null property constructed differently.
  • Custom columns are mapped/constructed using a slightly different format to that of the default columns, e.g. COL_NUM8_VAL is for column number 80, the new syntax corresponding to this is CUSTOMCOLUMN_80. So the property should be written as: user.connector.updateOnNull= CUSTOMCOLUMN_<column number>

Resolution

To resolve this issue, you need to follow the following steps:

  1. System Administration > Configuration > System Configuration > Connectors > Edit
  2. First, remap the custom column(s) desired using the following constructs: e.g. user.field.mapping.data.COL_NUM8_VAL=Cust_Col_Name (where 'Cust_Col_Name' is the name of the custom column as referenced in input file).
  3. You can find the column number as shown below:

    CustomColumn_User.png
  4. Map the update on null property to the custom column(s) using the following construct: e.g. user.connector.updateOnNull=CUSTOMCOLUMN_80 (where 'CUSTOMCOLUMN_80' is the actual custom column ID corresponding to the number shown and not the reference column name it is currently mapped to: 'Cust_Col_Name')
  5. Apply changes.
  6. Upload the input file containing the null values for custom column field(s).
  7. Run the connector.
  • This will resolve the issue and you will now be able to nullify fields mapped to the custom column(s) for the user connector. 
  • If you wish to use the property for multiple custom columns, you can use comma separator, e.g. user.connector.updateOnNull= CUSTOMCOLUMN_80,CUSTOMCOLUMN_10,CUSTOMCOLUMN_150
  • In addition, you can use user.connector.updateOnNull=CustomColumns to apply to all User Connector custom columns; although it is recommended to use individuals instead or engage a partner to discern possibilities for the file feed or dummy values to be used instead for unknown column behaviors.

IMPORTANT INFO:

While the updateOnNull property is a common user connector property, and available for all connectors; it is currently not handled by the Item Connector and is therefore unavailable at this time; in addition support is limited on using the with User Connector - SF and KBA 2222795 regarding.

See Also

2222795 - SF Extended User updateOnNull for Custom Columns - LMS

Keywords

SF, successfactors, learning, lms, connectors, custom columns, null, values, nullifying, fields, configuration, updateonnull, property, user.connector.updateOnNull , KBA , LOD-SF-LMS-CON , Connectors , LOD-SF-LMS , Learning Management System , How To

Product

SAP SuccessFactors Learning all versions