topic Re: EDX refresh from Access Point in QlikView

EDX refresh from Access Point

Mon, 03 Mar 2014 08:33:54 GMT

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

Re: EDX refresh from Access Point

Anonymous — Mon, 03 Mar 2014 20:17:11 GMT

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

Re: EDX refresh from Access Point

stevedark — Mon, 03 Mar 2014 20:30:11 GMT

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-triggering-edx-tasks-by-using-a-qlikview-extension/

Steve

Re: EDX refresh from Access Point

Tue, 04 Mar 2014 06:10:21 GMT

Hello Michael,

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

BR,

Kuba

Re: EDX refresh from Access Point

Anonymous — Tue, 04 Mar 2014 13:31:05 GMT

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

Re: EDX refresh from Access Point

qvusersandra — Fri, 22 Aug 2014 13:26:39 GMT

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

Re: EDX refresh from Access Point

Anonymous — Mon, 25 Aug 2014 15:07:07 GMT

Sandra,

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

Regards,

Michael

Re: EDX refresh from Access Point

qvusersandra — Mon, 06 Oct 2014 11:13:15 GMT

Thanks, now it works!

Regards,

Sandra