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:
- On your left dashboard, go to Settings > General Settings > Bulk Import
- On the Bulk Import page, select the import type trucks
- 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:
- Open the trucks-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 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 |
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.
Comments
0 comments
Please sign in to leave a comment.