Hey everyone!

With the holiday season upon us, we want to share our upcoming working hours:

After that, we’ll return to our regular schedule and assist you as quickly as possible.

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.

Thanks a bunch for your understanding and support!

Warm regards and happy holidays!

TMS

Okay
  Public Ticket #3501231
How Can I Export the Entire List of 10,000 Records from the Table to Excel
Closed

Comments

  • Engin started the conversation

    Hello,

    When I try to export the list table to Excel, it doesn't capture the entire list without displaying it in the browser first. How can I export all 10,000 records?

    Thank you.

  •  1,847
    Miloš replied


    Hi Engin,

    I am sorry to disappoint you, but at this time we do not have a valid solution to export such large number of rows with our Table Tools Export.

    The table tools functionalities are based on a 3rd party HTML5 library and they are not customizable. Unfortunately, the library allows very little “fine-tuning” of the generated files, so font, size, and other properties cannot be changed.

    This is one of the limitations in this library we will emphasize for your awareness:

     If you want the entire table to be exported (or copied to a clipboard), you need to choose the “Show All” feature in the “show … entries” block, and then do the export:6992668217.png

    But when you set to "Show All" for a Data Set of 10 thousand rows, your WP Page will most probably either become extremely slow or the browser might crash in that moment.


    When our Server-Side processing is enabled in Tables, then using AJAX, only the number of rows in the current Table's Page are loaded in the Page HTML, while the rest of the rows are not loaded,

    that helped to reduce the hosting server load.


    For tables less than 2 thousand rows, you can disable server-side processing if you have an SQL Query Based Table,  then your Export will get all the table rows regardless of pagination.


    For a Data Set that has more than around 6 thousand rows, unfortunately there is no valid solution without a very slow page or crashing the Page, to export that through our Plugin's Table Tools.


    The only way currently to export such large data set is if you log in your SQL Database via PhPMyAdmin and there you can export it directly from the Database as CSV/ or Excel.


    You can make a development suggestion to improve this feature for our Table Tools, to be able to export all rows with large Data Sets, but i can't say an ETA on it.

    Please feel free to search on our suggestions page

     to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

    You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

    and our newsletter, so you're informed about new features, bug fixes, freebies, etc.



    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables