Uploading CSVs with jobs is one of the common ways to create jobs into NowGo. Whilst you can include any information in the CSV there there are number of fields that have meaning in NowGo and that will be processed automatically. These might sometimes be referred to as “First Class” fields because NowGo has a first class understanding of how these pieces of information work.
For a CSV upload to be valid the only field required is the address. Whilst other fields can be useful they are optional. In the case where only the Address field is recognized, the following default values are assigned to some fields:
General Job ID: automatically generated
Job Type: Attend
ID: automatically generated
Co-ordinates: Automatically geocoded
Time Window: 9:00-17:00
Service time: 120 (this is in seconds)
Date: set to the next day
When uploading please note that while most of the field names are case insensitive (lowercase and uppercase letters are treated the same) some are not. Field names that aren’t recognized or don’t match the exact case are saved under “Special Data”, in which case field names are case sensitive.
Below is a table of all “First Class” fields that carry certain meaning in NowGo. If you upload a field that is not a “First Class” field it will be processed by NowGo and save under the job inside “Special data”. “Special Data” is not used by NowGo in any meaningful way in to the Dashboard or in the App but it exists as information on the job.
Field name | Description | Example | Requirement |
| Address of the job. If left blank, NowGo prompts “Please enter a recognisable address to locate”. You may also need to edit the stop information to ensure the address is visible to the driver. | 123 Example St, TOWN STATE 1000 | Required |
| If left blank NowGo automatically assigns the “Attend” job type.
Creates a heading for the Id, External Reference, Address, Coordinates, Time Window, and Service time | Onboard | Recommended |
| Start time for the job. Defaults to 9:00am if not specified | 23:00 | Recommended |
| End time for the job. Defaults to 5:00pm if not specified. | 23:00 | Recommended |
| Time that the job will take in seconds (e.g. 180 for 3 minutes). Defaults to 2 minutes (120) if not specified. | 180 | Recommended |
| Start date of the job. Also used as the end date unless | 07/03/2019 | Recommended |
| End date of the job. If not specified, Date/Start Date will be used instead | 08/03/2019 | Optional |
| Will not be recognized if the corresponding Longitude is not included.
Useful when you have the specific coordinates for a particular service entrance. | -33.896273 | |
| Will not be recognized if the corresponding Latitude is not included.
Useful when you have the specific coordinates for a particular service entrance. | 150.969011 | |
| Email for the driver. Jobs with a driver email will be assigned to the corresponding driver’s shift. | Optional | |
| The LHS value in the bracket is the
Capacity cost of this job. If the shift has a vehicle/vehicle type with capacities, then this job must not exceed capacity limits of the vehicle/vehicle type | (weight, 50)(volume, 100) | Optional** |
| The LHS value in the bracket is the | (refrigerated, false) | Optional** |
| The LHS value in the bracket is the
| (big_truck, allowed) (big_truck, disallowed) (big_truck, preferred) (big_truck, dispreferred) (big_truck, allowed and preferred) (big_truck, allowed and dispreferred) | Optional** |
| The LHS value in the bracket is the
| (car, allowed) | Optional** |
| Used to link stops as part of the same job
e.g., Job Reference:
Pickup = “1”;
Deliver = “2”
For CSV, rows must be uploaded in sequential order i.e., pickup before delivery | 12345 | Optional |
**These fields need to be set up in NowGo dashboard for these CSV fields to function as expected
Capacities
There are two capacity units available: Number and Weight
If you select Weight, the number specified in the CSV will be in milligrams even if you select grams or kilograms. e.g in the Capacity Settings page you select grams, in the csv you enter (weight, 1000) → in NowGo this displays as 1 gram as 1 gram = 1000 milligrams.
For the bracket format, the first item in the bracket is whatever you set as the external reference. For example, if you set your Capacity external reference to widget, in the csv you would enter (widget, number).
Stop Custom Data
You can add custom data fields to NowGo in the Dashboard.
Click on your email address on the top right
Click on Settings from the drop-down menu
Click on Dashboard Configuration, then click on Stop custom data from the side menu
Click on Add New;
Enter the stop field details and a JSONpath;
Click on Save Changes.
NowGo needs a JSONPath to the custom data you want to show. This path can point to lists as well as single items. For more information on how to use JSONPath, we like Stefan Goessner's guide.
If you added custom data via CSV, the JSONPath will simply be $. followed by the column header. For example, if the column header is booking, the path will be $.booking.
Field name | Example | Details | Requirement |
booking | 20220330-1234-01 | Based on the example given in the dashboard, this would be custom data related to relevant booking details | optional |
Entering jobs with depot interactions
A job that requires something to be picked up from a depot and then delivered to a customer will share a Job Reference, for example:
Date | Address | Job Reference | Time Window Start | Time Window End | Type | Service Time | Driver Email | Contact Name | Contact Phone | instructions |
27/3/20 | 24 Hanly St, Lansdowne NSW 2163, Australia | 1 | 8:00 | 21:00 | Pickup | 180 | John Doe | 0407400400 | Pickup from docks behind reception | |
27/3/20 | 3 Booyong St, Cabramatta NSW 2166, Australia | 1 | 8:00 | 21:00 | Dropoff | 180 | John Doe | 0407400400 | ATL: leave outside building 3 behind security fence. |
(In the above example, the instructions field is stored as custom data)