Import vehicle plannings
Permissions:
create_task_lists
Bulk-create vehicle plannings in a product from a CSV file. From the product’s Vehicle plannings page in Control Center, select Import, download the template, fill it in, and upload it. Files that include pauses also require manage_pauses, and files that include repositioning tasks also require update_task_lists.
The import requires a timezone, chosen during import, which is used to interpret the date-times in the file. Date-times use ISO 8601 (for example 2019-01-18T12:00:00).
CSV columns
Vehicle planning columns
One row per vehicle planning.
| Column | Required | Description |
|---|---|---|
V_LICENSE_PLATE | Yes | License plate of the vehicle. |
T_START | Yes | Planned start, ISO 8601; must be in the future. |
T_END | Yes | Planned end, ISO 8601; must be at or after T_START. |
T_CONFIG | No | Matching configuration name. |
T_START_PLACE | No | Start place slug. |
T_END_PLACE | No | End place slug. |
T_START_STATION_EXT_ID | No | Start station external ID (use when T_START_PLACE is blank). |
T_END_STATION_EXT_ID | No | End station external ID (use when T_END_PLACE is blank). |
T_STATE | No | Vehicle-planning state. |
T_BOOKING_MODE | No | One of always, ad_hoc_booking_only, prebooking_only. |
T_REPOSITIONING_STRATEGY | No | Automated repositioning strategy. |
T_LINE | No | Line slug. |
T_SERVICE_START | No | Service start, ISO 8601. |
T_SERVICE_END | No | Service end, ISO 8601. |
T_MATCHING_RANK | No | Matching rank. |
Pause columns
Pauses are optional and numbered—P1_, P2_, and so on.
| Column | Required | Description |
|---|---|---|
P{n}_START | Yes (per pause) | Pause start, ISO 8601, within the planning’s start/end. |
P{n}_END | Yes (per pause) | Pause end, ISO 8601, within the planning’s start/end. |
P{n}_PLACE | No | Pause place slug. |
P{n}_PRESERVE_DURATION | No | Whether to preserve the pause duration (boolean). |
Repositioning-task columns
Repositioning tasks are optional and numbered—R1_, R2_, and so on.
| Column | Required | Description |
|---|---|---|
R{n}_TIME | Yes (per task) | Repositioning time, ISO 8601. |
R{n}_PLACE | Yes (per task) | Repositioning place slug. |
R{n}_DISMISSABLE | Yes (per task) | Whether the task can be dismissed (boolean). |