Location Import Template
The import schema and attribute descriptions for the location .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 |
|---|---|---|---|
|
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. |
|
referenceCode |
Reference Code |
Unique identifier for the location in the system. |
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). |