Setup A Shortcut for the Fuel Import Processor
Fuel data must be imported chronologically. In other
words, you cannot import fuel data for May 2008, and later import data for April
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.
FLEETMATE ENTERPRISE EDITION:
The Fuel Import Processor
for the Enterprise Edition features command line arguments that are different
from the Standard Edition. The instructions below are for the Standard Edition
only. Please refer to the Fuel Import Manager Customer Guide under your
FLEETMATE Enterprise program group for additional information.
Once you have created your fuel import
profile, you will need to execute the profile using the Fuel Import Processor (fm32fia.exe).
This will bring in your fuel data. You can do this daily, weekly, or at any
interval that is required. An easy approach to do this is to setup a shortcut on
your Windows desktop, so that you need only double-click the shortcut to process
your fuel data. In this example, our fuel import profile is named FUELPRO.
- Required The
name of the profile that will govern the import process.
- Conditional Whether
this parameter is required will depend upon your profile settings. If you use
the same input filename for your fuel data, this parameter is not required,
since your Profile definition will contain the filespec. However, if each
import filename is unique, you will need to specify the import filename using
this parameter. You must specify the full path to your import file.
- Optional This
parameter is required if you are running the Processor on a separate PC, other
than the one where FLEETMATE is used. By
default, the Processor will import data into the FLEETMATE database that was
last used on the same PC where the Processor is run. If you use the same
database on a daily basis, and you are executing the Processor on the same PC
where FLEETMATE is used, this parameter is not required. However, you can use
this parameter to cause the Fuel Import Processor to import your data into a
specified database. Using this parameter will ensure that your fuel data is
imported into the intended database, regardless of the database that was last
used. You must specify the full path to your database file.
With the Enterprise Edition if FLEETMATE, this parameter is the database name
as defined in SQL Server.
In this example, our fuel import profile is named FUELPRO.
Follow the steps below to create your fuel import shortcut.
Right-click on your Windows
desktop, select New, and click on Shortcut
Browse to C:\Program
Files\FLEETMATE\fm32fia.exe and click Next
Provide a Name
for your shortcut (e.g. Import Fuel Data)
Next, right-click on your new
shortcut and choose Properties. At the very
end of the Target path, specify the name of your
profile and click OK. An example of how the edited line should appear is listed
In the above
example, FUELPRO is the name of the profile. The "/p=" is required to
specify the profile name. In this profile, it is assumed that the input data
file always has the same filename, and it is always located in the same folder.
If your input filename varies with each download, you will need to edit the
filename in the Target setting prior to running each import. An example of this
target setting is listed below.
Files\FLEETMATE\fm32fia.exe" /p=FUELPRO /f=C:\fueldata\data1234.csv
In the above
example, we're using the "f/=" parameter to specify that
is the file that contains your fuel data from your fuel card company.
To execute the fuel import processor, double-click on your new shortcut. Afterwards,
log file to check for any errors
that may have occurred during the import process.