Troubleshooting
An import file does not upload or cannot be read
Why a bulk import file does not upload, or an error appears instead of the dry-run report, and how to solve it.
If the file does not pass the checks, no dry-run report is created. The upload area gives the reason below the file's name. Follow the section below that matches this warning.
The upload stopped halfway
If the connection dropped or the server did not answer for a while, press Try again in the upload area. You do not need to select the file again. If the warning "Too many uploads right now. Try again a little later." appears, wait a little and try again as well.
The file is too large or its type is not accepted
An import file can be at most 20 MB. Split a larger file into several files. Only files with the .csv, .xlsx and .json extensions are accepted. Save an Excel file in the .xlsx format. An empty file is rejected too.
The file cannot be read
The warning "The file could not be read. Check its format (CSV, XLSX or JSON)." has these causes:
- The CSV file cannot be read as text or its format is broken. Save the file again as "CSV UTF-8".
- The XLSX file is broken or its content is too large.
- The JSON file is not valid JSON or does not hold the records as a list.
The format is taken from the file's extension. Every file other than XLSX and JSON is read as CSV.
Columns are unknown or missing
- The warning "The file has unknown columns." does not say which columns are unknown. Compare the header row with the template, then delete the extra columns or correct their names to match the template.
- The warning "The file lacks required columns." means that the file has no
typecolumn, or has neither of thetitle_trandtitle_encolumns.
The valid column names are in Import Columns.
There are no rows or too many rows
If there is no data row below the header row, the warning "The file has no data rows." appears. At most 5000 rows are imported from one file. Split a longer list into several files.
At most 100,000 rows of an XLSX worksheet are read, empty rows included. If the sheet is longer, a note in the report's Notes box says so. If there is data in the later rows, split the file.
The file did not pass the virus scan
No records are created from a file in which the virus scan found a problem. Produce the file again from a clean copy and upload it.
Uploads are switched off
The message "File uploads are switched off at the moment." in the upload area means that file uploads are switched off on the site. The system administrator switches uploads on again with the File uploads switch on the Site settings → Features tab.
The source system name is not valid
The Source system name field accepts only letters, digits, full stops, underscores, colons and hyphens. Remove Turkish-specific letters and spaces, then upload again.