Tractor Import Template
The import schema and attribute descriptions for the tractor .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
Tractor Template Help Page
Column Header |
Attribute |
Description |
Requirements |
|---|---|---|---|
|
defaultYardLocationRefCode |
Default Yard Location Reference Code |
Reference code for the default yard location of the tractor, aligned with the Locations template. |
Matches the reference code in the Locations template (e.g., LOC125). |
|
exteriorHeight |
Exterior Height |
The external height of the tractor in inches. |
Numeric value (e.g., 162). |
|
exteriorLength |
Exterior Length |
The external length of the tractor in inches. |
Numeric value (e.g., 240). |
|
exteriorWidth |
Exterior Width |
The external width of the tractor in inches. |
Numeric value (e.g., 102). |
|
fleetCode |
Fleet Code |
Code representing the fleet to which the tractor belongs. |
Plain text or alphanumeric. |
|
grossVehicleWeight |
Gross Vehicle Weight |
The gross vehicle weight rating (GVWR) of the tractor in pounds. |
Numeric value (e.g., 80000). |
|
isActive |
Is Active |
Indicates whether the tractor is currently active. |
Boolean value (TRUE or FALSE). |
|
lastYardLocationRefCode |
Last Yard Location Reference Code |
Reference code for the last yard location of the tractor, aligned with the Locations template. |
Matches the reference code in the Locations template (e.g., LOC132). |
|
make |
Make |
The manufacturer of the tractor. |
Plain text (e.g., Freightliner). |
|
manualTransmission |
Manual Transmission |
Indicates if the tractor has a manual transmission. |
Boolean value (TRUE or FALSE). |
|
mileage |
Miles Per Gallon Rating |
The current miles per gallon rating of the tractor |
Numeric value (e.g., 6.4). |
|
model |
Model |
The model of the tractor. |
Plain text (e.g., Cascadia). |
|
name |
Tractor Name |
The name of the tractor, typically based on fleet assignment or reference. |
Plain text (e.g., Tractor TR001). |
|
notes |
Notes |
General notes about the tractor’s usage, certifications, or condition. |
Plain text. |
|
odometer |
Odometer |
The current odometer reading of the tractor in miles. |
Numeric value (e.g., 112500). |
|
ownerAddressCity |
Owner Address City |
The city where the tractor’s owner is located. |
Valid city name. |
|
ownerAddressState |
Owner Address State |
The state where the tractor’s owner is located. |
Two-letter state code (e.g., TX). |
|
ownerAddressStreet |
Owner Address Street |
The street address of the tractor’s owner. |
Plain text. |
|
ownerAddressZip |
Owner Address ZIP |
The ZIP code of the tractor’s owner address. |
Valid numeric ZIP code (e.g., 60601). |
|
ownerEmail |
Owner Email |
The email address of the tractor’s owner. |
Valid email format (e.g., owner@example.com). |
|
ownerExtension |
Owner Extension |
The phone extension for the tractor’s owner. |
Alphanumeric prefixed with x (e.g., x101). |
|
ownerName |
Owner Name |
The name of the tractor’s owner. |
First and last name. |
|
ownerPhone |
Owner Phone |
The phone number of the tractor’s owner. |
Valid phone number format. |
|
ownershipType |
Ownership Type |
Indicates whether the tractor is owned, leased, or contracted. |
Enum: Owned, Leased, Contracted. |
|
referenceCode |
Reference Code |
Unique identifier for the tractor in the system. |
Alphanumeric, usually prefixed with TR. |
|
registrationExpiry |
Registration Expiry Date |
The date when the tractor’s registration expires. |
Date format: MM/DD/YY. |
|
registrationNumber |
Registration Number |
The registration number assigned to the tractor. |
Alphanumeric. |
|
registrationState |
Registration State |
The state where the tractor is registered. |
Two-letter state code (e.g., TX). |
|
sleeperBerth |
Sleeper Berth |
Indicates if the tractor is equipped with a sleeper berth. |
Boolean value (TRUE or FALSE). |
|
vendorPurchasedFrom |
Vendor Purchased From |
The vendor or dealership where the tractor was purchased. |
Plain text. |
|
vin |
VIN |
The Vehicle Identification Number (VIN) of the tractor. |
Alphanumeric. |
|
year |
Year |
The manufacturing year of the tractor. |
Four-digit year (e.g., 2024). |