• Resolved JHS_NL

    (@jhs_nl)


    Hi,

    I have a problem when importing tables. If I import a table using a .csv file, I use save updates and push save and go back. If I insert the short code to a page it displays that the table is empty. Even though I have seen the data inside the table before returning to the table list.

    Can anybody tell how this can be happening and how I can solve this??

    Greetings,

    JHS

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    thanks for your post.

    Very likely this is a problem with the character encoding. I have noticed in the past, that certain characters (especially from foreign languages) seem to cause trouble with some PHP functions.

    This happens, when the plugin can’t read the table data correctly from the database, which usually happens during the saving of the imported data.
    While the initial import works, the ensuing saving fails, very likely to a problem with the character encoding.
    I was not yet able to find a definite cause or a solution, but usually this helps:
    Check the CSV file (in a text editor) for “special” characters.
    This means for example quotation marks or apostrophes that are not exactly the ones from the keyboard, but more typographically nice ones (i.e. the sometimes look more like an accent ´ instead of an apostrophe ‘). Then replace those by the “regular” characters.
    It could also help to open the CSV file in Notepad and then “Save as” with a different “Character Encoding” selected.

    After that the import and saving process should work as expected and the table should appear fine on the page.

    Regards,
    Tobias

    Thread Starter JHS_NL

    (@jhs_nl)

    Hi,

    thnx a lot again! I used € signs in the file that corrupted it, I removed them and inserted them later on while editing the table.

    Works fine!

    Greetings from a satisfied user!

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    great! Nice to hear that this worked so easily! Thanks for the confirmation and have fun with the plugin!

    Best wishes,
    Tobias

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

The topic ‘Tables getting cleaned out’ is closed to new replies.