Get started
Color

Export reports to CSV

Download any report, fixed or custom, as a CSV file for a spreadsheet, or print it as a PDF, for the dates and time zone you chose.

For
OwnerService advisorDispatcherAdministrator
Hosting
Any hosting
Devices
Web browser
Business
All businesses

Checked against Pop Dispatch 0.1.0

Every report can leave Pop Dispatch as a CSV file. You will be able to download the figures you see on screen and open them in a spreadsheet.

The Reports screen in the web console for the demo business.
The Reports screen.

Before you start #

  • Run the report first, so you know the dates and time zone it covers.
  • The file holds the same rows and totals as the table, for the same dates and time zone.

Steps #

  1. Open Reports for the fixed reports, or Report builder for custom and saved reports.
  2. Choose the report and the First day and Last day.
  3. Select Run report (or Run on a saved report).
  4. Select Download CSV. The browser saves a file named with the report and the dates, and a message says "The CSV file is saved."
  5. Open the file in your spreadsheet. The first row holds the column names and the last row holds the totals, labeled Total.
  6. To print instead, select Print / PDF. The printable page opens in a new tab with your business name, the report, the dates, the time zone and the day you ran it.

How the file reads #

  • Money is written as plain numbers in dollars with two decimals, such as 1250.50, so a spreadsheet can add it up.
  • Distances are written with one decimal.
  • Dates in a custom report are written as year-month-day, with the time when the field holds one.
  • Text that a spreadsheet would read as a formula starts with an apostrophe.
Technical details
  • Fixed reports: GET /reports/:name?from=&to=&tz=&format=csv. Custom reports: POST /report-builder/run?format=csv with the definition, and GET /report-builder/saved/:id/run?format=csv for a saved one.
  • The CSV is built from the same table as the screen, so the two always agree. A custom run exports up to its row limit.
  • Printing a PDF is written to the audit log as "printed a report".

If something goes wrong #

  • "This report is for owners, managers and advisors.": ask one of them to run it.
  • "from must not be after to": swap the dates.
  • A browser that keeps the PDF tab closed saves the PDF as a file instead.