The fuel import is an interface dedicated to the integration of data coming from fuel pumps.

One line in the input file corresponds to:

• a measurement reading on the odometer (actual reading),
• a measurement reading at the fuel consumption Reading point ("energy" category),
• a measurement reading at the average consumption reading Point ("Consumption" category),
• an inventory withdrawal corresponding to the volume of fuel consumed.

 

Format of the input file

The input file is a "flat" file with separators, which must comply with the Exchange standard FUEL_1.0.

It includes:

• A first fixed header line: exchangeInterface;FUEL_IN;externalSystem;<Code of the external system>.
  FUEL_IN is the code of the standard interface.
• Data lines in the following format:

Data	Format	Required
Record type	alphanumeric	Yes: Filled in with the text MEASURES
Asset: Vehicle code	alphanumeric	Only if the badge code is not entered
Badge: Badge code of the odometer.	alphanumeric	Only if the Asset code is not filled in
Reading value of the odometer	numeric	Yes
Date of the reading	yyyy-mm-dd hh:mm:ss	Yes
Fuel: code of the fuel item for the inventory withdrawal.	alphanumeric	No: may be deduced from the fuel of the Reading point template.
Warehouse: Code of the storage warehouse for the inventory withdrawal.	alphanumeric	Only if there are several warehouses for storing fuel
Location: Location code in the warehouse.	alphanumeric	No
Withdrawal quantity: Quantity of the inventory withdrawal and the "Fuel" reading point."	numeric	Yes
Technician: Code of the agent originating the data.	alphanumeric	Yes
Consumption reading value	numeric	No

Input file example

exchangeInterface;FUEL_IN;externalSystem;BORNES-CARBURANT;
MEASURES;P306;;450;21/03/2010 00:00;GAZOLE;CARBURANT;MAGC1;55;MARTIN;10
MEASURES;667CSI69;badge_667;889;2009-06-06 00:00:00;GAZOLE;MAG1;A1C10;76.6;LEFEVRE;8.61
MEASURES;668CSI69;;900.67;2009-07-06 01:00:00;;;;45.6;DURAND;7.47