Customer Status Updates Export - CSV File Format
- Frank Ridenti
- Lloyd Jones
- Adrian Cooper
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 |
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
“DF” (Delivery Futile)
Status Reference = Delivery 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.