In Carrier TMS, the bulk import feature allows you to add multiple facilities profiles into the system through a .csv file. You will need to fill out a template file with your facilities’ information and import the data to Carrier TMS via .csv upload.
This article will cover:
- Downloading the facilities' import template file
- Formatting cells
- Uploading the import file to Carrier TMS
To download the facilities' import template file:
- On your left dashboard, go to Settings > General Settings > Bulk Import
- On the Bulk Import page, select the import type Facilities
- Download the facilities' import template by clicking on Download Template
The template will be downloaded and saved to your computer under the filename “facilities-import-template”.
To format the facilities' import template file:
- Open the facilities-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 to the column headers will prevent the system from matching the correct fields to upload the facilities' data.
Column Name |
Description |
Format |
Required/Optional |
name |
Facility name |
Must contain an alphabetical value |
Required |
address |
Facility address |
Standard address format |
Required |
phone |
Facility phone number |
Free form text |
Optional |
lat |
Latitude coordinate of the facility for precise geofencing |
Number format |
Optional |
lng |
Longitude coordinate of the facility for precise geofencing |
Number format |
Optional |
Important: Invalid facility addresses will prevent the template from uploading successfully. Please ensure that the address is valid.
To upload the facilities’ import template file:
- Save the file as a .csv file.
- Navigate back to the facilities’ bulk import page > click Upload File
- A list with the facilities’ information from the .csv document will appear at the bottom of the page. Check if everything is correct and click Import Facilities on the top right of the page.
The facilities' profiles will be added in Carrier TMS. If you are experiencing issues uploading the template, please send a copy of the facilities' import template file to the support team for further assistance.
Related Articles:
Comments
0 comments
Please sign in to leave a comment.