To quickly add and edit drivers in bulk, you start with a template in a comma-separated values (CSV) format. When you export the template from the Samsara dashboard, 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.
-
From within Fleet settings, select Organization > Drivers.
-
Select More Actions > Upload CSV.
-
Select Download Drivers List to download a template that contains your existing driver data or Download Blank Template to start a new template and define driver data from scratch.
You can later return here when you complete your edits in the 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 field 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 download the spreadsheet as a CSV file.
See CSV Format for Drivers for required fields and detailed formatting requirements. Review the following additional considerations when you modify the CSV file:
-
Any changes to existing drivers will overwrite the definitions in the Samsara dashboard 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).
-
Ensure that you have fewer than 50,000 entries.
-
You must include the first row (the header row) in the CSV file.
-
-
After you download the CSV file, return to the Drivers setting in the Samsara dashboard.
-
Select More Actions (...) > Upload CSV.
-
Choose the CSV file or drag and drop the CSV file.
-
Preview Changes of your driver updates.
The Samsara dashboard displays CSV Uploads, where you can view the upload progress.
-
Review your changes before you commit to updates.
If the upload has errors, click Review Errors. Edit your CSV file to correct the errors and retry the file upload.
-
Select Finalize Changes to add drivers in bulk.
The following table describes the CSV fields you can use to define your drivers:
|
Field |
Description |
Example |
||
|---|---|---|---|---|
|
ID |
Internal ID Number of the driver. |
1000001 |
||
|
External ID |
The unique, customizable identifiers used to assign an ID from a system outside your Samsara organization. The external ID must be a key-value pair, where the key identifies the outside system and the value is the unique ID for the object in that system. For example, Driver 123 in Samsara is Driver 456 in your Transportation Management System (TMS). The Driver has an External ID assigned as tms:456. To learn more about external IDs, see the Samsara developer portal. You can add more than one External ID key-value pair for the driver. Multiple External IDs must be semi-colon separated. |
tms: 122; wabu: 1211 |
||
|
Username |
(Required) The username of the driver. The username must be unique, at least four characters long, and not contain any special characters. |
user123 |
||
|
Password |
(Required) The case-sensitive password of the driver. |
Password123 |
||
|
Name |
(Required) The name of the driver. The name of the driver must not contain any special characters. |
First Last |
||
|
Phone |
The 10 digit phone number of the driver. |
10020030000 |
||
|
Notes |
Any notes for the driver. |
Contacts, orders, and delivery information. |
||
|
License Number |
(Required for ELD compliance) The unique driver license number. |
12412D3 |
||
|
License State |
(Required for ELD compliance) The driver license state. |
AK |
||
|
ELD Exempt |
For ELD Exempt Drivers, mark this field as TRUE. If the driver is not ELD Exempt, you can leave this field blank. |
TRUE |
||
|
ELD Exempt Reason |
The reason the driver is ELD exempt. If the driver is not ELD exempt, leave this field blank. |
The vehicle is unregulated and does not transport hazardous material. |
||
|
16-hour Short-Haul Exemption |
If a driver has 16-hour Short-Haul Exemption enabled, mark this field as TRUE. Otherwise, leave this field blank. For more information regarding whether a driver is eligible for this exemption, see 16-Hour Short-Haul Exemption (Big Day). |
TRUE |
||
|
Adverse Driving Exemption |
If a driver has Fleet Adverse Driving Exemptions enabled, mark this field as TRUE. Otherwise, leave this field blank. |
TRUE |
||
|
Defer Off-Duty Exemption |
(Canada only) If a driver has Deferral of Off Duty Exemption enabled, mark this field as TRUE. Otherwise leave this field blank. |
TRUE |
||
|
Adverse Driving (Canada) Exemption |
If a driver has Fleet Adverse Driving Exemptions enabled, mark this field as TRUE. Otherwise, leave this field blank. |
TRUE |
||
|
ELD Personal Conveyance (PC) |
If a driver can perform off-duty driving and has PC enabled, mark this field as TRUE. If not, leave this field blank. |
TRUE |
||
|
ELD Yard Moves (YM) |
If a driver can perform on-duty driving activity without it counting toward on-duty drive time, mark this field as TRUE. Otherwise, leave this field blank. |
TRUE |
||
|
ELD Utility Exemption |
If a driver has ELD Utility Exemption enabled, mark this field as TRUE. Otherwise, leave this field blank. |
TRUE |
||
|
Waiting Time (WT) |
If a driver has Waiting Time Exemption enabled, mark this field as TRUE. Otherwise, leave this field blank. |
TRUE |
||
|
ELD Day Start Hour |
The day start hour for the driver HOS logs. |
0 or 12 |
||
|
Home Terminal Timezone |
Timezone for the home terminal of the driver. |
New York - EST/EDT |
||
|
Carrier Name Override |
Carrier name override for the driver if different from the group default. |
Carrier Name |
||
|
Main Office Address Override |
Main office address override for the driver if different from the group default. |
123 Real St, Springfield |
||
|
Carrier US DOT Number Override |
DOT number override for the driver if different from the group default. |
1234567 |
||
|
Home Terminal Name |
Home terminal name of the driver. |
My Terminal |
||
|
Home Terminal Address |
Home terminal address of the driver. |
350 Rhode Island St. |
||
|
Peer Group Tag |
The peer group(s) of the driver. Must match an existing tag. |
tag1 |
||
|
Vehicle Selection and Map Tag |
The tag that limits which vehicles the driver can select in the Driver App. Must match an existing tag. |
EX.TAG |
||
|
Additional Asset Selection and Map Tag |
The tag that limits which assets, such as trailers, that the driver can select in the Driver App. Must match an existing tag. |
EX.TAG |
||
|
ID Card Code |
The code on the ID card of the driver. |
198936554 |
||
|
Tachograph Card |
The 16 digit tachograph card number of the driver. |
5639902673566548 |
||
|
Driver Status |
Status of the driver account, either Active or Deactivated. |
Active Deactivated |
||
|
Tags |
The tag(s) for the driver. Must match existing Tags. |
EX.TAG |
||
|
Driver Attribute: (Attribute Name) |
A unique column for each asset attribute name that describes driver details using one or more attribute values. The attribute name and value must match existing attributes. To separate attributes, use a semicolon. To remove all attribute values, type NULL. For more information about attributes, see Attributes. |
|
||
|
US Short Haul Exemption |
If a driver has Short-haul Air-mile radius exemption enabled, indicate the air-mile exemption type: 150 Air-Mile (Property), 150 Air-Mile (Passenger), or 150 Air-Mile (Non-CDL). If not, leave this field blank. |
150 Air-Mile (Non-CDL) |
||
|
Driver ID |
The Bluetooth Key ID of the driver. |
DriverID |
||
|
Driver Ruleset Cycle |
Name of the driver ruleset 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 the override is a Federal ruleset, then the State field should be left blank. |
TX |
||
|
Driver Ruleset Restart |
The time it takes to restart a cycle and reset the driver weekly hours to zero. |
34-hour Restart 24-hour Restart |
||
|
Driver Ruleset Restbreak |
The time it takes for Samsara to reset the clock after a break time is over. See the different Customizable Driver Rulesets. |
Property (on-duty/off-duty/sleeper) California Meal Break (off-duty/sleeper) |
||
|
Has Driving Features Hidden |
If a user is a non-driver using the Samsara Driver App for Connected Forms only, mark this field as TRUE. If not, leave this field blank. For more information about hiding driving features for non-drivers, see Worker Mode for Non-Drivers in the Samsara Driver App. |
TRUE |
Comments
0 comments
Article is closed for comments.