1. ComData Fuelcard Interface setup

To utilize this process Prophesy will need to get a couple of files from your company. There are two files that we will need, Comdata transaction fuel file & also the Prophesy Dispatch database, which is named prodsp.mdb. Call your Comdata Customer Relations Representative. Tell them you need flagged FM 00001 Fuel Bill (Data) because you need 384 byte fuel data or 'Standard Fuel Layout Via Motors' data that is processed by Comdata Reports. Once this request is made the files will be available the next day. At this point ask Comdata to help you download Comdata Reports and install this on your PC. With this configuration you will also create a folder on the C drive called Comdata. Steps you would take to download the Comdata information. To get files from Comdata follow this process

Select TRANSFER and FILES

Select "All Account and Customer Codes" and "All Data and Print Files" and click <OKAY>

Should give you a RESULT SUMMARY window

Click <OKAY>

Then to prove you got files from Comdata

Select REPORTS and DATA

Select "Fuel Card Billing US " - (if flagged at Comdata for mixed billing, also need Fuel Card Billing )

Select "Customer Ids"

Select "From Date" and "To Date"

Select "Print" or "Print Preview" and click <OKAY>

If you get a blank report and you think you had activity on a day, call Comdata to confirm you did or did not have activity

If doing Print Preview, close all Preview Windows before proceeding To make the fuel data available for Prophesy

Select DATABASE and EXTRACT

Select "Fuel Card Billing US " (if flagged at Comdata for mixed billing, also need Fuel Card Billing Canada )

Select "Customer Ids" (this is data you want to make available for Prophesy)

Select "From Date" and "To Date" (this is data you want to make available for Prophesy)

Record Length is always 384

Click <OKAY>

This then takes you to a "SAVE AS" window

Select the C-drive

Select Comdata folder

For file name, We recommend that you use transaction date. An example of this would be "032504.txt"and then click <SAVE>

Should say "Database Extract Completed Successfully "

At this point you have successfully downloaded the information from Comdata. The next step of this interface will be to import this data into Prophesy Dispatch. To do this, Prophesy Technical Support will set up a time with you. We currently dial into your machine with a set meeting using a product called WEBEX. This will allow us to set up the rest of the interface by transmitting/updating a definition file, and we will also give you a walkthrough of the import process of your Comdata files. If you have additional questions about this process, please email support@mile.com.