Support » Plugin: TablePress » Error: The data for the import is invalid.

  • Resolved pictureitsolved

    (@pictureitsolved)


    I’m trying to import an HTML formatted table with 1800+ lines. It fails with the message “Error: The data for the import is invalid.”

    I tried importing only half the data, and have the same problem with both halves. I was successful with the first 36 rows of the same data.

    Is there a limit to the number of rows in a table?

    How can I find where the error is occurring?

    http://wordpress.org/extend/plugins/tablepress/

Viewing 15 replies - 1 through 15 (of 19 total)
  • I made a CSV version of the data, which didn’t fail on import, but wouldn’t save. The error is
    “Error: The table could not be saved.”

    A suggestion appeared to try holding down the SHIFT key while I clicked Save, but that had the same result.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    sorry to hear that you are having such problems.

    The HTML import and the CSV saving problems are most likely not related to each other.
    As you have already sent me an email with details, I’ll take a direct look with that then, and reply shortly.

    Regards,
    Tobias

    I am also having this same error. Is there an update on this issue? I had a table that I updated from Tables-Reloaded. I saw the plugin was going out of date so I replaced it with TablePress and pulled my table from Tables-Reloaded with no issue. I was recently sent a new file to replace that one, and now no matter what I do i get the same error. I event tried copying and pasting the data manually and got the same error. It all fails on import and gives me the “Error: The data for the import is invalid.” The one time i got it to list the table, I clicked on preview and it told me the table was empty. Then when I went back to my table list, it was empty. I have repeated this 7 times with the exact same results.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    sorry to hear that you are also having problems.

    Just to clarify, can you explain which error message you are getting:
    “Error: The data for the import is invalid.” during an import, or “Error: The table could not be saved.” when saving a table?

    Regards,
    Tobias

    TablePress>Import>File Upload. Browse, located oc.csv
    Import: Format CSV
    Addor Replace: Add as new table

    IMPORT

    “Error the data for the import is invalid.”

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    ah, thanks for the clarification. This means that you are actually not affected by the problems that are discussed in this thread already (it is however related).

    Could you please try a different import source, i.e. the “From URL” method? For that, just upload the CSV file to your server via FTP, and then use the resulting URL during the import.
    That test will help to find out, it the upload process maybe is involved in this issue.
    Also, I can then test with your CSV directly, if you post the URL.

    Regards,
    Tobias

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for testing this, and for the link!

    Unfortunately, I have bad news: Your file is just too big for TablePress.
    Although there’s no direct limit in theory, a table of this size is too much for the memory (and then also the user interface) to handle.

    Even if we were successful in importing this file, you would not have fun with this table. Basically, the “Edit” screen of TablePress would be virtually unusable for this table, due to the large amount of input fields. Also, the rest of the site would probably be slow, as the table would always be loaded entirely.

    For a table like this, which is more like a large database, a custom database solution, e.g. based directly on mySQL and PHP will be the much better option.
    If you want, you can then also add the advanced features like sorting, search, and pagination, by manually using the DataTables JS library from http://www.datatables.net

    I’m really sorry that I don’t have better news or a working solution here 🙁

    Regards,
    Tobias

    Is this a limitation for WordPress in General or just the TablePress plugin. I was curious if their might be a better solution. Could I break the big table up into smaller tables?

    Thanks for your help.

    Cheston

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi Cheston,

    this is more of a limitation in TablePress than in WordPress.
    TablePress was just not designed with such database-like tables in mind, but more for smaller tables (with maybe a few hundred rows as a maximum). The user interface and the internal storage structure are just not scaling for tables with several thousand rows 🙁
    The very best solution would be a custom solution, that only retrieves the desired rows from the database to reduce the overhead. That’s going to require custom programming though.

    Breaking up the table into several smaller ones would of course also be possible, if your table structure allows that.

    Regards,
    Tobias

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    just for everybody following this thread: I have worked directly with pictureitsolved on solving the problem on her site, and it turned out that increasing the PHP memory limit did the trick.

    Regards,
    Tobias

    TobiasBg, how would I go about doing that?

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    you could try the instructions at http://codex.wordpress.org/Editing_wp-config.php#Increasing_memory_allocated_to_PHP
    with something like

    define('WP_MEMORY_LIMIT', '256M');

    But even if that works, you’ll most likely not be able to edit this table in TablePress. It’s just too big.

    Regards,
    Tobias

    okay. I tried it and got the same error. I think I will see if I can break it down into smaller tables. Although with that many rows it may take a little bit.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    sorry about that 🙁 Yes, splitting the table will then be the best approach going forward.

    Regards,
    Tobias

Viewing 15 replies - 1 through 15 (of 19 total)
  • The topic ‘Error: The data for the import is invalid.’ is closed to new replies.