Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gandalfgray
Specialist II
Specialist II

ServerSideExportEx in AjaxZFC?

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

8 Replies
ljhowell
Contributor III
Contributor III

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

Not applicable

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

ljhowell
Contributor III
Contributor III

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

Not applicable

Hi Les,

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

Thanks,

Arnold

ljhowell
Contributor III
Contributor III

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 vFileNamelet vFileName='D-'&Replace(Replace(Now(),'/','-'),':','-')&'.xls';

I hope this helps. 

Les

Not applicable

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

ljhowell
Contributor III
Contributor III

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

ljhowell
Contributor III
Contributor III

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