Search code examples
datatabletabletools

datatable tabletools csv not working


This code was working fine , but without changing anything the export button is not displaying.

I have inserted the libraries on right location:

    $this->document->add_css('jquery.datetimepicker.css');
    $this->document->add_css('dataTables.tableTools.min.css');
    $this->document->add_js('jquery.datetimepicker.js');
    $this->document->add_js('jquery.dataTables.min.js');
    $this->document->add_js('dataTables.tableTools.js');

this is my code :

  $(".table-dashboard").DataTable({
        "dom": "T<\'clear\'>lfrtip",
        initComplete: function(){
            $(".scrollable-list").before($(".DTTT_container"));
            $(".DTTT_container").css("margin-bottom", "-33px");
        },
        bFilter: false,
        "aoColumnDefs":
        [
            {
                "bSortable": false,
                "aTargets": [$(this).find("thead tr th").length - 1]
            }
        ],
        "oTableTools":
        {//        "sSwfPath": "'.base_url(SYSTEM_MEDIA . "swf/copy_csv_xls_pdf.swf").'",
            "sSwfPath": "http://cdn.datatables.net/tabletools/2.2.2/swf/copy_csv_xls_pdf.swf",
            "aButtons":
            [ 
                {
                    "sExtends"      :   "csv",
                    "sButtonText"   :   "Export CSV <i class=\'fa fa-file-excel-o\'></i>",
                    "sButtonClass"  :   "btn btn-primary"
                }
            ]
        }
    });

Solution

  • I`ve founded by myself solution, i added some these libraries which were missing.

    <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
    <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/buttons/1.4.2/js/dataTables.buttons.min.js"></script>
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css">
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/1.4.2/css/buttons.dataTables.min.css">
    <script type="text/javascript" charset="utf8" src="//cdn.datatables.net/buttons/1.4.2/js/buttons.html5.min.js"></script>
    <script type="text/javascript" charset="utf8" src="//cdn.datatables.net/buttons/1.4.2/js/buttons.print.min.js"></script>
    

    Script:

       dom: 'Bfrtip',
            initComplete: function(){
                $(".scrollable-list").before($(".DTTT_container"));
                $(".DTTT_container").css("margin-bottom", "-33px");
            },
            bFilter: false,
            "aoColumnDefs":
            [
                {
                    "bSortable": false,
                    "aTargets": [$(this).find("thead tr th").length - 1]
                }
            ],
            buttons: [
                {
                    extend: "csv",
                    text:  "Export CSV",
                    className: "btn btn-primary"
                }
            ]