GravityExport Lite Changelog

Note: GravityExport Lite now requires WordPress 6.5 or newer.

• Security: Field values starting with characters such as = could be interpreted as formulas when a CSV export was opened in a spreadsheet application. These values now begin with a single quote (') so they display as plain text, while regular numbers such as -5 are left unchanged (thanks to Ali Hidayat for the report).
• Fixed: Download links created by other GravityExport add-ons could return a "not found" error when a GravityExport Lite feed's settings happened to contain the same security key. These links now work correctly.

Developer Updates:
* Added: gk/gravityexport/renderer/csv/escape-formulas filter to turn off formula escaping in CSV exports (useful when CSV files are imported into other systems rather than opened in a spreadsheet application).

• Security: On some sites, a request to the download URL that carried no security key returned a form's entries to a visitor who was not logged in. Thanks to Ashish Agarwal for the report.
• Security: Disabling a form's download URL did not always stop downloads, because a request that carried no security key was still served.
• Security: When an export failed, the error page showed server file paths, a stack trace and the plugin, Gravity Forms, PHP and WordPress versions to visitors.
• Fixed: A download URL could return "not found" when another add-on's settings happened to contain the same security key.
• Fixed: A file extension added to the end of a download URL was used as-is, so an export could be returned in a file format the plugin does not offer. Unsupported extensions now fall back to the file type configured for the form.
• Fixed: A malformed download URL could trigger a PHP fatal error on the site. Malformed URLs are now rejected.

Note: GravityExport Lite now requires PHP 7.4 or newer.

• Fixed: PDF exports were not sent with a PDF file type, which could cause browsers, proxies and file previewers to handle the downloaded file incorrectly.
• Fixed: A browser console error appeared on a form's GravityExport Lite settings page before a download URL was enabled.

• Fixed: Sites running PHP 8.4 or newer logged repeated "deprecated" warnings on every page.
• Fixed: The global settings page was hidden for administrators when the Members plugin managed capabilities. The page now requires the "Export Entries" capability, which can be granted per role.

• Added: The single-entry export attached to a notification is now saved to a unique temporary folder, so simultaneous submissions can no longer overwrite each other's attachment.
• Fixed: Copy-to-clipboard button icons were vertically misaligned in WordPress 7.0.
• Fixed: A "translation loading triggered too early" notice (WordPress 6.7+) caused by the download-URL feed actions loading translations during plugin bootstrap.
• Fixed: The success message shown after regenerating, enabling, or disabling a download URL was lost because the page redirected before it could display.

Developer Updates:
* Added: gk/gravityexport/notification/attachment-ids filter to change the notification IDs the single-entry export is attached to.
* Added: gk/gravityexport/notification/attachment-source-ids filter to replace the stored notification selection; it runs first, so callbacks on the filter above always receive the complete selection (used by GravityExport to attach the export to multiple notifications).
* Added: gk/gravityexport/renderer/save-path filter to change the path a rendered export file is saved to.
* Added: gk/gravityexport/feed/pre-save-settings filter to change the feed settings before they are stored; it runs inside the save, so related settings are written in a single update.

• Added: gk/gravityexport/fields/additional-meta-fields filter to customize the additional meta fields available for export.
• Fixed: "Date Updated" values were displayed in GMT instead of the local time.

Developer Updates:
* Please note that the gravitykit/gravityexport-lite package on Packagist has been abandoned and is no longer maintained.

• Added: A search field for the Enabled and Disabled Fields lists on the form settings page. Quickly find fields by name when configuring exports for forms with many fields.
• Enhancement: Accessibility support for the field selector:
  • Screen reader announcements when fields are moved between lists;
  • Keyboard navigation with Enter/Space to move fields and Escape to clear search;
  • Visible focus indicators for keyboard users;
  • Proper ARIA labels on all interactive elements.
• Enhancement: RTL (right-to-left) language support for the field selector interface.
• Enhancement: Added filter hooks change the separator used to combine complex fields, like Name and Address.
• Fixed: PHP warning when field names are used as regex patterns without proper delimiters.

Developer Updates:

• Added: gfexcel_field_separated_separator filter to change the default separator for all combined subfields (default: newline).
• Added: gfexcel_field_{field_type}_separator filter (e.g., gfexcel_field_name_separator) to change the separator for a specific field type.

• Fixed: Added a deterministic sort order to prevent missing and duplicate entries.
• Fixed: Entries without a payment_date value would show the current date/time instead of an empty value.
• Change: Release process to WordPress.org from GitHub Actions.

• Enhancement: Added support for defining a GFEXCEL_AVOID_CLASS_ALIAS constant as true to prevent registering PhpSpreadsheet class aliases.

• Changed: Updated download link handling to allow future enhancements.
• Enhancement: Entries can now be ordered by "Date Updated".

• Fixed: PHP notice in WordPress 6.8 caused by initializing product translations too early.
• Fixed: The download URL of an Upload Field with multiple files was not passed through gfexcel_field_value.

• Enhancement: Nested forms can now also export entry meta values.
• Fixed: Nested form values could cause an exception.
• Fixed: Columns labels from Nested Form Fields no longer included the parent label.

• Fixed: A warning would appear when upgrading GravityExport Lite.

• Fixed: Type errors on fields no longer cause exports to fail. Values become empty, and errors are logged.
• Enhancement: Added a gfexcel_field_checkbox_empty filter to control checkbox output, when no option was selected.

• Fixed: PHP notice in WordPress 6.7 caused by initializing product translations too early.

• Fixed: Critical error in combination with GravityExport and PHP 8.

• Enhancement: Added a gfexcel_field_fileuploads_force_download filter to control whether file upload links open in the browser or download directly.

• Fixed: Added compatibility for servers that miss the iconv or mbstring PHP extension.
• Fixed: Critical error when downloading an export file.

• Updated: Release to wordpress.org was missing files.

• Updated: PhpSpreadsheet to 1.19.0.
• Enhancement: Added a gfexcel_renderer_csv_output_encoding hook to set the character encoding on the CSV.

• Added: Option to secure the download link embed shortcode with a secret key.
• Added: New button to easily copy the download link embed shortcode.
• Bugfix: Nested forms with missing entries could trigger a critical error.

• Bugfix: Data from the old nested form could be exported if the nested form was changed.
• Bugfix: Nested form fields could end up in different columns.
• Enhancement: Added global Use admin label setting.
• Enhancement: Moved dependencies to a custom namespace to avoid collision with other plugins.
• Added: German translation

Developer Updates:

• Added: gk/gravityexport/settings/use-admin-labels hook.
• Added: gk/gravityexport/field/use-admin-labels hook.
• Added: gk/gravityexport/field/nested-form/export-field hook to dynamically add other nested form fields to the export.

Developers: This might be a breaking change to some plugins, if they directly reference any of the dependencies.

• Bugfix: Checkbox lists without values in the entry could cause problems on transposed exports.

• Bugfix: Single option survey fields were no longer exported.

• Bugfix: Prevents throwing errors on a malformed notification.

• Bugfix: Filtering on URL's didn't work on the old download URL structure anymore.

• Bugfix: Attachments could have the wrong fields.

• Bugfix: The notification for the migration could throw an exception in some instances.

• This is a major update! Enjoy the much nicer feed configuration interface!
• Changed: The minimum version of Gravity Forms is now 2.5
• Enhancement: Fields can now be enabled or disabled all at once on the form settings page.
• Enhancement: Meta fields can now be (de)selected all at once on the plugin settings page.
• Enhancement: Meta fields with array values are now properly deconstructed on export.
• Enhancement: Added support for GravityPerks Media Library ID fields.
• Enhancement: Upload fields can now split into multiple rows (GravityExport).
• Security: Upload fields now show the private download URL to avoid enumeration on public files.

Developer Updates:

• This is a major release behind the scenes; we have rewritten much of the plugin to better integrate with Gravity Forms feed add-on framework.
• Modified: Changed the textdomain of the plugin to gk-gravityexport-lite.

• Enhancement: Added Entry ID as a sorting option. Useful when duplicate entry dates exist.
• Bugfix: on PHP 8 an array value threw an error instead of silently failing.

• Enhancement: List fields column labels can now be manipulated by the gfexcel_field_label filter.

• Enhancement: Added date_updated as a default exported meta field.
• Bugfix: Filtering using in and not in operators in the URL query string did not work.
• Bugfix: Exported multiselect fields (e.g., checkboxes and nested forms) could be missing a separator between values if one value is a 0.

• Enhancement: Nested form field values are formatted properly through transformers.
• Bugfix: Sort order of nested form fields could be swapped on some entries.
• Bugfix: PDFs displaying field names as a vertical column could contain extra empty columns.
• Bugfix: Download of nested forms could fail on PHP 8.

• Feature: Survey Likert fields can return the score instead of the value by applying the gfexcel_field_likert_use_score hook.
• Enhancement: Updated all gfexcel_renderer_csv_* hooks to include the form id.
• Bugfix: Possible errors when using gform_export_separator callbacks with 2 expected parameters.

• Bugfix: Fatal error when using the plugin with PHP <7.4.

• Enhancement: Support for Gravity Perks Nested Forms.
• Enhancement: gfexcel_field_value filters will also be applied on subfields of separable fields.
• Enhancement: gform_export_separator filter will also be used to determine the delimiter.
• Enhancement: gform_include_bom_export_entries filter will also be used to determine BOM character use.
• Bugfix: Default value of file upload was not available without saving the general settings once.
• Bugfix: Gravity Perks: Live Preview (show hidden) would not work properly.

• Bugfix: Feed settings page would break when using Gravity Forms ≥2.5.10.1.

• Bugfix: Fatal error when using Gravity Forms ≤2.4.23.
  • We highly recommend upgrading to Gravity Forms >2.5.

• GravityExport Lite requires PHP 7.2
• Bugfix: Fatal error when trying to download an export file.

• Gravity Forms Entries in Excel is now known as GravityExport Lite
  • Same plugin and functionality you love!
  • Internal code restructuring ensures better extensibility and facilitates new feature development (coming in future versions!)
  • Ready to be used with GravityExport that brings additional functionality to an already full-featured plugin.
• Enhancement: Improved Gravity Forms 2.5 compatibility.

Developer Updates:

Please note that gfexcel_* hooks will be gradually renamed while retaining backward compatibility.

• Enhancement: Removed all displayOnly fields from the export list like the normal export function.
• Enhancement: Added a gfexcel_output_sorting_options filter to set sorting options.
• Enhancement: Added a gfexcel_hash_form_id filter to get form ID from the unique URL hash value.
• Enhancement: Added a gfexcel_hash_feed_data filter to get feed object from the unique URL hash value.
• Enhancement: Added a gfexcel_get_entries_<form_id>_<feed_id> filter to override default logic responsible for querying DB entries.

• Enhancement: Improved usability on small screens and enhanced accessibility.
• Bugfix: Incorrect or incomplete export of certain form field values (e.g., Gravity Forms Survey fields).

• Bugfix: Plugin would not activate on hosts running PHP 7.1.

• Enhancement: Updated PhpSpreadsheet to 1.17.
• Enhancement: Added gfexcel_file_extension webhook to overwrite the extension (by default, .xlsx).
• Enhancement: composer.json constraints updated for Bedrock users.
• Bugfix: Removed deprecation warning on Gravity Forms 2.5.
• Bugfix: Sort order is now saved again on Gravity Forms 2.5.
• Bugfix: Improve button appearance on Gravity Forms 2.5.
• Bugfix: Sanitized URLs with esc_url() in the dashboard.
• Bugfix: Resolved some silent PHP warnings.

Not released on WordPress due to linter issues.

• Bugfix: Default combiner glue for List Fields was accidentally changed.
• Bugfix: Mark baker dependencies no longer clash with other plugins using the same dependencies.

• Conflict: Updated dependencies to resolve conflict with Visualizer.

• Enhancement: Better support for checkbox fields.

• Bugfix: Product quantity was set to 1 by default if the value was empty.

• Bugfix: Resetting the form count could result in an error you would receive per email.

• Enhancement: You can now sort by subfields like "last name" in a name field.
• Enhancement: Hover state for sorting items.
• Enhancement: Added form id to gfexcel_renderer_cell_properties hook.

• Bugfix: Product field was unhappy without splitting fields.

• Bugfix: Notification update sometimes produced error. No more happy emoticons.

• Bugfix: Empty numeric values are not allowed by PhpSpreadsheet anymore. So much for SemVer :-)
• Bugfix: Product subfields were all parsed as currency. Now they are the correct type.

