Data export from my site running though yours!?

[MatthewVParticipant]

I am working on a financial report for my company and they need it exported to excel. I added the data.export.js file and wired it up. When I ran it to test it sat for a while then I got the following error:

Request Entity Too Large
The requested resource
/subfolder1/export_server/dataexport.php
does not allow request data with POST requests, or the amount of data provided in the request exceeds the capacity limit.

Apache Server at jquerygrid.net Port 80

From the website http://jquerygrid.net/export_server/dataexport.php

Why is my data being transferred to your site for processing?
How do I prevent my data from being moved to your site and instead do all processing on my servers?

[DimitarParticipant]

Hello MatthewV,

This is the default export setting. If you have purchased a Developer or an Enterprise License, you have access to the file dataexport.php along with the jQWidgets source code (from the jQWidgets Client Portal). You can host dataexport.php on your server and, when setting up your data table, pass the path to the file as the serverURL field of the exportSettings property/object, e.g.:

$("#dataTable").jqxDataTable({
  exportSettings: {
    columnsHeader: true,
    hiddenColumns: false,
    serverURL: 'http://www.myserver.com/dataexport.php',
    characterSet: null,
    recordsInView: true,
    fileName: "jqxDataTable"
  }
});

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[fewrParticipant]

This is a miserable behavior!
It’s an absolutely No-Go to spy us by default!

At least you should create *export example* a hint with big red letter that jQWidgets scrape our data.

BTW: jQWidgets is such a good product that my company purchased a license.
But since today I’ll not recommend jqwidgets anymore.

[Peter StoevKeymaster]

Hi fewr,

The Behavior is explained in the Documentation. Also you as a developer should read the documentation before using API!

This is what’s written there:

Exports all rows loaded within the Grid to Excel, XML, CSV, TSV, HTML or JSON.

The first parameter of the export method determines the export’s type – ‘xls’, ‘xml’, ‘html’, ‘json’, ‘pdf’, ‘tsv’ or ‘csv’.
The second parameter is the file’s name. If you don’t provide a file name, the Grid will export the data to a local variable.
For example:
var data = $(“#jqxgrid”).jqxGrid(‘exportdata’, ‘json’);

The third parameter is optional and determines whether to export the column’s header or not. Acceptable values are – true and false. By default, the exporter exports the columns header.
The fourth parameter is optional and determines the array of rows to be exported. By default all rows are exported. Set null, if you want all rows to be exported.
The fifth parameter is optional and determines whether to export hidden columns. Acceptable values are – true and false. By default, the exporter does not export the hidden columns.
The sixth parameter is optional and determines the url of the export server. By default, the exporter is hosted on a jQWidgets server.
The last parameter is optional and determines the char set.
Parameter Type
dataType String
fileName(optional) String
exportHeader Boolean
rows Array
exportHiddenColumns Boolean
serverURL String
charSet String

Read the Text in BOLD.

So no one spies. The Export requires a Server and we have a file hosted for EVAL purposes only. If you did not read what you use, then that is not our problem.

Best Regards,
Peter Stoev

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

[nelsowiParticipant]

If 3 people hit the export button, do they all attempt to use the same file at that url at the same time?

[Peter StoevKeymaster]

Hi nelsowi,

Hitting the Export button makes a Form postback with your unique data which the server file just turns into a downloadable file. But, you should Never use a file hosted for evaluation purposes. The file on our server is just to demonstrate our software and for commercial apps, you should host it somewhere and use the hosted file for data export.

Best Regards,
Peter Stoev

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

[Author]

Posts