• Resolved animevortex

    (@animevortex)


    I’m wondering if there is a MAX table size for the plugin. I am trying to import my .xlsx file which as over 24,000 Rows.

    I have tried uploading the file and it gives me a 500 Error

    Any help would be appreciated.

    Great plugin!

    The page I need help with: [log in to see the link]

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

    (@tobiasbg)

    Hi @animevortex!

    Thanks for your post and sorry for the trouble!

    There’s no direct limit in theory, but overall resources do of course play a role. For direct XLSX import, the internal format also plays a role. It’s then often more memory-efficient to first save the table to the CSV format and import that into TablePress. Can you please try that?

    If that still fails, can you please try again after increasing the value of the WP_MEMORY_LIMIT constant to e.g. 1024M in the wp-config.php file on your server, by following the instructions from https://developer.wordpress.org/apis/wp-config-php/#increasing-memory-allocated-to-php ?

    Now, with over 24.000 rows, you might then experience that the “Edit” screen is slow or (depending on your browser and computer) unusable. In that case, I recommend first creating a small table manually and configuring all settings and options as desired. Then, import your file, choosing to replace that just-created small table. (This will only replace the data, but keep all settings.)

    Finally, you might then want to consider making this large table faster on the frontend (on the page where you have then embedded the table). For that, you could check out the “Advanced Loading” and “Server-side Processing” feature modules that are part of the TablePress Max license plan.

    Best wishes,
    Tobias

    Thread Starter animevortex

    (@animevortex)

    Awesome! Thanks for the help! I’ll try it and get back to you!

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    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 in the plugin directory. Thanks!

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

You must be logged in to reply to this topic.