Hey everyone!
With the holiday season upon us, we want to share our upcoming working hours:
- New Year: Our team will be off on January 1st and 2nd. We’ll be back on Friday, January 3rd, to respond to any messages received during this time.
- Weekend: As usual, we don’t work on weekends, so January 4th and 5th will also be non-working days.
- Orthodox Christmas: Our office will be closed on Monday and Tuesday, January 6th and 7th for the holiday.
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
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.
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:
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 | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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