eForm Simple SQL is an addon for our eForm – WordPress Form Builder plugin. It means that you can straight export submissions to a devoted database desk on the go.
Simple 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 document comparable 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 possibly can carry out a bunch of SQL operations on them straight. This primarily removes all limitations you’ve had with FSQM’s personal serialized information storage system.
With model 1.2.0 you will have a brand new revision management characteristic. If that is enabled, then every time consumer performs an replace Simple SQL will retailer the older information. It could possibly later be seen in a side-by-side desk by way of admin interface or may be downloaded by way of the XLSX file.
Key Options:
- Document on to a database desk as submissions happen.
- Maintain revisions of consumer submission updates.
- Each column would signify a query factor and rows would signify submissions.
- Optionally restrict to maintain previous n days information to the database.
- Optionally restrict whole variety of information to be saved within the database.
- Browse and search by way of submissions straight 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: Challenge 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: Choice for entry delimiter * Improved: Auto Export web page will present solely types whose settings are lively * Improved: Change default row delimiter to nn
Underneath the hood:
* Improved: Use worth class to populate row information
Model 1.2.0 (3 Nov, 2016)
Modifications:
* Added: Revision management system to check consumer updates * Mounted: Challenge with vary and spinner components recording incorrect merchandise label
Model 1.1.0 (17 Mar, 2016)
Modifications:
* Added: Help for jSignature components * Added: Help for Cost components
Underneath 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.
