How to download data after filtering with server side datatable

arievtha

Hallo, Iam new in here and this my first posting, but I always looking in this site when I need a references about datatable.

I want to download my data after filtering with datatable server-side in xls or csv format, but I don't get an idea how to do. I tried using table tools v2, but only print button which is working in my site.
what else should I do to download my data?

Thank's for datatables.net :)

allan

> but only print button which is working in my site.

Please link to a test case as noted in the forum rules. At the moment we have no idea why it isn't working for you - sorry.

Also note that TableTools is a client-side script, while you specifically not that you are using server-side processing. So not all of the data is available at the client-side, and thus TableTools can only export what is currently visible in the table.

Allan

arievtha

[code]var oTable = $('#table_id').dataTable( {
"oLanguage": {
"sSearch": "Search all columns:"
},
"bProcessing": true,
"bServerSide": true,
"bStateSave": true,
"sPaginationType": "full_numbers",

"sDom": 'T<"clear">lfrtip',
"oTableTools": {
"sSwfPath": "TableTools-2.0.0/media/swf/copy_csv_xls_pdf.swf",
"aButtons": [ {
"sExtends": "download",
"sButtonText": "Download CSV",
"sUrl": "TableTools-2.0.0/media/script/generate_csv.php"
} ]
},[/code]

and my generate_csv.php

[code]<?php
header('Content-type: text/csv');
header('Content-Disposition: attachment; filename="downloaded.csv"');

echo 'ID BANK,BULAN,TAHUN,JENIS UANG,JENIS SEKTOR, RASIO NPL'."\n";
echo 'Body1,Body2'."\n";
?>[/code]

I don't know, how should I write in my generate_csv.php, please help me