To quickly and easily create a large number of routes for your fleet, you can upload a comma-separated values (CSV) file. At a high-level, each row in the file represents a stop on a route, with multiple rows collectively representing an entire route. The first row for a given route represents the starting location and time.
 |
To upload routes in bulk, you must create a CSV file that adheres to the following guidelines:
The file can contain up to 1,000 rows of data.
It is recommended to use a spreadsheet application to edit your CSV file. If you use a text editor, you must format any entries that contain commas (for example a full address) in quotes.
You can view two example templates. The first template represents creating routes using the Address Book. The second template represents creating routes using raw addresses (Latitude, Longitude, Full Address). It is also possible to mix and match these two methods in one file (with some rows using the Address Book and other rows using raw addresses).
The file must specify real driver usernames in the Assigned Driver Username field. If the usernames do not match those specified in Samsara, the upload will fail. Alternatively, you can delete the driver usernames in that column and create the routes as unassigned.
The CSV file must include the fields in the order presented in the following table and follow the described syntax:
Field |
Description |
|---|---|
Route Name |
Descriptive name to identify the route. |
Assigned Driver Username |
(Optional) Specify the driver to which you want to assign the route. To assign a driver, the driver username must already be defined in Samsara. Otherwise, you can leave this field blank to instead supply an Assigned Vehicle Name. If neither a driver nor vehicle are specified, Samsara imports the route as unassigned. |
Assigned Vehicle Name |
(Optional) Specify the vehicle to which you want to assign the route. To assign a vehicle, the vehicle name must already be defined in Samsara. Otherwise, you can leave this field blank to instead supply an Assigned Driver Username. If neither a driver nor vehicle are specified, Samsara imports the route as unassigned. |
Stop Name |
This field should be blank for the first row in each route (the route start location) but should be filled in for the remaining rows in the route. Descriptive name to identify the stop. |
Stop Arrival Time |
For the first row of a route, this field represents the Scheduled Start Time for the entire route. The date/time can be provided in any of the following formats. All date/time values in a single CSV file must be in the same format:
|
Stop Departure Time |
(Optional) This field can be left blank. For the first row of a route, this field represents the Scheduled End Time for the entire route. The date/time can be provided in any of the following formats. All date/time values in a single CSV file must be in the same format:
|
Stop Notes |
(Optional) This field can be blank. Identifies any notes you want to include about the stop. Notes added to route stops will be visible to drivers in the Samsara Driver App under the respective stop. The route view for fleet administrators does not include the driver notes. |
Address Name |
(Optional) This field can be blank. If filled in, this route stop will be created using the geofence of the Address Book entry with the same name. (If not using the Address Book entry with the Address Name field, all three fields below, Latitude, Longitude and Full Address are required for successful upload.) |
Latitude |
This field can be blank but is required if no Address Name is provided. The Latitude, Longitude, and Full Address fields can be used to create a route stop without relying on an Address Book entry. |
Longitude |
This field can be blank but is required if no Address Name is provided. The Latitude, Longitude, and Full Address fields can be used to create a route stop without relying on an Address Book entry. |
Full Address |
This field can be blank but is required if no Address Name is provided. The Latitude, Longitude, and Full Address fields can be used to create a route stop without relying on an Address Book entry. |
The following example displays a CSV file with sample stops.
Route Name,Assigned Driver Username,Assigned Vehicle Name,Stop Name,Stop Arrival Time,Stop Departure Time,Stop Notes,Address Name,Latitude,Longitude,Full Address Ice Cream Deliveries,driver_a,,,2020-04-27 6:45,,,Samsara,,, Ice Cream Deliveries,driver_a,,Bi-rite,2020-04-27 7:45,2020-04-27 8:00,Deliver 5 cases,Bi-rite,,, Ice Cream Deliveries,driver_a,,Smitten,2020-04-27 8:45,2020-04-27 9:00,Deliver 7 cases,Smitten,,, Ice Cream Deliveries,driver_a,,Salt & Straw,2020-04-27 9:45,2020-04-27 10:00,Deliver 3 cases,Salt & Straw,,, Ice Cream Deliveries,driver_a,,Humphry Slocombe,2020-04-27 10:45,2020-04-27 11:00,Deliver 9 cases,Humphry Slocombe,,, Tour of San Francisco,driver_b,,,2020-04-27 6:45,,,Samsara,,, Tour of San Francisco,driver_b,,Coit Tower,2020-04-27 7:45,2020-04-27 8:00,Take pictures,Coit Tower,,, Tour of San Francisco,driver_b,,Ferry Building,2020-04-27 8:45,2020-04-27 9:00,Take pictures,Ferry Building,,, Tour of San Francisco,driver_b,,Lombard Street,2020-04-27 9:45,2020-04-27 10:00,Take pictures,Lombard Street,,, Tour of San Francisco,driver_b,,Golden Gate Park,2020-04-27 10:45,2020-04-27 11:00,Take pictures,Golden Gate Park,,, Bay Area Airport Fuel Deliveries,driver_c,,,2020-04-27 6:45,,,Samsara,,, Bay Area Airport Fuel Deliveries,driver_c,,SFO,2020-04-27 7:45,2020-04-27 8:00,500 gallons of fuel,SFO,,, Bay Area Airport Fuel Deliveries,driver_c,,Oakland International,2020-04-27 8:45,2020-04-27 9:00,300 gallons of fuel,Oakland International,,, Bay Area Airport Fuel Deliveries,driver_c,,Napa County Airport,2020-04-27 9:45,2020-04-27 10:00,700 gallons of fuel,Napa County Airport,,, Bay Area Airport Fuel Deliveries,driver_c,,San Carlos Airport,2020-04-27 10:45,2020-04-27 11:00,400 gallons of fuel,San Carlos Airport,,, Bay Area Airport Fuel Deliveries,driver_c,,Palo Alto Airport,2020-04-27 11:45,2020-04-27 12:00,450 gallons of fuel,Palo Alto Airport,,,
 |
If you have not already done so, create your CSV file containing all routes. Make sure the file adheres to the Fields and Formatting Requirements of the CSV File.
Select Dispatch (
) > Routes > More Actions > Upload CSV.Click the link to Upload a file, or drag and drop it to the dialog.
Click Upload to initiate the file upload.
Comments
0 comments
Article is closed for comments.