jQuery UI Widgets Forums Grid Download of exported data and www.jqwidgets.com

This topic contains 14 replies, has 3 voices, and was last updated by  Brett lee 8 years, 10 months ago.

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

  • sdalby
    Member

    I have implemented features to export data in a grid to Excel and CSV.

    I have noted that the download url is stated to be your site. Does this mean that the data is uploaded to your site? I cannot detect any network trafic from the browser !?!

    Working in a bank with very strict policies on confidentiality and having to rely on your servers up time can be a critical issue.

    Thanks in advance
    Søren


    Peter Stoev
    Keymaster

    Hi Søren,

    The data is not stored on our server. In addition, the licensed customers of jQWidgets receive the Server Side files for the exporting so you can host it on your own server.

    Best Regards,
    Peter Stoev

    jQWidgets Team
    http://www.jqwidgets.com


    sdalby
    Member

    Even though they are not saved there are no chance that I will get permission to post data to your server.

    How does the Server Side files distributed fit into an ASP.NET WebForms project?


    Peter Stoev
    Keymaster

    Hi Søren,

    They are PHP files so I don’t know whether that fits to ASP .NET project. We don’t have ASP .NET implementation of these.

    Best Regards,
    Peter Stoev

    jQWidgets Team
    http://www.jqwidgets.com


    sdalby
    Member

    It doesnt fit in at all, I will have to wait for an ASP.NET version, but for now we maybe can use the current feature for techinal data. As a temporary improvement, I suggest that you turn on HTTPS for this.

    Thanks for your swift answer.


    Peter Stoev
    Keymaster

    Hi Søren,

    For now, I am afraid that there are no plans for ASP .NET version of these. In addition, no data is stored on our server and we don’t intend to store any data on it, too. The files are hosted on our server for test purposes only to suit our Online Demos and to show how users should use the feature. However, If you intend to use that for business, better host them on your own server.

    Best Regards,
    Peter Stoev

    jQWidgets Team
    http://www.jqwidgets.com


    sdalby
    Member

    I understand that you dont store it.

    Up until now I have *NOT* understood that the data was send on the internet at all. If I had not discovered this and wrote a program that transmitted customer or account related informaion to your site over the internet, I would be expelled and blacklisted.

    For now our focus are on less sensitive information, but I interprete your latest answer as if I cannot be sure that this feature will be available or my usage of it in a production scenario would be allowed.

    I can understand your position, but I really, really recommend that you state in your demo and documentation, that this feature can only be used by customers using PHP.

    Actually I am now in a delicate position because grids with Excel export was one of my selling points of jqWidgets in my organisation, and now I have to tell that it cannot be used at all.

    This information would have been nice to have initially.

    In a large organization you cannot just setup a PHP installation. You can only use pre-approved technologies based on a Development and Operations Strategy.


    Peter Stoev
    Keymaster

    Hi Søren,

    Well, you can get the exported data locally, too and having it you can do whatever you want with it. You can send it to a server and download it from the browser or something else. So that is not restricted to PHP or any other technology. We also provide an option to set URL and that URL could be anything.

    Here’s how to get the exported data locally:

    var data = $("#jqxgrid").jqxGrid('exportdata', 'xls');  

    Best Regards,
    Peter Stoev

    jQWidgets Team
    http://www.jqwidgets.com


    sdalby
    Member

    Actually, please disregard the discussion about access to your site, because I just realized that the server which runs this solution has no access to the internet at all.

    As damage control: Do you plans to allow users to copy cell or line values in a jqxGrid to the clipboard?


    Peter Stoev
    Keymaster

    Hi Søren,

    The feature is not still in the http://www.jqwidgets.com/roadmap/ so I can’t tell. I will create a work item about that.

    Best Regards,
    Peter Stoev

    jQWidgets Team
    http://www.jqwidgets.com


    sdalby
    Member

    Sorry our last posts overlapped, this sounds interesting and I will investigate the possibilities.

    Do you have any documentation? I could not find anything on exportdata.

    Btw, do you have additional information regarding the quistion on clibboard fetures? One of my users has already pointed out that he could copy/paste from the previous ASP.NET Gridview based picture.


    sdalby
    Member

    Yes, I see: It should be fairly easy to handle it my self on the server 🙂

    Thanks, Peter


    sdalby
    Member

    Hi Peter

    I am almost there. But it appears as if I am using the wrong content-type because Excel shows the xml rather than the formatted content.

    I use: application/vnd.ms-excel

    Is this correct?


    sdalby
    Member

    I have now managed to get it working on my own ASP.NET server.

    Thanks


    Brett lee
    Participant

    Hi jqwidgets team,

    We are very much interested to buy the commercial license of jqwidgets,but the export issue has become the show stopper now. When I export the data of a grid it always go to your site and download the file. I cant see any network traffic but it goes to your site. As a work around you have shown to export the grid data into a local variable and export. Still it shows a popup saying Do You want to save the file from jqueryGrid.net which is not at all acceptable by the clients.
    We cant send our important data to your servers since banks will have high security policy.

    You have your service implementation in PHP which is not supported by our servers.
    Do you have any service implementation in java??

    It would be better if you have notified it prior that you are using a php service hosted on your servers.

    Since it is a UI frame work we might be using different technology stacks at the backend. It would have been graet if you have given this service implementation in all possible and popular technologies.

    Anticipating a faster reply.

    If you dont have a java service,Guide me with sme code or logic which u have done in php so that we may handle it in java.

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

You must be logged in to reply to this topic.