Follow for free plugins, new theme releases and theme news
Plugin Description
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
Screenshots
View the report, export data, search content, filter by date, and paginate through the records
Create and manage report groups that can contain their own sets of reports
Create and manage reports
Specify the SQL query to use to select data from the database — you can customize a special query used only for counting the total number of records
Specify the fields to display on the report and what kind of data they are
The list of supported data types for each field
Set advanced field options to further customize how fields will be displayed, exported, searched, filtered, or related to other tables
Manage plugin settings and get useful URLs for API access
