EDX refresh from Access Point

[#1]

Hello,

My another problem with QlikView after upgrade from version 9 to 11 is forcing EDX refresh to work. Several of our Qlikview 9 reports had a button, available for specific users on Access Point, which their clicked and forced report refresh.

Macro is no longer working on QV 11. I did my research, found that now QMSEDX console is used to do that. But I can't get it to work.

I use below macro:

Sub Reload_data

    Dim strTaskPassword
    Dim strTaskName
    Dim strCommand
    Dim strServer
    Dim strEDX

    strEDX = "D:\EDXConsole\QMSEDX.exe"
    strServer = "http://my_server:4799/QMS/Service"
    strTaskName = "Report Task name"
     strTaskPassword = "QVEDX"

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

    ActiveDocument.Variables("vEDXpath").SetContent strCommand,true

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

     MsgBox ("Refresh of " & strTaskName & " started.")
End Sub

It works fine, when report is opened directly on server, but it does not work on Access Point.

How can I get this to work?

BR,

Kuba

[Anonymous]

There is no need for macro.  I use actions.  Here is what I used as a guideline: http://community.qlik.com/docs/DOC-2650

[stevedark]

I would recommend a look at Stefan Walther's solution that he has documented here:

http://www.qlikblog.at/2321/qliktip-47-reloading-qlikview-documents-using-the-ajax-mobile-client-tri...

Steve

[#4]

Hello Michael,

Can you please provide any sample code that works for you on Access Point?

BR,

Kuba

[Anonymous]

Kuba,

There is no code.

First, you create a .bat file (let call it EDXRefresh.bat for now) which contains, in your case, this:

D:\EDXConsole\QMSEDX.exe -task="Report Task name" -password=QVEDX -qms="http://my_server:4799/QMS/Service"

(Notice that it is the result of the strCommand in your macro above)

Next, create a button with action Launch, and application EDXRefresh.bat with its full path, for example

\\MachineName\...\EDXRefresh.bat

Make sure this location is available to all users who are allowed to use this button.

Regards,

Michael

[qvusersandra]

Hi Michael,

if I try executing the .bat from my pc I get a "path not found". In commandline there is "W:\>C:\...\qmsedx.exe.

"W:" is the location on qlikview-server available to all users.

Any ideas?

Regards,

Sandra

[Anonymous]

Sandra,

Try to use UNC address instead of the mapped W-drive, as in my response above.

Regards,

Michael

[qvusersandra]

Thanks, now it works!

Regards,

Sandra