SAP Knowledge Base Article - Public

2482151 - How to remove email address from users records on LMS instance

Symptom

The aim of the SAP Knowledge Base Article is to explain the options available to LMS Administrators to remove all the Email IDs of users from their user records.

Environment

  • SuccessFactors Learning Management System (LMS)
  • Release Independent

Cause

Such a step maybe needed due to business requirements. Also in situations where a system refresh has led to the email IDs being copied over, this KBA can help.

Resolution

The options that are available:

  1. If the intention is that the email address should not be updated through the connector, then remove the mapping that is currently updating the email addresses. Navigate to System Admin->Configuration->System Configuration->Connectors config file and search for the parameter: sfuser.field.mapping.data.EMAIL_ADDR=EMAIL.
    This needs to be changed to the below instead:
    sfuser.field.mapping.data.EMAIL_ADDR=

  2. Emails can also be purged by the LMS Admin by putting the SF user connector file in an excel and then deleting the email for the users while keeping the email column. This will effectively result in the Emails being null in the connector file for every user that is in the connector. After doing so, navigate to the connector configuration: LMS -> System admin -> configuration -> system configuration -> connectors. Here add the configuration preferably near the other sfuser.connector configurations:
     sfuser.connector.updateOnNull=EMAIL_ADDR.
    For more information, check SAP KBA 2185921 - Data getting nullified through connectors. This will allow the connector to put null in for the email addresses. If the connector file is then run, it will then make the emails empty for every user that is in the connector file. After doing so, do delete that configuration or comment out the configuration by placing a # before it (For example: #sfuser.connector.updateOnNull=EMAIL_ADDR).

  3. Finally Emails can also be purged on the DB level.  

Keywords

JIRA, Operations, mapping email addresses BizX System Admin Configuration CONNECTORS config file sfuser.field.mapping.data.EMAIL_ADDR=EMAIL sfuser.field.mapping.data.EMAIL_ADDR= purged sfuser.connector configurations 2185921 email addresses #sfuser.connector.updateOnNull=EMAIL_ADDR , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS , Learning Management System , How To

Product

SAP SuccessFactors HCM Core 1702 ; SAP SuccessFactors Learning all versions