Driver Import Template
The import schema and attribute descriptions for the driver .csv import file
Instructions for Use
1.Navigate to the Bulk Import section by clicking the Add Item button (➕) on the main navigation bar.
2.Download the import template from the Bulk Import section of LoadAi for the relevant object, or use your own spreadsheet.
3.Prepare your data and upload the completed file.
4.If you’re using your own template, you may need to manually select the object you are mapping. If you use the LoadAi Sample Template, columns will be auto-identified and auto-mapped.
5.Review the column mapping and click Validate to check for warnings or errors. If corrections are needed, download the validation report to adjust your data.
6.Once validation is successful, click Import to create or update your records based on the reference code alignment.
Sample File
Data Schema
Column Header |
Attribute |
Description |
Requirements |
|---|---|---|---|
|
baseLocationRefCode |
Base Location Reference Code |
Reference code for the driver’s base location, aligned with the Locations template. |
Matches the reference code in the Locations template (e.g., LOC123). |
|
certificationDoublesTriples |
Certification for Doubles/Triples |
Indicates if the driver is certified to operate doubles and triples. |
Boolean value (true or false). |
|
certificationHazardous |
Certification for Hazardous Materials |
Indicates if the driver is certified to transport hazardous materials. |
Boolean value (true or false). |
|
certificationHazmat |
Certification for Hazmat |
Indicates if the driver has a hazmat certification. |
Boolean value (true or false). |
|
certificationTanker |
Certification for Tankers |
Indicates if the driver is certified to operate tankers. |
Boolean value (true or false). |
|
defaultTractorRefCode |
Default Tractor Reference Code |
Reference code for the driver’s default tractor, aligned with the Tractors template. |
Matches the reference code in the Tractors template (e.g., TR001). |
|
defaultTrailerRefCode |
Default Trailer Reference Code |
Reference code for the driver’s default trailer, aligned with the Trailers template. |
Matches the reference code in the Trailers template (e.g., TRL001). |
|
eldSystemId |
ELD System ID |
Electronic Logging Device (ELD) system ID assigned to the driver. |
Plain text or alphanumeric. |
|
|
|
Email address of the driver. |
Valid email format (e.g., name@example.com). |
|
employmentStartDate |
Employment Start Date |
Date when the driver started their employment. |
Date format: MM/DD/YYYY. |
|
employmentType |
Employment Type |
Type of employment for the driver (e.g., Employee, Owner-Operator). |
Enum: Employee, Owner-Operator. |
|
fleetCode |
Fleet Code |
Code representing the fleet to which the driver belongs. |
Plain text or alphanumeric. |
|
homeLocationCity |
Home Location City |
The city where the driver’s home location is based. |
Valid city name. |
|
homeLocationLat |
Home Location Latitude |
Latitude of the driver’s home location. |
Valid latitude value (e.g., 33.7490). |
|
homeLocationLong |
Home Location Longitude |
Longitude of the driver’s home location. |
Valid longitude value (e.g., -84.3880). |
|
homeLocationState |
Home Location State |
The state where the driver’s home location is based. |
Two-letter state code (e.g., TX). |
|
homeLocationStreet |
Home Location Street |
The street address of the driver’s home location. |
Plain text. |
|
homeLocationTimezone |
Home Location Timezone |
The timezone for the driver’s home location. |
Valid timezone string (e.g., America/New_York). |
|
homeLocationZip |
Home Location ZIP |
The ZIP code for the driver’s home location. |
Valid numeric ZIP code. |
|
isActive |
Is Active |
Indicates whether the driver is currently active. |
Boolean value (true or false). |
|
name |
Driver Name |
The name of the driver. |
First and last name. |
|
notes |
Notes |
Additional notes about the driver’s certifications, experience, or roles. |
Plain text. |
|
operationType |
Operation Type |
The type of operation the driver performs (e.g., OTR, Regional, Local). |
Enum: OTR, Regional, Local. |
|
phone |
Phone |
Contact phone number for the driver. |
Valid phone number format. |
|
projectedTimeOfAvailability |
Projected Time of Availability |
The date and time when the driver is projected to be available for their next load. |
Date and time format: MM/DD/YYYY HH:MM. |
|
referenceCode |
Reference Code |
Unique identifier for the driver in the system. |
Alphanumeric (e.g., DR001). |
|
restrictionAirBrakes |
Air Brakes Restriction |
Indicates if the driver is restricted from operating vehicles with air brakes. |
Boolean value (true or false). |
|
restrictionCanOperateOnlyClassBAndCPassengerVehiclesOrSchoolBuses |
Class B and C Restriction |
Indicates if the driver can operate only Class B or C passenger vehicles or school buses. |
Boolean value (true or false). |
|
restrictionCanOperateOnlyClassCPassengerVehiclesOrSchoolBuses |
Class C Restriction |
Indicates if the driver can operate only Class C passenger vehicles or school buses. |
Boolean value (true or false). |
|
restrictionCmvEquippedWithFullAirBrakes |
Full Air Brakes Restriction |
Indicates if the driver is restricted to operating CMVs equipped with full air brakes. |
Boolean value (true or false). |
|
restrictionFifthWheelConnection |
Fifth-Wheel Connection Restriction |
Indicates if the driver is restricted to vehicles with fifth-wheel connections. |
Boolean value (true or false). |
|
restrictionManualTransmission |
Manual Transmission Restriction |
Indicates if the driver is restricted to operating manual transmission vehicles. |
Boolean value (true or false). |
|
restrictionMedicalVarianceIssuedToDriver |
Medical Variance Issued |
Indicates if the driver has been issued a medical variance. |
Boolean value (true or false). |