Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to use ServerSideExportEx in AjaxZFC?(in v10 and/or v9)
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
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
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
Hi Les,
I really appreciate the response. Kindly post the response you'll be getting from the QV support.
Thanks,
Arnold
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
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
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
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