Support » Plugin: wpDataTables - Tables & Table Charts » Date limitations limit use of this plugin

  • Date parsing is a mess, it doesn’t respect your choice. No matter what option I choose, wpDataTables has decided 15-07-05 is July 5th, 2015. Even if choose d-m-y, it still says it’s July 5th, 2015 instead of the correct July 15th, 2005.

    And for some reason the author decided that date output settings should be universal, so you can’t have one chart with a date column as January 2019 and another chart that has dates including dates. I want to have monthly averages but also have charts with info by the date. Yes, this basic use case is unsupported, why? I don’t know, the author didn’t answer.

    Just try and have a discussion with the author and wait for cryptic excuses and not addressing the actual problems at hand. There tons of unclear aspects of free vs paid and the author barely helps distinguish this, or says its unnecessary. For example, the free version does not support dual y axis charts but the author says that the user should read the documentation of the different chart APIs to find this out and doesn’t feel spelling that out is necessary. His loss.

Viewing 1 replies (of 1 total)
  • Plugin Author wpDataTables

    (@wpdatatables)

    Hi there, thank you for your honest opinion.

    We’ve tried to answer all of your support questions as detailed as we could, highlighting all the limitations and features of the plugin, and dates and date formats in particular, but we are happy to cover it once again if necessary.

    Like mentioned in the ticket you submitted, you have been creating a table from an existing data source (Excel file). If your Excel file has dd-mm-yy format, and wpDataTables’ date format is set to F j, Y (July 15, 2005), all the dates from the source file may be read wrong due to the difference between formats. You would need to either change the date format in your Excel file, or when the table is generated in wpDataTables – open the date column settings, and apply the format used in your Excel file. This doesn’t mean the plugin will be displaying that format in the table, but it will show the correct date in it.

    Here’s an example:

    1. Excel file has dd-mm-yy (15-07-05)
    2. wpDataTables’ date format is set to F j, Y (July 15, 2005)
    3. You create a table linked to the Excel file, and the table shows a wrong date (in your case July 5, 2015).
    4. Open the date column settings, go to Data, and change the date format to match your Excel file (dd-mm-yy).
    5. wpDataTables now shows July 15, 2005.

    So, again, it will show what default date format is in main settings of wpDataTables, but you can tweak the column so it displays the correct date.

    At the moment, there is unfortunately no way of having two different date formats in two different tables, that is true. So, one default date format applies to all tables. It is planned to have the font, date, skin, and other similar settings applied to each table individually, but at the moment that is not possible.

    When you open the description here, on wordpress.org you can see the limitations of the free version:

    1. MySQL-query based tables support is not included.
    2. Creating tables from the Google Spreadsheet files is not included.
    3. Create a table manually is not included.
    4. Server-side processing is not included.
    5. Responsive mode for the tables is not included.
    6. Table filters are not included.
    7. Front-end table editing is not included.
    8. Excel-like editing is not included.
    9. Advanced Google Charts (except for Line, Column and Pie), HighCharts and Chart.js are not included
    10. Table Constructor Wizard (step-by-step table generator) is not included.
    11. Access to our premium support system is not included.

    So, in here you can also see that only Line, Column and Pie charts are available, with no access to advanced charts in Lite version of the plugin. We mentioned that wpDataTables is using free charts libraries, and not all that you can see in their API is available out-of-the-box with wpDataTables. What you see is the default behavior of charts engine, but if you need some custom solution you can check in our documentation about wpDataCharts callbacks.

    We are truly sorry that you were not satisfied with the plugin, we value the feedback and will use it to continue improving wpDataTables.

    Kind regards.

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this review.