13 Replies Latest reply: Aug 14, 2012 10:59 PM by yongsl83 RSS

EDX trigger with QVS API

Henrik Matz

Since QV 11 no longer aupports "http EDX" im looking for an example in VBScript to start an EDX trigger with the QVS API.

 

I can only find examples in C#, but i need to write it in vbScript.

 

Henrik

  • Re: EDX trigger with QVS API
    Arthur Lee

    Hi Henrik,

     

    I don't have a vbScript example but see this document:  http://community.qlik.com/docs/DOC-2650.  I has some sample code (.net) to go along with it - easiest to write it in .net.

     

    Arthur

    • EDX trigger with QVS API
      Henrik Matz

      Thanks,

       

      but i cannot find anything written in vbScript in the enclosed.

       

      And my skills are zero in .net and c#.

    • EDX trigger with QVS API
      Jerry Svensson

      Hi

      Many of our customers use EDX to start a reload when they run an application in plugin.

      Now we achieve this with a macro in the application.

      Will this be possible to do in version 11?

    • EDX trigger with QVS API
      Arthur Lee

      Henrik,

       

      If you can compile the code then it can be used with VBS.  We are working on getting working samples up on the community.

       

      Arthur

      • EDX trigger with QVS API
        John Witherspoon

        I don't know if it's directly relevant as I haven't fiddled with it, but Rob Wunderlich's download page (http://robwunderlich.com/downloads/) has a file REQUESTEDX, described as a "VBS script to trigger a Qlikview task from the command line."

        • EDX trigger with QVS API
          Arthur Lee

          Rob's code will not work in v11 since we aren't supporting the http post method of triggering EDX and EDX is triggered through the QMS API not through a single QDS.

          • EDX trigger with QVS API
            Chi Hang Wong

            Hi Arthur,

             

            Will they any step / documentation on the EDX trigger through QMS API?

             

            I am already following the steps and using the command in the post : http://community.qlik.com/docs/DOC-2650

             

            But I cannot run the command through the access point while it only succeed in the qlikview client.

            • EDX trigger with QVS API
              yoavgeva

              Hi,

               

              I solved this issue like this:

              1. I downloaded the QMSEDX from the resources on the site (linked above).

              2. Using this macro, I was able to run it from the access point:

               

               

              sub QmsEdxCmd

                        dim strTaskName

                        dim strTaskPassword

                        dim strServer

                        dim strCommand

               

               

                        strTaskName= ActiveDocument.Variables("vTask").GetContent.String

                        strTaskPassword= ActiveDocument.Variables("vPassword").GetContent.String

                        strServer = "http://qvpublish:4799/QMS/Service"

                        strCommand = "\\qvdev\QMSEDX\qmsedx.exe -task="&strTaskName&" -qms="&strServer&" -password="&strTaskPassword

               

                        Set WshShell = CreateObject("WScript.Shell")

                        Return = WshShell.Run (strCommand,0,false)

               

              end sub 

               

              Hope it helps

              • EDX trigger with QVS API
                Chi Hang Wong

                Hi yoavgeva,

                 

                Yes, I do the same way as you.

                 

                And from QlikTech's feedback, this is the only way to handle EDX trigger in QV 11.

                 

                By the way, the task name shoud be the qvw name instead of the reload task name.

                • EDX trigger with QVS API
                  Marcel Hug

                  We are using this too:

                   

                  sub QmsEdxCmd

                            dim strTaskName

                            dim strTaskPassword

                            dim strServer

                            dim strCommand

                   

                   

                            strTaskName= ActiveDocument.Variables("vTask").GetContent.String

                            strTaskPassword= ActiveDocument.Variables("vPassword").GetContent.String

                            strServer = "http://qvpublish:4799/QMS/Service"

                            strCommand = "\\qvdev\QMSEDX\qmsedx.exe -task="&strTaskName&" -qms="&strServer&" -password="&strTaskPassword

                   

                            Set WshShell = CreateObject("WScript.Shell")

                            Return = WshShell.Run (strCommand,0,false)

                   

                  end sub 

                   

                  and it works with the IEPlugin, However it does not work with the AJAX interface. Any ideas? Thx.

                  • EDX trigger with QVS API
                    Fernando Suzuki

                    Hi hugmarcel,

                     

                    I tried to use your vbscript code with AJAX and it didn't work as you said. But then I changed the shared folder path with the server's local folder path:

                     

                    strCommand = "\\qvdev\QMSEDX\qmsedx.exe....

                    to

                    strCommand = "c:\QMSEDX\qmsedx.exe....

                     

                    and now it is working! Tested in Chrome, IE (ajax mode), and also iPad's Safari!!

                     

                     

                     

                    Hope this helps you

                    Regards

                    Fernando

                  • Re: EDX trigger with QVS API
                    yongsl83

                    Hi hugmarcel,

                     

                    Seems like we need to put the exe file into the shared folder in order for the script to run on the client side. What if my production server is in DMZ zone? I can't just shared the folder to the public.

                     

                    Thanks and Regards,

                    YSL

  • EDX trigger with QVS API
    Henrik Matz

    Thanks John and Arthur,

     

    The script from Rob will not work in QV11 because it use port 4720 (QDS).

     

    I like the idea about making an example, cause i think we are a few that needs the feature.

     

    Henrik