Driver Preferences Import Template
The import schema and attribute descriptions for the driver preferences .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.
Data Schema
Column Header |
Attribute |
Description |
Requirements |
|---|---|---|---|
|
avoidStates |
Avoid States |
States the driver avoids, separated by commas. |
Enclose multiple states in quotes (e.g., “CA,NY”). |
|
dailyTimeOffDuration |
Daily Time Off Duration |
Number of hours allocated for daily time off. |
Numeric value representing hours (e.g., 8). |
|
dailyTimeOffEndHour |
Daily Time Off End Hour |
The hour when the driver’s daily time off ends, in HH:MM format. |
Time in 24-hour format (e.g., 8:00). |
|
dailyTimeOffStartHour |
Daily Time Off Start Hour |
The hour when the driver’s daily time off begins, in HH:MM format. |
Time in 24-hour format (e.g., 22:00). |
|
dayNightDriving |
Day/Night Driving |
Driver’s preference for driving during the day, night, or both. |
Enum: Day, Night, Both. |
|
dvirPreference |
DVIR Preference |
Driver Vehicle Inspection Report preference for pre-trip or no inspection. |
Enum: Pre-Trip, None. |
|
homeTimePreference |
Home Time Preference |
Driver’s preference for home time (e.g., Weekly Reset, Home Every Night). |
Enum: Weekly Reset, Home Every Night, Flexible. |
|
preferredStates |
Preferred States |
States the driver prefers to operate in, separated by commas. |
Enclose multiple states in quotes (e.g., “TX,FL”). |
|
referenceCode |
Reference Code |
Unique identifier for the driver preferences record. |
Matches the reference code in the Driver Template (e.g., DR001). |
|
targetWeeklyEarnings |
Target Weekly Earnings |
Driver’s target earnings per week (in USD). |
Numeric value (e.g., 1500). |
|
targetWeeklyMiles |
Target Weekly Miles |
Driver’s target weekly mileage. |
Numeric value (e.g., 2500). |
|
targetWeeklyRevenue |
Target Weekly Revenue |
Driver’s target revenue per week (in USD). |
Numeric value (e.g., 3000). |
|
useSleeperBerthProvision |
Use Sleeper Berth Provision |
Indicates if the driver uses the sleeper berth provision. |
Boolean value (TRUE or FALSE). |
|
weeklyTimeOffDuration |
Weekly Time Off Duration |
Number of hours allocated for weekly time off. |
Numeric value (e.g., 48). |
|
weeklyTimeOffEndDay |
Weekly Time Off End Day |
Day of the week when the driver’s weekly time off ends. |
Enum: Sunday, Saturday, etc. |
|
weeklyTimeOffEndHour |
Weekly Time Off End Hour |
The hour when the driver’s weekly time off ends, in HH:MM format. |
Time in 24-hour format (e.g., 8:00). |
|
weeklyTimeOffStartDay |
Weekly Time Off Start Day |
Day of the week when the driver’s weekly time off begins. |
Enum: Friday, Saturday, etc. |
|
weeklyTimeOffStartHour |
Weekly Time Off Start Hour |
The hour when the driver’s weekly time off begins, in HH:MM format. |
Time in 24-hour format (e.g., 8:00). |
|
workWeekLengthDays |
Work Week Length (Days) |
Number of days in the driver’s work week. |
Numeric value (e.g., 7). |
|
workWeekLengthHours |
Work Week Length (Hours) |
Number of hours in the driver’s work week. |
Numeric value (e.g., 60). |