jQuery DataTables - File becomes empty after dynamic change of filename

Question

I want to dynamically change my exported CSV file name.

accountsDataTable = $('#accounts-list').DataTable({
    "dom": 'Tlfrtip',
    "tableTools": {
        "sSwfPath": "swf/copy_csv_xls.swf",
        "aButtons": [{
            "sExtends": "csv",
            "sTitle": "Temporaire",
            "sButtonText": "Exporter en CSV",
            "mColumns": "visible",
            "fnClick": function ( nButton, oConfig, oFlash ) {
                oFlash.setFileName("MonNomDeFichier.csv");
            }
        }]
    },
}

This does change the file name but the content is missing. I think fnClick function is missing this.fnSetText but I don't know what to put in it ?!

It works right away here. The default filename is set as `MonNomDeFichier.csv` - are you sure the SWF is loaded properly? — davidkonrad, Dec 25 '14 at 22:54
This does indeed change the file name, but it doesn't print out the content. The file is empty. — Mehdiway, Dec 26 '14 at 16:40

JaskeyLam · Accepted Answer · 2015-03-03T10:48:36.103

1

Try:

"fnClick": function ( nButton, oConfig, oFlash ) {
              oFlash.setFileName("MonNomDeFichier.csv");
              this.fnSetText( oFlash, this.fnGetTableData(oConfig) );//Add this after your code, since you have overridden the original code 
           }

Check here for more info : http://datatables.net/forums/discussion/10248/fnclick-callback-on-tabletools-flash-button-breaks-csv-xls-export

edited Mar 03 '15 at 10:48

answered Mar 03 '15 at 09:57

JaskeyLam

15,405
21
114
149

jQuery DataTables - File becomes empty after dynamic change of filename

1 Answers1