Fuel Import Utility Setup
In order to get started, you will provide a sample of the import data. The file format must be either .CSV (Comma Separated Values, or Comma Delimited) or .TXT (Tab or Position Delimited Text File). An .XLS spreadsheet can be converted to .CSV using the Save As function.
The Fuel Import Utility matches any of the following fields from your data:
- odometer
- unit #
- date
- total volume consumed
- price
- total cost
- fuel type
- state
- vendor
- driver (must be in the format LastName, Firstname)
- tank (this is for on-site fuel tanks, and must correspond to the tank name in your fuel inventory)
We will provide you with 2 files: a configuration file and a mapping file. You will save these files to the Program Folder for Fleet Maintenance Pro. This varies on different computers but it is usually found on the C: drive in Program Files (x86)
Run the utility by going to Tools > Fuel Import Utility. If you have more than one fuel import file layout, you can use the radio button to select the appropriate one. Browse to your import file and click Import.
You will see a report of the Error List, if any. Here, the program reports to you any meter readings out of range, or any Unit #'s which failed to match your existing equipment list.
You can copy these results using the " Copy to clipboard" button if needed.
To check out the transactions you have imported, click the " Fuel" button in the toolbar at the top of Fleet Manager
Fuel transactions can be manually edited quickly and easily if you find errors.
Then, go to Reports > Fuel to view the available Fuel reports. These are two popular reports: