Import Excel to Gravity Forms


Bulk Import of Records from Excel (CSV) files for “Gravity Forms” with Validation and Internal Logic support.

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: “Import Excel to Gravity Forms“.

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.

= Features =
* Works with PHP 7.4
* Works with Gravity Forms versions 2.3.3.4 (earlier GF versions were simply not tested. Probably will work) and higher. Tested up to 2.5.7.1
* Import entries are lines of a text file (usually CSV) separated by commas.
* You can choose any other separator.
* You can navigate through the list of imported records and save only a few of them.
* Each record is checked for compatibility of field formats before saving.
* If the Form Fields have internal logic, then each record is processed with this logic in mind before being saved.
* All types of fields are imported: “Text”, “TextArea”, “Number”, “Date”, “Select”, “MultiSelect”,  “Radio”, “CheckBox”.
* Works correctly with Cyrillic and other National character encodings.
* Each Form has its own “Import Enable” option.
* Works correctly when there are several other GForms on the page.
* Possibility to choose encoding of CSV file: ‘utf-8’ – default; ‘ISO-8859-1’; ‘CP1251’; etc…
Continue reading “Import Excel to Gravity Forms”

No Active for GravityForms


Displays a message that the Form is not Active, instead of a blank page.

If the GF Form has the “is_active” option = False, then when it is displayed via the Shortcode ‘gravityform’, an empty Page is usually displayed.
Such behavior may cause confusion and questions from Users.
And even the owner of the Site will not always be able to immediately understand what is happening.

Plugin “No Active for GravityForms” displays a normal Message that this Form is not Active.
And everything immediately becomes clear. Everyone is happy. ))

Demo

= Futured =
* Works with PHP 7.4
* Works with Gravity Forms versions 2.3.3.4 and higher. Tested up to 2.5.7.1
* You can change the appearance of the Message through CSS Styles.
Continue reading “No Active for GravityForms”

GV Excel-Export

Make realy comfortable, complete export to normal Excel files from GravityView.

GravityView (whatever my attitude towards him) popular tool. But the built-in Export allows to generate only CSV files. For many, this is inconvenient and insufficient, because tedious post-processing of such files is required. The presence of the Cyrillic alphabet in the name of the fields can greatly spoil the mood and desire to do something.

This Plugin is designed to solve this problem.
Continue reading “GV Excel-Export”

New Users Monitor

“New Users Monitor” – A freeware plugin that will help you quickly find out that you have already been hacked. This is main task of ‘NUM’. Well, in general, ‘NUM’ will inform about the appearance of a new user in WP. If you are an administrator, then such an event is important to you.

* All new users will be highlighted in red until Admin confirm each of them in User-Profile.

* This plugin has already helped out many times when some of our sites were hacked. But we quickly found out about it. And we were able to fast stop the problem.

* With the active Option: “Deny Login if User is not confirmed”, you will sleep much more peacefully.

Continue reading “New Users Monitor”

List-Forms for Gravity

The “List-Forms for Gravity” plugin extends the capabilities of the standard Forms-List in the Admin Panel on the “Gravity Forms” & “Gravity View” pages.

A new line with a Description of the Form itself is harmoniously added to each line with the Form, which indicates its Name, ID, Number of Records and Number of Views, as well as an Interactive Control Unit.
This Note – is the “Description” field on the “Settings” page of each GF/GV Form.

It would seem that it would be good for this Description to be initially in a separate Column right after the Title, but if you think carefully, you realize that no – not good. The point is that Names can be long, and Descriptions can be even longer, otherwise they simply don’t make sense. And besides, the same Interactive Control Unit 0n requires a lot of space and takes up half the width of the Form List table.

It is possible that the “Description” field is not used by many. And therefore, the developers did not bother about this. Although, the developers could also make the List Customization option.
But if there are really many Forms, then the Description is simply necessary.

This Plugin gives you this opportunity.

= Futured =
* Fits harmoniously with the usual style of the List of Forms.

Continue reading “List-Forms for Gravity”

Plugin Notes

This plugin is rarely updated. Yes there is no need. A good tool and it does its job well. And you do not need to do anything to improve it and make it the operating system. Respect to the author, because he understands.
This plugin no PRO version.

But there is a small, annoying problem (about which most people probably do not even know, especially someone on free hosting sites). This plugin makes a lot of error entries in the log file.
And in general it is possible to live with it. But over time, the log file can grow to an enormous size. This somehow affect the system performance.

Continue reading “Plugin Notes”