Skip to main content
Cartegraph Campus

Petro Vend Fuel Integration

The Petro Vend fuel integration interacts with the Equipment\Fuel Log recordset. There are no upgrade instructions necessary for this integration to persist through Cartegraph Software upgrades.

Feature Description

Fuel logs are created in Cartegraph from the Petro Vend database using a standard scheduled integration, making use of the file import. Setup email notifications with Cartegraph's Notification Manager.

Implementation

Complete the following steps to deploy the integration:

  1. Add the following Fuel Types to the Equipment Fuel Types library if they do not exist:
  • Unleaded
  • Diesel
  1. Add the following Fuel Codes to the Equipment Fuel Types library if they do not exist:
  • Unleaded
  • #2 Diesel
  1. Place the Petro Vend File Integration for Equipment Fuel Log.imx file in a location available to the Application server.
  2. Create a field in Equipment\Fuel Logs called:
  •  Driver as Text(50).
  • Phoenix ID as Text(50).
  • Total Cost as Currency and publish.
  1. In Automation Manager configure an automation to calculate the Total Cost by multiplying the Unit Cost and Quantity fields.
  2. In Administration, open Notification Manager and subscribe users to the Integration Results notification. 

Data File Location

For Hosted customers, install the Cartegraph Remote File Upload Utility and configure for the integration

For On-Premise clients, setup Petro Vend to automatically export the file to the predetermined location.

Schedule the Integration

In Automation Manager configure an automation to schedule an import.

Field Map

File column

Cartegraph field

Comments

EquipmentID

..\ID and Portion of ID

Used to identify the parent Equipment.  If the Equipment does not exist an error is logged.

TransactionDate

Date & Portion of ID

Date is expressed in the custom format of yyyy-MM-dd.

FuelType

Fuel Type

Converted from code to text value:

Unleaded is Unleaded

#2 Diesel is Diesel

Odometer

Odometer

Non-numeric values generate an error.

Quantity

Quantity

 

UnityCost

Unit Cost

 

Driver

Driver

 

PhoenixID

Phoenix ID and Portion of ID

 

<PhoenixID>_<EquipmentID>_<Date>

ID

This value is used to check if the record exists in Cartegraph. If it does, the record is updated. If the record does not exist it is added.

  • Was this article helpful?