Bulk Import of Records from Excel (CSV) files for "Gravity Forms" with Validation and Internal Logic support.
An easy and convenient way to bulk load and process large numbers of records in GF forms.
Each record is checked for compatibility of field formats before saving.
If you have a Form in which there are Calculated Fields based on the Values of other Fields and the need for bulk import of source data, then this Plugin will definitely be useful to you.
For example. Form Type Calculator:
Field id=2 “A”: Term 1.
Field id=3 “B”: Term 2.
Field id=5 “Ratio”: Coefficient.
Field “Calc”: C = (A + B) * Ratio
When Importing Records, you usually need to prepare all the Values of all Fields:
A; B; Ratio; C.
So, to carry out preliminary calculations.
Difficulties begin when branched Inner Logic is used. When there are various additional Fields for selecting conditions in the form of Lists, Options. (“Gravity Forms” allows you to use both built-in Internal Logic in each of the Fields, and connect JS Scripts with Scripts.)
Transferring JS Scripts with Scripts to an Excel-prepared Table can be quite a difficult task. Errors are almost inevitable. Moreover, it is necessary to carefully maintain the correspondence of the calculated formulas in the Table with the Form Algorithms. And if you have changed something in the algorithms of the Form, then you again need to change and then test the Formulas in the Table. Even writing about it is tiresome.
Moreover, some Field Values may have both Value and Format Constraints. In normal cases, import without checking such Restrictions may lead to an abnormal termination of the Import process, or to incorrectly filled Fields.
In any case, manual correction of Records after such an Import can be costly and resource intensive.
It is for such Tasks that this Plugin is needed.
It is enough to fill in only the Initial Fields.
In our Example – Fields: A B and Ratio.
Calculated Field “C” will be calculated in each imported Record by the internal Form algorithms and will be saved.
If some of the Values are out of range, then such a Record will not be saved and will require correction directly during the Import process.
You can watch and try the Demo on a real Form.
Possibility to choose encoding of CSV file: ‘utf-8’ – default; ‘ISO-8859-1’; ‘CP1251’; etc…
PRO Version Features:
Page with fields "Gravity Forms" and active option "Import Excel to Gravity Forms".
"Import Excel to Gravity Forms" interface. Step 1. Button for download CSV file.
"Import Excel to Gravity Forms" interface. Step 2. Select CSV file.
"Import Excel to Gravity Forms" interface. Step 3. Processing records. Navigation. Save.
"Import Excel to Gravity Forms". Settings page.
The "Gravity Forms" settings page with the "Import Excel to Gravity Forms" plugin activated.
2023.09.28 * Change Plugin Images. * Tested to WP 6.3.1 * Tested to Gravity Forms 2.7.10.1
2022.11.17 * Fix "Number" type Field processing. * Tested up to WP: 6.1.1
2022.02.11 * Fix problem with any version MS Excel. Thanks goodmuyis! * Tested up to WP: 5.9
2022.01.13 * Possibility to choose encoding of CSV file: 'utf-8' - default; 'ISO-8859-1'; 'CP1251'; etc...
2022.01.10 * Fixed Conflict of connecting controls when there are several more GForms on the page.
2021.10.26 * Fix AJAX processing for non-logged in Users.
2021.08.02 * Fix "MultiSelect" type Field on Save. * Fix "Radio" type Field on Save.
2021.07.31 * Fix AJAX processing.
2021.07.30 * Fix "CheckBox" type Field on Save.
2021.07.30 * Fix "CheckBox" type Field processing for multiselect choice. * Fix "TextArea" type Field processing for Non RTF mode. * Updated AJAX answers. * Updated Samples.
2021.07.20 * Fix Plugin File Name.
2021.07.20 * Added check processing Min, Max values for Fields type "Number"
2021.07.18 * Fix "Clear_Fields()". * Fix "Radio" type Field processing. * Fix "CheckBox" type Field processing. * Fix "MultiSelect" type Field processing.
2021.07.16 * Fix "Paragraph" type Field processing.
2021.07.16 * Fix "Paragraph" type Field processing.
2021.07.15 * Fix JS Processing.
2021.07.15 * Remove phpExcel_7.4 Lib. * Fix Internal Path after rename Plugin Name.
2021.07.13 * Published in the Repository. Go! * Rename from "GF Eexcel Import" to "Import Excel to Gravity Forms"
2021.07.07 * Initial release