Description
wpDataTables is a powerful responsive Tables, Spreadsheets and Charts Data Manager in a form of a WordPress Plugin.
For all our users wondering about the high price, and for all users with expiring support: please reach out to us so we could provide you with detailed answers and information, and suggest currently available solutions and special offers.
If you want to join the testers team just open a support ticket here and we will add you to the list. You will always get the newest features first. Please note that you must be among existing users of wpDataTables.
Some Articles about wpDataTables plugin
- WPKube – wpDataTables Plugin Review: Build Responsive Tables Quickly
- Elegant Themes – Creating Advanced HTML Tables In WordPress Using Plugins
- WPMayor – wpDataTables – a Plugin that Makes Tables in WordPress Easy
- ScratchingInfo – wpDataTables – Best WordPress Responsive Editable Tables Plugin
- WP-magazin.ch – Tabellen in WordPress
- wplift.com – wpDataTables Review: Create Responsive Tables and Charts from a Range of Data Sources
- WPVirtuoso – the 5 Best Free WordPress Table Plugins
User reviews
Plugin listed in WP catalogs
WPLift.com
WPExplorer.com
wpDataTables in social networks
For the people who want to request support: please make sure that you check the FAQ, documentation first. If your question isn’t there feel free to contact our support manager through the support system. We receive a lot of requests nowadays, so we ask you for understanding in case of delayed replies.
MANUAL UPGRADE PROCEDURE (when a new version is released)
- Go to your FTP and open WordPress plugins folder.
- Delete the old wpDataTables version folder.
- Upload the new version of wpDataTables.
- Go to WP-admin panel, open Plugins section.
- Deactivate wpDataTables, and then activate it again.
DO NOT DELETE THE OLD VERSION FROM WP-ADMIN IF YOU DON’T WANT TO DELETE YOUR TABLES
Please note that minimum PHP version required is 5.6
What’s new / Changelog
Version 3.4.3 (Released 22.04.2021)
A minor update with a couple of bug fixes, and stability improvements:
- Improvement: Added warning message on system info when LibXML version is lower than 2.7.7.
- Bugfix: Fixed issue with showing simple editor on Safari browser.
- BugFix: Fixed issue with welcome page on bulk plugin activation.
- BugFix: Fixed issue with button strings in edit modal for different skins.
- BugFix: Fixed issue with strings in loops (conflict with other plugins).
- BugFix: Fixed issue with color-picker visibility in column color option on small screens.
- BugFix: Fixed error message on welcome page.
- BugFix: Fixed issue with showing quotes in charts.
- BugFix: Fixed issue with showing all data in table when placeholders are empty and set as predefined filter value.
- BugFix: Fixed issue with conditional formatting for URL columns.
- BugFix: Fixed issue with saving data in Excel-like table with separate connection.
- BugFix: Fixed issue with translating strings in add-ons.
- BugFix:Fixed issue with showing charts when Follow table filtering option is used.
- Compatibility with WordPress 5.7.1 approved.
- Other small bug fixes and stability improvements.
Version 3.4.2 (Released 10.03.2021)
A minor update with a couple of new features, improvements, and bug fixes:
- Feature: Added code option in TinyMCE editor for editing.
- Feature: Added new date format.
- Improvement: Added auto-save functionality after inserting media in the Simple tables.
- Improvement: Added translate functions on several strings.
- Improvement: Added new hooks for enqueuing scripts in the admin area, filters for elementor widgets, table init data and disable_limit parameter.
- Improvement: Improved error handlers.
- Added German translation
- Bugfix: Fixed issue with vulnerability for server-side tables.
- Bugfix: Fixed issue with vulnerability when option “Users can see and edit own data” is used for tables.
- Bugfix: Fixed issue with the font in material skin and background in graphite skin
- Bugfix: Fixed issue with saving NULL values in the database for empty string columns after save/edit.
- Bugfix: Fixed issue with class name in Global font color settings.
- Bugfix: Fixed issue with charts when option “Follow table filtering” is used.
- Bugfix: Fixed issue with wpDataCharts callbacks.
- Bugfix: Fixed issue with setCellContent in Conditional formatting and Responsive collapse button.
- Bugfix: Fixed notice for Highcharts.
- Bugfix: Fixed issue with duplicating server-side tables.
- Bugfix: Fixed issue with CSS in Columns visibility option for all new skins.
- Bugfix: Fixed issue with rendering some date formats for non-server-side tables.
- Bugfix: Fixed issue with English translation files in Loco translate.
- Bugfix: Fixed issue when users turn off server-side option when table has a large number of rows.
- Bugfix: Fixed issue with Fatal errors if allow_url_fopen is turned off on server.
- Bugfix: Fixed issue with loading simple table preview after clicking on back button in browser from some pages.
- Bugfix: Fixed issue with inserting “px” in column width option.
- Bugfix: Fixed issue with showing CSS code in one line after save on Custom CSS filed in table settings
- Compatibility with WordPress 5.7 approved.
- Other small bug fixes and stability improvements.
Version 3.4.1 (Released 02.02.2021)
A minor update with a couple of bug fixes and stability improvements:
- Bugfix: Fixed issue with Edit buttons disappearing
- Bugfix: Fixed vulnerability issue with order direction for server-side tables
- Bugfix: Fixed issue with position of preloader icon on graphite skin
- Other small bug fixes and stability improvements.
Version 3.4 (Released 01.02.2021)
A major update with a couple of new features, bug fixes and stability improvements:
- Feature: Customize options for each table like language, skin, font, colors, and much more.
- Feature: New option to choose which Edit buttons will be visible on the front-end table (New, Edit, Delete).
- Feature: New option “Make NOFOLLOW link” in the link editor in a simple table and in link columns for data tables
- Feature: New option to set column data to be enabled/disabled in global Search results
- Improvement: Added link for Google Sheet API
- Improvement: Added code highlighter for fields where is used custom code(Custom JS, Custom CSS, SQL editor)
- Improvement: Allowed subqueries inside bracket expressions in PHP SQL parser
- Improvement: Allowed pre tags in HTML editor
- Bugfix: Fixed issue with errors when the table is created over Google Sheet API
- Bugfix: Fixed issue with not rendering charts under the table when Follow table filtering is enabled
- Bugfix: Fixed issue with Fatal error on Dashboard page when PHP DOM and PHP XML are not installed on the server
- Bugfix: Fixed issue with pre-defined values when “Apply and Add New” button is used in edit modal.
- Bugfix: Fixed issue with switching tabs in the backend
- Bugfix: Fixed issue with tooltip when is loaded jQuery UI in the backend
- Bugfix: Fixed issue with not rendering table data with serverside tables
- Bugfix: Fixed issue with searching when Foreign keys are used
- Bugfix: Fixed issue with not showing Show entries selectbox
- Bugfix: Fixed issue with the position of popover edit modals on Mozilla Firefox browser
- Bugfix: Fixed issue with saving page in Divi builder with the simple table shortcode
- Bugfix: Fixed issue with showing search in the selectbox filter when the number of possible values is set to ALL
- Bugfix: Fixed issue with not showing icons in popover edit buttons for Graphite and Lite skin with Avada theme
- Other small bug fixes and stability improvements.
Version 3.3 (Released 22.12.2020)
A major update with a couple of features and bug fixes:
- Feature: Added option to connect Google Spreadsheets tables with Google Spreadsheet API
- Feature: Implemented instant synchronization in wpDataTables after changes in Google sheets.
- Feature: Added option for creating tables from Private Google Spreadsheets.
- Feature: New option to set tables sorting order on browse pages.
- Compatibility with WordPress 5.6 approved.
- Compatibility with PHP 8 approved.
- Other small bug fixes and stability improvements.
Version 3.2 (Released 09.11.2020)
A major update with a couple of new features, bug fixes and stability improvements:
- Feature: Elementor integration – Added Elementor Blocks for tables and charts.
- Feature: A new option to hide the pagination for each table.
- Feature: A new option to set the pagination position for each table (right, center and left).
- Feature: A new option to set the pagination layout for each table (Six different layouts).
- Improvement: Reduced the number of AJAX calls triggered for the ‘input’ filter.
- BugFix: Fixed the issue with options resetting for the ‘remove borders’ option.
- BugFix: Fixed the issue with showing the tables in the Internet Explorer browser..
- BugFix: Removed the wpdt-c class from the admin area on the admin pages not related to wpDataTables.
- BugFix: Corrected the folder name for Slovenian language.
- BugFix: Fixed the cards height in the manual constructor after the import, in case there are date columns.
- BugFix: Fixed the notice in the column settings for the Conditional formatting with the color setter.
- BugFix: Fixed the issue with hiding the plugins’ message modals in admin area.
- BugFix: Fixed the issue with the predefined filters and the pre-filter URL for the input filter.
- BugFix: Fixed the issue for Simple tables on the servers that use MyISAM engine.
- Other small bug fixes and stability improvements.
Version 3.1.1 (Released 16.10.2020)
A minor stability update including some patches for the PHP version issue.
Version 3.1 (Released 14.10.2020)
A major update with a new table type, and a couple of bug fixes and stability improvements:
- Feature: New table type – Create a simple table with any data, merged cells, styling, star rating, and a lot more.
- Feature: Added Slovenian translation.
- Improvement: Updated the French translation.
- Improvement: Added a new color picker.
- Fixed the issue with multiple Excel-like tables on the front-end.
- Fixed the issue with the minus sign in the number inputs.
- Other small bug fixes and stability improvements.
Version 3.0.4 (Released 08.09.2020)
A minor stability update including some patches for creating tables.
Version 3.0.3 (Released 12.08.2020)
A regular update including some stability improvements and bugfixes.
- Fixed the issue with the slow backend.
- Fixed the issue with the checkbox labels in modal.
- Fixed the issue with the filters and “clear” button in Firefox.
- Fixed the issue with the preloader after saving global plugin settings.
- Fixed the ”$ is not a function in columnFilter.js” error.
- Fixed the issue with the selected value in select-box, after clicking on the “clear” button.
- Fixed the issue with custom settings of decimal and thousand separators on page with function Highcharts.setOptions.
- Fixed the issue with CURRENT_POST_ID placeholder.
- Fixed the issue with creating Formidable and Gravity tables.
Version 3.0.2 (Released 11.08.2020)
A minor stability update including some patches for compatibility with WordPress version 5.5.
Version 3.0.1 (Released 30.06.2020)
A minor stability update including some patches for showing charts.
Version 3.0 (Released 29.06.2020)
A major update with refreshed back-end, couple of new options and several bug fixes and stability improvements.
- Design: New fresh admin UI.
- New page: New Dashboard page with lots of useful information and guides.
- New page: New detailed System Info page which simplifies resolving external conflicts.
- Feature: New Popup First-launch Guide with feature explanations for new users.
- Feature: New options like Feature suggestion, Subscription and lot more.
- Feature: Added new hook to filter URL of PHP array tables (wpdatatables_filter_url_php_array($url, $tableID)).
- Bugfix: Fixed issue with creating tables from Google spreadsheet.
- Bugfix: Fixed pagination layout for the new skins.
- Bugfix: Fixed JS error that appeared when connection in table wizard was changed on dropdown change on connection in table wizard.
- Bugfix: Fixed issue with removing All SQL columns and All post properties field when tables are removed from Selected SQL tables or Selected post types.
- Bugfix: Fixed issue with Excel like editing and separate connection.
- Bugfix: Fixed issue with not showing details in tab for separate connection.
- Bugfix: Fixed issue with customJS field with HTML entities.
- Bugfix: Fixed issue with predefined edit value for multiselect.
- Bugfix: Fixed issue with loading Report Builder edit modal and download button.
- Bugfix: Fixed conflict with checkbox modal and regular checkbox in filters.
- Bugfix: Fixed issue with inline editing date column and two ajax calls.
- Bugfix: Fixed issue with masterdetail column type.
- Bugfix: Fixed issue with current post id placeholder.
- Bugfix: Fixed issue with showing decimals in charts tooltip.
- Bugfix: Fixed issue with Gutenberg hooks.
- Bugfix: Fixed issue with sum shortcodes and server-side tables.
- Compatibility with WordPress 5.4.2 confirmed.
- Other small bug fixes and stability improvements.
Version 2.8.3 (Released 26.03.2020)
A regular update including some stability improvements and bugfixes.
- BugFix: Fixed an issue with showing multiple tables on the page.
- BugFix: Fixed editing and deleting rows in the case when there’re several editable tables on the same page.
- BugFix: Fixed showing rows after Next and Prev in edit modal.
- BugFix: Fixed number range slider in the SQL-based tables that contain placeholders.
- BugFix: Fixed sorting for SQL-based tables using the foreign key feature that contain placeholders.
Version 2.8.2 (Released 19.03.2020)
A minor update with several new features, bug fixes and stability improvements:
- Feature: Added CURRENT_USER_EMAIL placeholder.
- Feature: Added support for iframe (HTML tag) in the table cells.
- Feature: Added a hook for dynamic placehodlers update.
- Feature: New Russian translation.
- Feature: Updated Franch translation.
- BugFix: Fixed issues with license deactivation in the main plugin, and in all add-ons.
- BugFix: Minor security fixes for server side tables.
- BugFix: Fixed the issue with duplicating Gravity tables where the server side processing is enabled.
- BugFix: Fixed the issue with showing/hiding Editing views.
- BugFix: Fixed issue with the CURRENT_USER_LOGIN placeholder.
- BugFix: Fixed PHP notices for the tables created with Gravity forms.
- Other small bug fixes and stability improvements.
NOTE: New versions of all add-ons require the latest version of wpdatatables (version 2.8.2)!
Version 2.8.1 (Released 19.12.2019)
A minor update with a couple of small bugfixes:
- BugFix: Fixed issue with sum, min and max column for non-server side tables.
- BugFix: Fixed conflict with WooCommerce product page and Gutenberg.
- BugFix: Fixed warnings for PHPSpreadsheet lib.
- Resolved minor security issues.
- Other small bug fixes and stability improvements.
Version 2.8 (Released 28.11.2019)
A major update with one new addon, and a couple of bug fixes and stability improvements:
- New addon “Master-Detail Tables” available. The Master-Details Tables addon for wpDataTables allows showing additional details for a specific row in a popup or a separate page or post./li>
- BugFix: Plugin and all addons are now compatible with jQuery 3.x.
- BugFix: Fixed issue with chart JS Linechart handling negative values.
- BugFix: Fixed PHP notice for update of plugin and all addons.
- Compatibility with WordPress 5.3 confirmed.
- Other small bug fixes and stability improvements.
Version 2.7.2 (Released 04.10.2019)
A minor update with one feature and a couple of bug fixes:
- Feature: Advanced HTML Editor – Added new options: Underline, Strikethrough, Subscript, Supscript, Bullet and Numbered List, Blockquote, Horizontal line, Fullscreen, Insert/Edit link, Remove link, Insert/Edit image, Text color, Text background color and Clear formatting.
- BugFix: Fixed issue with showing checkbox modal.
- BugFix: Fixed notice for option showAllRows.
- BugFix: Fixed calculation functions SUM, AVG, MIN and MAX for tables created with Postgre SQL connection.
Version 2.7.1 (Released 26.09.2019)
A minor update with one bug fix and updated library:
- BugFix: Fixed issue with auto-update.
- Updated DataTables library to 1.10.19 version
Version 2.7 (Released 25.09.2019)
A major update with a couple of new features, bug fixes and stability improvements:
- Feature: Added option for showing the table with data of all users on back-end when ‘User can see and edit only their own data’ option is enabled.
- Feature: New date formats.
- Feature: New placeholders for SQL query (CURRENT_DATE, CURRENT_DATE_TIME, and CURRENT_TIME).
- Feature: Enabled placeholders for edit and filtering of manual tables and for filtering of other table types (please note that these placeholders are not enabled for tables created with Gravity and Formidable form integration addons).
- Feature: Added Dropdown for choosing SQL driver in separate SQL connection.
- BugFix: Fixed issue with filtering and functions with separate database connection.
- BugFix: Fixed issue with Number range slider in tables created from separate database connection.
Please note: If you have used MSSQL separate connection before this update you will have to select the driver that is installed on your server (by default dblib driver is selected).
Version 2.6.1 (Released 26.07.2019)
A minor update with a couple of bugfixes and stability improvements:
- Feature: Full french translation added.
- Other small bug fixes and stability improvements.
Version 2.6 (Released 25.07.2019)
A minor update with a couple of small features and stability improvements:
- Feature: New types of HighCharts: Polar and Spiderweb chart,
- Feature: New types of Google charts: Candlestick and Waterfall chart,
- BugFix: Fixed the issue with PHP 7.3 version,
- BugFix: Fixed the issue with float and integer empty values with separate connection,
- BugFix: Fixed the conflict with the Avada theme, Fusion builder and Gutenberg blocks,
- BugFix: Fixed the issue with Excel-like tables and Gutenberg,
- Other small bug fixes and stability improvements.
Version 2.5.2 (released 21.05.2019)
A minor release with a couple of improvements.
- Feature: Added Gutenberg block – the plugin is now Gutenberg optimized.
- Feature: Added option to choose whether you want to keep the tables after deleting the plugin from the Plugins page (by default the tables will be saved in database after deleting the plugin).
- BugFix: Fixed issue with creating Queries that occurred after the last update.
- BugFix: Fixed issue with saving data in database with integer and float empty values.
- BugFix: Fixed issue with creating tables from Gravity forms for the first time.
- Some hardcoded strings for attachment column now can be translated.
- Small bug fixes and stability improvements.
Version 2.5.1 (released 15.04.2019)
A minor release with a couple of improvements.
- Feature: New auto-update and plugin activation system. Make sure to re-acivate your purchase once again to make it work.
- Small bug fixes and stability improvements.
Version 2.5 (released 06.03.2019)
A major release with a couple of new features and stability improvements.
- Feature: Number range slider – now it is possible to use the number range slider for filtering float and integers columns.
- Feature: new “Purple” skin.
- Feature: new “Dark” skin.
- Feature: Google Stacked Bar chart.
- Feature: Possible values in edit modal for the foreign key column – Added checkbox option where you will be able to choose possible values for the current user or all possible values from a foreign key table.
- BugFix: Foreign key for non-server side Gravity tables enabled.
- BugFix: Fixed issue with applying font and color settings in the new skin.
- Small bug fixes and stability improvements.
- Compatibility with WordPress 5.1 confirmed.
Please note: If you update the wpDataTables to version 2.5, please update the Gravity Forms Integration addon to the latest version as well.
Version 2.4 (released 12.11.2018)
A major release with a couple of new features and stability improvements.
- Feature: New “Aqua” skin.
- Feature: On/Off advanced filtering, sorting and editing option in the column list.
- Feature: New date format Y.m.d in Date format options.
- BugFix: Problem with integers in Scatter plot chart Highcharts resolved.
- Small bug fixes and stability improvements.
- Compatibility with WordPress 5.0 confirmed.
Version 2.3.2 (released 07.11.2018)
A minor update with a couple of features, bug fixes and stability improvements.
- Feature: Support for new date formats: Y-m-d, Y/m/d, m/Y, M Y, Y
- BugFix: Filtering trough URL for the first column.
- Small bug fixes and stability improvements.
Version 2.3.1 (released 23.10.2018)
Please note: as of 2.3 version, the minimum required PHP version is 5.6!
A minor update with a couple of features, bug fixes and stability improvements.
- Feature: New placeholders for CURRENT_USER_FIRST_NAME and CURRENT_USER_LAST_NAME
- Feature: French translation.
- BugFix: Minimum PHP version check – plugin will show a warning and won’t activate if you’re running an outdated PHP version.
- Small bug fixes and stability improvements.
Version 2.3 (released 30.08.2018)
Please note: as of 2.3 version, the minimum required PHP version is 5.6!
A major update with a new feature, bug fixes and stability improvements.
- Feature: Separate database connections for MS SQL and PostgreSQL databases, and an option to add more than one separate database connection. Now every table can have its own separate database connection, so tables can pull data from multiple databases and servers.
- Small bug fixes and stability improvements.
Version 2.2.3 (released 13.07.2018)
A regular update with a couple of new features, bug fixes and stability improvements.
- Front-end editing for Gravity Forms-based tables (with Gravity Forms integration addon version 1.1);
- Server-side processing for Gravity Forms-based tables (now it is possible to create tables with large number of entities. (with Gravity Forms integration addon version 1.1);
- An option to choose CSV delimiter in the Settings page.
- Small bug fixes and stability improvements.
- WordPress 4.9.7 compatibility confirmed.
Version 2.2.2 (released 04.06.2018)
A regular update including some stability improvements and bugfixes.
Version 2.2.1 (released 21.05.2018)
A minor stability update including some patches for auto-update feature.
Version 2.2 (released 17.05.2018)
A significant update with a couple of new features, stability improvements, and other.
- 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 other table types (JSON, XML, PHP array);
- Feature: Option to set table without borders;
- Feature: Auto-detection of the delimiters for the CSV files;
- Feature: Searching for tables and charts using ID on browse pages;
- Feature: Option to change color and hover for pagination buttons;
- Feature: New types of HighCharts: Treemap chart and Treemap level chart;
- Feature: Multiple y axes and different series types on the same chart, developed for HighCharts types: Line chart, Spline chart, Basic area chart, Basic bar chart and Basic column chart.;
- Feature: Search in selectbox and multiselectbox filters;
- Feature: More options for defining the number of rows in the table;
- Feature: Changed appearance of the URL links in checkbox and selectbox filter- instead whole link now the content will be shown;
- Fix: refresh of the page with newly created table will no longer return you to the first step of the creation process;
- Fix: Gravity Forms PHP compatibility problem
- Fix: Bootstrap problem with themes and plugins;
- BugFix: problem with separate connection and selectbox in Powerful filters addon resolved;
- BugFix: multiple problem with filtering and predefined value resolved;
- Other smaller bug fixes;
- Stability and security improvements;
- Compatibility with WordPress 4.9.5 approved.
Version 2.1 (released 20.11.2017)
A significant update with a couple of new features, stability improvements, and other.
- Feature: New Multi-selectbox filter type;
- Feature: checkbox filter when the filter is rendered above the table can appear in a popup, instead of rendering checkboxes directly on the page;
- Feature: New settings for URL link columns – now it is possible e.g. to make them display as buttons, configure if the links should open in a new tab, or change the default text;
- Feature: support for new addon added (Powerful Filters – to be released on CodeCanyon soon);
- Fix: removed “All” when table displays all of the entries, and if you have less entries than selected displayed length;
- Bugfix: Problems with checkbox filters resolved (weird display in modal, not remembering the selection in modal);
- Bugfix: custom roles for editable tables support;
- Stability and security improvements.
- Compatibility with WordPress 4.9 approved.
Version 2.0.2 (released 24.08.2017)
A minor update mostly with stability improvements.
- Feature: Checkbox for including Bootstrap on the front-end added on the Settings page – now if there is a JS conflict in Bootstrap files with your theme it can be resolved by disabling the checkbox.
- Feature: support for new addons added (Gravity Forms integration, Formidable Pro integration) added – addons will be published soon on CodeCanyon – stay tuned;
- Bugfix: calculation functions in more than one column for server-side tables – calculations weren’t working correctly, now resolved;
- Bugfix: editor modal in responsive mode – the editor modal appeared too low in the bottom on tablets and mobiles, fixed now;
- Bugfix: formula column on the first position causing the table to show no records – resolved;
- Bugfix: Clear Filters button with filters in a form – clear works correctly now;
- Bugfix: Sorting dates in Mozilla Firefox for non-server-side tables – sorting works correctly in all browsers now;
- Bugfix: Duplicating the table where “Users see and edit only own data” feature is enabled – now the tables can be duplcated properly.
- Security improvements.
- Compatibility with WordPress 4.8.1 approved.
Version 2.0.1 (released 11.07.2017)
A minor release with a couple of patches for 2.0:
- PHP version compatibility – Fixed fatal errors that were thrown on PHP versions 5.4 and 5.5;
- Fix for reordering formula columns – causes JS errors in 2.0 version;
- Sorted possible values – possible values are now sorted alphabetically when read dynamically from the data source.
Version 2.0 (released 11.07.2017)
A major release with a ‘revamp’ of back-end and front-end:
- New admin/back-end design and improved UX – the plugin’s design was re-worked from scratch to a more intuitive, smooth and user friendly interface;
- Fix for custom CSS classes – some changes in 1.7.1 caused this feature not to work properly, now fixed;
- Table relations – foreign key support – now you can configure any column to work as a foreign key for a different table;
- New skin and new UI elements – a new Material-style skin for tables front-end, new UI elements (datepicker, timepicker, dropdown, modal);
- Under-the-hood improvements – code refactoring, new SQL parser, and a lot more;
- Security and stability improvements;
- A number of other minor bugfixes;
- Compatibility with WP 4.8 confirmed.
See more detailed overview of wpDataTables 2.0 in our blogpost
Version 1.7.2 (released 08.03.2017)
A minor release with numerous stability improvements:
- HTML tags in Excel-like tables – this didn’t work properly in previous versions, now fixed;
- Fix for custom CSS classes – some changes in 1.7.1 caused this feature not to work properly, now fixed;
- Timepicker in Excel like tables fixed – an issue appeared in 1.7.1, now fixed;
- Google spreadsheet links works from publish dialog as well as address bar;
- Adding and removing columns fixed;
- Editing IMG and link columns (no more HTML tags in editor);
- Add wpDataChart callback for Chart.js;
- Conditional formatting works with responsive option;
- Fixes for the selectbox editor input type;
- A number of other minor bugfixes;
- Compatibility with WP 4.7.3 confirmed.
Version 1.7.1 (released 09.01.2017)
A minor update, introducing 2 new features and a number of minor fixes and improvements:
- Chart.js – Now wpDataTables plugin has third chart rendering engine. Beside Google Charts and Highcharts we have added Chart.js that renders simple and flexible charts with a lot customization options.
- Chart live preview – In wpDataTables Chart Wizard now there is no Preview step anymore. Chart changes are instantly visible and shown on the chart that is rendered in the right side of the screen.
- Support for NULL/empty values – Now when editing editable wpDataTable it is possible to leave a blank cell for integer and float columns.
- Fix for Row Grouping – Row Grouping feature was causing a JavaScript error in version 1.7.
- Edit table in Excel-like editor when using Separate MySQL connection fix.
- Fix for Formula columns – In version 1.7 if some of the columns contained number in column original header then formula column didn’t work.
- Fix for Conditional formatting and Responsive mode – When table was in responsive mode show on mobile phone conditional formatting didn’t work.
- Fix for Datepicker layering – Datepicker was appearing behind edit modal on some themes in previous versions.
- Other minor stability and security improvements and bugfixes.
- WordPress 4.7 compatibility approved.
Version 1.7 (released 23.09.2016)
A major update, starting some new sub-modules, massively improving existing functionalities:
- Excel-like table editing – Now tables can be shown and edited not only with DataTables library, but also with Handsontable library, which has a nice Excel-like interface which supports bulk selection, drag’n’fill, duplicate, bulk delete, convenient inline editing, and many other features. Read more here.
- Lots of improvements for charts – more formatting and styling options for both engines, group feature. Read more in the blogpost, check the video part showing the new features.
- DateTime and Time column types – proper displaying of DateTime and Time (till minutes till now), as well as editing, sorting, filtering, etc. See the blogpost for more details.
- Import Google Spreadsheets to WP database with Table Constructor – see the blogpost for more details, or see this video part showing the feature.
- Settings on Settings page divided into tabs. See quick video overview.
- Table duplicating for manually created tables now allows duplicating the data source as well. See quick video overview.
- Extended multisite support.
- Other minor stability improvements and bugfixes.
See more information in the full blogpost.
Version 1.6.2 (released 12.05.2016)
A regular update, adding some functionalities, stability improvements, and several features:
- HTML editor for editable tables – now for columns which have string column type you can edit the data using a HTML WISYWYG editor (TinyMCE), both for editor dialog and for in-line editing.
- Addons support – from now on plugin supports addons, each addon brings some unique feature which extends the core functionality. The first addon launched is the Report Builder, which is a tool for generating individualised Word DOCX and Excel XLSX documents in real-time from WordPress.
- Responsive Charts – this was a highly requested feature: now each chart (both Google and Highchart) can be responsive – just tick the “responsive” checkbox near the width input. Responsive chart will occupy 100% width of the container, instead of having fixed width, therefore always render correctly on any device types, and when you resize browser window.
- Fixes for sum row – Sum row works more stable now.
- Fixes for chart editing – selected Google chart type and the follow table filtering option didn’t persist correctly on editing, now this works fine.
- Fixes for conditional formatting for values above 1.000.000 – now conditional formatting works correctly for any numbers.
- Security fixes – more security checks added to the plugin back-end to prevent attacks.
- More HTML allowed in the editable tables. We restricted allowed HTML for editable tables in 1.6.1 for better protection against XSS. Now the list of allowed tags was extended.
- Fix for uploading images in editable tables. Editing images wasn’t always working smooth, fixed now.
- Fix for ‘skip thousands separator’ in server-side tables. The setting was ignored for tables with server-side processing, now it works correctly.
- WordPress 4.5.2 compatibility confirmed. This site is running WP 4.5.2 so you can see it works.
- PHP7 compatibility confirmed. After multiple internal tests no conflicts or problems found.
- Other minor stability improvements and bugfixes
Version 1.6.1 (released 23.03.2016)
A large update, a lot of new functions. Was supposed to be a stability update, but grown to a large release. Click here to see a brief video overview of the new features. Among others:
- Inline editing – you can edit the content in editable tables directly from the cells now. Click here to see the docs, or here for video demo.
- Conditional formatting – it is possible to highlight rows, cells, columns, or change CSS classes. Click here to see the docs, or here for video demo.
- Formula (calculated) columns – you can add columns in the table that will be calculated based on other columns values. Click here to see the docs, or here to see video demo.
- Sum (totals) row – you can show totals for numeric columns in the table footer now. Click here to see the docs, or here to see video demo.
- Auto-read possible values for column – if the table has server-side processing enabled you don’t need to type in possible values manually any more. See video demo.
- Realtime auto-refresh for tables and charts – Tables which have server-side processing enabled can auto-reload in front-end with defined interval. See video demo.
- No-flash Table Tools, and advanced configuration for Table Tools – the export functionality is now Flash-independent, works on HTML5, also you can define from the admin panel which buttons to show or hide per each table. See video demo.
- Global search via URL. You can add a special key in the page URL, and your table will get pre-filtered on load. Click here to see the docs, or See video demo.
- Auto-generate thumbs for image columns in editable tables. When you upload a new image, a thumb with a link to full picture will be inserted automatically.
- Skip thousands separator for integer columns. If your column is an integer, but you don’t want formatting (e.g. for years or product codes), you can disable it.
- Fixed filter rendered in header. It was looking clumsy before when you chose to render the filter in header, now it is rendered in a separate row.
- Non-UTF8 names for columns in Table Constructor. This was causing trouble before, but now it’s allowed.
- DataTables front-end renderer library upgraded to 1.10.10
- PHPExcel updated to latest version
- Lots of stability and UX improvements and bugfixes
Version 1.6 (released 23.07.2015)
A major update. A lot of different changes and improvements. Basically the biggest change to wpDataTables since launch. Check this document for more info on new functions.
Version 1.5.6 (released 13.02.2015)
Just another patch on a long way to Table Constructor module. No new features, just bugfixes.
- False update notification fixed – in the previous version there was a tiny bug that caused plugin to report that there’s a new version available all the time, also to throw a notice in the update list; this is fixed now.
- Attachments title not displayed – refactoring in the previous version caused an attachments title (uploaded from front-end editor) not to be displayed; this is fixed now.
- XML parsing errors – a bug which caused a problem with XML format parsing is fixed; also added a check if XML elements have attributes for correct parsing.
- Table ID notice in shortcode fixed – in some cases when ID was empty it thrown a notice; it is fixed now.
- Front-end editor add/edit row selectbox problem – front-end editor dialog selectbox was showing first value as selected by default, but actually nothing was selected. Fixed now.
- Formatted numbers in range filters did not work. Values more then 1000, or if user entered the value in the same format as in cell caused the filter to crash. Fixed now.
- Column filter selectbox when shown in header did not show. Minor issue with CSS fixed, dropdowns will show correctly now.
- Date parsing fixed for CSV. In some cases dates weren’t parsed correctly, works fine now.
- New filter added for the table title (wpdatatables_filter_table_title) – you can use it to change the title dynamically, or hide it when you don’t need it
- Custom JS was multiply escaped (‘\\’). Now it’s fixed.
- EU date format sorting issue – when there was an empty cell in a date column with EU-formatted date (dd.mm.yyyy) it crushed sorting; now it’s fixed – empty cells will always be treated as the earliest date possible.
- Preview with charts fixed. Now you can preview your charts in the backend along with the table, which didn’t work in earlier versions.
- Even rows color picker didn’t work. Now it’s fixed and you can choose the color of the even rows.
- Font color picker for table header didn’t work. fixed now.
Version 1.5.5 (released 08.12.2014)
- Auto updates – we planned this for 1.6, but since there were already a couple of unplanned releases, we decided not to postpone it any more to make life easier for users. Starting from current version, if you enter your Envato Purchase Code, plugin will tell you when the new version is released, and do the auto update. To prevent piracy, maximum number of downloads of one version per purchase code is 2. But you can always download new versions directly from Envato and install in the good old-fashioned manual way.
- File-based tables speedup – for large tables based on files you should have a significant improvement in speed now.
Version 1.5.4 (released 23.11.2014)
Security patch. A couple of minor bugfixes also included. New in this version:
- Uploader security issue fixed.
- Number range filter issue fixed. There was an issue in version 1.5.3 that broke number range filtering because of number formatting, for non server-side processing tables. Fixed now.
- utf8_general_ci collation added to wpDataTables created tables. Chinese, Japanese, Vietnamese and other UTF-8 characters in column names shouldn’t be a problem any more.
- “Clear filters” problem solved. Before when users clicked on “Clear filters” some dropdown values weren’t refreshed.
- Default value dropdown problem solved. Previously if you defined a default value for a dropdown selectbox it didn’t work, fixed now.
- WP 4.0.1 compatibility checked.
For more info on what’s new and complete changelog you can see this page.
Update procedure: Disable plugin, overwrite with files from the new package, enable plugin again. This is necessary since the database structure has to be updated on reactivation.
Video tutorials
- Installing and updating wpDataTables
- Creating a table from Excel with wpDataTables
- Creating a table in WordPress from MySQL with wpDataTables
- Creating an editable table in WordPress
Overview
wpDataTables 1.6 is a mighty data manager in a form of a WordPress plugin. It helps you to create dynamic responsive tables, charts in your WordPress site edit and allow your front-end users to edit data in them. See the video features overview or the text features overview if you’re interested.
Features
A short list of wpDataTables features:
- Cute interactive multi-functional front-end jQuery tables with filtering, sorting and pagination features rendered by DataTables library. You can manipulate all features easily from the WordPress administrator panel.
- Server-side processing for MySQL-based tables.
- Charts based on Google Chart and Highcharts libraries. Easily render charts from the
same dataset as your table. Charts can be updated in realtime together with the table, as you filter the data set. - Front-end editing for MySQL-based tables.
- Table constructor which allows to create the tables from back-end.
- MySQL query generator. Builds all the “SELECT FROM, JOIN, WHERE, GROUP” for you – just click the correct buttons!
- WordPress DB query generator.
- Allows to prepare an editable table out of your Excel or CSV
- Responsive mode for any tables.
- Advanced front-end table features: print view, save to PDF, save to CSV, save to Excel, Copy to clipboard by TableTools extensions.
- Row grouping based on RowGrouping extension. If a lot of rows have same values of some column you can group them based on the value of this column. The sorting will be performed inside of these groups.
- Accepted data sources: PHP serialized arrays, Google Spreadsheets, MySQL queries, MS Excel XLS and XLSX, OpenOffice Calc ODT, CSV files, JSON objects, XML data source.
- Tweakable columns with different column types – strings, integers, floats, links, dates, images.
Video Tutorials on wpDataTables Table Plugin
There’s a video course of around 40 short tutorials filmed on wpDataTable. Check it out on our site!
Documentation and examples
Check out the documentation and live examples before you purchase on our demo site.
Source
Reviews
There are no reviews yet.