Fuel Card Integrations: MPASS07
BP, Shell, Caltex, Mobil, and other fuel card interfaces
MPASS07
The WEX Motorpass (WEX) card can be used for purchasing fuel as well as a range for vehicle services such as maintenance, tyres, scheduled services etc. The file format must be .txt, i.e. Text (Tab Delimited). Column headings are expected in the file but not account opening and closing balances.
The MPASS07 interface has been introduced to allow the import of a revised file format introduced by Motorpass in 2015. That format was used in the "E07".
Sometime before 01/07/2021 WEX changed the file name to "E17" without a change to the file format.
This interface reads and ignore each row from the file until a row with the heading of "Account No" in the first column is reached.
Real data starts after the line starting with 'Account No' heading.
Maximum up to 100 rows are ignored if they do not have line starting with 'Account No' in it. If the line starting with 'Account no' is not found within first 100 rows, the file is invalidated.
You can leave these rows of the file in, or delete them prior to uploading if you prefer.
The '17' file format differs from the '05' file in the following ways:
Column 18, 'Merchant No', has been removed
All columns between column 7 'Amount', and column 17 'Driver Name', have been shifted 1 column to the right
The gap created in column 7 has been filled by the new field 'Transaction Time'
Product Code 89 is a WEX Fuel Rebate. These rebates are negative and reduce the fuel costs and (if applicable), the recharge amount of fuel.
The transactions import with a quantity value. The fuel data will change this to a zero quantity value when loaded into Catch-e. Doing this maintains continuity on fuel reports and billings where appropriate.
Validation and business rules for MPASS07.
- IF number of columns NOT = 30 (empty rows will fall into this category) OR column 14 (Voucher) NOT = 'Voucher' THEN File column validation fails with error message “The format of the Import File does not match the selected Card Interface! Please check your selections and try again!”
- Any row with empty column 1 or empty column 2 is ignored
- IF column 13 (product code) = 89 THEN fmfuel.quantity = 0 ELSE fmfuel.quantity = column 8 (Litres)
- IF column 17 (Brand Description) contains text 'NON FUEL' AND column 21 (Merchant Name) is populated THEN fmfuel.sitelocation = column 21 (Merchant Name) + column 23 (Merchant Suburb) ELSE fmfuel.sitelocation = column 16 (Brand Description) + column 23 (Merchant Suburb)
TROPIC
The Tropic card can be used for purchasing fuel as well as a range of vehicle services such as maintenance, tyres, scheduled services, etc.
The file format must be *.csv format, i.e. Text (Tab Delimited).
File Validation
Header Row: Column headings are expected in the file.
Column count: Must be 17 columns.
File Columns and Mappings
File View
An image of a Tropic file in Notepad
PUMA
The Puma card can be used for purchasing fuel as well as a range for vehicle services such as maintenance, tyres, scheduled services etc.
The file format must be .txt, i.e. Text (Tab Delimited).
Column headings are expected in the file as are three account opening and closing balance rows.
File Validation
Header Row 1: 1st 21 characters must be “PUMATRANSEXTRACT_05” or “Account No” if you’ve deleting the first three rows of the file.
Column count: Must be 37 columns
Column 17: Must be “Voucher” (where first column is numbered 0, see table below)
File Columns and Mappings
File View
An image of a puma file in Notepad
United
The United card can be used for purchasing fuel as well as a range for vehicle services such as maintenance, tyres, scheduled services etc. The file format must be .csv, i.e. Text (Tab Delimited).
File Validation
Header Row: Column headings are expected in the file.
Column count: Must be 17 columns.
File Columns and Mappings
File View
An image of a United file in Notepad
Summit
The Business rules for importing the Summit file per column are:
- A: invoice_no (start identified by column heading "Invoice Num"
- B: invoice_date
- C: odometer_timestamp
- F: Reg_no
- G: card_number
- M: product_code (e.g. "Monthly Rental")
- M: description (use Description Import Type = Replace)
- O:product_net
- P:product_gst
The .xls file needs to be saved as Text (Tab delimted).txt prior to importing.
7ELEVEN
The 7-Eleven card can be used for purchasing fuel as well as a range for vehicle services such as maintenance, tyres, scheduled services etc.
The file format must be .txt, i.e. Text (Tab Delimited).
Column headings are expected in the file as are three account opening and closing balance rows.
File Validation
Header Row 1: 1st 21 characters must be “E07REPORTEXCLMERNO” or “Account No” if you’ve deleting the first three rows of the file.
Column count: Must be 30 columns
Column 14: Must be “Voucher” (where first column is numbered 1, see table below)
File Columns and Mappings
File View
An image of a 7-Eleven file in Notepad