SAP Knowledge Base Article - Public

2987746 - Transformation Rules Not Working in Item Connector - LMS

Symptom

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.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  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

Cause

The transformation rule for Item Connector is not enabled.

Resolution

  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.

Keywords

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

Product

SAP SuccessFactors Learning 2005