• Bugfix: Numeric values were presented as currency by default.

• Last version to support PHP 7.1. Next minor release will only support 7.2+.
• Feature: Added setFontSize(?float $font_size) on value objects, so every cell can have a different font size.
• Feature: Added setBorder($color, $position) on value objects to set a border on a cell.
• Feature: Added CurrencyValue type and formatting on numeric cells. So you can have a currency symbol and a numeric value.
• Feature: Added new CombinerInterface to streamline the process of combining values into columns.
• Feature: Added notifications base to bomb you with info. Kidding, only useful messages of course.
• Bugfix: 'gfexcelrenderercsvincludeseparator_line' had a typo.
• Bugfix: List field threw notice when you changed the column names.
• Bugfix: Disabled warning when set_time_limit is not allowed to prevent failing download.
• Enhancement: Updated PhpSpreadsheet to 1.12 (last to support PHP 7.1).
• Enhancement: Added quick-link to documentation on the plugins page.
• Enhancement: Added quick-link to settings on the plugins page.
• Enhancement: Replaced all translation calls with WordPress native calls to be polite to Poedit.
• Enhancement: Added some unit tests.

• Enhancement: Added some renderer hooks for CSV manipulation.
  • gfexcel_renderer_csv_delimiter -> default: ,
  • gfexcel_renderer_csv_enclosure -> default: "
  • gfexcel_renderer_csv_line_ending -> default: PHP_EOL
  • gfexcel_renderer_csv_use_bom -> default: false
  • gfexcel_renderer_csv_include_separator_line -> default: false

