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.
- On Learning Adminstration: Go to System Administration > Configuration > System Configuration > find the CONNECTORS configuration file and click to edit;
- 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:
- SAP Help Portal: Engage Certified Partner to Import Data to SAP SuccessFactors Learning
- 2149831 - Contacting Professional Services, Partner and Account Management Team
See Also
- SAP Help Portal: Engage Certified Partner to Import Data to SAP SuccessFactors Learning
- KBA 2149831 - Contacting Professional Services, Partner and Account Management Team
- KBA 2318341 - LMS Connectors Knowledge Support and Tips (Topic 7.Connectors Mapping : Mapping / Custom Columns / Transformation Rules)
Keywords
custom column, LMS, transform, rules, date pattern, change, userconnector, sfuser , KBA , LOD-SF-LMS-CON , Connectors , How To