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"
}
]
}
});
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"
}
]