• Bugfix: Setting a cell to bold no longer makes it italic too.

• Bugfix: Download rights were not checked properly. No security risk, but it should work. :)

• Bugfix: Custom filenames were not being showed by the field anymore.

• Bugfix: Column-names now match the filters in the sortable lists.
• Bugfix: Filters now only respond to the correct URL.
• Bugfix: Forgot to update composer.json to reflect minimum PHP version of 7.1. (for Bedrock users).
• Changed: Updated composer.json to use PhpSpreadsheet ~1.9.0 to be consistent with the normal plugin version.

• Feature: Added field filtering to the URL. Checkout the documentation for more info.
• Feature: Added support for Repeater fields.
• Feature: Added download links for a single entry on the entry detail page.
• Feature: Added download link to admin bar for recent forms.
• Enhancement: Added a maximum column width via gfexcel_renderer_columns_max_width.
• Enhancement: Added a gfexcel_renderer_wrap_text hook to disable wrapping text.
• Enhancement: Added $form_id as an argument to gfexcel_output_search_criteria for convenience.
• Enhancement: Added noindex, nofollow to the headers of the export, and added a Disallow to the robots.txt.
• Enhancement: Added a gfexcel_download_renderer hook to inject a custom renderer.
• Bugfix: Prevent notice at render-time for ob_end_clean.
• Bugfix: Reset download hash and counter on duplicated form.
• Updated: PhpSpreadsheet updated to 1.9.0. Package to ^1.3.

