Please wait...

Hi everyone! We hope you had some great time during the winter holidays with your family and friends! Here at TMS-Plugins we were working hard during last couple of months, and now we are proud to introduce you the new 1.7.1 version of our plugin.

Here we’ll go through a brief overview of the new features.

Charts.js support

Till this version wpDataTables was supporting 2 charting engines: Google Charts and Highcharts.  However Google Charts sometimes produce relatively basic output, and HighCharts requires purchasing a separate license to be used. So we introduce one more engine, Charts.js that isn’t perhaps as sophisticated as HighCharts, but also produces a number of quite nice looking diagrams, has a lot of customization options, and of course supports all the features of wpDataTables (such as data grouping, or follow table filtering). Charts.js adds 9 new charts to the wpDataTables charts base, including a Radar and Polar Area charts that we didn’t have before:

Charts.js supported charts

Charts Live Preview

Previously when you were building a chart you had to configure all the chart settings on ‘Formatting’ step, and then preview the result on the next ‘Preview’ step. To improve the user experience we decided to merge these 2 steps so that anything you change would apply immediately, as WYSIWYG is always the best approach in designing different site elements, without the ‘back and forth. Also we grouped the different blocks of chart settings into tabs for easy switching between them:

wpDataTables 1.7.1 Live Preview

Support for empty values

Previously, when working with Integer, or Float columns, whenever you had an empty cell it was automatically converted to zero value. It didn’t always work for all of the tables, as sometimes no value just means no value – and not a zero – so we implemented support for blank values for all kind of tables. Sorting is still working, they are treated as ‘negative infinity’.

Fixes and improvements

There was a number of fixes and improvements we added to this version:

  • Fix for Row grouping – a minor bug from previous version fixed.
  • Excel-like editing with separate MySQL connection – also a minor bug, fixed.
  • Numbers in column names – in previous versions if column names contained numbers it caused problems with using them in formulas, and with some other features. This is fixed now.
  • Conditional formatting with responsive mode – wasn’t always working very smooth, fixed now.
  • Datepicker appearing behind edit modal – there was a problem with datepicker on some themes. Fixed now.
  • Stability and security improvements. We did also a number of minor fixes for issues reported on support, or that we noticed ourselves.

Next stop – 2.0

Our next primary focus is version 2.0 of wpDataTables, that will take all parts – back-end, front-end and the code – to the next level, along with introducing new features. A modern interface for managing tables (no more scrolling), live realtime preview for all changes on the table (no more preview popup), support for foreign keys, and many more… If you didn’t purchase wpDataTables yet – now is the right time, as with 2.0 release the price will raise 🙂


Tags: , ,
  • Víctor M. Cuadrado

    Thanks for upgrading and fixing row grouping. I wish a happy new year to everyone at wpDataTables!

    • wpDataTables

      Thank you very much!

  • Paul

    Thank you! Chart.js is a nice addition… Do you think editing of joined mysql-tables will be a feature of the next version?

    • wpDataTables

      Thank you!

      Yes, not exactly direct support of MySQL inner join/foreign key, but a support for relation between wpDataTables (and e.g. for editing a table which stores references to other tables) will be introduced!

  • hervé

    Well I look at this 🙂
    However, as you talk about version 2.0, will it have examples of native access to buddypress (members, groups, activities …)?
    ETA? Weeks? Month?

    • wpDataTables


      Sorry to disappoint you, but BuddyPress integration isn’t among the task list for the 2.0 version.
      And for the timeline – there’s so much work, so it’s more than a month for sure.

  • martinward

    1.7.1 – Look like some significant bug fixes included but where has “word wrap” gone – doesn’t seem to exist in additional settings anymore?

    • wpDataTables

      Hi, thank you!

      It’s not gone, it was actually always functional only when “Limit table layout” was turned on, so we decided to hide it in case this checkbox isn’t ticked. Can you please check?

      • martinward

        Thanks for identifying where word wrap had gone

  • Mark Rickan

    Any chance that amCharts might be given consideration for the next round of charting support?

    Not only is the range or supported charts extensive, but they rival HighCharts in appearance and the basic license is much more reasonable.

    • wpDataTables

      Hi, thanks for the suggestion, we didn’t yet consider that, but will add to our idea list!

      • Mark Rickan

        Terrific, thanks. I think most users would find it to be a welcome addition.

  • Tom Eagles

    Hi There, first off really liked the Lite version, but really love the premium, I’ve been trying to figure a way round a few things and am not sure if its possible, i had a look at some of the filters (hooks) and maybe it can be done that way, I am building the tables from a json url and that data changes every two minutes, there are 2 columns I need to work out the difference of (unix timestamps) so i need to subtract one from the other then /60 to return the time difference in between them and display that as a new column. I tried using the unix time stamp columns as interger type but that didnt work. And finally and I guess possibly easiest is i have for example a server name and server ip address and want to combine both of those into a single url entry in the row. Are these possible yet using hooks if needed or planned as a future feature?

    • wpDataTables

      Hi, thank you very much for the kind words!

      Unfortunately this kind of functionality isn’t among next-up tasks for us (there are so many use cases – unlike each other – so it is hardly possible to build a universal out-of-the-box solution for all). However we could recommend for your case instead of trying to do this all in wpDataTables hook, rather prepare a standalone PHP script that would read the data from the JSON url and prepare it the way you need. The PHP script could then output data as a serialized array – which can be used as a data source for wpDataTables, even the Lite version.

      Thank you!

  • Séverin

    Hi Alex,
    With 1.7.1 upgrade, I have a serious drawback since all the fields in “single value” edit mode are reseted to the first list value when editing. I tried to downgrade but the problem persists. Any idea on how to solve this as my website is now blocked in order not to loose data.

    • Issac Chua

      Yes, I am having this issue too! The selectbox for single value has reset to the first possible value but not the original value whenever I try to edit it. Can you look into it as well? Thanks!

      • Guy E Bouchard

        Same here

        • Go Sales

          This is really annoying, it limits the usage of this great plugin. Please provide a link with a fix.

  • Nico Teuschler

    Still no sum function in the formula? 🙁
    This would be so good to show the actuall total amounts in the charts…pleasee!!! 🙂