Edit Gateways in Bulk

To quickly modify information about your Asset Gateways (AGs) and Vehicle Gateways (VGs), you can upload data directly to the Samsara dashboard in bulk.

The easiest way to modify information about your devices is to first download the gateway list from the Samsara dashboard. Samsara provides the gateway list in comma-separated values (CSV) format and includes all editable fields. Consider the following notes before downloading and making changes to the gateways list.

• The file must be a properly formatted CSV file.

• The first row of the CSV file is the header row, and you must include it in the file.

• The header row must contain all fields from the CSV table.

• The CSV file must contain no more than 500 rows of data (including one row for the header).

• Fields that contain commas (such as device names and tags) will disrupt the import format. To avoid errors, revise any fields containing commas.

• Leading 0s in numerical fields will be truncated in exported files. Device names with numbers, license numbers, and user notes are at risk of this issue. Make sure to check your imported file for missing digits.

To download your gateways list and edit gateways in bulk:

1. Select the Settings icon ( ) at the bottom of your Fleet menu to view dashboard settings.

2. From within Devices, select Devices > Gateways.

3. Select More Actions > Upload CSV.

4. Select Devices List to download data for your existing activate devices. To activate devices, see the instructions to activate devices.

   Note

   Ensure that you only use the provided template. Any other format will display an error.

   

5. Update the information in the CSV file and save the changes (see CSV Format for Devices for detailed formatting requirements).

6. After you edit your file, select Upload a file.

7. Choose the CSV file from your computer, or drag and drop the CSV file to the window.

8. Click Preview to review the devices that will be added and edited.

9. Click Confirm to save the changes.

CSV Format for Devices

The following table describes the CSV fields you can use to define your vehicle and asset gateways. When there is no data specified for a given field, the value will be n/a. This can mean that this data has never been defined or that the data is not collected by Samsara. Where indicated in the description, internal identifying information such as the ID and gateway serial cannot be edited.

Field	Description	Example
ID	Internal ID number of device. This field is not editable on import since it represents an internal storage identifier.	G212014918601586
Gateway Serial	Serial number associated with the gateway. This field is not editable.	G12W-ABC-DEF
Name	The name of the associated vehicle.	Truck 265
Tags	Tags associated with the vehicle.	Tag 1, Tag 2, Tag 3
License Number	(Required) License plate of the paired vehicle.	ABC1234
VIN	The VIN as reported by the diagnostic connection from the VG. If your vehicle does not report it automatically, you can manually provide the value.	55SJF3JA6IU270951
Carrier US DOT Number Override	Alternate carrier US DOT number if different from your default settings. If this field is blank, the default carrier settings apply.	USDOT1234567
Carrier Name Override	Alternate carrier name if different from your default settings. If this field is blank, the default carrier settings apply.	Carrier Name
Carrier Address Override	Alternate carrier address if different from your default settings. If this field is blank, the default carrier settings apply.	123 Delivery St., Hauling
Harsh Event Detection Setting	Vehicle type to use for Harsh Event Detection.	Off, Automatic, Passenger Car, Light Truck, Heavy Duty
Driver Id	ID of the driver assigned to the vehicle.	1234567
User Note	Vehicle notes for your organization. Vehicle notes have a limit of 255 characters.	Out of service
Aux Input #(1-13)	Type of auxiliary input for the vehicle to assign to each auxiliary input # from 1 to 13.	Emergency Lights, Emergency Alarm, Stop Paddle, Power Take-Off, Plow, Sweeper, Salter, Door, Boom, Auxiliary Engine, Generator, Eight-Way Lights, Panic Button, None
Vehicle Regulation Mode	Select the vehicle regulation status for CMV. For more information, see Unregulated Vehicles (non-CMV).	Regulated, Unregulated
Asset Attribute: (Attribute Name)	A unique column for each asset attribute name that describe the features of a vehicle using one or more attribute values. The attribute name and value must match existing attributes. To separate attribute values, use a semicolon. To remove all attribute values, type NULL. For more information about attributes, see Attributes.	Asset Attribute: Vehicle Type Pickup; Dualcab