Import Errors

Import File Format

All data import files must be in the Comma Separated Values (.CSV) format. In many cases, there are issues with the file itself that will not allow it to be validated during the processing step in Fleetio.

If you have problems importing your data using a CSV file created by Excel, please try using Google Sheets or Apple Numbers. Excel can sometimes cause data formatting issues when saving CSV files.

You can test the file at http://csvlint.io/ to ensure your file meets CSV standards.

Import History

View a history of all imports by going to your Account Menu and selecting Imports.

Filter Imports

Search for an Import using the search box, or use the available Filter options: Type, Status, Created On, Created By, and Completed On.

Import State

After launching the import process described in the Data Import Overview, your import will briefly display a State of "Queued".

Once the file has been processed, a toast message will appear on the bottom right of the screen with a link that reads Complete: (Name of Import) You may have to refresh your browser to see the changes. Click this link to refresh your screen.

The import State will update according to the results. If the State is Complete, no errors were found. Review the imported records to ensure that all data displays as intended.

If your import contains any errors, the State will display as Failed or Partially Complete.

A previous import that has been reversed will display the State as Rolled Back.

Common Causes for Failure

• Duplicate entries are in the report (the same vehicle appears twice in the report)
• A unique identifier is not listed in the file mapping (a common field that tells Fleetio where to save the fuel/service/meter entry to)
• Meter readings or fuel entries cannot be validated based on the mileage and/or date specified in the file (meter reading in file is less than meter reading currently in the system)
• Data in the file is not formatted correctly (see format requirements for the specific field in question, in the corresponding article for the import data type)

Import - Failed

If errors are found in ALL rows of the source file, the import State is Failed. No records have been imported.

Click the number link in the Failed Records column to display the error details.

The Failed Records link identifies the specific row(s) that contain import errors that need to be addressed, along with a link to Export CSV with Errors.

The More Actions button includes options to Download Original File and Download Error File. The Rollback option is disabled since there are no imported records available to roll back.

The Error File includes a column explaining the cause of the issue. Fix any typos or incorrect entries, then retry the import.

Import - Partially Complete

If errors are found in only SOME rows of the source file, the import State is Partially Complete.

Fleetio will import the rows with no errors and omit rows with errors. You may download the Error File to fix any errors and re-import failed rows.

Click the Failed Records number link to view details and Export CSV with Errors:

Or, click the More Actions menu to Rollback, Download Original File or Download Error File.

Rollback is available for 1 day after import, and only for new records (not updates via data import).