Symptom
When attempting to import a Role-Mapped Competencies file, receive an error:
Invalid number for field [Weight].
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP SuccessFactors Talent Intelligence Hub
Reproducing the Issue
- Log in to SuccessFactors
- Navigate to Admin Center > Tools > Import and Export Data
- In the Select the action to perform dropdown, select Import Data
- Select the CSV File tab
- Locate the Select Generic Object field and select Role-Mapped Competencies
- Populate all relevant details and select a file > Import
- Navigate to Admin Center > Tools > Scheduled Job Manager
- Locate the MDF Data Import job and select View Details
- Open the file and it shows the error
Cause
Numeric values are not populated in the weight columns
Resolution
Any columns including the word weight in Row 1 must have a numerical value populated. An example is below:
Adjust the rows to include numerical values only and the import will process successfully.
Keywords
success factors, sf, sfsf, tih, jpb, competencies, roles, mapped, mappings, missing, without, importing, files, cannot load, errors, failures, failed , KBA , LOD-SF-TIH-LIB , Attribute Library , LOD-SF-MDF-IMP , Import and Export Issues , Problem