Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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
Anonymous
Not applicable
Author

ie plugin, i turned on the qvtunnel for that

fosuzuki
Partner - Specialist III
Partner - Specialist III

As far as I know, this QMSEDX.exe tool has to have a QMSEDX.exe.config file in the same folder. Do you have it?

Anonymous
Not applicable
Author

in the same folder of my QVW ??

fosuzuki
Partner - Specialist III
Partner - Specialist III

In the same folder as the QMSEDX.exe.

I suppose you don't have it, so I'm attaching it to this post.

In it, you just have to adjust the part:

        <client>

            <endpoint address="http://HOSTNAME:4799/QMS/Service" binding="basicHttpBinding"

                bindingConfiguration="BasicHttpBinding_IQMS" contract="QMSAPI.IQMS"

                name="BasicHttpBinding_IQMS"/>

            <endpoint address="http://HOSTNAME:4799/ANY/Service" binding="basicHttpBinding"

                bindingConfiguration="BasicHttpBinding_IQTService" contract="QMSAPI.IQTService"

                name="BasicHttpBinding_IQTService" />

        </client>

replacing the HOSTNAME with your server's name.

Not applicable
Author

Try to add the permission to the folder that contains the QMSEDX.exe files to EVERYONE (see the attached image).Immagine.jpg

Anonymous
Not applicable
Author

Hi all,

Unfortunetly i had this file

@capetto : when i added a permission to everyone i get this :Capture.PNG

Anonymous
Not applicable
Author

Guys it work's

i just forgot the -qms="SERVER" in my commande line !!!

Thanks for your help and your time.

what i did to work :

-> Shared the QMSEDX.EXE to everyone @capetto

-> Modify the QMSEDX.exe.config @Fernando Suzuki

-> used the script given by @capetto

Anonymous
Not applicable
Author

guys it works under IE8.0 but not under IE9.0.

the message :

Capture.PNG

?????

Not applicable
Author

Check your local macro permission pressing CTRL+SHIFT+M on your keyboard and verify that the first option is selected:

Immagine.jpg

Anonymous
Not applicable
Author

it's ok for local macro permission.

i've hot this message under IE9.0 trying to lunch the macro.