I change the pagelength in datatable but not show the export buttons in datatable

itteambgs

Link to test case:
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem:

itteambgs

pls reply for my qn

allan

Please link to a test case, as required in the forum rules and the template text that you didn't fill in.

Allan

itteambgs

Hi All,
I am using datatables version : **1.10.24 **

I want to change default pagination to 500 / page for this I have included below script as

$('#example1').dataTable( {
"pageLength": 50
});

unfortunately export button like excel, pdf,print & copy are hidden or not showing.
how to fix it. This is my first post if any thing wrong apologize it.

allan

1.10.24 is three years old and no longer supported. I would suggest you update to the current release - 2.0.3.

That said, I see nothing in your confirmation that would make the Buttons show. I would have expected the use of the dom parameter, or perhaps a use of the API to insert the buttons after initialisation.

Without a test case it is impossible to say for sure what is wrong.

Allan

itteambgs

Hi all,
I had change the upgrade version for datatable . I get answer all data rows shows in one page.Thank you.
But I need add the export buttons are excel,pdf,print and coloumn visibility .

itteambgs

Can any one pls reply for me?

allan

You sometimes need to wait more than 9 minutes for a reply before bumping a post.

You haven't provided a test case, as previously asked for, so I don't know why the export buttons wouldn't be showing for you.

This example shows how to get the export buttons to display.

If you are having problems with that, please provide a test case.

Allan

itteambgs

<script src="<?php echo base_url('resources/plugins/datatables-buttons/js/dataTables.min.js');?>"></script>
<link rel="stylesheet" href="<?php echo base_url('resources/plugins/datatables-buttons/css/dataTables.dataTables.min.css');?>">

i was use for upgrade version cdn .

Then i used some script codes for show the export buttons .

I will show the codes below:

new DataTable('#example1', {
  pageLength:150,
    layout: {
        topStart: {
            buttons: [  'copyHtml5', 'excelHtml5', 'csvHtml5', 'pdfHtml5','colvisHtml5']

            
        }
    }
});

<script src="https://code.jquery.com/jquery-3.7.1.js"></script>
<script src="https://cdn.datatables.net/2.0.3/js/dataTables.js"></script>
<script src="https://cdn.datatables.net/buttons/3.0.1/js/dataTables.buttons.js"></script>
<script src="https://cdn.datatables.net/buttons/3.0.1/js/buttons.dataTables.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/3.0.1/js/buttons.html5.min.js"></script> 

Edited by allan Syntax highlighting

itteambgs

I get the export buttons show and using the above code.

but didnot show the colvisHtml5 and printHtml5
what i code use for this

allan

You'd need

<script src="https://cdn.datatables.net/buttons/3.0.1/js/buttons.print.min.js"></script> 

for the print button.

<script src="https://cdn.datatables.net/buttons/3.0.1/js/buttons.colVis.min.js"></script> 

For the column visibility button.

Use the download builder to make sure you get all the files you need.

Allan

itteambgs

css:

<link rel="stylesheet" type="text/css" href="path/to/datatables.min.css">
<link rel="stylesheet" href="<?php echo base_url('resources/plugins/datatables-buttons/css/dataTables.dataTables.min.css');?>">

<script src="<?php echo base_url('resources/plugins/datatables-buttons/js/dataTables.min.js');?>"></script>
<script src="https://code.jquery.com/jquery-3.7.1.js"></script>
<script src="https://cdn.datatables.net/2.0.3/js/dataTables.js"></script>
<script src="https://cdn.datatables.net/buttons/3.0.1/js/dataTables.buttons.js"></script>
<script src="https://cdn.datatables.net/buttons/3.0.1/js/buttons.dataTables.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/3.0.1/js/buttons.html5.min.js"></script> 
and
<link rel="stylesheet" type="text/css" href="path/to/datatables.min.css">
<link rel="stylesheet" href="<?php echo base_url('resources/plugins/datatables-buttons/css/dataTables.dataTables.min.css');?>">

<script src="https://cdn.datatables.net/buttons/3.0.1/js/buttons.print.min.js"></script>
<script src="https://cdn.datatables.net/buttons/3.0.1/js/buttons.colVis.min.js"></script>
<script>
 new DataTable('#example1', {
  pageLength:150,
    layout: {
        topStart: {
            buttons: [  'copyHtml5', 'excelHtml5', 'csvHtml5', 'pdfHtml5','colvisHtml5', 'printHtml5']

            
        }
    }
});
</script>

i used above the scripts for all data rows show in one page with show the export buttons .
But i am not till get the proper working function page.
And i using the script code blelow i give:

<script>
 new DataTable('#example1', {
  pageLength:150,
    layout: {
        topStart: {
            buttons: [  'copyHtml5', 'excelHtml5', 'csvHtml5', 'pdfHtml5','colvisHtml5', 'printHtml5']

            
        }
    }
});
</script>

And i got the DataTables warning: table id=example1 - Cannot reinitialise DataTable. For more information about this error, please see https://datatables.net/tn/3 in this error in my page.
And shot showing th e colvis ,print buttons

Edited by Kevin: Syntax highlighting. Details on how to highlight code using markdown can be found in this guide

kthorngren

I don't believe there are colvisHtml5 and printHtml5 button types. See the Built-in buttons doc for more details. Try this instead:

buttons: [  'copyHtml5', 'excelHtml5', 'csvHtml5', 'pdfHtml5','colvis', 'print']

Use the troubleshooting steps at the link in the error:
https://datatables.net/tn/3

If you need help with this then please post a link to your page or test case replicating the issue so we can help debug.
https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

Kevin

itteambgs

DataTables warning: table id=example1 - Cannot reinitialise DataTable. For more information about this error, please see https://datatables.net/tn/3
how to i solve above problem in datatable

colin

It sounds like you're initialising the table multiple times - that's the only reason why you'd get that error. You can call destroy() before re-initialising.

But as Kevin said, please provide a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

Colin