Replies

• bindrid Posts: 730Questions: 0Answers: 119

  June 2017

  You have <script> in the wrong order and duplicates so your page is loading with errors. Load order matters.
  Also, in addition to the print script, you need the buttons include.

  http://jsbin.com/lacaqeb/edit?html,js,output is my jsbin that has them in a working order in the html section
• srcargentina Posts: 5Questions: 0Answers: 0

  June 2017

  Thanks!. I put the js in the right order and it works.
  I dont understand what you mean by saying : "you need de buttons include", because they are already included:
  
  Anyway, the export buttom doesnt appears. Do I miss another js or code?

  I read on the reference manual that I have to add:
  {
  extend: 'excel',
  text: 'Save current page',
  exportOptions: {
  modifier: {
  page: 'current'
  }
  }
  }

  But when I did it, anything works properly. Should I add it? where exactly?

  http://munafoautomoviles.com/control/autosBOsinseguridad.php

  sincerely
• bindrid Posts: 730Questions: 0Answers: 119

  June 2017

  That a look at the html panel on this page http://jsbin.com/gabara/edit?html,output
• srcargentina Posts: 5Questions: 0Answers: 0

  June 2017

  Im sorry but I couldnt follow your example
  Is there anything else that you can add?
  my table is made from a sql db, so the data is added automatically.
  And the js code is:

  if(<?php echo $totalRows_rsAutos; ?> >0){ $(document).ready(function(){ $('#myTable').dataTable(); }); $('#myTable').DataTable( { retrieve: true, scrollY: 600, paging: false, dom: 'Bfrtip', buttons: [ 'print','copy', 'excel', 'pdf' ] } ); }
• bindrid Posts: 730Questions: 0Answers: 119

  June 2017

  I am saying is that you are missing some of the needed CDN.
  Copy the datatable related <script> and <link> tags to make sure you have the right CDN.
  After that, we can look at your code.
  Why do you have $('#myTable').dataTable and $('#myTable').DataTable?

  if(<?php echo $totalRows_rsAutos; ?> >0){ 
      $(document).ready(function(){
           // this is the one you should be using for the latest version of DataTables
           $('#myTable').DataTable( { retrieve: true, scrollY: 600, paging: false, dom: 'Bfrtip',    buttons: [ 'print','copy', 'excel', 'pdf' ] } ); } 
  
• srcargentina Posts: 5Questions: 0Answers: 0

  June 2017

  I copied your code, but it doesnt work.

  ----Why do you have $('#myTable').dataTable and $('#myTable').DataTable?---
  I copied from others examples.... i dont know wich one is the right.
• bindrid Posts: 730Questions: 0Answers: 119

  June 2017

  There is another thing for you to check.
  There are two version of buttons, one intended for older browsers, which uses flash and a version for HTML 5.
  If you are using the older version, you will have buttons:['excel']

  If you are using the newer version, it will be buttons:['excelHtml5'],

  so change your code from 'excel' to 'excelHtml5' and see if that fixes it.
• allan Posts: 63,535Questions: 1Answers: 10,475 Site admin

  June 2017

  i dont know wich one is the right.

  See the top FAQ.

  The page currently has a Javascript syntax error which is going to stop any buttons from being shown.

  Allan
• srcargentina Posts: 5Questions: 0Answers: 0

  June 2017

  I changed excel to excelHtml5 and all the buttoms dessapear, so I roll it back.

  Allan, where is the error? con the jquery.min.js library? Im taking it from the server.... could it have errors?
• allan Posts: 63,535Questions: 1Answers: 10,475 Site admin

  June 2017 edited June 2017

  I can see the print button now. Looks like the JS error has been resolve - perhaps I caught it while you were doing some work on it.

  To get the Excel button you need to include JSZip and the HTML5 export buttons. See the excelHtml5 button type for more info.

  Allan