Carrier Import Template
The import schema and attribute descriptoins for the carrier .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 |
|---|---|---|---|
|
address.city |
Address City |
The city where the carrier is located. |
Valid city name. |
|
address.country |
Address Country |
The country where the carrier is located. |
Two-letter ISO country code (e.g., US). |
|
address.id |
Address ID |
Unique identifier for the carrier’s address. |
Matches the reference code in the Locations template. |
|
address.isNewRelay |
Is New Relay |
Indicates if the carrier’s location is newly designated as a relay hub. |
Boolean value (true or false). |
|
address.isRelay |
Is Relay |
Indicates if the carrier’s location serves as a relay hub. |
Boolean value (true or false). |
|
address.lat |
Latitude |
Latitude coordinates of the carrier’s location. |
Valid latitude value (e.g., 33.7490). |
|
address.locationIdNameRefCode.id |
Location ID |
The unique identifier for the location, referencing the Locations template. |
Matches the ID in the Locations template. |
|
address.locationIdNameRefCode.name |
Location Name |
The name of the carrier’s hub or facility. |
Plain text. |
|
address.locationIdNameRefCode.refCode |
Location Reference Code |
The reference code for the carrier’s location. |
Matches the ref code in the Locations template. |
|
address.locationName |
Location Name |
The full name of the carrier’s location. |
Plain text. |
|
address.long |
Longitude |
Longitude coordinates of the carrier’s location. |
Valid longitude value (e.g., -84.3880). |
|
address.name |
Address Name |
The official name associated with the carrier’s address. |
Matches the name of the facility or hub. |
|
address.state |
Address State |
The state where the carrier is located. |
Two-letter state code (e.g., TX). |
|
address.street |
Address Street |
The street address of the carrier. |
Plain text. |
|
address.timezone |
Address Timezone |
The timezone for the carrier’s location. |
Valid timezone string (e.g., America/New_York). |
|
address.zip |
Address ZIP |
The ZIP code of the carrier’s location. |
Valid numeric ZIP code (e.g., 30303). |
|
contacts.email |
Contact Email |
The email address for the carrier’s main contact. |
Valid email format (e.g., name@example.com). |
|
contacts.name |
Contact Name |
The name of the carrier’s main contact person. |
First and last name. |
|
contacts.phone |
Contact Phone |
The phone number for the carrier’s main contact. |
Valid phone number format, optionally with extensions. |
|
dotNumber |
DOT Number |
The Department of Transportation number assigned to the carrier. |
Valid numeric DOT number. |
|
isActive |
Is Active |
Indicates whether the carrier is active. |
Boolean value (true or false). |
|
mcNumber |
MC Number |
The Motor Carrier (MC) number assigned to the carrier. |
Valid numeric MC number. |
|
mode |
Mode |
The type of freight mode the carrier operates (e.g., Full Truckload, Partial Truckload). |
Enum: FTL, Partial. |
|
name |
Carrier Name |
The name of the carrier company. |
Plain text. |
|
notes |
Notes |
General notes or comments about the carrier. |
Plain text. |
|
numberOfTrucks |
Number of Trucks |
Total number of trucks in the carrier’s fleet. |
Valid numeric value. |
|
referenceCode |
Reference Code |
Unique identifier for the carrier in the system. |
Alphanumeric, usually prefixed (e.g., CAR). |
|
scac |
SCAC |
The Standard Carrier Alpha Code (SCAC) used to identify the carrier. |
Four-character SCAC code. |