Symptom
For example locale IDs in BizX are es_MX, fr_CA and en_US. The Locale IDs in LMS are Spanish Mexican, French Canadian, and English.
We want to translate the value from BizX to LMS for English, Spanish, and French on the sf user connector, and the English translation works, but the Spanish and French don’t. If we set the rule as Spanish Mexican the system automatically adds an equals symbol (Spanish=Mexican) on the sfuser.field.transform.data.LOCALE statements.
If we use an underscore we get an error. Either way the locale is not being set correctly. It won't allow the space in the locale ID.
The transformation rule we used (System Admin-> Configuration-> System Configuration-> CONNECTORS) are:
sfuser.field.transform.data.LOCALE.French=Canadian=fr_CA
sfuser.field.transform.data.LOCALE.Spanish=Mexican=es_MX
Environment
SAP SuccessFactors Learning
Reproducing the Issue
- Add transformation rule(s) in the Connector Configuration File (System Admin->Configuration->System Configuration->Connectors) such as:
sfuser.field.transform.data.LOCALE.Spanish Mexican=es_MX
or sfuser.field.transform.data.LOCALE.Spanish_Mexican=es_MX
or sfuser.field.transform.data.LOCALE.Spanish/Mexican=es_MX
- Run the User SF Connector with es_MX in the 'LOCALE' column of the input file
- Those rows with es_MX will be excepted with an error such as Entity does not exist.LocaleID: Spanish_Mexican
Cause
Records can be rejected if, for example, there is a locale language transformation rule that contains spaces between words in the connector XML file.
- Spanish Mexican saved as Spanish=Mexican, causing the records to be rejected.
Resolution
- To resolve this problem in CONNECTORS xml file, navigate to System Admin-> Configuration-> System Configuration-> CONNECTORS
- Place a back slash in between the two words and click apply changes. For Example: sfuser.field.mapping.data.LOCALE.Spanish\ Mexican=es_MX
- Run the connector to load the records successfully
The application will sync automatically with internal transformation rule; when changing locale in BizX, the change will be automatically reflected on Learning. In this case, there is no need to add transformation rules in the UI for locale. And you might want to remove the ones you already put there which transform the locale to names LMS can't recognize and throws an exception.
Note: However, if you want to update locales and timezones via SF - User Connector, the transformation rules will be needed to reflect the changes on LMS.
See Also
2459580 - How BizX SEB & ODATA Web Service syncs user data to SF LMS
2738874 - SF User Connector Transform Timezone is not working
2250834 - Timezone and Currency field not getting updated in LMS via the SF user connector
Keywords
locale, locales, Transform, Connectors, transformation rule, SF user connector, sfuser.field.mapping.data , KBA , LOD-SF-LMS-CON , Connectors , LOD-SF-LMS , Learning Management System , How To