Uploading vehicles

Importing a vehicle list via a spreadsheet allows you to quickly create multiple vehicles in Stream at once, eliminating the need to add them manually one by one.

Additionally, the vehicle upload can be used to make bulk updates to your existing vehicles.

Prerequisites before uploading vehicles

There are a couple of steps to take before uploading your vehicles to Stream:

• Set up Vehicle Types: Ensure all required Vehicle Types are created in Stream before uploading, as every imported vehicle must be assigned to an existing type. For help, see our guide on Adding a vehicle type
• Create sample vehicles: If you are setting up Stream for the first time, manually add at least one vehicle per Vehicle Type directly in Stream. Exporting these provides visual examples of how column data must be formatted, and will include the Vehicle Type ID required to set this correctly. Sample vehicles will be safely skipped as duplicates during the upload. A guide on adding vehicles manually can be found here: Adding a vehicle

Downloading the vehicle upload template

Before we can upload our vehicles, we need to download the spreadsheet template containing the correct column headers:

1. From the main menu, navigate to ‘Vehicle Details’
2. In the ‘Vehicles’ section on the left, click the ‘Actions’ button and select ‘Export’
3. Open the downloaded XLS or CSV file in your preferred spreadsheet application

Populating the vehicle upload file

Once you have downloaded the template file:

1. Open the exported spreadsheet template
2. Enter the details for each new vehicle into the corresponding columns, ensuring all data formats match the existing rows or header requirements
3. If you are updating existing vehicles, make the necessary changes to the fields. 
4. Save the completed file to your computer in .CSV or .XLSX format

Uploading the vehicle upload file

To upload your vehicles:

1. Return to the ‘Vehicle Details’ screen in Stream
2. Select the ‘Vehicles’ option from the dropdown located on the top left of the page, click the ‘Actions’ button and select ‘Upload’
3. In the pop-up window, select your saved .CSV or .XLSX file and click ‘Upload’
4. Review the import summary screen to confirm the status of each row:
   1. Uploaded successfully: The vehicle profile has been created in Stream
   2. Updated successfully: The vehicle profile has been updated in Stream
   3. Vehicle already exists: The registration is already in your system and was skipped to prevent duplication
   4. Validation errors: Displays specific row issues that prevented an import. Correct these errors in your spreadsheet, save the file, and re-upload
5. Click ‘OK’ to finish and return to your updated vehicle overview list