Overview #

Vehicle import in the Vehicle Administration tab of the Drivewyze Hub enables you to make large or small updates to your fleet quickly by uploading a CSV file of vehicles.

For example, you can change multiple vehicles from Analytics to Subscriber subscriptions. You can also make bulk edits to details like VINs and DOT Numbers.

Considerations #

  • Drivewyze recommends importing less than 2000 vehicles at a time. Attempting to import more than 2000 records in a single file may result in slow response time and increase the chances of failed import attempts.
  • Transponders and Groups cannot be adjusted in the import process.
  • Vehicles may not be able to be deleted in Drivewyze Hub depending on your partner integration.

Import Vehicles #

  1. Navigate to Admin > Vehicles.

  2. Click Import. A modal opens that displays all the items you can import
    Note: The items you can import depend on your Drivewyze partner integration.

  3. Click the upload icon, then choose your file.

  4. Click Upload and Continue.
    If the upload has no errors, click Import Vehicles.
    If the upload has errors, refer to the error referenced and fix your import file. Then try the upload again.

  5. Click Import Vehicle.

  6. Click Close to confirm the import.

Common Import errors #

Below is a list of the most common import errors that can occur during an import.

Incorrect permissions

You may not have permission to add vehicles or make updates to certain details about vehicles. To see what you are able to edit, check out the upload preview.

Duplicate vehicles detected

If duplicate vehicle are detected, go back into your upload file and make adjustments to remove the duplicates.

Validation issues

A poorly formatted VIN or a US DOT number or CVOR number that is not available to the fleet.

Expected column not found

The import process looks for correctly named columns. If an expected column is not found during import, go back into your upload file and verify that all columns are where they should be. You can download the template file to compare with your upload file.

Import File Fields #

Below is the full field list for the vehicle import. Note: If you are missing some fields they are not available in your partner integration.

Field Description
Fleet Reference Used within the fleet to share details between fleet systems. Either Fleet Reference or External Reference must be used in order to update a Unit Number for a vehicle.
Note: This field is not required and can be deleted from the template.
External Reference Used within the fleet to share details between fleet systems. Either Fleet Reference or External Reference must be used in order to update a Unit Number for a vehicle.
Note: This field is not required and can be deleted from the template.
Unit Number The name of the vehicle as defined by the fleet. Also sometimes known as Unit Name or Truck Number.
Note: If a Fleet Reference or External Reference are not provided, Unit Number is the key value used to update records with the same Unit Number.
VIN Vehicle Identification Number – The unique code assigned to every motor vehicle when manufactured.
License Plate An identifier provided on registration sometimes called registration plate or number plate.
Plate State The abbreviated state or territory where the site is located.
US DOT Registered US DOT number
CVOR Registered CVOR number
US Bypass For a vehicles participation in Weigh Station Bypass program in all of the United States.
Can be Subscriber, Analytics, or Inactive
Ontario Bypass For a vehicles participation in Weigh Station Bypass program in the province of Ontario.
Can be Subscriber, Analytics, or Inactive
Alberta Bypass For a vehicles participation in Weigh Station Bypass program in the province of Alberta.
Can be Subscriber, Analytics, or Inactive
Florida Agriculture For a vehicles participation in Agricultural Bypass program in the state of Florida.
Can be Subscriber, Analytics, or Inactive
Risk Zones For a vehicles participation in the Drivewyze Safety Notification and Safety+ programs.
Can be Subscriber, Analytics, or Inactive