• Bugfix: Radio and checkboxes caused unforeseen error on short tag for GF.

• Bugfix: Referenced unavailable constant.
• Bugfix: short code had an breaking edge case.

• Security: Removed old style URL. If you were using it, please regenerate the URL.
• Enhancement: Added [gfexcel_download_link id=2] short tag for WordPress and {gfexcel_download_link} for GF notification.
• Enhancement: Added reset of download counter (also refactored all counter code to SRP class).
• Enhancement: Added setting to format prices as numeric values.
• Enhancement: Added a download event so you can append logic to the download moment.
• Enhancement: Added CreatedBy field to easily change user_id to nickname or display_name. Use filter gfexcel_meta_created_by_property.
• Bugfix: Stripping title could cut multibyte character in half, making the xlsx useless.
• Bugfix: Removed start_date or end_date from date range filter when empty. Caused errors for some.
• Bugfix: created_by and payment_date were not converted to the WordPress timezone.

• Feature: The renderer now supports transposing, so that every column is a row and vice versa.
• Feature: Added a date range filter. Also included as start_date and end_date query_parameters.
• Feature: Added a "download" link per form on the Forms page. Fewer clicks for that file!
• Feature: Hide a row by hooking into gfexcel_renderer_hide_row. Checkout the FAQ for more info.
• Enhancement: All separable fields are handled as such, except for checkboxes. Made no sense.
• Enhancement: Product and calculation have some specific rendering on single field for clarity.
• Enhancement: Now supports Gravity Forms Chained Selects.
• Enhancement: Querying entries in smaller sets to avoid massive database queries that can choke a database server.
• Enhancement: Added a gfexcel_output_search_criteria filter to customize the search_criteria for requests.
• Bugfix: Downloading files didn't work on iOS.
• Info: PHP 5.6 is no longer actively supported. Will probably still work; but 7.1 is the new minimum.
• Info: Launched a (first version) documentation site! Check out gfexcel.com

