Solved: Re: EDX Macro - Qlik Community

Anonymous · ‎2012-10-18

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

fosuzuki · ‎2012-10-29

Did you include the user to the 'QlikView Administrators' or 'QlikView EDX' local server group?

"The user making the request calls must be a member of the QlikView Administrators local group or the QlikView EDX local group. The QlikView Administrators group is set up during the installation of QlikView Server, but the QlikView EDX group must be created manually in Computer Management." (QV Server Reference Manual, page 119)

View solution in original post

Report Inappropriate Content · ‎2012-10-18

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

Anonymous · ‎2012-10-23

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)

Report Inappropriate Content · ‎2012-10-23

Have you checked the flags of the macro editor form?

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

Anonymous · ‎2012-10-24

yep !

Report Inappropriate Content · ‎2012-10-24

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?

Anonymous · ‎2012-10-25

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.

Report Inappropriate Content · ‎2012-10-25

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

Anonymous · ‎2012-10-25

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

fosuzuki · ‎2012-10-25

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