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 5.4 – 8.2
* Works with Gravity Forms versions 2.3.3.4 and higher. Tested up to 2.9.1
* You can change the appearance of the Message through CSS Styles.
Continue reading “No Active for GravityForms”

Plugin Notes Label


Add your Notes to each plugin.

This Plugin allows you to Add personal Notes, comments, memo to each of the Plugins.
You can change or delete any Note at any time.
Notes are available to anyone who has access to the Plugins page.

Here are some reasons why “Plugin Notes Label” is needed and useful:

  • Over time, sometimes you forget exactly why this or that Plugin was installed.
  • Some Plugins have to be modified (although this is not correct), and their updating requires special attention. That is, you need to remind yourself and others that you cannot update such a Plugin without careful preparation.
  • Sometimes you expect a specific new promised functionality from a certain Plugin, and up to this point, all intermediate updates are not particularly important.
  • Anyone who administers WordPress can remember a few more similar reasons. ))

Continue reading “Plugin Notes Label”

Org. Departments


Plugin “Org. Departments” allows you to create a Hierarchical Structure of Departments. And use this Structure in relation to the User.

In the Profile of each User, you can select one or more Subdivisions to which this User is related.

Additionally, it is possible to temporarily Include / Disconnect Users in this Subdivision Structure, without excluding him from a particular Subdivision. This can be useful in some internal situations, such as Academic Leave, etc.

= Futured =
* The number of Levels and Sublevels is not limited.
* The current User does not have the ability to edit his Divisions to which he belongs. The Administrator or Human Resources Manager is expected to establish these links.
* Add Column: “Department” on Admin -> Users List.
* Option: Show Column: “Department” (On/Off).
* Use ShortCode [org.departments] for Show Departments Tree on FrontEnd.
* Search argument for ShortCode [org.departments search=true]. Use for Search in Departments and Members.
Continue reading “Org. Departments”

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”

Counter Hits

A simple, easy, fast, local, objective counter to visit your site.

It does not use any additional requests to other servers, which means it consumes minimal resources.

Displays the count of all views of any page as a number.
You can customize your own display style. Use class: ‘wpgear_counter_hits’

Just paste Shortcode 2499961 wherever you like and that’s it.
Or you can use calls in PHP scripts code:
echo get_Counter_Hits (0);

As a result, you get: 2499961

If the Counter is installed on a Site that already has certain ratings, then you can adjust the readings using the attribute base. For example: 'Get_Counter_Hits base = "100000"' will add + 100000 offset to the current Counter.

As a result, you get: 2599961
Continue reading “Counter Hits”

Notice Interceptor

Notice Interceptor

Tool for creating a comfortable living environment in the WordPress admin area without annoying notifications and ad units.

For some reason, many developers of Themes and Plugins believe that they just need to remind the Administrator of their existence every minute. Intrusive and obsessive offers to subscribe somewhere, buy something, like, poke something, etc.
And even the presence of the “disable” button does not guarantee that after a new entrance to the Admin panel, all this jumble of information garbage will not creep out again and will not take over part of the working space of the monitor screen.

The concept of this tool is to remove all unnecessary, but give an opportunity to manage this Information Garbage. It is possible that under certain circumstances something from all this is really necessary and useful. And you just know where you have it, on which shelf. You reach out and take it, study it. And then you put it away again so it doesn’t get in the way.

How it works:

Continue reading “Notice Interceptor”

Page and Post Description


The “Page and Post Description” plugin extends the capabilities of the standard Post-List in the Admin Panel.

Posts and Pages do not have Descriptions by default, but sometimes, when a lot of time passes, it can be difficult to remember what exactly is written in a particular page. And you have to spend time opening this Post to see its contents. A small Description – like a Note, can be of great help in some situations.

It is this new “Description” Field that is added to each Post. And it can be changed both on the Edit page (in the form of a Widget), and directly in the List of Posts (Posts and Pages)

The “Description” field (for brevity in the List named “Note” to make the most of the workspace and at the same time avoid abbreviations) is highlighted on a separate line for the entire width of the List, because these Descriptions can be long and detailed. Otherwise, there is no point in them.

Displays the Author who made a Note and Date of creation.

This Plugin gives you this opportunity.

= Futured =
* Works for Pages and Posts.
* Does not add a new Column to the List, compressing the standard set of Post Columns to inconvenience.
* The “Description” can be edited on the edit pages or directly in the List without the need to update.
* You can separately select on which Lists the plugin “Page and Post Description” will work: Pages / Posts.
* PRO Version futured :
+ Automatic finding of all Castoms Post-Types and their connection.
Continue reading “Page and Post Description”

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”