topic ServerSideExportEx in AjaxZFC? in QlikView

ServerSideExportEx in AjaxZFC?

gandalfgray — Mon, 26 Jan 2026 18:19:17 GMT

Is it possible to use ServerSideExportEx in AjaxZFC?(in v10 and/or v9)

ServerSideExportEx in AjaxZFC?

ljhowell — Wed, 29 Jun 2011 19:52:26 GMT

Yes

See code macro code. Also works in iPad.

Sub ServerExportEx
Set st = ActiveDocument.GetSheetObject("T100")
st.ServerSideExportEx "G:\QlikView\Downloads\Projects\sjb1001_project.xls" , ";" ,0
End Sub

Re: ServerSideExportEx in AjaxZFC?

Wed, 09 May 2012 05:02:14 GMT

Hi Les,

I want to export the sheet object to csv file and tried your code but it didn't work on the AJAX/Accesspoint.

But the code works if I test the macro while the file is not yet published.

"Macro parsed failed. Functionality was lost."

I'm using Qlikview 11.

Kindly help on this.

Thanks,

Arnold

ServerSideExportEx in AjaxZFC?

ljhowell — Wed, 09 May 2012 13:16:10 GMT

Hello

We are using QV 10, not 11. If it does not work for QV 11, then we are in trouble here. We cannot move forward to the new version. I will reach out to QV support on this.

Les

ServerSideExportEx in AjaxZFC?

Fri, 11 May 2012 01:03:31 GMT

Hi Les,

I really appreciate the response. Kindly post the response you'll be getting from the QV support.

Thanks,

Arnold

ServerSideExportEx in AjaxZFC?

ljhowell — Fri, 11 May 2012 15:42:01 GMT

Hello

I have tested on QV 11 and seems to work Ok.

Here is our Macro

Sub ExportExcel
Set st = ActiveDocument.GetSheetObject(ActiveDocument.Variables("vExportSheet").GetContent().String)
st.ServerSideExportEx ActiveDocument.Variables("vQlikviewPath").GetContent().String & ActiveDocument.Variables("vFileName").GetContent().String , ";", 5
End Sub

The variable 'vExportSheet' contains the Chart Object Id. Example: 'SAL01'

The variable 'vQlikviewPath' contains the path to a folder on the server where the document will be stored.

Example; \\cinnamon\files_qv\ (note: the path needs to be a network path and the folder needs shared and Read/Write access. So 'cinnamon' is our Server name and 'files_qv' is the folder where the documents are stored. In this case, and Excel document.

The variable 'vFileName' is the filename.

To keep documents unique for each User on the iPad,I use this format for vFileName: let vFileName='D-'&Replace(Replace(Now(),'/','-'),':','-')&'.xls';

I hope this helps.

Les

Re: ServerSideExportEx in AjaxZFC?

Mon, 14 May 2012 07:27:57 GMT

Hi Les,

Thanks for the reply and sample code. Did you try to export the object to csv file?

I don't have problems exporting the objects to xml, html and xls but when i try to export it on CSV the code doesn't work on AJAX/Access Point.

Below is the code I'm using:

sub ServerSideExportToCSV

set graphObject = ActiveDocument.GetSheetObject("TB01")

graphObject.ServerSideExportEx "\\arnold-pc\Temp\TB01.csv",",",1

end sub

Kindly help check if this code works for you.

Regards,

Arnold

Re: ServerSideExportEx in AjaxZFC?

ljhowell — Wed, 23 May 2012 14:44:04 GMT

Hello Arnold

Well, I confirmed that the text file export does not work for .txt or .csv using parameter 1 at the end.

I have confirm that is works with 3 and 5 (XML and XLS) formats.

What is wrong with Qlikview about taking away functionality that works in QV 10???

I have alerted our VAR about this but don't know if there is any resolution. We are now trying to see if we can import data with XML instead of csv format.

Maybe you can complain as well.

Les

ServerSideExportEx in AjaxZFC?

ljhowell — Thu, 31 May 2012 13:17:48 GMT

Hello Arnold

Our software vendor says they can import data from XML as well as csv. Since QV11 now only supports XML and XLS formats, we are good to go with QV 11 on this ServerSideExportEX function with our mobile users on iPads.

Maybe you can use XML instead.

Les