SAP Knowledge Base Article - Public

2928179 - Date transformation rules for Custom Columns - User Connector

Symptom

Customer wants to edit the date format of a custom column when using the User Connector.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

Customer has a custom column coming from BizX, present in the input file, with a date format as following: MM/dd/yyyy, but they would like to transform it to dd/MM/yyyy.

Resolution

  • Firstly check if you have already mapped your Custom Column correctly to indicate that the header ID (from the input file) will be received and stored by the specific LMS custom column, as required. To know more about mapping rules, please check the "See Also" session below.
  1. On Learning Adminstration: Go to System Administration > Configuration > System Configuration > find the CONNECTORS configuration file and click to edit;
  2. Add the required transform rule to the configuration file and click "Apply Changes".
  • e.g: if we are using the User Connector and LMS receives the date information as "01/24/2021" (MM/dd/yyyy) from the input file (column COL_NUM3_VAL in the mapped field), we can transform it in the required format, which is "24-01-2021" (dd-MM-yyyy) by using the following transform rule:
    • user.field.transform.date.format.COL_NUM3_VAL.dd-MM-yyyy=MM/dd/yyyy

So the rule will be basically the following:

  • user.field.transform.date.format.<LMS CUSTOM COLUMN ID>.dd-MM-yyyy<or another date format required on LMS>=MM/dd/yyyy<or another format coming in the connector input file>
  • sfuser.field.transform.date.format.<LMS CUSTOM COLUMN ID>.dd-MM-yyyy<or another date format required on LMS>=MM/dd/yyyy<or another format coming in the connector input file>

NOTE: Since connectors can be used to import thousands of records in the system, we highly recommend that you engage with our Professional Services team before attempting to utilize a connector to import/update data, especially in a production environment. Please, check the following documentation if further information is necessary:

See Also

Keywords

custom column, LMS, transform, rules, date pattern, change, userconnector, sfuser , KBA , LOD-SF-LMS-CON , Connectors , How To

Product

SAP SuccessFactors Learning 2005