jQuery UI Widgets Forums DataTable Data export from my site running though yours!?

This topic contains 5 replies, has 5 voices, and was last updated by  Peter Stoev 3 years, 1 month ago.

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author

  • MatthewV
    Participant

    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?


    Dimitar
    Participant

    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/


    fewr
    Participant

    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 Stoev
    Keymaster

    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/


    nelsowi
    Participant

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


    Peter Stoev
    Keymaster

    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/

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.