Unable to export Data

[durianParticipant]

Hi have function to export data from grid into CSV file. It is working fine at my local environment, but unfortunately it is not working when I deployed it into server. When I clicked the button, nothing happen. Is it related to firewall or browser?

$(“#btnExport”).click(function () {
var exportInfo;
exportInfo = $(“#searchResultGrid”).jqxGrid(‘exportdata’, ‘csv’);
}

Thank you,
Hidayah

[svetoslav_borislavovParticipant]

Hi,

Can you please try using the exportview method?
Here is an example: http://jsfiddle.net/g59oLp8v/

NOTE that you need to import additional files:
jszip.min.js and jqxexport.js

I hope this helps you!

Best regards,
Svetoslav Borislavov

jQWidgets Team
https://www.jqwidgets.com/

[durianParticipant]

Do I need to import any library? Currently it shows this error message

[durianParticipant]

I found why this code below is not working because my website have secure ssl, but this http://jquerygrid.net/export_server/dataexport.php don’t have secure ssl. Any advise?

$(“#btnExport”).click(function () {
var exportInfo;
exportInfo = $(“#searchResultGrid”).jqxGrid(‘exportdata’, ‘csv’);
}

Thank you

[durianParticipant]

I manage to solve this issue, just need to include this:

<script src=”~/Scripts/jqwidgets/jqxexport.js” type=”text/javascript”></script>
.
.
.
$(“#btnExport”).click(function () {
$(“#searchResultGrid”).jqxGrid(‘exportview’, ‘csv’, “ListName”);
});

But my CSV format have double quotes example:
“First Name”,”Last Name”,”Date”,”Address 1″, “Address 2”

My expectation is like this example:
First Name,Last Name,Date,Address 1,Address 2

Any advise? Thank you.

[svetoslav_borislavovParticipant]

Hi,

Here is a workaround for that: http://jsfiddle.net/a2o3b9kh/
If you do not pass a fileName to the exportdata method, the data will be exported to a local variable.
When you have the data in a variable as a string you can manually download the CSV file

Best regards,
Svetoslav Borislavov

jQWidgets Team
https://www.jqwidgets.com/

[durianParticipant]

Hi

Thank you, finally issue solved

[Author]

Posts