WordPress.org

Ready to get started?Download WordPress

Forums

TablePress
[resolved] Error: The data for the import is invalid. (20 posts)

  1. pictureitsolved
    Member
    Posted 1 year ago #

    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/

  2. pictureitsolved
    Member
    Posted 1 year ago #

    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.

  3. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    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

  4. networkadmin
    Member
    Posted 1 year ago #

    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.

  5. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    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

  6. networkadmin
    Member
    Posted 1 year ago #

    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."

  7. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    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

  8. networkadmin
    Member
    Posted 1 year ago #

  9. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    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

  10. networkadmin
    Member
    Posted 1 year ago #

    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

  11. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    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

  12. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    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

  13. networkadmin
    Member
    Posted 1 year ago #

    TobiasBg, how would I go about doing that?

  14. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    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

  15. networkadmin
    Member
    Posted 1 year ago #

    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.

  16. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

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

    Regards,
    Tobias

  17. networkadmin
    Member
    Posted 1 year ago #

    If anyone else is following this.

    I was able to load my previous table of approx 3500 rows and it cam up fine. I haven't tried a table that is slightly larger than that yet, but my previous table of 3,469 rows imported successfully.

    Thanks to TobiasBg for helping me with some troubleshooting.

  18. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    thanks for sharing that information!

    I hope that you can find a working solution for your project.

    Best wishes,
    Tobias

  19. pictureitsolved
    Member
    Posted 1 year ago #

    I just want to state publicly that Tobias was incredibly helpful in finding and fixing my problem. Thank you for your exceptional level of service and excellent plugin.

    Cheston, I'm glad you found a solution too. Something like Formidable Forms Pro might work for importing, viewing, and manipulating your data if you want to do it in WordPress and have it live on the web.

    Karen

  20. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Karen,

    thanks for the nice words, I really appreciate it!

    Also thanks for that suggestion of a forms plugin! I have never worked with that plugin, but maybe it helps, yes.

    Best wishes,
    Tobias

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.