Export to csv and pdf with Table Tools

samiesta

Data Table data is loading using ajax with php. At a time I am loading 100 records and per page count also 100. Total records are 1000. Is it possible to export all the 1000 records while exporting Table Tools csv/pdf? if not is there any alternate solution?

Pagination and Sorting actions are loading with ajax call.

Thanks,
Sami

mRender

It should do this automatically. The 100 records per page is just a view. If you export the table, does it only do the 100 that you are currently viewing?

In this example, https://www.datatables.net/extensions/tabletools/ ,the page exports all of the results.

allan

Unless you are using server-side processing (which you shouldn't need to do for only 1000 records). If you are using server-side processing only the rows visible will be exported since TableTools is a client-side script and that is all the rows that are available at the client-side.

You could use the download plug-in for TableTools if you want to have the server generate the exported file that contains all of the rows. You would need to create the server-side script for that though.

Allan