SAP Knowledge Base Article - Public

2532750 - First record from file is skipped with sf user connector run

Symptom

  • Admin manually places file with two users records on sftp
  • Admin schedules SF User Connector to run in LMS
  • First record from file is skipped and only second user is successfully created in LMS instance

Environment

Learning Management System (LMS)

Reproducing the Issue

1. As an Admin create a csv. file with two test users and place it on sftp

1.PNG

2. Run sf user connector in LMS instance by navigating to system admin > connectors > User connector SF

3. Once run has been completed, check the results of run by clicking on "view results" button and downloading the result report

4.PNG

3.PNG

6.PNG

4. In downloaded results we can see that only one record has been processed - the second row - user 1049 that we can verify by checking if the user has been created in LMS

    Users > type user ID "1049" and can see that this user exists in LMS

5.PNG

5. Other user from file "1048" cannot be found in LMS

Cause

  • When running sf user connector after manual placement of file on sftp, this file has to consists of two headers
  • First headers in file are names of fields in BizX
  • Second headers in file are names of corresponding fields in LMS

Resolution

  • Add missing second row to file with corresponding headers

7.PNG

  • The corresponding fields names can be found in connector workbook
  • For customized fields, connector configuration settings for custom columns mapping needs to be checked in system admin > configuration > system configuration > connectors

Keywords

  • user sf connector did not create user record, manual run of sf user connector
, KBA , LOD-SF-LMS , SuccessFactors Learning , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors Learning 1511 ; SAP SuccessFactors Learning 1602 ; SAP SuccessFactors Learning 1605 ; SAP SuccessFactors Learning 1608 ; SAP SuccessFactors Learning 1611 ; SAP SuccessFactors Learning 1702 ; SAP SuccessFactors Learning 1705 ; SAP SuccessFactors Learning 1708 ; SAP SuccessFactors Learning 1711 ; SuccessFactors Learning 1502 ; SuccessFactors Learning 1505 ; SuccessFactors Learning 1508