Skip to main content

Importing Trucks

  • Updated

In Carrier TMS, the bulk import feature allows you to add multiple trucks into the system through a .csv file. You will need to fill out a template file with your trucks’ information and import the data to Carrier TMS via .csv upload. 

This article will cover: 

  • Downloading the trucks’ import template file
  • Formatting cells
  • Uploading the import file to Carrier TMS

To download the trucks’ 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 trucks
  3. Download the trucks’ import template by clicking on Download Template

The template will be downloaded and saved to your computer under the filename “trucks-import-template”.

 

To format the trucks’ import template file:

  1. Open the trucks-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 trucks’ data.

Column Name

Description

Format

Required/Optional

truck_no

Truck Number

Free form text

Required

registration_no

Truck registration number

Free form text

Required

mileage

Truck odometer mileage

Free form text

Optional

make

Truck make

Free form text

Optional

model

Truck model

Free form text

Optional

year

Truck year

Number format

Optional

vin

Truck VIN (Vehicle Identification Number)

Free form text

Optional

license_state

State of registration

2-letter state abbreviation

Optional

license_expire

Registration expiration date

Standard date format

Optional

last_inspection

Last inspection date

Standard date format

Optional

eld_id

ELD (Electronic Logging Device) identification number

Free form text

Optional

deleted

Truck status

TRUE
or
FALSE

Optional

owner

Is the truck 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

truck notes

Free form text

Optional

 

 

To upload the trucks’ import template file:

1. Save the file as a .csv file.

2. Navigate back to the trucks’ bulk import page > click Upload File

3. A list with the truck’s information from the .csv document will appear on the bottom of the page. Check if everything is correct and click Import Trucks on the top right of the page.

The trucks’ profiles will be added in Carrier TMS. If you are experiencing issues uploading the template, please send a copy of the trucks’ import template file to the 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.