If you have a large number of vehicles, you can choose to import them using a comma delimited CSV format import file. You can also export vehicles created in the Scenarios user interface in the same format, for backup purposes.
To import a vehicles file:
-
Open the list menu in the upper left corner of the List panel and select the Vehicles option. The Vehicles list opens.
-
Click the More button
in the upper right corner of the Lists panel, and then select the Import Vehicles option in the menu that opens.
-
Drag and drop the CSV format file from its saved location into the dialog box. Alternatively, click Choose File, browse to the file on your computer, select it, and then click Open.
-
Click Manage Mappings. The Manage Mappings dialog box opens. From here you can use one of the following methods to map the columns in your import file to the columns in the Vehicles list:
-
If you have used the column naming conventions described in the vehicle import file format table below, you can click Auto Map and the columns in your import file are mapped to the correct vehicle values automatically. You can use the Sort button to toggle between sorting the columns on the left alphabetically or in the order they appear in the file.
-
If you have previously saved a JSON file containing the column mappings, you can click Load to use the saved mappings.
-
If your import file uses your own custom column names, follow these steps:
-
Click a column name in the left panel, and then click the right-facing arrow
.
-
Select the field in the right panel, and click Edit Mapping.
-
Select the field that matches the values contained in the import column.
-
Click OK.
-
Repeat this process for each column in your import file.
-
-
(Optional) When you have mapped your columns from the file to the Vehicles list, you can perform any of the following actions:
-
Click on the left-facing arrow
to remove the selected field from the Vehicles list.
-
Click Edit Mapping to change the mapping for the selected field.
-
Click Clear to clear all mappings you have made and start over.
-
Click Download to save the current mappings so that you can reuse them another time.
-
Click the Settings button
to select the formatting to use for dates.
-
-
When you have finished mapping all your columns from the import file to the Vehicles list, click OK to complete the import.
Your vehicle import CSV files can contain some or all of the following columns. Each row describes a single vehicle:
|
Column Name |
Value |
|---|---|
|
vehicle.id |
The unique ID of the vehicle. |
|
vehicle.name |
The name of the vehicle. |
|
vehicle.location_id |
The ID of the vehicle's location marker (at the vehicle's normal start and end location, typically at a depot or at a driver's home). Can be supplied as an inline marker or the ID of a marker (marker.id, see Marker Import File Format). |
|
vehicle.location_name |
The name of the marker at which the vehicle starts and ends its routes, typically a depot or at a driver's home. |
|
vehicle.lat |
The latitude coordinates of the vehicle's normal start and location. |
|
vehicle.lon |
The longitude coordinates of the vehicle's normal start and location. |
|
vehicle.lat_lon |
The longitude and longitude coordinate pair of the vehicle's normal start and location. |
|
vehicle.address |
The formatted address of the vehicle's normal start and location, including the country. Required if vehicle.lat and vehicle.lon are not provided. |
|
vehicle.required_driver_attributes |
The attributes (tags) that any driver assigned to this vehicle must have, if any. Accepted as a comma-delimited list. |
|
vehicle.attributes |
The attributes associated with this vehicle, if any. Accepted as a comma-delimited list. |
|
vehicle.cost_per_km |
The cost, in US dollars, per kilometer of driving this vehicle. |
|
vehicle.cost_per_mi |
The cost, in US dollars, per mile of driving this vehicle. |
|
vehicle.fixed_cost |
The fixed cost of using this vehicle in US dollars. |
|
vehicle.driving_speed_percentage |
The percentage of the normal speed limit on roads that this vehicle is expected to be driven at, between 0 and 100. |
|
vehicle.max_jobs_on_route |
The maximum number of jobs that this vehicle can service on a single route. |
|
vehicle.load_capacity |
The total amount of load that can be delivered by the vehicle in a single route. |
|
vehicle.allow_u_turns |
Whether or not this vehicle is permitted to perform u-turns to reach the job sit, crossing oncoming lanes of traffic. "TRUE" or "FALSE". |
|
vehicle.same_side_routing |
Whether or not this vehicle is required to approach jobs on the same side of the road as the job site entrance, avoiding u-turns. "TRUE" or "FALSE". |
|
vehicle.allow_toll_roads |
Whether this vehicle is permitted to travel on toll roads. "TRUE" or "FALSE". |
|
vehicle.allow_ferries |
Whether this vehicle is permitted to travel on routes that require ferries. "TRUE" or "FALSE". |
|
vehicle.vehicle_type |
The vehicle type. Either 'Truck' or 'Car'. |
|
vehicle.height_cm |
The height of the vehicle in centimeters. |
|
vehicle.height_in |
The height of the vehicle in inches. |
|
vehicle.weight_kg |
The weight of the vehicle in kilograms. |
|
vehicle.weight_lb |
The weight of the vehicle in pounds. |
|
vehicle.unladen_weight_kg |
The weight of the vehicle in kilograms when not carrying any load. |
|
vehicle.unladen_weight_lb |
The weight of the vehicle in pounds when not carrying any load. |
|
vehicle.length_cm |
The maximum length of the vehicle in centimeters. |
|
vehicle.length_in |
The maximum length of the vehicle in inches. |
|
vehicle.width_cm |
The maximum width of the vehicle in centimeters. |
|
vehicle.width_in |
The maximum width of the vehicle in inches. |
|
vehicle.kingpin_to_last_axle_cm |
The distance from the vehicle's kingpin to the last trailer axle, measured in centimeters. |
|
vehicle.kingpin_to_last_axle_in |
The distance from the vehicle's kingpin to the last trailer axle, measured in inches. |
|
vehicle.number_of_axles |
The number of axles on the vehicle. This setting allows vehicles with more axles to carry more weight on some weight-restricted roads. |
|
vehicle.number_of_trailers |
The number of trailers attached to the vehicle. Used to avoid roads with legal restrictions on vehicles with items in tow. |
|
vehicle.number_of_wheels |
The number of wheels on the vehicle and attached trailers. This setting allows vehicles with more wheels to carry more weight on some weight-restricted roads. |
|
vehicle.hazmat_load_type |
The hazardous materials load carried by the vehicle. One of 'non_hazardous', 'hazmat1', 'hazmat2', 'hazmat3', 'hazmat4', 'hazmat5', 'hazmat6', 'hazmat7', 'hazmat8', 'hazmat9', or 'hazardous'. |
|
vehicle.time_on_site_at_start_location |
The length of time on site required for this vehicle at the start location depot in order to load, unload or prepare the vehicle. |
|
vehicle.time_on_site_at_return_to_depot |
The length of time on site required for this vehicle when returning to a depot during a mid-route return to depot stop in order to load, unload or prepare the vehicle. |
|
vehicle.time_on_site_at_end_location |
The length of time on site required for this vehicle at the end location depot in order to load, unload or prepare the vehicle. |
|
vehicle.custom.[custom] |
Any custom properties associated with the vehicle. |
To export a vehicles file:
-
Open the list menu in the upper left corner of the Lists panel and select the Vehicles option. The Vehicles list opens.
-
Select the check box beside each vehicle you want to export in the grid. Click the More button
-
Click Choose Columns and select the columns that you want to export. By default all columns are selected. Click Export.
-
The CSV format export file is saved to the default download location on your computer.
Comments
0 comments
Please sign in to leave a comment.