Importing Fuel Transactions And Meter Readings
Maintenance Pro supports importing CSV files containing fuel transactions and meter readings, streamlining data entry and eliminating the need for manual input.
Fuel Import
The following data can be imported as fuel transactions using a CSV file.
Mandatory fields:
- Equipment Unit ID (can substitute this with a Fuel Card # if needed)
- Fuel Transaction Date
- Primary Odometer Reading
- Volume Of Fuel (how much fuel was used for the transaction)
- Unit Price
Optional fields:
- Vendor Name
- State
Here is an example of what we're looking for:
A sample CSV file can be found here:
Turning On Fuel Import
If fuel import is not already enabled on the account, submit a copy of the fuel file to be imported. The import settings will then be configured, and fuel import will be activated. Send the file via email to support@mtcpro.com, including the organization name.
Once fuel import is enabled, a CSV file of transactions can be tested. Click the cloud icon with the up arrow in the top-right corner and select the Fuel Import option.
The system will prompt for the file to import. Locate the CSV file in the file explorer window and select Open. The system will then process the import.
Once the file has finished processing, fuel transactions can be viewed in the unit’s history. To access this, select the unit from the equipment list, navigate to the History tab, and choose the Fuel category.
To reverse a fuel import, click the cloud icon and select Manage. Choose the import to be undone and click the Undo Import button. Note that imports can only be reversed within 72 hours of processing.
Meter Import
The same process applies to meter imports. The following values can be imported using a CSV file:
- Equipment Unit ID
- Meter Reading Date
- Primary Meter
- Secondary Meter (optional if you do not use a secondary meter on your equipment).
The following is an example of the expected format:
A sample template file for Meter Updates is provided below:
To enable meter import, submit a copy of the meter template via email. The import settings will be configured and the feature activated. Send the template to support@mtcpro.com, including the organization name.
To perform a meter update, click the cloud icon and select the Meter Import option. In the pop-up window, choose the CSV file and click Open.
The import will process in the same manner as fuel imports. Meter imports can also be undone within 72 hours if necessary.