We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #3218043
Date Sorting and by default reads the date as European Format when its not.
Closed

Comments

  • Jay Clark started the conversation
    January 27, 2023 at 7:55pm

    When I import a excel document. The dates come out as European Format when they are not in the Document itself. This is when I clear all formatting in excel and just change the column to be a Date column, with default settings.

    If I change in excel the format to have the Month spelled out it imports correctly. But in doing this the Sort doesn't work on the Front end (Still works on the WP backend).

  •  1,894
    Miloš replied
    January 28, 2023 at 4:47pm

    Hi, Jay

    Thanks for reaching out to us

    -

    If the table works correctly and sorts the data as needed on the back-end,

    but the issue only happens in the front-end, that is quite strange.

    -

    Can you please first check in the back-end plugin's main settings,

    see what is set for the default Date Format,  and make sure that it is set to the correct Format as needed?

    6009649489.png

    If you match the source data Date format coming from the connected Excel Spreadsheet,

    to be the same as this Date setting in the plugin, it should resolve the issue,

    but let me know if the issue persists after that, and we can check this out remotely for you.

    Thank you

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  • Jay Clark replied
    January 31, 2023 at 6:44pm

    Milos,


    Here is what we have for the Date format in the backend

    6026530030.png

    We can not change this due to being an international association to be just numbers. As I have stated in the backend I can sort and in fact its the default sort which works just fine, its just the frontend that sorting dates do not work. All other columns can be sorted. Check it out here. I see no HTML or JS errors when I try. https://heliexpo.com/schedule/



  •  1,894
    Miloš replied
    January 31, 2023 at 7:58pm

    Hi, Jay 

    Thank you, i think i can realise the issue now.

    I do notice that if i try to click to sort in any direction on either Date column, it just does not respond at all, while the other columns do respond to sorting.

    Can i please check out the back-end of this table?

    Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

    We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

    You can write credentials here just check PRIVATE Reply so nobody can see them except us.

    And if i can also take a look at the database, that would be very useful;

    ( It can be URL with credentials for PHPMyAdmin or access to hosting panel);

    also if you can please send me the source Excel file - i can try to replicate this issue on my Test site as well.

    -  For the Excel file, Ticksy won't let you upload it , so you can either wrap it in a zipped folder, or upload to weTransfer and send me a link, please?

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables