TECHNICAL ARTICLE: howto_009.htm

 Close Window  


HOW TO:  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 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.

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.
Runtime Syntax:

fm32fia /p=<profilename> [/f=<importfilename>] [/d=<database>]


<profilename> - Required The name of the profile that will govern the import process.

<importfilename> - 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.

<database> - 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.

  1. Right-click on your Windows desktop, select New, and click on Shortcut

  2. Browse to C:\Program Files\FLEETMATE\fm32fia.exe and click Next

  3. Provide a Name for your shortcut (e.g. Import Fuel Data)

  4. Click Finish

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 below.

"C:\Program Files\FLEETMATE\fm32fia.exe" /p=FUELPRO

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.

"C:\Program Files\FLEETMATE\fm32fia.exe" /p=FUELPRO /f=C:\fueldata\data1234.csv

In the above example, we're using the "f/=" parameter to specify that C:\fueldata\data1234.csv 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, review the
fm32fia.log log file to check for any errors that may have occurred during the import process.

If you need additional assistance, please write or call us: 

FLEETMATE Software Copyright (c) 2005-2013 by SCB Consulting.  All rights reserved.
FLEETMATE is a registered trademark of SCB Consulting, LLC.