[Plugin: WP-Table Reloaded] Manual Imput of Table Not Working

  • pmwilson

    (@pmwilson)


    13 years ago

    Ever since I started using this plugin (which I think is great) I’ve been manually imputing the tables that I use.

    What I mean by manually imputing is copying the data from an excel spreadsheet, and pasting it in the box on the Import a Table page.

    Since I only update the data table once a week, I haven’t had any problems until today, when I was updating the table. I did exactly what I always do (copy and paste), but this time instead of the data going into the table like it’s supposed to, it’s coming out all weird.

    A typical line might look like this (with 7 columns)when I’m copying and pasting:

    Anime Boston Hynes Convention Center Boston Massachusetts USA 2015/04/03 2015/04/05

    but now all the words are in the first column and the dates are spread out between 6 or 7 more columns. (Kind of like 2 15/ 04/ 032 25/ 04/ 05)

    I haven’t done anything different, haven’t updated anything. I have no idea why things are suddenly not working well.

    Any help would be greatly appreciated.

    Patricia
    colbyjack.net

    http://wordpress.org/extend/plugins/wp-table-reloaded/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    13 years ago

    Hi Patricia,

    thanks for your post.

    This seems to happen because the part of the code that does the import is not detecting the “delimiter” correctly, which is the character that separates the columns.

    I believe that when using the copy&paste method as you do, this character is a “tab”, so we should try with a different one.

    For that, please save your table to “CSV” from within Excel and then try importing the resulting file.
    That way, the delimiter should be a comma or semicolon, which is easier to detect for the plugin.

    Can you try that?

    Regards,
    Tobias

    Thread Starter pmwilson

    (@pmwilson)

    13 years ago

    Thanks for getting back to me.

    I’ve tried to save the tables as “CSV” and then upload the file, and it does upload, but it never saves. The second I want to do anything to the table, include saving it, the data disappears. Suddenly my table which was full is now empty.

    That is why I’d gone to the copy and paste method and before now, it has always worked.

    I did try again, but again the table content is there one minute and gone the next.

    Any more ideas?

    Patricia

    Plugin Author TobiasBg

    (@tobiasbg)

    13 years ago

    Hi Patricia,

    thanks for that more detailed explanation.
    This sounds like a problem with the character encoding, which can sometimes happen with “special” characters in tables.
    In Excel, this is sometimes happening due to the automatic conversion.

    Can you email your CSV file to me? I will then try to find those characters and fix the table.
    (My address is in the main plugin file “wp-table-reloaded.php”.)

    Thanks,
    Tobias

    lauhakari

    (@lauhakari)

    13 years ago

    Hey, I thought I’d jump in here cuz I have a similar problem although a bit different.
    And also, like Patricia this came out of nowhere during the weekend…

    I can’t seem to update/edit my tables any more, when I do it troughs an “Error 500: Internal Server Error”… Now I did try disable loads of plugins, uninstalled and reinstalled it nothing!
    Suddenly it worked to create a new table, and I can edit it – all fine! But it’s still the same problem with existing tables. Even tried to export a table and create it as a new one, import works but when I edit and save that some “Error 500″…

    Asked my host and they couldn’t see anything on their side (as usual).
    So now I’m asking you oh master creator of the plugin – any suggestions?

    Plugin Author TobiasBg

    (@tobiasbg)

    13 years ago

    Hi,

    thanks for your question – and sorry that you suddenly have such problems.

    Unfortunately, I have no idea what might be causing this, but as it appeared so suddenly (and as no one else has reported something like this), I really believe that this is a problem with the PHP or server configuration.
    It might be possible that some sort of security extension on the server is blocking access somehow (I have seen that in the past with the PHP extension “Suhosin”, especially with large tables).
    It might also be possible that some resource like PHP memory or execution time is not sufficient (e.g. due to using many plugins, which you however seem to have tried to reduce already).

    So, from the WP-Table Reloaded side, I really have no ideas on what might be causing this 🙁

    Regards,
    Tobias

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘[Plugin: WP-Table Reloaded] Manual Imput of Table Not Working’ is closed to new replies.