Server Side - Export to CSV
Server Side - Export to CSV
Caldaga
Posts: 24Questions: 6Answers: 0
I'm working on exporting to CSV with server side processing. I created the following custom button:
{
text: 'Export to CSV',
action: function ( e, dt, node, config ) {
var data = table.ajax.params();
str = JSON.stringify(data);
$.ajax({
type: 'POST',
url: 'exporttocsv.php',
data: {json: JSON.stringify(json_data)},
dataType: 'json'
});
}
}
For some reason when I press this button exporttocsv.php doesn't open. This button results on results.php which is in the same directory as exporttocsv.php. If I type in the full url to exportocsv.php it comes up just fine. Any ideas?
This discussion has been closed.
Answers
That's an interesting button
Had to check it out myself and built this example:
http://live.datatables.net/zepisile/1/edit
I'm not sure what
json_datais so I changed it to data. In my case the button performs a post toexporttocsv.phpwith the table ajax parameters. It fails with 403 Forbidden. Of course I don't have that script and expected a 404 but the Datatables JS BIN environment responds with 403. If I change the URL to/ssp/server_processing.php, which is different than the original AJAX URL, I get a 200 response with the JSON data.What are you expecting to happen?
Are you expecting a new page or table to open?
Kevin
Right now my initial goal is to get exporttocsv.php to open a new page and this is the code in the php file:
```
<?php > ``` ?><html>
<?php
data = json_decode($_POST['json']);
echo var_dump(data);
Once I get the data over there and can see what format its in and how to access it I will get rid of the html and end up building a SQL query to create a CSV and download it to the client.
I don't think an AJAX request will open a new window. But you might be able to see what you want by using the browser's developer tools and looking at the Network tab. I can see what's returned from server_processing.php in my example above.
Kevin