Customer Status Updates Export - CSV File Format

Contents

Overview


We are able now able to offer our customers a new feature that allows us to export live data to our customers via FTP or Email.  This feature allows our customers to get the latest information about the whereabouts of their freight right from their own third party system or via an email.


What the export sends to a customer

  • Pickup Created Online
  • Pickup Acknowledged by our fleet controller
  • Pickup Allocated to a local truck
  • Pickup Completed
  • Added to a manifest
  • Manifest Arrived at depot
  • Delivery Allocated (Runsheet created)
  • Delivery completed
  • Sign On Glass image
  • Scanned Documents (POD, etc)



Setup


Below is the standard format for all of the CSV files that are exported from the Hi-Trans System.

Field

Max Length

Example

Freightnote Number

10

SN1234

Freightnote Despatch Date

10

12/12/2012

Freightnote Sender's Reference

12

SRF12345

Status Code

2

C = Created
PR = Pickup Rebooked
K = PUP Acknowledged
L = PUP Allocated
P = PUP Completed
PF = PUP Futile
PN = PUP Signed By Name
M = Manifested for Linehaul
A = Linehaul Manifest Arrived
R = Delivery Allocated
D = Delivery Complete
DF = Delivery Futile
N = Delivered To Name
T = Timeslot Date/Time Change

Status Reference

10

MN1242

Status Date

10

23/12/2013

Status Time

5

08:23

The files that are exported from the Hi-Trans system will be received in the below CSV format.


Status Codes

Status Code can be one of the following values:


“C”  (Connote Created In Our System)

Status Reference = Blank

Status Date = Blank

Status Time = Blank


“PR" - Pickup Rebooked

Status Reference = Blank

Status Date = Blank

Status Time = Blank


“K”  (Pickup Acknowledgement - That It's Been Received By Our System)

Status Reference = Blank

Status Date = Blank

 Status Time = Blank



“L”  (Pickup Allocated To A Vehicle)

Status Reference = Vehicle Allocated To ID

Status Date = Blank

Status Time = Blank



“P”  (Pickup Completed)

Status Reference = Blank

Status Date = Completed Date

Status Time = Completed Time


“PF”  (Pickup Futile)

Status Reference = Futile Code

Status Date = Completed Date

Status Time = Completed Time


“PN”  (Pickup Completed Signed By Name)

Status Reference = Signed By Name

Status Date = Completed Date

Status Time = Completed Time


“M”  (Manifested)

Status Reference = Manifest Number

Status Date = Manifest Date

Status Time = Blank



“A”  (Manifest Arrived)

Status Reference = Manifest Number

Status Date = Arrived Date

Status Time = Arrived Time



“R” (Runsheet)

Status Reference = Runsheet Number

Status Date = Runsheet Date

Status Time = Blank



“D” (Delivered)

Status Reference = Delivery ID

Status Date =  Delivered Date

Status Time =  Delivered Time


“D” (Delivery Futile)

Status Reference = Deilivery Code

Status Date =  Delivered Date

Status Time =  Delivered Time


“N”  (Delivered Name)

Status Reference = Delivered To Name

Status Date = Delivered Date

Status Time = Delivered Time


“T”  (Timeslot Date / Time Change)

Status Reference = Blank

Status Date = New Timeslot Date

Status Time = New Timeslot Time


Freightnote Status files exported will be named “FNStatus<date/time stamp>X.csv” where X = a unique identifier for the current export profile.

A file is generated every hour containing ALL status updates that have occurred since the last file and transferred to FTP server.



Sign On Glass - JPEG File format

The file will be provided in jpeg format with the name of the freightnote as the file name.

POD - TIF, PNG, PDF File format

PODs can be provided in Tiff, PNG, PDF or bmp depending on the source of the POD.

The filename will always end with an underscore and the freightnote number with extension.  For example, Freightnote SW12345 will be  XXXX_SW12345.tif.