Export all rows using TableTools buttons

a.raghavan

Hi,

I am using the legacy datatables (collective.js.datatables-2.0.1-py2.7.egg) in Plomino database.

We have around 1000+ rows and paginated. I am completely baffled as to why I am unable to export all the rows in my table. The TableTools example in this site exports all rows irrespective of pagination and I am using an exactly similar code. However, the export buttons are always exporting only the number of visible rows in the table.

This is the code I am using

"sDom": 'T<"clear">lfrtip',
"aLengthMenu":[[10,25,50,100,200,500,-1],[10,25,50,100,200,500,"All"]],
"bPaginate": true,
"bLengthChange": true,
"bSort": true,
"bFilter": true,
"bSmart": true,
"oTableTools": {
"oSearch": {"sSearch": "Initial search"},
"aButtons": [
"print",
"csv",
"xls"
],
"sSwfPath": "++resource++jquery.datatables/extras/TableTools/media/swf/copy_csv_xls_pdf.swf"
}

As you can see, I am using the Length menu option as a temporary workaround to show all results and then click on the export button. Not a bad option but not slick either.

Can someone kindly let me know as to what I might be missing?

Thanks
Ash