Symptom
We have noticed a discrepency between the number of records the connector has processed and the number of records in our user_data and extended_user data files.
For example:
- User data file = 263 records
- Extended User file = 213 records
- Processed records = 333 (and no records were rejected)
Environment
- SAP SuccessFactors HCM suite
- Learning Management System (LMS)
- System admin > connectors > User connector -SF
- View results > Processed
- Show archived input files > # of records contained in files
Cause
- All the records have been processed correctly.
- The way the connector counts the records is as follow: All the records in user_data file + all UNIQUE records in user_extended_data file = processed records
- Unique means that there is no record for the same user in the user_data_file (specific to updating certain fields for an existing user)
For example: User A is changing region and this field is mapped in my extended user file, there is no other update to this user record.
User A will have a record in the extended_user_data file ONLY but no record in the user_data file.
Resolution
By using a lookup formula in Excel, we were able to determine the number of unique records in the extended_user_data file and confirmed that this number, added to the records in the user_data file do match the total number of processed records.
- Unique extended records = 70 records
- User data file = 263 records
- Total processed records = 263 +70 = 333 records
Keywords
SAP, SF, Successfactors, LMS, learning, connnectors, SF connector, User connector -SF, records, processed, archived, input file, user file, extended user file , KBA , LOD-SF-LMS-CON , Connectors , LOD-SF-LMS , Learning Management System , How To