wpDataTables – Tables and Charts Manager for WordPress – WPSTALL

wpDataTables is a robust responsive Tables, Spreadsheets and Charts Data Manager in a type of a WordPress Plugin.

For all our customers questioning in regards to the excessive value, and for all customers with expiring help: please reach out to us so we may give you detailed solutions and data, and counsel presently out there options and particular provides.

If you need to be part of the testers crew simply open a support ticket here and we’ll add you to the checklist. You will all the time get the most recent options first. Please word that you just should be amongst present customers of wpDataTables.

Some Articles about wpDataTables plugin

User critiques

Plugin listed in WP catalogs

WPLift.com
WPExplorer.com

Twitter

For the individuals who need to request help: please just be sure you check the FAQ, documentation first. If your query isn’t there be happy to contact our help supervisor by way of the support system. We obtain a whole lot of requests these days, so we ask you for understanding in case of delayed replies.

MANUAL UPGRADE PROCEDURE (when a brand new model is launched)

Go to your FTP and open WordPress plugins folder.
Delete the outdated wpDataTables model folder.
Upload the brand new model of wpDataTables.
Go to WP-admin panel, open Plugins part.
Deactivate wpDataTables, and then activate it once more.

DO NOT DELETE THE OLD VERSION FROM WP-ADMIN IF YOU DON’T WANT TO DELETE YOUR TABLES

Please word that minimal PHP model required is 5.6

What’s new / Changelog

Version 2.7.2 (Released 04.10.2019)

A minor replace with one characteristic and a few bug fixes:

Feature: Advanced HTML Editor – Added new choices: Underline, Strikethrough, Subscript, Supscript, Bullet and Numbered List, Blockquote, Horizontal line, Fullscreen, Insert/Edit hyperlink, Remove hyperlink, Insert/Edit picture, Text colour, Text background colour and Clear formatting.
BugFix: Fixed subject with displaying checkbox modal.
BugFix: Fixed discover for possibility presentAllRows.
BugFix: Fixed calculation capabilities SUM, AVG, MIN and MAX for tables created with Postgre SQL connection.

Version 2.7.1 (Released 26.09.2019)

A minor replace with one bug repair and up to date library:

BugFix: Fixed subject with auto-replace.
Updated DataTables library to 1.10.19 model

Version 2.7 (Released 25.09.2019)

A serious replace with a few new options, bug fixes and stability enhancements:

Feature: Added possibility for displaying the desk with knowledge of all customers on again-finish when ‘User can see and edit solely their very own knowledge’ possibility is enabled.
Feature: New date codecs.
Feature: New placeholders for SQL question (CURRENT_DATE, CURRENT_DATE_TIME, and CURRENT_TIME).
Feature: Enabled placeholders for edit and filtering of handbook tables and for filtering of different desk varieties (please word that these placeholders are usually not enabled for tables created with Gravity and Formidable type integration addons).
Feature: Added Dropdown for selecting SQL driver in separate SQL connection.
BugFix: Fixed subject with filtering and capabilities with separate database connection.
BugFix: Fixed subject with Number vary slider in tables created from separate database connection.

Please word: If you’ve got used MSSQL separate connection earlier than this replace you’ll have to choose the driving force that’s put in in your server (by default dblib driver is chosen).

Version 2.6.1 (Released 26.07.2019)

A minor replace with a few bugfixes and stability enhancements:

Feature: Full french translation added.
Other small bug fixes and stability enhancements.

Version 2.6 (Released 25.07.2019)

A minor replace with a few small options and stability enhancements:

Feature: New forms of ExcessiveCharts: Polar and Spiderweb chart,
Feature: New forms of Google charts: Candlestick and Waterfall chart,
BugFix: Fixed the problem with PHP 7.Three model,
BugFix: Fixed the problem with float and integer empty values with separate connection,
BugFix: Fixed the battle with the Avada theme, Fusion builder and Gutenberg blocks,
BugFix: Fixed the problem with Excel-like tables and Gutenberg,
Other small bug fixes and stability enhancements.

Version 2.5.2 (launched 21.05.2019)

A minor launch with a few enhancements.

