To quickly add drivers in bulk, you start with a template in comma-separated values format. When you export the template from the Samsara web interface, Samsara includes all existing drivers and their unique Samsara ID. In the CSV file, you can add new drivers or modify information about your existing drivers:
- Select the Settings icon (
) at the bottom of your Fleet menu to view dashboard settings. - In Organization > Drivers, select More Actions > Upload CSV.
NOTE: Do not select Export to CSV for the purpose of bulk updates. The Export to CSV file is not properly formatted for bulk upload and is intended for viewing only.
- Select Sample Template to start a new template without any existing data. To download your existing data, select Drivers List. Samsara exports all existing data and associated information to the CSV file. You can modify existing drivers or append new ones in the provided format. You will return to this screen later in this workflow to upload your appended CSV file.
- Open the CSV file in a spreadsheet application of your choice.
- If you open the file in Microsoft Excel, the application identifies the ID as a scientific number. As a result, you must first set the format for the ID column as a Number and remove any additional decimal places before saving the file. If you skip this step you will overwrite the unique ID and will need to start over with a new file.
- Make any desired changes to your drivers and save the file. At a minimum, you must include the ID and driver Name. Use the CSV Format table below to properly format your CSV file prior to upload. Additional considerations when you modify the CSV file:
- Any changes to existing drivers (including blank or empty fields) will overwrite the definitions in Samsara upon import. Be careful in these cases to avoid accidentally overwriting existing stored data.
- If you include a column and leave a value blank, Samsara assigns the default value for the field (typically null or blank).
- Save your file and return to the Drivers page in Samsara.
- Select More Actions (...) > Upload CSV.
- Choose the CSV file from your computer, or drag and drop the CSV file into the window.
- Preview to review the drivers.
- Confirm to confirm the changes.
CSV Format
|
Field |
Description |
Example |
|---|---|---|
|
ID |
Internal ID Number of driver. This field is not editable on import since it represents an internal storage identifier. Leave blank when creating new drivers. |
1 |
|
Username |
(Required) The driver's username. Username is case sensitive. Additional requirements:
|
username |
|
Password |
(Required) Driver's password. Case sensitive. |
password |
|
Name |
(Required) Driver's name. |
First Last |
|
Phone |
Driver's phone number expressed as 10 digits. |
10020030000 |
|
Notes |
Any notes for the driver. |
Driver notes |
|
License Number |
The driver's license number. Must be unique. |
12412D3 |
|
License State |
The driver's license state. |
AK |
|
ELD Exempt |
Setting that removes ELD functionality for the driver |
TRUE |
|
ELD Exempt Reason |
The reason the driver is ELD exempt |
Reason |
|
16-hour Short-Haul Exemption |
Ability for driver to claim the Short-haul 16 hour short-haul exception |
TRUE |
|
Adverse Driving Exemption |
Ability for driver to claim the Adverse Driving Exemption |
TRUE |
|
Defer Off-Duty Exemption |
Ability for driver to claim Deferral of Off-Duty |
TRUE |
|
Adverse Driving (Canada) Exemption |
Ability for driver to claim the Adverse Driving Exemption |
TRUE |
|
ELD Personal Conveyance (PC) |
Ability for driver to select Personal Conveyance duty status |
TRUE |
|
ELD Yard Moves (YM) |
Ability for driver to select Yard Move duty status |
TRUE |
|
ELD Utility Exemption |
Ability for driver to claim the Utility Exemption |
TRUE |
|
Waiting Time (WT) |
Ability for driver to select Waiting Time duty status |
TRUE |
|
ELD Day Start Hour |
Day start hour for the driver’s hours of service logs |
0 or 12 |
|
Home Terminal Timezone |
Timezone for the driver’s home terminal |
Honolulu - HST Anchorage - AKST/AKDT Los Angeles - PST/PDT Phoenix - MST Denver - MST/MDT Chicago - CST/CDT New York - EST/EDT Halifax - AST/ADT Azores - AZOT/AZOST Reykjavik - GMT London - GMT/BST Paris - CET/CEST Kaliningrad - EETHelsinki - EET/EEST Turkey - TRT |
|
Carrier Name Override |
Carrier name override for the driver if different than group default |
|
|
Main Office Address Override |
Main office address override for the driver if different than group default |
|
|
Carrier US DOT Number Override |
DOT number override for the driver if different than group default |
|
|
Home Terminal Name |
Home terminal name for the driver |
|
|
Home Terminal Address |
Home terminal address for the driver |
|
|
Peer Group Tag |
The driver’s peer group(s). Must match an existing tag. |
|
|
Vehicle Selection Tag |
The tag that limits which vehicles the driver can select in the Driver App. Must match an existing tag. |
|
|
Trailer Selection Tag |
The tag that limits which trailers the driver can select in the Driver App. Must match an existing tag. |
|
|
ID Card Code |
The driver’s ID card |
|
|
Tachograph Card |
The driver’s tachograph card |
|
|
Tags |
The driver’s tag(s). Must match an existing tag. |
|
|
Attributes (Beta) |
The driver's attributes. Must match an existing attribute. Format: Name1:Value1&Value2; Name2:Value3&Value4. |
License Type: ClassA&ClassB |
|
US Short Haul Exemption |
Ability for driver to claim the Short-haul Air-mile radius exemption |
|
|
Driver ID |
The driver’s Bluetooth Key ID |
|
|
Driver Ruleset Cycle |
Name of cycle |
USA Property (8/70) USA Property (7/60) USA Passenger (8/70) USA Passenger (7/60) Alaska Property (8/80) Alaska Property (7/70) Alaska Passenger (8/80) Alaska Passenger (7/70) Nebraska (8/80) North Carolina (8/80) North Carolina (7/70) Oklahoma (8/70) Oklahoma (7/60) Oregon (8/80) Oregon (7/70) South Carolina (8/80) South Carolina (7/70) Texas (7/70) Wisconsin (8/80) Wisconsin (7/70) California School/FLV (8/80) California Farm (8/112) California Property (8/80) California Flammable Liquid (8/80) California Passenger (8/80) California Motion Picture (8/80) Florida (8/80) Florida (7/70) |
|
Driver Ruleset US State to Override |
Two character state code. Must match one of the above rulesets. If override is a Federal ruleset, State field should be left blank. |
TX |
|
Driver Ruleset Restart |
Time to restart cycle |
34-hour Restart 24-hour Restart None |
|
Driver Ruleset Restbreak |
Time to reset the break clocks |
Property (on-duty/off-duty/sleeper) None California Mealbreak (off-duty/sleeper) |
Comments
0 comments
Article is closed for comments.