topic Re: EDX Macro in QlikView

EDX Macro

Anonymous — Thu, 18 Oct 2012 08:40:50 GMT

Hi,

I'm trying to execute a EDX macro via a button with this script :

Sub RefreshEdx()
set shl = createobject("wscript.shell" )
shl.run "cmd  /c \\xdwhqview01b\QlikView\Test\QMSEDX.exe -task=Test\B.qvw -password=test"
End Sub

but it doesn't work ?? did i something wrong ?

thanks

Re: EDX Macro

Thu, 18 Oct 2012 11:35:03 GMT

Try this one:

Sub Reload_data

    Dim strTaskPassword
    Dim strTaskName
    Dim strCommand
    Dim strServer
    Dim strEDX

    strEDX = "<path to QMSEDX.exe>\QMSEDX.exe"
    strServer = "http://<qlikview server name>:4799/QMS/Service"
    strTaskName = "<file qvw>"
    strTaskPassword = ""

    strCommand = strEDX & " -task=" & Chr(34) & strTaskName & Chr(34) & " -qms=" & Chr(34) & strServer & Chr(34) & " -password=" & Chr(34) & strTaskPassword & Chr(34)

     Set WshShell = CreateObject("WScript.Shell")
     Call WshShell.Run(strCommand,0,False)

     MsgBox ("L'aggiornamento del documento " & strTaskName & " è iniziato.")

End Sub

Re: EDX Macro

Anonymous — Tue, 23 Oct 2012 12:47:29 GMT

nothing's happening

(2012-10-23 14:50:51) Error: The task "EDX Reload and Distribute of Finance Reporting\GoldenRule - Copy.qvw" failed. Exception:

(2012-10-23 14:50:51) Error: QDSMain.Exceptions.CommandLineIsEmptyException: Command line is empty.

(2012-10-23 14:50:51) Error: at QDSMain.ExternalProgramTask.Execute(TaskResult taskResult)

(2012-10-23 14:50:51) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

Re: EDX Macro

Tue, 23 Oct 2012 13:36:26 GMT

Have you checked the flags of the macro editor form?

You have to set the flags like the picture...

Re: EDX Macro

Anonymous — Wed, 24 Oct 2012 12:38:18 GMT

yep !

Re: EDX Macro

Wed, 24 Oct 2012 13:55:45 GMT

Try to execute the macro command trough the windows command line (see the attachment). It works?

Do you use QMSEDX.exe with QMSEDX.exe.config?

Re: EDX Macro

Anonymous — Thu, 25 Oct 2012 12:28:04 GMT

when i did this from my server it works perfectly, but when i tried from my desk it doesnt work.

know that the QMSEDX is correctly shared.

Re: EDX Macro

Thu, 25 Oct 2012 14:59:14 GMT

Can you show me the error when you try to execute the command from the shell (CLI) of your desk?

Re: EDX Macro

Anonymous — Thu, 25 Oct 2012 15:13:53 GMT

i've .net 4.0 on my desk !!!!

Re: EDX Macro

fosuzuki — Thu, 25 Oct 2012 15:32:56 GMT

In your desk, how are you accessing the app with the macro? IE Plugin, QV Desktop or AJAX?

Re: EDX Macro

Anonymous — Thu, 25 Oct 2012 15:35:30 GMT

ie plugin, i turned on the qvtunnel for that

Re: EDX Macro

fosuzuki — Thu, 25 Oct 2012 15:48:23 GMT

As far as I know, this QMSEDX.exe tool has to have a QMSEDX.exe.config file in the same folder. Do you have it?

Re: EDX Macro

Anonymous — Thu, 25 Oct 2012 15:50:13 GMT

in the same folder of my QVW ??

Re: EDX Macro

fosuzuki — Thu, 25 Oct 2012 16:09:38 GMT

In the same folder as the QMSEDX.exe.

I suppose you don't have it, so I'm attaching it to this post.

In it, you just have to adjust the part:

<endpoint address="http://HOSTNAME:4799/QMS/Service" binding="basicHttpBinding"

bindingConfiguration="BasicHttpBinding_IQMS" contract="QMSAPI.IQMS"

name="BasicHttpBinding_IQMS"/>

<endpoint address="http://HOSTNAME:4799/ANY/Service" binding="basicHttpBinding"

bindingConfiguration="BasicHttpBinding_IQTService" contract="QMSAPI.IQTService"

name="BasicHttpBinding_IQTService" />

</client>

replacing the HOSTNAME with your server's name.

Re: EDX Macro

Fri, 26 Oct 2012 06:11:32 GMT

Try to add the permission to the folder that contains the QMSEDX.exe files to EVERYONE (see the attached image).

Re: EDX Macro

Anonymous — Fri, 26 Oct 2012 07:53:43 GMT

Hi all,

Unfortunetly i had this file

@capetto : when i added a permission to everyone i get this :

Re: EDX Macro

Anonymous — Fri, 26 Oct 2012 09:48:23 GMT

Guys it work's

i just forgot the -qms="SERVER" in my commande line !!!

Thanks for your help and your time.

what i did to work :

-> Shared the QMSEDX.EXE to everyone @capetto

-> Modify the QMSEDX.exe.config @Fernando Suzuki

-> used the script given by @capetto

Re: EDX Macro

Anonymous — Fri, 26 Oct 2012 13:21:04 GMT

guys it works under IE8.0 but not under IE9.0.

the message :

?????

Re: EDX Macro

Fri, 26 Oct 2012 13:32:47 GMT

Check your local macro permission pressing CTRL+SHIFT+M on your keyboard and verify that the first option is selected:

Re: EDX Macro

Anonymous — Fri, 26 Oct 2012 13:36:39 GMT

it's ok for local macro permission.

i've hot this message under IE9.0 trying to lunch the macro.