If you happen to have your custom headers for your CSV, you may edit the default headers in your ElasticRoute account for easy importing of your file.
Under the Settings, you can customise the headers under Fields. If the Custom Header(Second Column) field is left empty, the Default Header (first column) will be used. This can be very useful if you are exporting your manifest from your existing system or your manifest file already comes with its own set of headers.
For example, your existing manifest file uses the header D.O. Number instead of Name (our default). So all you need to do to make your manifest file compatible with Detrack is just to enter D.O. Number in the Custom Header field for Name and our system will search for D.O. Number in your manifest file to populate the Name field during import.
Likewise the header D.O.Number will be replaced by Name during export and it is more likely that your system will be able to import back the CSV file with the same header.
If you do not have your CSV manifest, you can download a sample of the CSV file and enter the relevant data.
Sample data for import CSV manifest
| Import Fields | Description | Data Example | Remarks |
|---|---|---|---|
| Name | Name of the stop | DET123456 | Required. Name is a unique identifier |
| Address | Address of the stop | 2-10 Darling Dr, Suite 235, Sydney NSW 2000, Australia | Required if you are not using line address for import |
| Address 1 | Line Address 1 | 2-10 Darling Dr | Required if you are not using address to import |
| Address 2 | Line Address 2 | Suite 235 | Optional. Part of line address |
| Address 3 | Line Address 3 | Optional. Part of line address | |
| City | Line Address City | Sydney | Optional. Part of line address |
| State | Line Address State | NSW | Optional. Part of line address |
| Postal Code | Line Address Postal Code | 2000 | Optional. Part of line address |
| Country | Line Address Country | Australia | Optional. Part of line address |
| Latitude | Latitude of Stop Address | 33.872 | Optional, if latitude and longitude is entered, no address or line address is required |
| Longitude | Logitude of Stop Address | 151.1991 | Optional, if longitude and latitude is entered, no address or line address is required |
| Weight Load | Weight of load for the stop | 13.4 | Optional, Format: decimal number |
| Volume Load | Volume of load for the Stop | 450 | Optional, omit the units |
| Seating Load | Seating of load for the Stop | 4 | Optional, omit the units |
| Time Window | Name of Time Window | AM | Optional. Refer to How To Set Time Windows |
| Service Time | Time taken to service the stop | 5 | Optional. Refer to How To Set Service TIme For Your Stops |
| Depot | Name of the Depot | Mandai Depot | Optional. Refer to How To Add Depots |
| Group | Name of the Group | Group 1 | Optional |
