Trailer Import Template

Instructions for Use
Use this page to bulk import trailer records into LoadAI. Follow the step-by-step instructions below to download the import template, prepare your data, map columns, validate, and complete the import. Refer to the Data Schema table for field definitions, accepted formats, and requirements for each column.

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 identify and fix errors in your data file, then re-upload and re-validate before proceeding.

6. Once validation is successful, click Import to create or update your records based on the reference code alignment.

Sample File

Download a sample Trailer Import Template

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. This is the primary key used to match records during import — existing records with a matching reference code will be updated; new reference codes will create new records.	Required. Alphanumeric, prefixed with TL (e.g., TL001).
registrationExpiry	Registration Expiry Date	The date when the trailer’s registration expires.	Date format: MM/DD/YYYY (e.g., 12/31/2025).
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).	Accepted values include: Dry Van, Reefer, Flatbed, Step Deck, Lowboy, and Tanker. Contact your administrator for the full list of trailer types configured in your system.
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).

Trailer Import Template

The import schema and attribute descriptions for the trailer .csv import file

Data Schema

Column Header

Attribute

Description

Requirements