topic Re: Export CSV file via AJAX client in QlikView

Export CSV file via AJAX client

googel84 — Tue, 31 May 2016 09:18:18 GMT

Hi there, is there a way to automate the Export... function which is available through the following contextual menu of a chart in an application published through the Access Point?

In other words, is possibile to set up a button which does the same as the Export... command?

Thnaks

Re: Export CSV file via AJAX client

jerrysvensson — Tue, 31 May 2016 10:33:11 GMT

You can do a ServerSideExport using a macro. Although that file will end up on the server.

Have a look in the APIguide (search the forum for it)

Re: Export CSV file via AJAX client

googel84 — Tue, 31 May 2016 10:37:24 GMT

Hi, thanks for the quick reply.

I have already tried that but it seemed not to be working once put on the access point.

In addition, the ideal result would be to automatically download the file, instead of putting it in a shared drive.

Thanks anyway.

Re: Export CSV file via AJAX client

Peter_Cammaert — Tue, 31 May 2016 10:42:05 GMT

You can use the Excel icon in the caption of your chart/table.

Exports to HTML, not CSV. But to Excel that's almost the same.

Peter

Re: Export CSV file via AJAX client

googel84 — Tue, 31 May 2016 10:45:14 GMT

Actually I shoudl have cleared it at the beginning.

The problem is the number of columns to export: when you export to Excel, there is a limit of 256 (or so); when you export to csv, there is no limit (or, at least it is much higher then 256).

Thanks anyway.

Re: Export CSV file via AJAX client

jerrysvensson — Tue, 31 May 2016 10:48:14 GMT

It should work, I use it myself.

Put the file on a local path on your QlikView server to test.

Re: Export CSV file via AJAX client

bindu_apte — Tue, 31 May 2016 10:51:15 GMT

Hi,

I am using one application where I used to click on button and it will export to excel.

If you are using Ajax then you need to install IE plugin. Through IE it will work fine.

Re: Export CSV file via AJAX client

googel84 — Tue, 31 May 2016 10:53:19 GMT

Thanks, but the IE plugin is not an option for us and I guess the limit on the number of columns you can export would be still there.

Thanks anyway.

Re: Export CSV file via AJAX client

ashokamp — Mon, 20 Jun 2016 01:35:43 GMT

Hi Alberto,

Do you got the solution?CSV export using a button. Kindly let me know the solution. I have a same scenario here.

Thanks

Ashok

Re: Export CSV file via AJAX client

googel84 — Mon, 20 Jun 2016 06:55:08 GMT

Unfortunaterly no... The client accepted the "Right-click-and-Export"solution and we did not go any further.

Re: Export CSV file via AJAX client

ashokamp — Mon, 15 Aug 2016 02:18:19 GMT

Hi Alberto,

Thanks. But here "Right-click-and-Export" also exports into QVSclientView.aspx.

Could you please let me know do I need to change any settings in server?

Thanks

Re: Export CSV file via AJAX client

googel84 — Wed, 17 Aug 2016 20:49:52 GMT

There are a couple of settings but, as far as I know, these options are enabled by default.

Setup > Select yours server > Documents > Allow Print and Export to Excel

Documents > User Documents > Select each document > Print and Export to Excel / All Users

Hope it helps.