2987746 - Transformation Rules Not Working in Item Connector - LMS

There are instances where some transformation rules are not taking effect when Item Connector runs. For example, even after adding the transformation rule item.field.transform.data.SUBJ_AREA_1.GEN_TOP="General Topic" to convert the label "General Topic" into the LMS Subject Area ID of "GEN_TOP", the Item Connector will still display an exception of Entity does not exist.SubjectAreaID: General Topic.

SAP SuccessFactors Learning

1. Navigate to References > Learning Activities > Categories
2. Click Add New
3. Set the Category ID field with value GEN_TOP
4. Set the Description field with value General Topic
5. Click Add
6. Navigate to System Administration > Configuration > System Configuration > Connectors
7. Add below property:
   • item.field.transform.data.SUBJ_AREA_1.GEN_TOP="General Topic"
8. Click Apply Changes
9. In the existing item_data input file, add the header SUBJ_AREA_1 with value of General Topic
10. Place the input file in the SFTP server
11. Navigate to System Administration > Connectors > Item Connector
12. Schedule the Item Connector to run
13. After the connector execution, click View Results > Exceptions

The transformation rule for Item Connector is not enabled.

1. Navigate to System Administration > Configuration > System Configuration > Connectors
2. Add below property:
   • item.connector.input.file.field.transformation.enable=true
3. Click Apply Changes

Note: Transformation rule won't work with NULL (N/A) value.

item connector, transformation, transformation not working, transformation rule not working, item, connector, rule, learning, lms, entity does not exist, configuration , KBA , LOD-SF-LMS-CON , Connectors , Problem