Ultramar Fuel Import
Version Prerequisites
https://pipelinecommercial.emergis.com/
After logging into the site choose reports and generate a report for a specific time period. The report is generated in an xls format. This option may not produce a file that can be imported to Fleet Manager. If that is the case, you must request the file from Ultramar. A file template can be provided by Trans Plus.
If requesting a file make sure it is an xls format not text (but is tab delimited)
If the file provided to you is .xlsx, then the file format must be changed before it can be imported.
To change this format please open up the invoice you get from MSGD’s website > click on File > the Save As > then choose Text (Tab deliminated) (*.txt) from the Save as type drop down > Save > import the file like usual into Fleet Manager.
Fleet Manager Professional Setup
- In Data Maintenance add a Vendor (under Misc Vendors) called Ultramar and then add and assign the fuel cards under the Credit Card tab
- Fuel cards can be assigned to either the driver or the truck. Under the credit card assignment tab assign the cards to the drivers preferably (or truck).
- Fuel Card number format is 0000 111122223333.
Other Notes
If the card is assigned to a truck then that supersedes anything passed in the file.
When the card is assigned to a driver then use the following rules:
Keycode 2 (Managed by Truck) has 2 options
-pin
-odometer**
OR
-pin
-odometer
-job#**
The field with the ** will be the field in the file that has the vehicle ID
Keycode 3 (Managed by Driver) has 1 option (this is what Fleet uses by default)
-pin
-vehicle ID**
On the website you can determine which of the above options their cards use by viewing the details of a card under card management on the website