Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

EDX Macro

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

46 Replies
Not applicable
Author

Sorry for my english... Before launch the macro on IE9 press the buttons and verify the option...

fosuzuki
Partner - Specialist III
Partner - Specialist III

In IE, go to Internet Options > Security > Local Intranet > Sites > Advanced > Add this site to the zone, indicating the link ot the qv server.

Maybe the IE config is not enabling activeX execution.

Anonymous
Not applicable
Author

i found that the user doesn't has acces to my serveur beceause he doesn't have it on his HOST.

so i modified the server name by the IP, and then i've got this :

ERROR - Copie.jpg

Miguel_Angel_Baeyens

Hi Nassim,

You need to manually create a local group in the QlikView Server computer named "QlikView Management API" and add all users allowed to launch EDX tasks here. As the group is local, you will need to log on to this computer with each of the users so they take full membership of the group and the permissions.

Hope that helps.

Miguel

fosuzuki
Partner - Specialist III
Partner - Specialist III

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)

Miguel_Angel_Baeyens

Hi,

The "QlikView Administrators" local group will allow that user not only to run EDX tasks but to manage the whole QMC as well. I would not add any user that is not actually a Server Manager to this group. The "QlikView EDX" group should work (as it appears in the documentation), but it did not in my V11 SR2 Server (I will test again, though). That's why I'm using the QlikView Management API group, so users can run EDX tasks through the QMS API (as opposed to version 10, that was the QDS API instead).

Best regards.

Miguel

Anonymous
Not applicable
Author

it works perfectly !!!

i juste creat  on my server QLIKVIEW EDX group, and i add my user on it.

Thanks

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi,

i just create edx ,but don't know this edx what will perform do,please explain. my edx file attached in post.Please find out.

Anonymous
Not applicable
Author

Hi Premul,

you're code are fine , except the HOSTNAME,

replace in this part of code the hostname:

C:\>Documents and Settings\QI\Desktop\New Folder\QMSEDX.exe -task="New Folder\Test.qvw" -qms=http://Hostname:4799/QMS/Service -password="quantum"

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi Nassim,

This code what function will do.i run bat,only popup command line ,no update in qlikview file.