2084735 - Error - Unable to import file. This might be due to one of the following - Compensation

SAP Knowledge Base Article - Public

2084735 - Error - Unable to import file. This might be due to one of the following - Compensation

Symptom

  • When importing a file via executive review you get the error Unable to import file. You are using compRating
  • Unable to import file. This might be due to one of the following:

    . File is not in Excel format.

    . File was not saved in earlier versions of Excel (Excel 97-2003).

    . Original file was not exported from the system

       1.png

 

Environment

  • Compensation

Cause

  • Invalid field format in Excel when using compRating. Excel will not correctly set the field type to number. The exported data is a text type and needs to be correctly changed back to a number format with only numbers imported to compRating.

Resolution

Check if compRating is being used in the form template and if it is an editable field. If it is used and is editable too proceed as follows:

  • Once you export the file change the Data Type of compRating column from General to number.

       2.png

 

  • Enter the number rating without the text. Example if rating is "2 - Didn’t meet the expectation", then just put 2 in compRating column.
  • Once that done save the file and import

 

Keywords

KBA , sf error messages comp-varpay , LOD-SF-CMP , Compensation Management , How To

Product

SAP SuccessFactors HCM Core all versions