In Carrier TMS, the bulk import feature allows you to add multiple trailers into the system through a .csv file. You will need to fill out a template file with your trailers’ information and import the data to Carrier TMS via .csv upload.
This article will cover:
- Downloading the trailers’ import template file
- Formatting cells
- Uploading the import file to Carrier TMS
To download the trailers’ import template file:
- On your left dashboard, go to Settings > General Settings > Bulk Import
- On the Bulk Import page, select the import type Trailers
- Download the trailers’ import template by clicking on Download Template
The template will be downloaded and saved to your computer under the filename “trailers-import-template”.
To format the trailers’ import template file:
- Open the trailers-import-template file and delete rows 2 - 4.
- Reference the table below of cell formats and required/optional fields while filling out the template.
Important: Please do not change the column header names. Changes made to the column headers will prevent the system from matching the correct fields to upload the trailers’ data.
Column Name |
Description |
Format |
Required/Optional |
trailer_no |
Trailer Number |
Free form text |
Required |
registration_no |
Trailer registration number |
Free form text |
Required |
mileage |
Trailer mileage |
Number format |
Optional |
make |
Trailer make |
Free form text |
Optional |
model |
Trailer model |
Free form text |
Optional |
year |
Trailer year |
Number format |
Optional |
vin |
Trailer VIN (Vehicle Identification Number) |
Free form text |
Optional |
license_state |
State of registration |
2-letter state abbreviation |
Optional |
last_inspection |
Last inspection date |
Standard date format |
Optional |
trailer_type.type |
Trailer type |
dry_van drayage_load |
Optional |
trailer_type.container_number |
Container number |
Number format |
Optional |
trailer_type.container_is_empty |
Is the container empty? |
TRUE |
Optional |
trailer_length |
Trailer length |
Number format |
Optional |
deleted |
Trailer status |
TRUE |
Optional |
owner |
Is the trailer owner operator, rent, or company owned?
|
owner_operator rent company_owned |
Optional |
termination_date |
Out of service date |
Standard date format |
Optional |
termination_reason |
Out of service reason |
Free form text |
Optional |
hire_date |
In service date |
Standard date format |
Optional |
notes |
Trailer notes |
Free form text |
Optional |
To upload the trailers’ import template file:
- Save the file as a .csv file.
- Navigate back to the trailers’ bulk import page > click Upload File
- A list with the trailers’ information from the .csv document will appear at the bottom of the page. Check if everything is correct and click Import Trailers on the top right of the page.
The trailers’ profiles will be added in Carrier TMS. If you are experiencing issues uploading the template, please send a copy of the trailers’ import template file to our support team for further assistance.
Comments
0 comments
Please sign in to leave a comment.