The Data Exporter pulls your data out of Zippykind as a file you can open in a spreadsheet. Find it at Data Exporter in the left menu of the dispatch software (/app/exporter). The export opens in a new browser tab when it is ready.
Export Type
Pick what you are exporting. The list is:
- Call Logs, Email Logs, Push Logs, SMS Logs — the notification records also visible under Logs in the left menu.
- Customer Accounts — your customer records.
- Driver Performance — a rollup per driver over the period you choose, rather than one row per event.
- Drivers — your driver records.
- Drivers Track Log — the recorded GPS positions. Only has data if Record Drivers Location is on; see Drivers Track Log.
- Products — your product catalog.
- Tickets with Order Information — tickets including their line items, fees, tax and totals.
- Tickets without Order Information — tickets only, one row each. Much smaller, and the right choice when you only need delivery data.
- Tickets with Status History — tickets with their status timeline, which is what you want for punctuality or audit questions.
Time
Today, Past 6 Hours, Past 12 Hours, Past 24 Hours, Past Week, Past Month, or Custom Date. Choosing Custom Date reveals Start Date and End Date pickers. Dates are read in your account's time zone.
Narrowing what comes out
- Team — limits to one team, and narrows the driver list below it to that team's drivers.
- Driver — all drivers, or one.
- Location — all locations, or one.
Choosing the columns
The panel on the right is a two-list picker. When you choose an export type it fills with the available columns; move the ones you want into the selected list and only those appear in the file. Take the time to do this — a ticket export with everything switched on is very wide, and a file with six meaningful columns is far more use to whoever asked for it.
File Format
CSV (.csv) or Excel (.xlsx). CSV is the default. Choose Excel when the file is going to a person, and CSV when it is going into another system — CSV imports more predictably.
Running it
Press Export File. The file is generated and opened in a new tab, so allow pop-ups for the site if nothing appears.
Access
The exporter is controlled by the Exporter permission on an operator group, so you can keep bulk data extraction away from operators who should not have it. See Operators, groups and permissions.