Replies

• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  January 2013

  With server-side processing, all the processing is done at the server :-). So it would be up to the server to read the file, process it, filter rows, sort them etc. You'd need to fully implement the protocol described here: http://datatables.net/usage/server-side . How exactly you do that will be highly dependent on your server-side environment.
  
  Allan
• HarryHogg Posts: 3Questions: 0Answers: 0

  January 2013 edited January 2013

  Hi Allan, once again thanks for such a great plugin. I think I might have been wrong with trying to look at this from a server-side processing view and even with an ajax source. But have managed to get it working with dataTable reading directly from the DOM and have the table created before hand. This might not be the best solution but for me was the easiest to set up. I'll add what I found below just incase someone else come across the same problem.
  
  I first added a CSV file to the DOM in a table using the csv2table plugin.
  
  [code]$("#ID").csv2table('CSVSource.csv');[/code]
  
  However to get this to work I had to modify the original plugin to add in a section and to remove all unnecessary styling.
  
  Next set dataTables to read directly from the DOM table.
  
  [code]
  setTimeout(function() {
  $('#ID table').dataTable( {
  "fnDrawCallback": function(){$('#ID').animate({opacity:1})}
  });
  },200);
  [/code]
  
  Adding a setTimeout is needed as it allows the csv2table to finish, I think csv2table does have an on complete callback but I haven't looked into it yet.
  
  Thanks
  
  Harry
• HarryHogg Posts: 3Questions: 0Answers: 0

  January 2013 edited January 2013

  EDIT-------
  There is an onload function in csv2table so the setTimeout is no longer needed.
  
  [code]
  $("#ID").csv2table('CSVSource.csv',{
  onload : function(){Initialise dataTable here}
  });
  [/code]
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  January 2013

  Sounds like a good solution :-)
  
  Allan