PHP lib: phpExcel for WP5.7 (PHP 7.4)

Popular phpExcel library does not work under new WordPress 5.7 and higher, because WP5.7 requires PHP 7.4
As a result, exporting data to an Excel file does not work.

You can switch to new, alternative, modern tools for exporting to Excel tables, or continue to use the familiar phpExcel library, but specially modified for the requirements of PHP 7.4

This modification (2024.05.10 PHP 7.4.3) was done independently, taking into account the flow of falling out errors. It is likely that over time, new problem areas will be identified, but at the moment they are not. All the features you need (for me anyway) work great.

There are no evil facking-hack inclusions. Guaranteed.

List of changes:
\PHPExcel\Shared\OLE.php
\PHPExcel\Writer\Excel5\Worksheet.php
\PHPExcel\Writer\Excel5\Workbook.php
\PHPExcel\Writer\Excel5\Parser.php
\PHPExcel\Cell\DefaultValueBinder.php
\PHPExcel\Cell.php
\PHPExcel\ReferenceHelper.php
\PHPExcel\Worksheet\AutoFilter.php
\PHPExcel\Calculation.php
\PHPExcel\Shared\String.php
\PHPExcel\Calculation\Functions.php

Deleted:
\PHPExcel\Shared\PCLZip
* This library is already included in the set of WordPress libraries .

Free to download.

Download “phpExcel lib for WP5.7 (PHP 7.4)” phpExcel_7.4.3_20240510.zip – Downloaded 2803 times – 932 KB


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”


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”