EDX Macro

[Anonymous]

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

[#2]

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]

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)

[#4]

Have you checked the flags of the macro editor form?

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

[Anonymous]

yep !

[#6]

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]

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.

[#8]

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

[Anonymous]

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

[fosuzuki]

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