Exporting data (CSV)
The export is launched from the ticket list, not from the Routes section:
- Filter and select the tickets you want to report on.
- Choose the Export routes CSV massive action.
- Optionally set a date range to restrict the export to journeys made between those dates, or export everything.
- Download the file.
The CSV contains one row per visit, with the route and its version, the position of the stop in the itinerary and whether it was marked as priority, the ticket and its title, the technician, start and end times, the four distance/time metrics from section 2.4, and the time actually worked on the ticket.
Two summary blocks are appended at the end of the file: totals per technician and totals per day, each with number of visits, distance, travel time, billable figures and time worked. This makes the file usable for invoicing without any further processing.
Durations are exported in seconds and distances in metres, deliberately: raw units are easier to aggregate in a spreadsheet than pre-formatted text.
Three tickets selected in the ticket list, with "Export routes CSV" chosen from the massive action dropdown.
The optional date-range step — set a range and click "Generate CSV", or skip it with "Export everything".
The resulting CSV: one row per visit (columns A–Q), followed by the "Summary by technician" and "Summary by day" blocks.