Feature: Added Gutenberg block – the plugin is now Gutenberg optimized.
Feature: Added possibility to decide on whether or not you need to hold the tables after deleting the plugin from the Plugins web page (by default the tables can be saved in database after deleting the plugin).
BugFix: Fixed subject with creating Queries that occurred after the final replace.
BugFix: Fixed subject with saving knowledge in database with integer and float empty values.
BugFix: Fixed subject with creating tables from Gravity varieties for the primary time.
Some hardcoded strings for attachment column now will be translated.
Small bug fixes and stability enhancements.

Version 2.5.1 (launched 15.04.2019)

A minor launch with a few enhancements.

Feature: New auto-replace and plugin activation system. Make positive to re-acivate your buy as soon as once more to make it work.
Small bug fixes and stability enhancements.

Version 2.5 (launched 06.03.2019)

A serious launch with a few new options and stability enhancements.

Feature: Number vary slider – now it’s attainable to make use of the quantity vary slider for filtering float and integers columns.
Feature: new “Purple” pores and skin.
Feature: new “Dark” pores and skin.
Feature: Google Stacked Bar chart.
Feature: Possible values in edit modal for the overseas key column – Added checkbox possibility the place it is possible for you to to decide on attainable values for the present person or all attainable values from a overseas key desk.
BugFix: Foreign key for non-server aspect Gravity tables enabled.
BugFix: Fixed subject with making use of font and colour settings within the new pores and skin.
Small bug fixes and stability enhancements.
Compatibility with WordPress 5.1 confirmed.

Please word: If you replace the wpDataTables to model 2.5, please replace the Gravity Forms Integration addon to the most recent model as nicely.

Version 2.4 (launched 12.11.2018)

A serious launch with a few new options and stability enhancements.

Feature: New “Aqua” pores and skin.
Feature: On/Off superior filtering, sorting and modifying possibility within the column checklist.
Feature: New date format Y.m.d in Date format choices.
BugFix: Problem with integers in Scatter plot chart Highcharts resolved.
Small bug fixes and stability enhancements.
Compatibility with WordPress 5.Zero confirmed.

Version 2.3.2 (launched 07.11.2018)

A minor replace with a few options, bug fixes and stability enhancements.

Feature: Support for new date codecs: Y-m-d, Y/m/d, m/Y, M Y, Y
BugFix: Filtering trough URL for the primary column.
Small bug fixes and stability enhancements.

Version 2.3.1 (launched 23.10.2018)

Please word: as of two.Three model, the minimal required PHP model is 5.6!

A minor replace with a few options, bug fixes and stability enhancements.

Feature: New placeholders for CURRENT_USER_FIRST_NAME and CURRENT_USER_LAST_NAME
Feature: French translation.
BugFix: Minimum PHP model test – plugin will present a warning and received’t activate when you’re operating an outdated PHP model.
Small bug fixes and stability enhancements.

Version 2.3 (launched 30.08.2018)

Please word: as of two.Three model, the minimal required PHP model is 5.6!

A serious replace with a brand new characteristic, bug fixes and stability enhancements.

Feature: Separate database connections for MS SQL and PostgreSQL databases, and an possibility so as to add a couple of separate database connection. Now each desk can have its personal separate database connection, so tables can pull knowledge from a number of databases and servers.
Small bug fixes and stability enhancements.

Version 2.2.3 (launched 13.07.2018)

A daily replace with a few new options, bug fixes and stability enhancements.

