• Resolved caswi

    (@caswi)


    Hello,
    I use “tablepress 0.9-RC” and “DataTables Sorting plugins Extension 1.0” but the sorting of European dates fails. Here is my example table:
    Datum,Uhrzeit,Bemerkung
    02.12.2012,14:07,Wert 1
    05.03.2012,07:05,Wert 2
    12.02.2013,12:00,Wert 3
    25.01.2013,22:45,Wert 4

    If I sort column “Datum” the result is
    Datum Uhrzeit Bemerkung
    02.12.2012 14:07 Wert 1
    05.03.2012 07:05 Wert 2
    12.02.2013 12:00 Wert 3
    25.01.2013 22:45 Wert 4

    What’s going wrong?

    https://www.ads-software.com/extend/plugins/tablepress/

Viewing 8 replies - 16 through 23 (of 23 total)
  • Hi Tobias,
    i’ve got the same issue. I’ve installed the plugin and follow your instruction.
    Not working….

    https://s490444215.onlinehome.fr/chamoniarde/?page_id=136

    Thanks for your help
    Sophie

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi Sophie,

    thanks for your post, and sorry for the trouble.

    Have you added the “Custom Commands” that are mentioned above?

    Also, there seems to be one cell that does not have a date but is empty. That’s not possible, if I remember correctly, so that you’ll have to add a date there.

    Regards,
    Tobias

    Thanks Tobias. I added the custom commands and i deleted the cell.

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    ok, just for testing, can you turn off all the Extensions on this table? It might be possible that one of them is interfering with the added “Custom Command”.

    Regards,
    Tobias

    Thanks for your answer. I’ve turned off all the extensions. Same result.

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    the Row Details Extension is still activated for that table, from what I can see.
    Can you please turn those off for the table by removing the parameters from the Shortcode? I can then try to debug things without the Extensions active, first.

    Regards,
    Tobias

    Nervosibert

    (@nervosibert)

    Hi Namensvetter

    I′ve also a sorting Prob with Dates. I think it′s because in some fields are Date Ranges like:

    21.02.104 – 26.02.2014

    and some of the Fields just contain a simple Date. When i try to order them, they′re all f… up. Just take a look at it and you′ll see what i mean:
    https://www.wilknergroup.de/terminkalender/

    A hint would be great!

    Best
    Tobi

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    The reason for this indeed those date ranges. By default, the JS library does not know how to handle those.
    My suggestion here would be to fix this by adding another (hidden) column where you paste that date that shall be used for sorting in the English format. For details, please see this thread: https://www.ads-software.com/support/topic/sorting-a-column-with-a-custom-date-format

    Regards,
    Tobias

Viewing 8 replies - 16 through 23 (of 23 total)
  • The topic ‘TablePress sort european dates’ is closed to new replies.