Pods Framework Soft Charisma

Exports and Reports

Download Exports and Reports

Download v 0.5.1 from WordPress.org | Downloads: 2,464

Visit Exports and Reports on WordPress.org »

About Exports and Reports

THIS IS A BETA VERSION – Currently in development

OFFICIAL SUPPORT – Exports and Reports – Support Forums: http://scottkclark.com/forums/exports-and-reports/

Define custom Exports / Reports (using MySQL queries) for users by creating each export / report and defining the fields as well as custom MySQL queries to run.

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.

Installation

  1. Unpack the entire contents of this plugin zip file into your wp-content/plugins/ folder locally
  2. Upload to your site
  3. Navigate to wp-admin/plugins.php on your site (your WP plugin page)
  4. Activate this plugin

OR you can just install it with WordPress by going to Plugins >> Add New >> and type this plugin’s name

Changelog

0.5.1

  • Feature: Reports menu split from Reports Admin so they’re two separate menus now to avoid confusion for users
  • Feature: Ability to reorder Groups so you can choose the order they appear in the menu
  • Feature: Ability to set a separate query for use when getting the ‘total’ count (for advanced / complex queries which otherwise would be a bad idea to use SQL_CALC_FOUND_ROWS for)
  • Feature: Report field settings now have ‘Advanced’ section that can be expanded to view advanced settings, otherwise you can use the three simple settings which are ‘Field Name’, ‘Data Type’, and ‘Label (optional)’
  • Feature: Now when you don’t enter ANY fields in the Field Settings area, the report will pick up fields directly from the query for you when you display a report
  • Feature: When making a boolean data type field filterable, a new filter will appear to choose ‘– Show All –’, ‘Yes’, and/or ‘No’
  • Feature: If you’re having trouble with a report, you can enable debug mode by adding debug=1 to the Report URL (must be Administrator)
  • Fix: Date fields that are empty (0000-00-00 00:00:00) will now show ‘N/A’ instead
  • Fix: Related fields have better handling for SQL building
  • Fix: No longer using default ORDER BY when no ORDER BY is found in SQL, causing issues with tables that didn’t have a field ‘id’ set
  • Fix: Smarter WHERE and HAVING dynamic building
  • Fix: Lots of PHP warnings / notice cleanups and general code tweaks to plugin and WP_Admin_UI class

0.4.2

  • Feature: Added ability to set the a field’s filter default value
  • Feature: Added additional ‘related’ field type options (where/order by SQL, related ON field)
  • Feature: Added ‘default_none’ option to DB and Report editor, which allows you to default a report to show no results until a search / filter is done, exports clicked will continue to generate the full export before search and/or filtering
  • Feature: EXPORTS_REPORTS_DISABLE_MENU constant added to disable the menu from being output completely (aside from the normal exports_reports_* capabilities you can define under user roles
  • Fix: Added comments to SQL Query field in Report editor to explain advanced %%TAGS%% which can be used
  • Fix: Reports list now ordered by Group then Weight (same for reordering)
  • Fix: Forcing version to be int instead of text when getting version from DB
  • Fix: Various minor bug fixes to plugin and WP Admin UI class

0.3.3

  • Bug fix for SQL (another)

0.3.2

  • Bug fix for SQL
  • Moved About to bottom of Menu
  • Added ‘Reset’ option in Settings

0.3.1

  • Fixed menu access

0.3

  • Upgraded Admin.class.php with Bug fixes and features (better UI and filtering)
  • Export data fixes on CSV / TSV to support Excel
  • Redefined Date Data Type into three (Date, Date + Time, Time)
  • Filter by Date
  • Ability to clear entire export directory (based on logged export files)
  • Daily Export Cleanup via wp_cron

0.2

  • First official release to the public as a plugin