GravityExport Lite
PluginExport all Gravity Forms entries to Excel (.xlsx) or CSV via a download button or a secret shareable URL.
- 0 Sterne
- 0 Beobachter
- 0 Downloads
- GPL-2.0-only
-
2.1.0 Neueste
Bugfix: Data from the old nested form could be exported if the nested form was changed. Versionshinweise
62 noch nicht verfügbare Versionen anzeigen
Releases, die im Changelog des Anbieters oder auf WordPress.org genannt werden und die das Repository noch nicht enthält.
-
2.7.4 Noch nicht verfügbar
-
2.0.6 Noch nicht verfügbar
Bugfix: Checkbox lists without values in the entry could cause problems on transposed exports.
-
2.0.5 Noch nicht verfügbar
Bugfix: Single option survey fields were no longer exported.
-
2.0.4 Noch nicht verfügbar
Bugfix: Prevents throwing errors on a malformed notification.
-
2.0.3 Noch nicht verfügbar
Bugfix: Filtering on URL's didn't work on the old download URL structure anymore.
-
2.0.2 Noch nicht verfügbar
Bugfix: Attachments could have the wrong fields.
-
2.0.1 Noch nicht verfügbar
Bugfix: The notification for the migration could throw an exception in some instances.
-
2.0 Noch nicht verfügbar
This is a major update! Enjoy the much nicer feed configuration interface!
-
1.11.4 Noch nicht verfügbar
Enhancement: Added Entry ID as a sorting option. Useful when duplicate entry dates exist.
-
1.11.3 Noch nicht verfügbar
Enhancement: List fields column labels can now be manipulated by the gfexcelfieldlabel filter.
-
1.11.2 Noch nicht verfügbar
Enhancement: Added dateupdated as a default exported meta field.
-
1.11.1 Noch nicht verfügbar
Enhancement: Nested form field values are formatted properly through transformers.
-
1.11 Noch nicht verfügbar
Feature: Survey Likert fields can return the score instead of the value by applying the gfexcelfieldlikertusescore hook.
-
1.10.1 Noch nicht verfügbar
Bugfix: Fatal error when using the plugin with PHP
-
1.10 Noch nicht verfügbar
Enhancement: Support for Gravity Perks Nested Forms.
-
1.9.3 Noch nicht verfügbar
Bugfix: Feed settings page would break when using Gravity Forms ≥2.5.10.1.
-
1.9.2 Noch nicht verfügbar
Bugfix: Fatal error when using Gravity Forms ≤2.4.23.
-
1.9.1 Noch nicht verfügbar
GravityExport Lite requires PHP 7.2
-
1.9.0 Noch nicht verfügbar
Gravity Forms Entries in Excel is now known as GravityExport Lite
-
1.8.14 Noch nicht verfügbar
Enhancement: Improved usability on small screens and enhanced accessibility.
-
1.8.13 Noch nicht verfügbar
Bugfix: Plugin would not activate on hosts running PHP 7.1.
-
1.8.12 Noch nicht verfügbar
Enhancement: Updated PhpSpreadsheet to 1.17.
-
1.8.11 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Not released on WordPress due to linter issues.
-
1.8.10 Noch nicht verfügbar
Bugfix: Default combiner glue for List Fields was accidentally changed.
-
1.8.9 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Conflict: Updated dependencies to resolve conflict with Visualizer.
-
1.8.8 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Enhancement: Better support for checkbox fields.
-
1.8.7 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Bugfix: Product quantity was set to 1 by default if the value was empty.
-
1.8.6 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Bugfix: Resetting the form count could result in an error you would receive per email.
-
1.8.5 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Enhancement: You can now sort by subfields like "last name" in a name field.
-
1.8.4 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Bugfix: Product field was unhappy without splitting fields.
-
1.8.3 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Bugfix: Notification update sometimes produced error. No more happy emoticons.
-
1.8.2 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Bugfix: Empty numeric values are not allowed by PhpSpreadsheet anymore. So much for SemVer :-)
-
1.8.1 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Bugfix: Numeric values were presented as currency by default.
-
1.8.0 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Last version to support PHP 7.1. Next minor release will only support 7.2+.
-
1.7.5 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Enhancement: Added some renderer hooks for CSV manipulation.
-
1.7.4 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Bugfix: Setting a cell to bold no longer makes it italic too.
-
1.7.3 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Bugfix: Download rights were not checked properly. No security risk, but it should work. :)
-
1.7.2 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Bugfix: Custom filenames were not being showed by the field anymore.
-
1.7.1 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Bugfix: Column-names now match the filters in the sortable lists.
-
1.7.0 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Feature: Added field filtering to the URL. Checkout the documentation for more info.
-
1.6.3 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Bugfix: Radio and checkboxes caused unforeseen error on short tag for GF.
-
1.6.2 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Bugfix: Referenced unavailable constant.
-
1.6.1 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Security: Removed old style URL. If you were using it, please regenerate the URL.
-
1.6.0 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Feature: The renderer now supports transposing, so that every column is a row and vice versa.
-
1.5.5 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Enhancement: Date fields now export the date according to its field setting.
-
1.5.4 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Language: Finnish language files added thanks to @Nomafin!
-
1.5.3 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Enhancement: Added plugin settings page with plugin wide default settings
-
1.5.2 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Bugfix: Posting a form gave a 500 error, because of missing form info in front-end.
-
1.5.1 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
(Awesome) Feature: You can now set the order of the fields by sorting them, using drag and drop!
-
1.5.0 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Failed upload. I wish WordPress would drop the ancient SVN approach!
-
1.4.0 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Celebration: 1000+ active installations! Whoop! That is so awesome! Thank you for the support and feedback!
-
1.3.1 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Enhancement: Added notes per entry. Activate with gfexcelfieldnotesenabled.
-
1.3.0 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Feature: Wrapped values in value objects, so we can be more specific in Excel for cell-type-hinting
-
1.2.4 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Enhancement: moved away from deprecated PhpExcel to PhpSpreadsheet (Thanks @ravloony).
-
1.2.3 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Bugfix: Worksheets could contain invalid characters, and break download.
-
1.2.2 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Enhancement: If a cell only contains a URL, that URL is set as a link on that cell, for easy access.
-
1.2.1 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Translation: Added Dutch translation + enabled possibility to translate via WordPress.org. You can help me out!
-
1.2.0 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
(Very cool) Feature: Download Excel output directly from forms table, and (drumroll), download multiple forms in one file!
-
1.1.0 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Feature: Download counter (starts counting as of this version)
-
1.0.2 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Bugfix: Only 20 results were being returned by the GFAPI
-
1.0.1 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
Updated readme
-
1.0 Noch nicht verfügbar Veröffentlichungsdatum nicht angegeben
First release
Readme
GPL-2.0-onlyGravityExport Lite
Export all Gravity Forms entries to Excel (.xlsx) or CSV via a download button or a secret shareable URL.
GravityExport (Gravity Form Entries in Excel) is the ultimate no-hassle solution for exporting data from Gravity Forms.
Powerful new functionality is available with GravityExport! Save exports to FTP & Dropbox, export as PDF, and format exports for data analysis.
Export entries using a secure URL
When you configure a new export, the plugin will generate a secure download URL that you can share with anyone who needs the data (No need to log in!). Reports will automatically update as new entries are added.
GravityExport Lite includes many features:
- Limit access to downloads—either make a URL public or require users to be logged-in with correct permissions
- Download reports from multiple forms at once
- Export entry notes along with entries
- Transpose data (instead of one entry per-row, it would be one column per row)
- Attach entry exports to notifications
[youtube https://youtu.be/diqNgFCguM4]
Export directly to Excel (.xlsx)
Export your entries directly to .xlsx format. No more wasting time importing your CSV files into Excel and re-configuring columns.
Export as CSV
If you'd prefer to have your reports generated as CSV, GravityExport Lite makes it easy.
Add search filters to the URL
Once you have your download URL, you can easily filter by date range and field value.
Configure export fields
Save time generating exports in Gravity Forms: Configure the fields that are included in your CSV or Excel export. No need to set up every time!
Documentation & support
If you have any questions regarding GravityExport Lite, check out our documentation.
If you need further assistance, read this first and our support team will gladly give you a helping hand!
Requirements
- PHP 7.2
php-xmlandphp-ziplibraries. The plugin will check for those.- Gravity Forms 2.5 or higher
Gain additional powerful functionality
The full version of GravityExport unlocks these game-changing features:
- 📄 PDF Export GravityExport supports exporting entries as PDF! You can choose to have a PDF generated for each entry or one PDF that includes all entries. You can also customize the PDF output by adjusting the size, orientation, and more.
- 📦 Dropbox integration Save your form data directly to Dropbox.
- 👩🏽💻 Send reports to FTP Store reports on your own FTP server! GravityExport supports the SFTP, FTP + SSL, and FTP protocols.
- ⬇️ Multiple download URLs Create multiple export URLs that output to different formats and include different fields.
- 📊 Export data ready for analysis Make it easier to process your Gravity Forms data by splitting fields with multiple values into different rows.
We've written an article that contains all you need to know about exporting data from Gravity Forms.
Credits
- The GravityExport Lite plugin was created by Doeke Norg
Was es mitbringt
- Shortcodes:
[gfexcel_download_url]
Installation
This section describes how to install the plugin and get it working.
- Upload
gravityexport-liteto the/wp-content/plugins/directory - Activate the plugin through the 'Plugins' menu in WordPress
- Go to Forms > Select a form > Settings > Results in Excel to obtain your URL
- Download that Excel file!
Faq
I don't want the metadata like ID, date, and IP in my file
No problem. You can use the gfexcel_output_meta_info or gfexcel_output_meta_info_{form_id} hooks to disable
this feature. Or (since version 1.4.0) you can select individual fields you want to exclude on the settings page.
Just add this to your functions.php:
add_filter( 'gfexcel_output_meta_info', '__return_false' );
I want to rename the labels, but only in Excel, how can I do this?
Sure, makes sense. You can override the label hooking into
gfexcel_field_label, gfexcel_field_label_{type}, gfexcel_field_label_{type}_{form_id} or
gfexcel_field_label_{type}_{form_id}_{field_id}
The field object is provided as parameter, so you can check for type and stuff programmatically.
How can I change the value of a field in Excel?
You can override the value by hooking into gfexcel_field_value, gfexcel_field_value_{type},
gfexcel_field_value_{type}_{form_id} or gfexcel_field_value_{type}_{form_id}_{field_id}
The entry array is provided as a parameter, so you can combine fields if you want.
Can I separate the fields of an address into multiple columns?
Great question! Yes you can! You can set it on the settings page, or make use of the following hooks to get that working:
gfexcel_field_separated_{type}_{form_id}_{field_id} where every variable is optional.
I have a custom field. Can your plugin handle this?
Yes it can, in multiple ways:
The default way the plugins renders output is by calling get_value_export on the field.
All Gravity Forms fields need that function, so make sure that is implemented.
The result is one column with the output combined to one cell per row.
But you can also make your own field renderer, like this:
- Make a class that extends
GFExcel\Field\BaseField(recommended) or extendsGFExcel\Field\AbstractFieldor implementsGFExcel\Field\FieldInterface - Return your needed columns and cells by implementing
getColumnsandgetCells. (SeeAddressFieldfor some inspiration) - Add your class via the
gfexcel_transformer_fieldshook as:type => Fully Qualified Classname(e.g.,$fields['awesome-type'] => 'MyTheme\Field\MyAwesomeField')
How can I change the downloaded file name?
By now you really should know you can change almost every aspect of this plugin. Don't like the name?
Change it using the settings page, or by using the gfexcel_renderer_filename or gfexcel_renderer_filename_{form_id} hooks.
Also you can update title, subject and description metadata of the document by using
gfexcel_renderer_title(_{form_id}), gfexcel_renderer_subject(_{form_id}) and
gfexcel_renderer_description(_{form_id}).
Can I change the sort order of the rows?
Sure, why not. By default, we sort on date of entry in ascending order. You can change this, per form, on the Form settings page (GravityExport Lite) under "General settings".
I want to download directly from the forms table without the URL!
You're in luck: for those situations we've added a bulk option on the forms table. As a bonus, you can select multiple forms, and it will download all results in one file, on multiple worksheets (!!!)
How can I disable the hyperlinks on URL-only cells?
You can disable the hyperlinks by using the gfexcel_renderer_disable_hyperlinks-hook.
//add this to your functions.php add_filter('gfexcel_renderer_disable_hyperlinks','__return_true');
My numbers are formatted as a string, how can I change the cell type?
A number field is formatted as a number, but most fields default to a string.
As of this moment, there are 3 field types. Boolean,String and Numeric. You can set these per field.
`
//add this to your functions.php
use GFExcel\Values\BaseValue;
add_filter('gfexcel_value_type',function($type, $field) { if($field->formId == 1 && $field->id == 2) { //Possible values are 'bool', 'string' or 'numeric', //or, use the constant, preferred: return BaseValue::TYPE_NUMERIC; //TYPE_STRING, TYPE_BOOL } }, 10, 2); `
I'd like to add a hyperlink to a specific field
Since most values are Value Objects, we can interact with them, and trigger a setUrl function on a value.
//add this to your functions.php add_filter('gfexcel_value_object',function($value, $field) { if($field->formId == 1 && $field->id == 2) { $value->setUrl('https://wordpress.org'); } }, 10, 2);
I've added some notes, where are they?
By default the notes are disabled for performance. If you'd like to add these to the row you can activate this like so:
//add this to your functions.php add_filter('gfexcel_field_notes_enabled','__return_true'); //or add_filter('gfexcel_field_notes_enabled_{formid}','__return_true'); // e.g., gfexcel_field_notes_enabled_2
How do I add colors? It's all too boring in Excel.
Definitely! You get to change: text color, background color, bold and italic. If that is not enough, maybe you should add clip art!
` //add this to your functions.php add_filter('gfexcel_value_object', function (BaseValue $value, $field, $is_label) { // Need to know if this field is a label? if (!$is_label) { return $value; }
$value->setColor('#ffffff'); //font color, needs a six character color hexcode. #fff won't cut it here.
$value->setBold(true); // Bold text
$value->setItalic(true); // Italic text (to be combined with bold)
$value->setBackgroundColor('#0085BA'); // background color
// $field is the GF_Field object, so you can use that too for some checks.
return $value;
}, 10, 3); `
I don't have enough memory!
Yes, this can happen. Unfortunately, this isn't something that can be fixed without modifying your
As a default, WordPress allocates 40 MB of memory. Because the plugin starts the rendering pretty early, it has most of it available.
But every cell to be rendered (even if it's empty) takes up about 1KB of memory. This means that you have (roughly)
40 MB * 1024 KB = 40,960 Cells. I say roughly, because we also use some memory for calculations and retrieving the data.
If you're around this cell-count, and the renderer fails; try to upgrade the WP_MEMORY_LIMIT. Checkout WooCommerce's Docs for some tips.
Can I hide a row, but not remove it?
You can hide a row by adding a hook. Checkout this example:
add_filter('gfexcel_renderer_hide_row', function ($hide, $row) { foreach ($row as $column) { if ($column->getFieldId() === 1 && empty($column->getValue())) { return true; // hide rows with an empty field 1 } } return $hide; // don't forget me! }, 10, 2);
Screenshots
- A 'GravityExport' link is added to the form settings
- There is your URL! Just copy and paste to the browser (or click the download button)
- Or download it from the list via the bulk selector
Installieren
composer require meteorgpl-plugin/gf-entries-in-excelDie Lizenzprüfungen des Anbieters sind unverändert: Aktivieren Sie das Plugin in WordPress mit einem beim Anbieter gekauften Lizenzschlüssel.
Lizenz
Deklarierte Lizenz: GPL-2.0-only. Der Code wird unter der Lizenz weiterverbreitet, die der Anbieter in den eigenen Headern des Plugins deklariert hat. Lizenzprofil: gpl-full.
Grafiken, Schriften, Medien und Dokumente, die möglicherweise separat lizenziert sind, werden nicht weiterverbreitet; die Lizenzseite erklärt, was ersetzt oder entfernt wird, und der Sicherheits-Tab listet es pro Version auf. Der Anspruch auf Support und Updates ergibt sich aus der Lizenz, die Sie beim Anbieter kaufen.