Creating Your CSV File
A CSV file template is provided at the end of this document as an attached file. This should be opened with Microsoft Excel. The fields in the CSV import file are detailed below.
The value in the 'action' column drives the import functionality as follows:
- ‘Add’ – System will add the corresponding record. If a record already exists with the same ‘Corporate Asset No’ or ‘Gps Vechicle Id’ value as the record being imported, system will display an error.
- ‘Update’ – System will find an existing record with the same ‘Corporate Asset No’ value as the record in the import file and replace all values of the existing record with those of the record being imported. If no match is found among the existing records in the system, an error message will be displayed.
Field | Accepted Values | Description | Is Required? |
Corporate Asset No | Alphanumeric | Unique identifier from fleet management system. Can be set to match GPS Vehicle Id value if not available. | Yes |
Vehicle Fleet Number | Alphanumeric | Number used to refer to a vehicle in an operating location | Yes |
GPS Vehicle ID | Alphanumeric | Must match the vehicle’s external system id in GTC in Zonar or vehicle GUID in Synovia | Yes |
Vehicle Type | Car Van Type A Type C Type D SUV Truck Motor Coach Others | Define the type of vehicle | Yes |
Action | Add Update | Define the import functionality | Yes |
VIN | Alphanumeric | Identifying code for a specific automobile | No |
Source System | Alphanumeric | Free text; the name of your fleet management system if applicable | No |
Vehicle Year | YYYY | Vehicle property details | No |
Vehicle Make | Alphanumeric | Vehicle property details | No |
Vehicle Model | Alphanumeric | Vehicle property details | No |
Walk On Capacity | Numeric | Number between 0 and 200 | No |
Wheel Chair Capacity | Numeric | Number between 0 and 50 | No |
Passenger Ac | Yes/No | Vehicle property details | No |
Brake Type | Hydraulic Air Others | Vehicle property details | No |
Fuel Type | Electric Propane CNG Diesel Gasoline Others | Vehicle property details | No |
In Service | YYYY-MM-DD | Date (The cells in this column should be formatted as text) | No |
High Back Seats | Yes/No | Vehicle property details | No |
Crossing Gate | Yes/No | Vehicle property details | No |
Seat Belts | Yes/No | Vehicle property details | No |
State | Alphanumeric | Two letter abbreviation of state | No |
Importing Your CSV File
The vehicle import process allows users to add new vehicles, or update existing vehicles, in bulk using a csv file.
To import vehicles, follow the steps below:
- Navigate to Set-Up > Vehicles.
- Select Import Vehicles (see screenshot below).
3. The pop out screen for “Import Vehicle” will appear. Select the appropriate vendor from the vendor drop-down menu and then choose your csv file before selecting upload.
4. After selecting upload, you will get confirmation that the data has been successfully uploaded. If any errors are encountered, please take a screenshot, and send the screenshot, as well as your CSV file to support@bytecurve.com for further assistance. Do not try uploading the file again.