How to use extension to export from access point on the server?

[#1]

I have a task to export the results of filters to a csv file on a drive on the qlikview server.  The file would be too large for the client's machine.  I am looking at an Export Action (no success), a VBScript (no success) and I am looking at a document extension and need help in creating a simple export object to csv.  The filename is fixed.

[Clever_Anjos · Accepted solution]

Maybe this piece of code can help you

set tb = ActiveDocument.GetSheetObject("CH01")

tb.ServerSideExportEx "C:\[A Shared Folder]\test.csv" , ";" , 1 '0=HTML, 1=Text, 2=Bitmap, 3=XML, 4=QVD, 5=BIFF

This exports your file into your server (or a shared drive)

[#3]

Thanks, this was a great help and solved the problem.

On Thu, Jan 22, 2015 at 5:28 PM, Clever Anjos <qcwebmaster@qlikview.com>

[#4]

very helpful thank you.

unfortunately this is only working within the full client.

Is there any chance to write the file from an access point session?

[Clever_Anjos]

I don´t think so, oliver...

This is one of main limitations of macros across Ajax client.

If you´re using IE plugin, everything should run smoothly

[#6]

In addition to the above code for serversideexport you also need to change the module from safe mode to allow system access