8 Replies Latest reply: May 31, 2012 9:17 AM by Les Howell RSS

    ServerSideExportEx in AjaxZFC?

    Goran Korsgren

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

        • ServerSideExportEx in AjaxZFC?
          Les Howell

          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?
              Arnold Ayaoan

              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?
                  Les Howell

                  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?
                      Arnold Ayaoan

                      Hi Les,

                       

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

                       

                      Thanks,

                      Arnold

                        • ServerSideExportEx in AjaxZFC?
                          Les Howell

                          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

                            • Re: ServerSideExportEx in AjaxZFC?
                              Arnold Ayaoan

                              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?
                                  Les Howell

                                  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?
                                      Les Howell

                                      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