Wrong encoding while bulk (.zip) import

  • Resolved alya6

    (@alya6)


    6 years, 4 months ago

    Hi, Tobias!
    I’m using TablePress for a while and have one problem.

    When I try to make bulk import using .zip archive, my tables are wrong imported. Suddenly they have more rows and cells than on my computer and wrong characters like ó and other.

    Interesting that while I import one .xlsx file, the table imports totally okay. When I gather the same table in or more that one table in .zip file, they import wrong.

    I checked an encoding using Notepad++, the encoding is UTF-8 (with or without BOM – I tried both formats). And checked with OpenOffice – it also says, that encoding is UTF-8.

    Tell me please, why this problem occurs and what should I do?
    Thanks!

    • This topic was modified 6 years, 4 months ago by alya6.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    6 years, 4 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    To be honest, I don’t know. It might be possible that the libraries that are used for ZIP handling on the server somehow modify the encoding or something like that.
    Can you maybe test again with CSV files? Those are usually better in this regard.

    Regards,
    Tobias

    Thread Starter alya6

    (@alya6)

    6 years, 4 months ago

    Hi! Thanks for quick answer.
    When I create one table in .csv and import it on the website, it imports wrong – it has more rows and cells than on my computer and wrong characters like ó and other.

    Maybe, I can send you one of those tables (in .csv and .xslx format) and you can look what am I doing wrong?

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    6 years, 4 months ago

    Hi,

    can you then maybe check the CSV file in a normal text editor? Does it already have more rows and columns there? If so, the problem is how Excel saves the table, I’m afraid. And TablePress can not know that you don’t want all of these cells…
    One idea in this case is to copy/paste the relevant data cells from the existing to a new Excel file. Often, Excel will save the table correctly after that again.

    Regards,
    Tobias

    Thread Starter alya6

    (@alya6)

    6 years, 4 months ago

    Hi, Tobias!
    I checked file and everything is ok. I found answer on my question: while importing I should’ve set files encoding. Earlier I didn’t do that and it was set on .csv format.

    Now I switched on .xlsx and everything is ok. It’s a shame, that I didn’t knew about this function before.

    Sorry for disturbing. Thanks for your help!

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    6 years, 4 months ago

    Hi,

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

    Best wishes,
    Tobias

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

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

The topic ‘Wrong encoding while bulk (.zip) import’ is closed to new replies.