Location Import Template
The import schema and attribute descriptions for the location .csv import file
Use the Bulk Import feature in LoadAI to create or update multiple location records at once by uploading a prepared spreadsheet file. Follow the steps below to download the template, map your columns, validate your data, and complete the import.
Instructions for use
- Navigate to the Bulk Import section by clicking the Add Item button (➕) on the main navigation bar.
- Download the import template from the Bulk Import section of LoadAI for the relevant object, or use your own spreadsheet. Supported file formats include .csv and .xlsx.
- Prepare your data by filling in the required fields (see the Data schema table below) and upload the completed file.
- 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.
- 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.
- Once validation is successful, click Import to create or update your records. Existing records are matched and updated using the referenceCode field; unmatched records are created as new entries.
Sample File
Data Schema
Column Header |
Attribute |
Description |
Requirements |
|---|---|---|---|
|
averageHandlingTimeMins |
Average Handling Time (Minutes) |
Average time (in minutes) required to handle a load at this location. |
Numeric value (e.g., 45). |
|
city |
City |
The city where the location is based. |
Valid city name. |
|
fridayCloseTime |
Friday Close Time |
The closing time for the location on Fridays. |
Time in HH:MM format (e.g., 23:59). |
|
fridayOpenTime |
Friday Open Time |
The opening time for the location on Fridays. |
Time in HH:MM format (e.g., 0:01). |
|
lat |
Latitude |
Latitude coordinates of the location. |
Valid latitude value (e.g., 41.8781). |
|
locationType |
Location Type |
Type of location, such as Base, Customer, Yard, Maintenance, or Other. |
Enum: Base, Customer, Yard, Maintenance, etc. |
|
lon |
Longitude |
Longitude coordinates of the location. |
Valid longitude value (e.g., -87.6298). |
|
mondayCloseTime |
Monday Close Time |
The closing time for the location on Mondays. |
Time in HH:MM format (e.g., 23:59). |
|
mondayOpenTime |
Monday Open Time |
The opening time for the location on Mondays. |
Time in HH:MM format (e.g., 0:01). |
|
name |
Location Name |
The name of the location. |
Plain text (e.g., Chicago Base). |
|
notes |
Notes |
General notes about the location. |
Plain text. |
|
|
Reference Code |
Unique identifier for the location in the system. During import, this field is used to match records — if a record with this code already exists it will be updated; otherwise, a new record is created. |
Alphanumeric, usually prefixed with LOC. |
|
requiredTrailerCount |
Required Trailer Count |
Number of trailers required to handle operations at this location. |
Numeric value (e.g., 5). |
|
saturdayCloseTime |
Saturday Close Time |
The closing time for the location on Saturdays. |
Time in HH:MM format (e.g., 23:59). |
|
saturdayOpenTime |
Saturday Open Time |
The opening time for the location on Saturdays. |
Time in HH:MM format (e.g., 0:01). |
|
state |
State |
The state where the location is based. |
Two-letter state code (e.g., IL). |
|
street |
Street Address |
The street address of the location. |
Plain text. |
|
sundayCloseTime |
Sunday Close Time |
The closing time for the location on Sundays. |
Time in HH:MM format (e.g., 23:59). |
|
sundayOpenTime |
Sunday Open Time |
The opening time for the location on Sundays. |
Time in HH:MM format (e.g., 0:01). |
|
supportedActivity |
Supported Activity |
The primary activity supported at the location (e.g., Relay, Sort, Trailer Pool). |
Enum: Relay, Sort, Trailer Pool, etc. |
|
thursdayCloseTime |
Thursday Close Time |
The closing time for the location on Thursdays. |
Time in HH:MM format (e.g., 23:59). |
|
thursdayOpenTime |
Thursday Open Time |
The opening time for the location on Thursdays. |
Time in HH:MM format (e.g., 0:01). |
|
timezone |
Timezone |
The timezone of the location. |
Valid timezone string (e.g., America/Chicago). |
|
tuesdayCloseTime |
Tuesday Close Time |
The closing time for the location on Tuesdays. |
Time in HH:MM format (e.g., 23:59). |
|
tuesdayOpenTime |
Tuesday Open Time |
The opening time for the location on Tuesdays. |
Time in HH:MM format (e.g., 0:01). |
|
wednesdayCloseTime |
Wednesday Close Time |
The closing time for the location on Wednesdays. |
Time in HH:MM format (e.g., 23:59). |
|
wednesdayOpenTime |
Wednesday Open Time |
The opening time for the location on Wednesdays. |
Time in HH:MM format (e.g., 0:01). |
|
zip |
ZIP Code |
The ZIP code of the location. |
Valid numeric ZIP code (e.g., 60601). |