• Enhancement: Date fields now export the date according to its field setting.
• Enhancement: Value Objects (BaseValue) can reference getField(), getFieldType() and getFieldId() to help with filtering.
• Enhancement: Name fields can now also be split up in to multiple fields. Made this a generic setting on the settings page. Please re-save your settings!
• Enhancement: Subfield labels can now also be overwritten with the gfexcel_field_value-hook.
• Bugfix: Found a memory leakage in retrieving fields for every row. Will now be retrieved only once per file.
• Bugfix: Custom Sub field labels were not exported.
• Bugfix: I spelled 'separate' wrong, and therefore the hooks were also wrong. Please update your hooks If you use them!

• Language: Finnish language files added thanks to @Nomafin!
• Enhancement: Better inclusion of script and styles.
• Enhancement: Renamed Results in Excel to Entries in Excel to be more consistent.
• Enhancement: Added a quick link to settings from the plugins page.
• Bugfix: Wrong minimum version of Gravity Forms set, should be 2.0.
• Help: Added some help text to the global settings page. I need your input!

• Enhancement: Added plugin settings page with plugin wide default settings
• Enhancement: Added dependency checks to plugin, so without them, the plugin won't work.
• Bugfix: Prices were shown in html characters. Not really a bug, but it was bugging someone :)
• Bugfix: Address field needed wrapping of value objects on separate fields.
• Bugfix: Some fields were missing wrapping of value object.

• Bugfix: Posting a form gave a 500 error, because of missing form info in front-end.

• (Awesome) Feature: You can now set the order of the fields by sorting them, using drag and drop!
• Feature: Add colors and font styles to cells by using the gfexcel_value_object-hook (See docs).
• Feature: Attach a single entry file to a notification email.
• Feature: We now support exports in CSV. Why? Because we can! (and also Harry asked me too).
• Enhancement: You can now add .xlsx or .csv to the end of the URL, to force that output.
• Enhancement: Added support for the Woocommerce add-on.
• Enhancement: Added support for the Members plugin. You need 'gravityformsexportentries' role for this plugin.
• Bugfix: The extension did not match the renderer, which sometimes caused Excel to give a warning.
• Bugfix: Lists with a single column could not be exported.

