[Plugin: Table Press] Importing table, Dates showing as serial number

  • ghanahmad

    (@ghanahmad)


    12 years, 9 months ago

    Hello,

    I am currently working on building my work diary on WordPress, the problem I am facing is that when I am importing and Excel file (xlsx), all the fields are showing correctly, except the date field, which is showing as a serial number, example:

    22/06/2012 is displayed as 29984

    I have installed the datatable sorting plugin, but still no luck, yet.

    Any help or advice would be really appreciated.

    Thanks

Viewing 12 replies - 1 through 12 (of 12 total)
  • Tobias Bäthge

    (@tobiasbg)

    12 years, 9 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    Yes, dates in XLSX files are not yet supported. Please see http://ww.wp.xz.cn/support/topic/date-issue-with-experimental-excel-import for some technical details.

    Until this can be fixed, I suggest to use the CSV format for importing from Excel. Just save to “CSV” in Excel and import that into TablePress.

    Regards,
    Tobias

    Thread Starter ghanahmad

    (@ghanahmad)

    12 years, 9 months ago

    Thanks Tobias !

    Another issue I’ve just noticed, when I click any of the sorting arrows, the custom css (stops to apply), i.e column width which I set using custom css go back to default.

    Any ideas whats causing this ?

    Thanks !

    Tobias Bäthge

    (@tobiasbg)

    12 years, 9 months ago

    Hi,

    that sounds strange. Can you please post a link to the page with the table where this happens, so that I can take direct look? Thanks!

    Regards,
    Tobias

    Rene W

    (@rene-w)

    12 years ago

    I’m happy to see that there is a solution for this problem, but I still have a question though.

    The presentation of the dates changes automatically from dd/mm/yyyy to mm/dd/yyyy. Is there something to do about that?

    Tobias Bäthge

    (@tobiasbg)

    12 years ago

    Hi,

    can you please explain when exactly that is happening? With the Excel import or with the CSV import? The CSV import should not show this, as that would mean that Excel is already saving the date in that wrong format then.

    Regards,
    Tobias

    NoLabel

    (@nolabel)

    12 years ago

    Hello!
    I tried saving the file as CSV and it solved the problem with the dates, but the text in the file is Ciryllic (Bulgarian), and it doesn’t display correctly. It’s unreadable. I tried saving the file in differend encodings, like Unicode, UTF-8, Ciryllic(Windows), but nothing helped. So it’s either no dates, or no text. I guess the plugin itself has a problem with ciryllic text in CSV files.
    Any ideas?

    NoLabel

    (@nolabel)

    12 years ago

    P.S. Sorry, it’s *Cyrillic, duuh!

    Tobias Bäthge

    (@tobiasbg)

    12 years ago

    Hi,

    thanks for your post, and sorry for the trouble.

    This is most likely a problem with UTF-8 then, but not in TablePress, but on the server, or in the file.
    Please try these steps again:
    – Save the file to CSV in Excel (or maybe also try OpenOffice).
    – Open the CSV file in Notepad, check if all characters/dates are correct, and use “Save as” to save it as “UTF-8 (without BOM)” again.
    – Then try importing that CSV file into TablePress.

    Regards,
    Tobias

    NoLabel

    (@nolabel)

    12 years ago

    It worked, thank you very much! It’s not very user friendly that way, but it does the job for now.

    …. Ok, so I decided to try with OpenOffice, and it worked perfectly! Tahanks a lot, Tobias!

    Tobias Bäthge

    (@tobiasbg)

    12 years ago

    Hi,

    no problem, you are very welcome! 🙂 Good to hear that this helped!

    Yeah, I know that this is not user friendly, but unfortunately, there’s nothing really that I can do about this, as this is something in Excel or on the server 🙁

    Best wishes,
    Tobias

    Rene W

    (@rene-w)

    11 years, 10 months ago

    My reaction is a little bit late, bus I just wanted to say that it works fine for me now. Apparantly something was wrong with the notation in Excel. Thanks!

    Tobias Bäthge

    (@tobiasbg)

    11 years, 10 months ago

    Hi Rene,

    very cool! That’s great to hear! 🙂 Thanks for the update!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 12 replies - 1 through 12 (of 12 total)

The topic ‘[Plugin: Table Press] Importing table, Dates showing as serial number’ is closed to new replies.