This article describes the information that is required by Reveal when you create a fuel upload format. See the Upload your fuel purchases article for guidance on how to create a format.
When dealing with formats, it’s important to understand how they work. The sections in this article describe the following rules and definitions:
Reveal uses either the Vehicle ID or Fuel Card ID to identify transactions. This means that at least one of these Reveal labels needs to be matched to a column in the imported file.
Note
If you match both, Reveal will always use Vehicle ID.
In Step 3 of Import Fuel Purchases wizard, you must select the My file has a Place ID column check box if your imported file has a column that can be matched with the Reveal label "Place ID". This determines whether location information is required.
In the following table, "New place" refers to any location that has not yet been added as a Reveal Place.
|
If your file has a Place ID column: |
If your file does not have a Place ID column: |
|
|
If your file has new places: |
Required: ● Place ID ● Location data The system uses location data and Place ID data to create a new Reveal place. |
Required: ● Location data The system uses location data to create new a Reveal place, and assigns each new place a unique Place ID. |
|
If your file does not have new places: |
Required: ● Place ID Since Reveal places have previously been created for all locations, the system needs Place ID only to identify location. |
Required: ● Location data The system needs location data to identify existing Reveal places. |
If Location Data is required:
-
Your file must have columns to match the following Reveal labels:
-
Location name
-
Street
-
-
Your file must have columns to match at least one of the following Reveal labels:
-
City and State/Region
-
Postal code
-
The following table shows accepted date formats:
|
Date format |
Example |
|---|---|
|
dd/mm/yyyy |
24/06/2023 |
|
dd-mm-yyyy |
24-06-2023 |
|
mm/dd/yyyy |
06/24/2023 |
|
yyyy/mm/dd |
2023/06/24 |
The following table shows accepted time formats:
|
Time format |
Example |
|---|---|
|
h:mm:ss XM |
4:00:00AM |
|
h:mm XM |
4:00AM |
|
hh:mm:ss |
04:00:00 |
|
hh:mm |
04:00 |
Your file must have a column to match the Reveal label "Liters purchased" or "gallons purchased".
Your file must have columns to match at least one of the following:
-
Price per liter or price per gallon
-
Total fuel cost
The following definitions apply for Vehicle ID, Fuel Card ID, and Place ID.
-
Definition: Identifies which vehicle was used to make a fuel purchase. Must match the "Vehicle number" in your Reveal account.
-
Where to view and edit: In the upper right corner of the screen, click your user icon, and then select "Admin" > Vehicle List > Edit icon
> Details tab. To edit in bulk, contact Customer Support.
-
Definition: Identifies which fuel card was used to make a purchase. This must match the "Fuel Card ID" in your Reveal account.
-
Where to view and edit: In the upper right corner of the screen, click your user icon, and then select "Admin" > Vehicle List > Edit icon
|
Description |
Identifies where a fuel transaction took place. Each fuel transaction must link to a Reveal Place, which is recognised by its unique Place ID. NoteIf your file does not have a Place ID, Reveal can create one for you as part of fuel card upload |
|
View and edit |
Reveal > Places > Edit Place > Advanced Options > Place ID |
There are three ways to create a Reveal Place:
|
1. As part of Fuel Card Upload |
With this option, import your file with information about the location of each purchase. Any new location is saved as a Reveal Place. NoteSee Template Rules & Location for detail |
|
2. In Reveal Places |
With this option, create one place at a time. This option allows you to enter the address in a single field. Go to Reveal > Places > Create a New Place, and enter an address. You can enter a Place ID under Advanced Options. NoteIf you are not interested in location data or if your file is not set up in a way that allows you to easily match location values, it may be helpful to use this workaround. The following allows you to link every fuel purchase to the same Reveal Place.
You fuel purchases will be uploaded to same address. |
|
3. Bulk upload geofences |
Create Reveal Places using latitude & longitude coordinates. ● See Help Centre > Bulk upload geofences |