SAP Knowledge Base Article - Public

2266821 - Nullifying custom columns via User Connector

Symptom

The customer has an issue where they are able to nullify default user columns as mapped in the Connector Workbook, but they are unable to update on null any custom column(s) they have mapped in the connector configuration file.

Environment

Learning Management System (LMS)

Reproducing the Issue

  1. Go to System Admin >configuration > System Configuration > Connectors > Edit
  2. Map the custom column(s) desired to one of the user connector: 'user.field.mapping.data.COL_NUM10_VAL=Cust_Col_Name' (where 'Cust_Col_Name' is the name of the custom column number 10 as referenced in input file)
  3. Map the update on null property to the custom column: 'user.connector.updateOnNull=Cust_Col_Name' (where 'Cust_Col_Name' is the name of the custom column number 10 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 (or SF 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 as documented in the Connectors Workbook. 

Resolution

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

  1. System Admin >configuration > System Configuration > Connectors > Edit
  2. Then remap the custom column(s) desired to the connector you of your choice using the following constructs: 'user.field.mapping.data.COL_NUM10_VAL='Cust_Col_Name' (where 'Cust_Col_Name' is the name of the custom column number 10 as referenced in input file).
  3. Map the update on null property to the custom column(s) using the following construct: 'user.connector.updateOnNull=CUSTOMCOLUMN_10' (where 'CUSTOMCOLUMN_10' is the actual custom column name and not the column name it is currently mapped to: 'Cust_Col_Name')
  4. Apply changes.
  5. Upload the input file containing the null values for custom column field(s).
  6. Run the connector.

This will resolve the issue and you will now be able to nullify fields mapped to the custom column(s) for eith of the user connector.

IMPORTANT INFO:

Whilst the updateOnNull property is a common connector property, and available for all connectors, it is currently not handled by the Item Connector and is therefore unavailable at this time.

 

Keywords

  • Connectors
  • Custom Columns
  • Null values for custom columns
  • Nullifying fields for custom columns
  • Connector Configuration
  • UpdateOnNull property
, KBA , LOD-SF-LMS , SuccessFactors Learning , How To

Product

SAP SuccessFactors Learning all versions