Trailer Import Template
The import schema and attribute descriptions for the trailer .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 |
|---|---|---|---|
|
defaultYardLocationRefCode |
Default Yard Location Reference Code |
Reference code for the default yard location of the trailer, aligned with the Locations template. |
Matches the reference code in the Locations template (e.g., LOC125). |
|
externalHeight |
External Height |
The external height of the trailer in inches. |
Numeric value (e.g., 162). |
|
externalLength |
External Length |
The external length of the trailer in inches. |
Numeric value (e.g., 636). |
|
externalWidth |
External Width |
The external width of the trailer in inches. |
Numeric value (e.g., 102). |
|
grossVehicleWeight |
Gross Vehicle Weight |
The gross vehicle weight rating (GVWR) of the trailer in pounds. |
Numeric value (e.g., 80000). |
|
internalHeight |
Internal Height |
The internal height of the trailer in inches. |
Numeric value (e.g., 110). |
|
internalLength |
Internal Length |
The internal length of the trailer in inches. |
Numeric value (e.g., 620). |
|
internalWidth |
Internal Width |
The internal width of the trailer in inches. |
Numeric value (e.g., 100). |
|
isActive |
Is Active |
Indicates whether the trailer is currently active. |
Boolean value (TRUE or FALSE). |
|
lastYardLocationRefCode |
Last Yard Location Reference Code |
Reference code for the last yard location of the trailer, aligned with the Locations template. |
Matches the reference code in the Locations template (e.g., LOC132). |
|
make |
Make |
The manufacturer of the trailer. |
Plain text (e.g., Wabash). |
|
model |
Model |
The model of the trailer. |
Plain text (e.g., DuraPlate). |
|
name |
Trailer Name |
The name of the trailer, usually a combination of its type and reference code. |
Plain text (e.g., Trailer TL001). |
|
ownerAddressCity |
Owner Address City |
The city where the trailer’s owner is located. |
Valid city name. |
|
ownerAddressState |
Owner Address State |
The state where the trailer’s owner is located. |
Two-letter state code (e.g., TX). |
|
ownerAddressStreet |
Owner Address Street |
The street address of the trailer’s owner. |
Plain text. |
|
ownerAddressZip |
Owner Address ZIP |
The ZIP code of the trailer owner’s address. |
Valid numeric ZIP code (e.g., 75201). |
|
ownerEmail |
Owner Email |
The email address of the trailer’s owner. |
Valid email format (e.g., owner@example.com). |
|
ownerName |
Owner Name |
The name of the trailer’s owner. |
First and last name. |
|
ownerPhone |
Owner Phone |
The phone number of the trailer’s owner. |
Valid phone number format. |
|
ownershipType |
Ownership Type |
Indicates whether the trailer is owned, leased, or contracted. |
Enum: Owned, Leased, Contracted. |
|
payloadCapacity |
Payload Capacity |
The maximum payload capacity of the trailer in pounds. |
Numeric value (e.g., 45000). |
|
referenceCode |
Reference Code |
Unique identifier for the trailer in the system. |
Alphanumeric, usually prefixed with TL. |
|
registrationExpiry |
Registration Expiry Date |
The date when the trailer’s registration expires. |
Date format: MM/DD/YY. |
|
registrationNumber |
Registration Number |
The registration number assigned to the trailer. |
Alphanumeric. |
|
registrationState |
Registration State |
The state where the trailer is registered. |
Two-letter state code (e.g., TX). |
|
trailerType |
Trailer Type |
The type of trailer (e.g., Dry Van, Reefer, Flatbed). |
Enum: Dry Van, Reefer, Flatbed, etc. |
|
vendorPurchasedFrom |
Vendor Purchased From |
The vendor or dealership where the trailer was purchased. |
Plain text. |
|
vin |
VIN |
The Vehicle Identification Number (VIN) of the trailer. |
Alphanumeric. |
|
year |
Year |
The manufacturing year of the trailer. |
Four-digit year (e.g., 2024). |