Exports and Reports

Define custom exports / reports for users, based off of any custom MySQL SELECT query you define.

Author:Scott Kingsley Clark (profile at wordpress.org)
WordPress version required:4.9
WordPress version tested:5.9.1
Plugin version:0.9.1
Added to WordPress repository:08-07-2010
Last updated:09-03-2022
Warning! This plugin has not been updated in over 2 years. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.
Rating, %:94
Rated by:18
Plugin URI:https://www.scottkclark.com/
Total downloads:36 030
Active installs:1 000+
plugin download
Click to start download

Define custom exports / reports for users, based off of any MySQL SELECT query you create. This plugin interacts with your SELECT query and does all the hard work for you: exporting, pagination, ordering, searching/filtering, and display formatting for you.

All you do is install the plugin, create your Groups, create your Reports, and hand it off to your clients. Exportable reports in CSV, TSV, XML, JSON, and custom delimiter separated formats.

Please submit bug reports or contribute your own enhancements/fixes on GitHub.

Features

Administration

  • Create and Manage Groups
  • Create and Manage Reports
  • Limit which User Roles have access to a Group or Report
  • Ability to clear entire export directory (based on logged export files)
  • Daily Export Cleanup via wp_cron
  • WP Admin UI – A class for plugins to manage data using the WordPress UI appearance

Reporting

  • Filter by Date
  • Automatic Pagination
  • Show only the fields you want to show
  • Pre-display modification through custom defined function per field or row

Exporting

  • CSV – Comma-separated Values (w/ Excel support)
  • TSV – Tab-separated Values (w/ Excel support)
  • TXT – Pipe-separated Values (w/ Excel support)
  • XLSX – Excel format, using PHP_XLSXWriter
  • XML – XML 1.0 UTF-8 data
  • JSON – JSON format
  • PDF – PDF printer friendly views, using TCPDF
  • Custom – Custom delimiter separated Values (Update the report screen URL parameters to &action=export&export_type=custom&export_delimiter=# and change # to whatever delimiter you want)

Cronjob / JSON API

  • Run the Export action for a specific report to any supported export type
  • Get paginated / full data from a report in JSON format