Skip to main content
Cartegraph Campus

Petro Vend Fuel Integration

This feature may not be available in every package. Not sure if you have this feature or you want to learn more about it? Send us a message at support@cartegraph.com

The Petro Vend fuel integration interacts with the Equipment\Fuel Log recordset.  Some configurations may require the use of the Cartegraph Remote File Upload Utility and configure for the integration.  There are no upgrade instructions necessary for this integration to persist through Cartegraph Software upgrades.  This integration eliminates duplicate entry, ensures, data integrity, and provides the data available in Cartegraph for review and inclusion in task costs.

The fuel system must be set to export the file to a set location accessible to Cartegraph on a regular schedule.

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. 

Schedule the Integration

In Automation Manager configure an automation to schedule an import.

Raw Transaction File Sample

 

Field Map

File column position Example 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?