• Failed upload. I wish WordPress would drop the ancient SVN approach!

• Celebration: 1000+ active installations! Whoop! That is so awesome! Thank you for the support and feedback!
  As a celebration gift I've added some new settings, making the plugin more user-friendly, while maintaining developer-friendliness!
• Feature / Security: Regenerate URL for a form, with fallback to old way. But please update all your URLs!
  This update also makes the slug more secure and unique by not using the (possibly default) NONCE_SALT.
• Feature: Disable fields and metadata with checkboxes on the settings page. Can still be overwritten with the hooks.
• Feature: Enable notes on the settings page. Can still be overwritten with the hook.
• Feature: Added setting to set the custom filename. Can also still be overwritten with the hook.
• Feature: Added error handling to provide better feedback and support.

• Enhancement: Added notes per entry. Activate with gfexcel_field_notes_enabled.
• Enhancement: Removed unnecessary files from the plugin to make it smaller.

• Feature: Wrapped values in value objects, so we can be more specific in Excel for cell-type-hinting
• Feature: NumberField added that uses the NumberValue type for Excel
• Feature: Added filters to typehint cell values. See FAQ for more info.
• Enhancement: updated cell > URL implementation. Each cell can be set individually now. See FAQ for more info.
• Upgraded to PHP 5.6 for minimal dependency. Last version with PHP 5.3 was 1.2.3
  (sorry for the mix-up, the new renderer forced my hand, and I forgot about this, otherwise the versioning had gone up sooner.)

• Enhancement: moved away from deprecated PhpExcel to PhpSpreadsheet (Thanks @ravloony).
• Enhancement: composer.json update to wordpress-plugin for easier installation with bedrock.
• Enhancement: Metadata now uses GFExport to get all metadata; so a row now has all metadata. Can still be disabled.
• Feature: New ListField transformer. Splits list fields into its own Excel columns, with newline-separate values per column.
• Feature: New meta fields transformer. Special filter hooks for meta fields with gfexcel_meta_value.
• Feature: New meta subfield transformer for date_created. Use gfexcel_meta_date_created_separated to split date and time in 2 columns.
• Bugfix: Plugin hooks later, so filters also work on bulk-download files.

• Bugfix: Worksheets could contain invalid characters, and break download.
• Last version to use PHP 5.3

• Enhancement: If a cell only contains a URL, that URL is set as a link on that cell, for easy access.

• Translation: Added Dutch translation + enabled possibility to translate via WordPress.org. You can help me out!
• Enhancement: Worksheets now have a title, and of course a gfexcel_renderer_worksheet_title hook.

• (Very cool) Feature: Download Excel output directly from forms table, and (drumroll), download multiple forms in one file!
• Feature: Added gfexcel_field_disable filter to disable all fields you want. Fields will be filtered out before handling.
• Feature: Added gfexcel_output_rows and gfexcel_output_columns filters to have more control over output. Thanks @mircobabini.
• Feature: Added a setting for sort order per form. Also contains some hooks to override that work!

• Feature: Download counter (starts counting as of this version)
• Feature: SectionField added to disable empty section columns. Disabled by default. Enable with gfexcel_field_section_enabled hook (return true).
• Feature: FileUploadField added to disable file upload columns. Enabled by default. Disable with gfexcel_field_fileuploads_enabled hook (return false).
• Update: Wait until plugins are loaded. Need to be sure Gravity Forms is active. This caused a problem in some multisite implementations.
• Bugfix: Changed the permalink registration so that it works with multisite combined with the GF API (thanks for the assist @zitomerh). No need to reactivate the plugin now.
• Bugfix: In Standard URL permalink structure, the hash wasn't escaped properly

• Bugfix: Only 20 results were being returned by the GFAPI
• The title of a form could not be longer than 31 characters

• Updated readme
• Removed unnecessary assets

• First release