eForm Straightforward SQL is an addon for our eForm – WordPress Form Builder plugin. It means that you can instantly export submissions to a devoted database desk on the go.
Straightforward SQL Addon works alongside with eForm, with out modifying the core. If lively, throughout each kind submission and updation, it checks for its related entry on the export desk, and if not discovered or required, it provides or updates the file similar to the submission. Every query factor of the shape will get its personal column and each row of the desk represents a submission.
As soon as the submissions are saved in their very own database desk, you’ll be able to carry out a bunch of SQL operations on them instantly. This primarily removes all limitations you’ve had with FSQM’s personal serialized knowledge storage system.
With model 1.2.0 you may have a brand new revision management characteristic. If that is enabled, then every time person performs an replace Straightforward SQL will retailer the older knowledge. It could actually later be considered in a side-by-side desk by means of admin interface or could be downloaded by means of the XLSX file.
Key Options:
- Document on to a database desk as submissions happen.
- Hold revisions of person submission updates.
- Each column would symbolize a query factor and rows would symbolize submissions.
- Optionally restrict to maintain previous n days data to the database.
- Optionally restrict complete variety of data to be saved within the database.
- Browse and search by means of submissions instantly from administrator space.
- Export database to XLSX file on the go.
Changelog
Lively Channel 1.3.x
Model 1.3.1 (4 Sep, 2018)
Modifications
* Mounted: Concern with HTML particular entities in factor label inflicting SQL to interrupt.
Model 1.3.0 (24 Feb, 2017)
Modifications:
* Added: Compatibility with eForm v3.6.0 * Added: referer, url monitor, time and hyperlink within the XLSX obtain * Added: Possibility for entry delimiter * Improved: Auto Export web page will present solely kinds whose settings are lively * Improved: Change default row delimiter to nn
Beneath the hood:
* Improved: Use worth class to populate row knowledge
Model 1.2.0 (3 Nov, 2016)
Modifications:
* Added: Revision management system to check person updates * Mounted: Concern with vary and spinner parts recording incorrect merchandise label
Model 1.1.0 (17 Mar, 2016)
Modifications:
* Added: Help for jSignature parts * Added: Help for Cost parts
Beneath the hood:
* Added: Now exhibiting script/db model within the admin web page
Information Edited:
changelog lessons/class-ipt-exp-sql-admin.php lessons/class-ipt-fsqm-form-elements-sql.php ipt_fsqm_exp_sql.php
Model 1.0.0 (1 Feb, 2016)
* Preliminary Launch
Credit
- PHP_XLSXWriter library.
- Some photographs and vectors used from freepik.com.
