Understand errors during data import

This table shows the common error messages and troubleshooting steps.

Note: The first 20 records with errors are displayed on the screen. If additional errors occur, click Export to download the SPE data import log file for troubleshooting reference.


Error message	Possible reasons and troubleshooting steps
`File exceeds the maximum size limit of 10MB. Select another file and try again.`	The file size exceeds the 10MB limit. Ensure that you are importing the correct file. If the file contains too many records, consider splitting the records into two or more files.
`Invalid file format. Only CSV files are accepted.`	The file is not in CSV format. Ensure that the file has a .csv extension.
`Invalid file format. Ensure the CSV is saved in standard UTF-8 encoding.`	The CSV file uses an unsupported encoding format. If the file is confirmed to be a CSV, open it in Notepad. Select File > Save As, and ensure that the encoding is set to UTF-8.
`Missing required field(s). Check the file and try again: (field name)`	The import file is expected to contain a column with the header specified in the error message, but the column is missing or incorrectly named. Verify the import file against the data mapping to ensure that the column exists, contains data, and uses the correct header name.
`Related record cannot be found for (field name)`	The value provided for the specified field must match an existing record in the application, but no matching record was found. This issue may occur for fields such as organization, period, metric, KPI, or unit of measurement. For example: The file specifies organization code 310, but the code does not exist in the Organization Structure module. Ensure that the import file uses correct and existing values from the application.
`Missing required value: (field name)`	The field is required but has no value. Enter a value for the specified field.
`Value should be a number: (field name)`	The field requires a numeric value, but a non-numeric value was provided. Ensure that the value entered for the field is numeric.