Front-end modifying for Gravity Forms-based tables (with Gravity Forms integration addon model 1.1);
Server-side processing for Gravity Forms-based tables (now it’s attainable to create tables with massive variety of entities. (with Gravity Forms integration addon model 1.1);
An possibility to decide on CSV delimiter within the Settings web page.
Small bug fixes and stability enhancements.
WordPress 4.9.7 compatibility confirmed.

Version 2.2.2 (launched 04.06.2018)

A daily replace together with some stability enhancements and bugfixes.

Version 2.2.1 (launched 21.05.2018)

A minor stability replace together with some patches for auto-replace characteristic.

Version 2.2 (launched 17.05.2018)

A big replace with a few new options, stability enhancements, and different.

Feature: New placeholders for Conditional Formatting – Last week, This week, Next week, Last 30 Days, This Month, Last Month, Next Month;
Feature: Placeholders works with different desk varieties (JSON, XML, PHP array);
Feature: Option to set desk with out borders;
Feature: Auto-detection of the delimiters for the CSV recordsdata;
Feature: Searching for tables and charts utilizing ID on browse pages;
Feature: Option to vary colour and hover for pagination buttons;
Feature: New forms of ExcessiveCharts: Treemap chart and Treemap stage chart;
Feature: Multiple y axes and completely different sequence varieties on the identical chart, developed for ExcessiveCharts varieties: Line chart, Spline chart, Basic space chart, Basic bar chart and Basic column chart.;
Feature: Search in selectbox and multiselectbox filters;
Feature: More choices for defining the variety of rows within the desk;
Feature: Changed look of the URL hyperlinks in checkbox and selectbox filter- as an alternative entire hyperlink now the content material can be proven;
Fix: refresh of the web page with newly created desk will now not return you to step one of the creation course of;
Fix: Gravity Forms PHP compatibility drawback
Fix: Bootstrap drawback with themes and plugins;
BugFix: drawback with separate connection and selectbox in Powerful filters addon resolved;
BugFix: a number of drawback with filtering and predefined worth resolved;
Other smaller bug fixes;
Stability and safety enhancements;
Compatibility with WordPress 4.9.5 permitted.

Version 2.1 (launched 20.11.2017)

A big replace with a few new options, stability enhancements, and different.

Feature: New Multi-selectbox filter kind;
Feature: checkbox filter when the filter is rendered above the desk can seem in a popup, as an alternative of rendering checkboxes immediately on the web page;
Feature: New settings for URL hyperlink columns – now it’s attainable e.g. to make them show as buttons, configure if the hyperlinks ought to open in a brand new tab, or change the default textual content;
Feature: help for new addon added (Powerful Filters – to be launched on CodeCanyon quickly);
Fix: eliminated “All” when desk shows all the entries, and if in case you have much less entries than chosen displayed size;
Bugfix: Problems with checkbox filters resolved (bizarre show in modal, not remembering the choice in modal);
Bugfix: customized roles for editable tables help;
Stability and safety enhancements.
Compatibility with WordPress 4.9 permitted.

Version 2.0.2 (launched 24.08.2017)

A minor replace principally with stability enhancements.

Feature: Checkbox for together with Bootstrap on the entrance-finish added on the Settings web page – now if there’s a JS battle in Bootstrap recordsdata together with your theme it may be resolved by disabling the checkbox.
Feature: help for new addons added (Gravity Forms integration, Formidable Pro integration) added – addons can be printed quickly on CodeCanyon – keep tuned;
Bugfix: calculation capabilities in a couple of column for server-aspect tables – calculations weren’t working appropriately, now resolved;
Bugfix: editor modal in responsive mode – the editor modal appeared too low within the backside on tablets and mobiles, mounted now;
Bugfix: formulation column on the primary place inflicting the desk to indicate no data – resolved;
Bugfix: Clear Filters button with filters in a type – clear works appropriately now;
Bugfix: Sorting dates in Mozilla Firefox for non-server-aspect tables – sorting works appropriately in all browsers now;
Bugfix: Duplicating the desk the place “Users see and edit solely personal knowledge” characteristic is enabled – now the tables will be duplcated correctly.
Security enhancements.
Compatibility with WordPress 4.8.1 permitted.

Version 2.0.1 (launched 11.07.2017)

A minor launch with a few patches for 2.0:

PHP model compatibility – Fixed deadly errors that had been thrown on PHP variations 5.4 and 5.5;
Fix for reordering formulation columns – causes JS errors in 2.Zero model;
Sorted attainable values – attainable values are actually sorted alphabetically when learn dynamically from the info supply.

Version 2.0 (launched 11.07.2017)

A serious launch with a ‘revamp’ of again-finish and entrance-finish:

New admin/again-finish design and improved UX – the plugin’s design was re-labored from scratch to a extra intuitive, easy and person pleasant interface;
Fix for customized CSS courses – some adjustments in 1.7.1 brought on this characteristic to not work correctly, now mounted;
Table relations – overseas key help – now you possibly can configure any column to work as a overseas key for a unique desk;
New pores and skin and new UI parts – a brand new Material-style pores and skin for tables entrance-finish, new UI parts (datepicker, timepicker, dropdown, modal);
Under-the-hood enhancements – code refactoring, new SQL parser, and much more;
Security and stability enhancements;
Numerous different minor bugfixes;
Compatibility with WP 4.Eight confirmed.

See extra detailed overview of wpDataTables 2.0 in our blogpost

Version 1.7.2 (launched 08.03.2017)

A minor launch with quite a few stability enhancements:

HTML tags in Excel-like tables – this didn’t work correctly in earlier variations, now mounted;
Fix for customized CSS courses – some adjustments in 1.7.1 brought on this characteristic to not work correctly, now mounted;
Timepicker in Excel like tables mounted – a problem appeared in 1.7.1, now mounted;
Google spreadsheet hyperlinks works from publish dialog in addition to tackle bar;
Adding and eradicating columns mounted;
Editing IMG and hyperlink columns (no extra HTML tags in editor);
Add wpDataChart callback for Chart.js;
Conditional formatting works with responsive possibility;
Fixes for the selectbox editor enter kind;
Numerous different minor bugfixes;
Compatibility with WP 4.7.Three confirmed.

Version 1.7.1 (launched 09.01.2017)

A minor replace, introducing 2 new options and plenty of minor fixes and enhancements:

Chart.js – Now wpDataTables plugin has third chart rendering engine. Beside Google Charts and Highcharts we’ve added Chart.js that renders easy and versatile charts with so much customization choices.
Chart live preview – In wpDataTables Chart Wizard now there isn’t a Preview step anymore. Chart adjustments are immediately seen and proven on the chart that’s rendered in the appropriate aspect of the display screen.
Support for NULL/empty values – Now when modifying editable wpDataTable it’s attainable to depart a clean cell for integer and float columns.
Fix for Row Grouping – Row Grouping characteristic was inflicting a JavaScript error in model 1.7.
Edit desk in Excel-like editor when utilizing Separate MySQL connection repair.
Fix for Formula columns – In model 1.7 if a number of the columns contained quantity in column authentic header then formulation column didn’t work.
Fix for Conditional formatting and Responsive mode – When desk was in responsive mode present on cell phone conditional formatting didn’t work.
Fix for Datepicker layering – Datepicker was showing behind edit modal on some themes in earlier variations.
Other minor stability and safety enhancements and bugfixes.
WordPress 4.7 compatibility permitted.

Version 1.7 (launched 23.09.2016)

A serious replace, beginning some new sub-modules, massively bettering present functionalities:

Excel-like desk modifying – Now tables will be proven and edited not solely with DataTables library, but additionally with Handsontable library, which has a pleasant Excel-like interface which helps bulk choice, drag’n’fill, duplicate, bulk delete, handy inline modifying, and many different options. Read more here.
Lots of enhancements for charts – extra formatting and styling choices for each engines, group characteristic. Read extra within the blogpost, test the video part displaying the brand new options.
DateTime and Time column varieties – correct displaying of DateTime and Time (until minutes until now), in addition to modifying, sorting, filtering, and so on. See the blogpost for extra particulars.
Import Google Spreadsheets to WP database with Table Constructor – see the blogpost for extra particulars, or see this video half displaying the characteristic.
Settings on Settings web page divided into tabs. See quick video overview.
Table duplicating for manually created tables now permits duplicating the info supply as nicely. See quick video overview.
Extended multisite help.
Other minor stability enhancements and bugfixes.

See extra data in the full blogpost.

Version 1.6.2 (launched 12.05.2016)

A daily replace, including some functionalities, stability enhancements, and a number of options:

HTML editor for editable tables – now for columns which have string column kind you possibly can edit the info utilizing a HTML WISYWYG editor (TinyMCE), each for editor dialog and for in-line modifying.
Addons help – any more plugin helps addons, every addon brings some distinctive characteristic which extends the core performance. The first addon launched is the Report Builder, which is a instrument for producing individualised Word DOCX and Excel XLSX paperwork in actual-time from WordPress.
Responsive Charts – this was a extremely requested characteristic: now every chart (each Google and Highchart) will be responsive – simply tick the “responsive” checkbox close to the width enter. Responsive chart will occupy 100% width of the container, as an alternative of getting mounted width, subsequently all the time render appropriately on any machine varieties, and if you resize browser window.
Fixes for sum row – Sum row works extra secure now.
Fixes for chart modifying – chosen Google chart kind and the comply with desk filtering possibility didn’t persist appropriately on modifying, now this works superb.
Fixes for conditional formatting for values above 1.000.000 – now conditional formatting works appropriately for any numbers.
Security fixes – extra safety checks added to the plugin again-finish to stop assaults.
More HTML allowed within the editable tables. We restricted allowed HTML for editable tables in 1.6.1 for higher safety towards XSS. Now the checklist of allowed tags was prolonged.
Fix for importing pictures in editable tables. Editing pictures wasn’t all the time working easy, mounted now.
Fix for ‘skip 1000’s separator’ in server-aspect tables. The setting was ignored for tables with server-aspect processing, now it really works appropriately.
WordPress 4.5.2 compatibility confirmed. This website is operating WP 4.5.2 so you possibly can see it really works.
PHP7 compatibility confirmed. After a number of inside exams no conflicts or issues discovered.
Other minor stability enhancements and bugfixes

Version 1.6.1 (launched 23.03.2016)

A big replace, a whole lot of new capabilities. Was purported to be a stability replace, however grown to a big launch. Click here to see a short video overview of the brand new options. Among others:

Inline modifying – you possibly can edit the content material in editable tables immediately from the cells now. Click here to see the docs, or here for video demo.
Conditional formatting – it’s attainable to focus on rows, cells, columns, or change CSS courses. Click here to see the docs, or here for video demo.
Formula (calculated) columns – you possibly can add columns within the desk that can be calculated based mostly on different columns values. Click here to see the docs, or here to see video demo.
Sum (totals) row – you possibly can present totals for numeric columns within the desk footer now. Click here to see the docs, or here to see video demo.
Auto-read attainable values for column – if the desk has server-aspect processing enabled you don’t have to kind in attainable values manually any extra. See video demo.
Realtime auto-refresh for tables and charts – Tables which have server-aspect processing enabled can auto-reload in entrance-finish with outlined interval. See video demo.
No-flash Table Tools, and superior configuration for Table Tools – the export performance is now Flash-independent, works on HTML5, additionally you possibly can outline from the admin panel which buttons to indicate or conceal per every desk. See video demo.
Global search by way of URL. You can add a particular key within the web page URL, and your desk will get pre-filtered on load. Click here to see the docs, or See video demo.
Auto-generate thumbs for picture columns in editable tables. When you add a brand new picture, a thumb with a hyperlink to full image can be inserted robotically.
Skip 1000’s separator for integer columns. If your column is an integer, however you don’t need formatting (e.g. for years or product codes), you possibly can disable it.
Fixed filter rendered in header. It was trying clumsy earlier than if you selected to render the filter in header, now it’s rendered in a separate row.
Non-UTF8 names for columns in Table Constructor. This was inflicting hassle earlier than, however now it’s allowed.
DataTables entrance-finish renderer library upgraded to 1.10.10
PHPExcel up to date to newest model
Lots of stability and UX enhancements and bugfixes

Version 1.6 (launched 23.07.2015)

A serious replace. Numerous completely different adjustments and enhancements. Basically the most important change to wpDataTables since launch. Check this document for extra information on new capabilities.

Version 1.5.6 (launched 13.02.2015)

Just one other patch on an extended strategy to Table Constructor module. No new options, simply bugfixes.

False replace notification mounted – within the earlier model there was a tiny bug that brought on plugin to report that there’s a brand new model out there on a regular basis, additionally to throw a discover within the replace checklist; that is mounted now.
Attachments title not displayed – refactoring within the earlier model brought on an attachments title (uploaded from entrance-finish editor) to not be displayed; that is mounted now.
XML parsing errors – a bug which brought on an issue with XML format parsing is mounted; additionally added a test if XML parts have attributes for appropriate parsing.
Table ID discover in shortcode mounted – in some circumstances when ID was empty it thrown a discover; it’s mounted now.
Front-end editor add/edit row selectbox drawback – entrance-finish editor dialog selectbox was displaying first worth as chosen by default, however really nothing was chosen. Fixed now.
Formatted numbers in vary filters didn’t work. Values extra then 1000, or if person entered the worth in the identical format as in cell brought on the filter to crash. Fixed now.
Column filter selectbox when proven in header didn’t present. Minor subject with CSS mounted, dropdowns will present appropriately now.
Date parsing mounted for CSV. In some circumstances dates weren’t parsed appropriately, works superb now.
New filter added for the desk title (wpdatatables_filter_table_title) – you should use it to vary the title dynamically, or conceal it if you don’t want it
Custom JS was multiply escaped (‘\’). Now it’s mounted.
EU date format sorting subject – when there was an empty cell in a date column with EU-formatted date (dd.mm.yyyy) it crushed sorting; now it’s mounted – empty cells will all the time be handled because the earliest date attainable.
Preview with charts mounted. Now you possibly can preview your charts within the backend together with the desk, which didn’t work in earlier variations.
Even rows colour picker didn’t work. Now it’s mounted and you possibly can select the colour of the even rows.
Font colour picker for desk header didn’t work. mounted now.

Version 1.5.5 (launched 08.12.2014)

Auto updates – we deliberate this for 1.6, however since there have been already a few unplanned releases, we determined to not postpone it any extra to make life simpler for customers. Starting from present model, when you enter your Envato Purchase Code, plugin will let you know when the brand new model is launched, and do the auto replace. To forestall piracy, most variety of downloads of 1 model per buy code is 2. But you possibly can all the time obtain new variations immediately from Envato and set up within the good outdated-usual handbook manner.
File-based tables speedup – for massive tables based mostly on recordsdata you need to have a major enchancment in pace now.

Version 1.5.4 (launched 23.11.2014)

Security patch. A few minor bugfixes additionally included. New on this model:

Uploader safety subject mounted.
Number vary filter subject mounted. There was a problem in model 1.5.Three that broke quantity vary filtering due to quantity formatting, for non server-aspect processing tables. Fixed now.
utf8_general_ci collation added to wpDataTables created tables. Chinese, Japanese, Vietnamese and different UTF-Eight characters in column names shouldn’t be an issue any extra.
“Clear filters” drawback solved. Before when customers clicked on “Clear filters” some dropdown values weren’t refreshed.
Default worth dropdown drawback solved. Previously when you outlined a default worth for a dropdown selectbox it didn’t work, mounted now.
WP 4.0.1 compatibility checked.

For extra information on what’s new and full changelog you possibly can see this page.

Update process: Disable plugin, overwrite with recordsdata from the brand new bundle, allow plugin once more. This is critical because the database construction needs to be up to date on reactivation.

Video tutorials

Overview

wpDataTables 1.6 is a mighty knowledge supervisor in a type of a WordPress plugin. It lets you create dynamic responsive tables, charts in your WordPress website edit and enable your entrance-finish customers to edit knowledge in them. See the video features overview or the text features overview when you’re .

Features

A brief checklist of wpDataTables options:

Cute interactive multi-practical entrance-finish jQuery tables with filtering, sorting and pagination options rendered by DataTables library. You can manipulate all options simply from the WordPress administrator panel.
Server-side processing for MySQL-based mostly tables.
Charts based mostly on Google Chart and Highcharts libraries. Easily render charts from the
similar dataset as your desk. Charts will be up to date in realtime along with the desk, as you filter the info set.
Front-end modifying for MySQL-based mostly tables.
Table constructor which permits to create the tables from again-finish.
MySQL question generator. Builds all of the “SELECT FROM, JOIN, WHERE, GROUP” for you – simply click on the proper buttons!
WordPress DB question generator.
Allows to arrange an editable desk out of your Excel or CSV
Responsive mode for any tables.
Advanced entrance-finish desk options: print view, save to PDF, save to CSV, save to Excel, Copy to clipboard by TableTools extensions.
Row grouping based mostly on RowGrouping extension. If a whole lot of rows have similar values of some column you possibly can group them based mostly on the worth of this column. The sorting can be carried out inside of those teams.
Accepted knowledge sources: PHP serialized arrays, Google Spreadsheets, MySQL queries, MS Excel XLS and XLSX, OpenOffice Calc ODT, CSV recordsdata, JSON objects, XML knowledge supply.
Tweakable columns with completely different column varieties – strings, integers, floats, hyperlinks, dates, pictures.

Video Tutorials on wpDataTables Table Plugin

There’s a video course of round 40 brief tutorials filmed on wpDataTable. Check it out on our site!

Documentation and examples

Check out the documentation and reside examples earlier than you buy on our demo site.

Source