Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)
Thanks, this was a great help and solved the problem.
On Thu, Jan 22, 2015 at 5:28 PM, Clever Anjos <qcwebmaster@qlikview.com>
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?
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
In addition to the above code for serversideexport you also need to change the module from safe mode to allow system access