If you have a large number of zones, you can choose to import them using a comma delimited CSV format import file. You can also export zones created in the Scenarios user interface in the same format, for backup purposes.
To import a zones file:
-
Open the list menu in the upper left corner of the List panel and select the Zones option. The Zones list opens.
-
Click the More button
in the upper right corner of the List panel, and then select the Import Zones 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 Zones list:
-
If you have used the column naming conventions described in the zone import file format table below, you can click the Auto Map button and the columns in your import file are mapped to the correct zone 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 Zones list, you can perform any of the following actions:
-
Click on the left-facing arrow
to remove the field from the Zone 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 Zones list, click OK to complete the import.
Your zone import CSV files can contain some or all of the following columns:
|
Column Name |
Value |
|---|---|
|
zone.id |
The unique ID of the zone. |
|
zone.name |
The zone’s display name. |
|
zone.color |
The color in which the zone is displayed on the map. |
|
zone.boundary |
The coordinates of the vertices that make up the polygon shape of the zone. |
|
zone.drivers |
The drivers who are assigned to the zone and who can service jobs that are located in the zone’s geographic area. |
|
zone.custom.x |
One or more custom properties that you have imported, with x being the name of the property. |
To export a zones file:
-
Open the list menu in the upper left corner of the Lists panel and select the Zones option. The Zones list opens.
-
Select the check box beside each zone 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.