To create new shifts, you can upload a CSV file with the appropriate information. This article guides you through the various formats and fields to use for a successful CSV upload. You can also manually create shifts in the dashboard. For more information about creating shifts manually, see the Add a new shift article.
When you have created a new shift CSV file, you can upload the file by navigating to Dispatch → Add → Upload shifts.
You can download this sample shift CSV file to use as a starting point.
CSV file format
All valid CSV files are supported, with values in single quotation marks and comma separated.
Make sure your uploaded CSV does not have duplicate columns with the same header. If you import a file with duplicate headers, it could return an error, or you might find that the first column is uploaded, but all subsequent columns are ignored.
It is possible to use a CSV file to create shifts containing default values. For each row in your CSV file, a shift is created, and any fields that are left blank are populated with the default values.
All field names are case sensitive. If your field name does not use the correct case, the field is generated using default values, rather than the values you have entered, and the data is dropped. Unrecognised fields are not stored as custom data on the shift.
For start and end locations, all fields are optional. This means that you can provide no location information, start location only, end location only, or both start and end location. You can also choose to provide:
Street address only
Latitude and longitude coordinates only
Both street address and coordinates
Fields
Field name | Example | Details | Default value |
| Driver's email address | blank | |
|
| Time the shift starts |
|
|
| Date the shift starts | the next day |
|
| Time the shift ends |
|
|
| Date the shift ends | same as the start date |
|
| The name of the shift | blank |
|
| Whether a driver can add jobs to the shift using the driver app |
|
|
| Whether a driver can sequence their shift using the driver app |
|
|
| Whether a driver can edit stops using the driver app |
|
or
or
|
| The latitude where the shift starts and ends. Must be accompanied by a longitude. | blank |
or
or
|
| The longitude where the shift starts and ends. Must be accompanied by a latitude. | blank |
or
or
|
| The street address where the shift starts and ends. Can be used alone, or in conjunction with coordinates. | blank |
|
| Specify a vehicle reference | blank |
|
| Specify a vehicle type reference | blank |
|
| Use an external reference to retrieve or modify a resource. | blank |