Field Validation for Vehicle Module
Overview
This article provides field-level validation rules for Vehicle Bulk Uploads based on the action: Add, Edit, or Delete. Use this guide to ensure your uploaded files meet all required formats and system constraints.
- For Add, fields such as Vehicle Name, Group Name, Device, Make, Model, Year, Cost per Mile, Vehicle Type, and Fuel Type are required.
- For Edit, Vehicle Name is used to identify the record. Any additional fields included will be updated; fields left out will remain unchanged.
- For Delete, only Vehicle Name is required.
Vehicle Name is the unique identifier and must exactly match the name in the system.
Note: For each operation, ensure that all required fields are provided. Optional fields that are omitted will be saved as blank during Add, or will remain unchanged during Edit.
Refer to the field validation table below for full details.
Add Vehicle
Field |
Description |
Example |
Validation Rule |
Required/ Optional |
Vehicle Name |
Enter the vehicle’s name. |
Ironman Ford 250 |
Must be unique; not blank. |
Required |
Group Name |
Enter the group name exactly as it appears in the system. |
Default Group |
Must match an existing group name in the system; not blank. |
Required |
Driver Username |
Enter the driver’s username exactly as it appears in the system. |
Must be a valid email format; must match an existing driver username if provided. |
Optional | |
Device |
Enter the device ID exactly as it appears in the system. |
1003298281 |
Must match an existing device ID in the system; not blank. |
Required |
Current Odometer Reading |
Enter the vehicle’s current odometer reading. |
5883.9 |
Must be a valid numeric value within a reasonable range. |
Optional |
Make |
Enter the vehicle’s make exactly as it appears in the system. |
Ford |
Must match an existing make in the system; not blank. |
Required |
Model |
Enter the vehicle’s model exactly as it appears in the system. |
Maverick |
Must match an existing model in the system; not blank. |
Required |
Year |
Enter the vehicle’s year exactly as it appears in the system. |
2022 |
Must match a valid year in the system; should be in the past or current year. |
Required |
VIN |
Enter the Vehicle Identification Number. |
5PVNJ8JV6D4S55309 |
Must be unique if provided; should follow VIN format (17 characters, alphanumeric). |
Optional |
Cost per Mile |
Enter the cost per mile driven. |
0.71 |
Must be a positive numeric value. |
Required |
Asset Number |
Enter the asset number. |
2735 |
Can be alphanumeric if provided; not blank. |
Optional |
Vehicle Type |
Enter the vehicle type exactly as it appears in the system. |
Car |
Must match an existing vehicle type in the system; not blank. |
Required |
Fuel Type |
Enter the fuel type exactly as it appears in the system. |
Diesel |
Must match an existing fuel type in the system; not blank. |
Required |
License Plate |
Enter the vehicle's license plate number. |
208556H - IL |
Must follow a valid format if provided (alphanumeric with optional state code). |
Optional |
Edit Vehicle
Field |
Description |
Example |
Validation Rule | Required/ Optional |
Vehicle Name |
Enter the exact vehicle name that exists in the system. |
Ironman Ford 850 |
Must exactly match an existing and unique vehicle name in the system. |
Required |
Updated Vehicle Name |
Enter a new name to update the vehicle (leave blank if unchanged). |
Jackson's Everland Shuttle |
Must be unique; follows standard vehicle name validation if provided. |
Optional |
Group Name |
Enter the group name as it appears in the system. |
Default Group |
Must match an existing group name in the system if provided. |
Optional |
Driver Username |
Enter the driver username as it appears in the system. |
Must match an existing driver username in the system if provided. |
Optional | |
Device |
Enter the new device ID if assigning or changing a device. |
1003298281 |
Must match an existing device ID in the system if provided. |
Optional |
Current Odometer Reading |
Enter the current odometer value. |
5883.9 |
Must be a valid numeric value within a reasonable range. |
Optional |
Make |
Enter the vehicle’s make as it appears in the system. |
Ford |
Must match an existing make in the system if provided. |
Optional |
Model |
Enter the vehicle’s model as it appears in the system. |
Maverick |
Must match an existing model in the system if provided. |
Optional |
Year |
Enter the vehicle’s manufacturing year. |
2022 |
Must match a valid year in the system; should be in the past or current year. |
Optional |
VIN |
Enter the Vehicle Identification Number. |
5PVNJ8JV6D4S55309 |
Must be unique if provided; 17-character alphanumeric. |
Optional |
Cost per Mile |
Enter the cost per mile. |
0.71 |
Must be a positive numeric value. |
Optional |
Asset Number |
Enter the internal asset number. |
2735 |
Can be numeric or alphanumeric if provided; |
Optional |
Vehicle Type |
Enter the vehicle type as it appears in the system. |
Car |
Must match an existing vehicle type in the system if provided. |
Optional |
Fuel Type |
Enter the fuel type as it appears in the system. |
Diesel |
Must match an existing fuel type in the system. |
Optional |
License Plate |
Enter the license plate number. |
208556H - IL |
Must follow a valid format if provided (alphanumeric with optional state code). |
Optional |
Fuel Tank Capacity |
Enter the fuel tank capacity in gallons or liters. |
2 |
Must be a valid numeric value; decimals allowed. |
Optional |
Delete Vehicle
Field |
Description |
Example |
Validation Rule |
Required/ Optional |
Vehicle Name |
Enter the exact vehicle name that exists in the system. |
Ironman Ford 250 |
Must exactly match an existing and unique vehicle name in the system. |
Required |