CSV File Export Without Loading All Pages

Dionatan

I would like to know if there is a way to export a CSV file of everything present in a paginated table using the Buttons extension, but without loading all the pages.

allan

I'm going to assume you are using server-side processing? Client-side processing will export all rows of the table, hence my assumption.

Based on that, please see this FAQ:

Q. How can I export the whole table when using serverSide and Buttons.

Allan

Dionatan

The processing is client-side. When the user queries a table with, for example, 40,000 records, pagination limits the display to, say, 50 records per page. However, I want the 'Export to .csv' button to export all 40,000 records at once, not just the 50 displayed on the current page.

kthorngren

Please post your Datatables init code. This example shows that by default the export buttons will export all rows in the table when using client side processing. There is something specific to your page that is limiting this.

Kevin

allan

If you could post a link to a test case as well, that would be great.

Thanks,
Allan