Importing Trailers

  • Updated

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:

  1. On your left dashboard, go to Settings > General Settings > Bulk Import
  2. On the Bulk Import page, select the import type Trailers
  3. 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:

  1. Open the trailers-import-template file and delete rows 2 - 4.
  2. Reference the table below of cell formats and required/optional fields while filling out the template.

Important: Please do not change the column header namesChanges 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

reefer

flat_bed

drayage_load

Optional

trailer_type.container_number

Container number

Number format

Optional

trailer_type.container_is_empty

Is the container empty?

TRUE
or
False

Optional

trailer_length

Trailer length

Number format

Optional

deleted

Trailer status

TRUE
or
False

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:

  1. Save the file as a .csv file.
  2. Navigate back to the trailers’ bulk import page > click Upload File
  3. 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. 

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.