|
Title:
HOW TO:
Check for Fuel Card Data Compatibility
IMPORTANT NOTES:
Fuel data must be imported chronologically. In other
words, you cannot import fuel data for May 2008, and later import data for April
2008.
As you are becoming familiar with the Fuel Import Manager,
make a copy of your database prior to running an import. This will give you
something to rely on in the event your profile is defined incorrectly, or if
there are problems with your fuel data.
Overview:
The Fuel Import Manager is compatible
with many types of data from various fuel card companies. This document will
describe how to verify compatibility.
Delimited-Text Data:
First, the data that you receive from your fuel card company must be in
clear-text format, one record per physical line. Basically, if you can view your
data in Notepad, it is clear-text. Next, each piece of information (e.g. date,
odometer, gallons, etc.) must be separated or delimited by a character. This is
the delimiter. A common delimiter is a comma. Some files are tab-delimited. The
actual tab character does not appear, but rather positions each field of data
into tabbed columns. Lastly, your data may be delimited by an unusual character,
such as "~". FLEETMATE is compatible will essentially any delimiter.
However, the delimiter character cannot appear within in the actual data values.
Required Fields:
Following is a list of five (5) pieces of information that must exist in
each fuel card record:
-
Transaction Date
-
Odometer
-
Total Fuel Cost
-
Total Fuel Volume
-
Vehicle ID (VIN, Veh No,
or Tag No)
No formatting or punctuation
should appear for data in your import file. As an example, the value $1,234,56
must existing in your import data as the numeric value 1234.56. The currency
symbol and comma should not appear.
|