Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

QV10 Ajax Mode - VB Script

We are planning to switch to web view(AJAX) in QV10. However there is a VBScript macro in our QV 8.5 documents. When enabling AJAX view for these documents, the scripts(macros) are not working. Is this because the AJAX mode does not support VBScript or do we need to rewrite the script in any other language? If anyone has a workaround, please let us know.

Thanks!

Murali

Tags (3)
Labels (1)
10 Replies
pablolabbe
Valued Contributor II

QV10 Ajax Mode - VB Script

Unfortunatelly, macros are not supported in Ajax / Web View. You need to redesign the way you intereract with the document.  Maybe you can do something with javascript.

Good Luck.

jerrysvensson
Valued Contributor II

QV10 Ajax Mode - VB Script

Hi

Macros doesn't work in WebView mode in Developer.

However if you publish your app on the server macros will work when you use Ajax to view your app.

erich_shiino
Honored Contributor

QV10 Ajax Mode - VB Script

In QV 10 you can replace some macro codes by actions (they do work on Ajax, right?)

Then, if you describe your macros we may be able to find some actions (or even other ways) to implement it

Regards,

Erich

jerrysvensson
Valued Contributor II

QV10 Ajax Mode - VB Script

Macros do work in Ajax but not in WebView.

hrdzpqkv
New Contributor II

QV10 Ajax Mode - VB Script

Jerry,

I'm upgrading from 9 SR7 to 10 SR2, and we had some documents running a task using an EDX event.

I was crossing my fingers but it looks like we can't start the task using the regular macro calling the HTTP event as QlikView recommend on the "Triggering EDX Enabled Tasks" on the documentation.

I'm wondering if you had been able to get this code to work over the AJAX Client on Internet Explorer.

Thanks,

jsn
Honored Contributor

QV10 Ajax Mode - VB Script

Like jerry says, certain macros will work with Ajax, but as it's an installationless client, it doesn't have the same flexibility in running vbscript etc. (or something along those lines).

As suggested in the thread, I would look at using actions. If you come across things you'd like to be able to do from the Ajax client that you have used macros for in the past, post the suggestions as Ideas for new actions. They could make good additions for upcoming versions.

When it comes to triggering EDX tasks, you could possibly just do a button with a link-action to a webpage where you launch the EDX task?

jerrysvensson
Valued Contributor II

QV10 Ajax Mode - VB Script

I have successfully used EDX tasks in AJAX.

It even works on my Iphone (Safari).

A button that runs a macro with the EDX code.

You might have to check the box " Allow macro execution on server " on the server.

If it works in the regular plugin it should work in Ajax.

hrdzpqkv
New Contributor II

QV10 Ajax Mode - VB Script

Thanks Johannes and Jerry,

I was able to have the macro ran enabling the "Allow unsafe macro execution on server" on the Security Tab.

We also notice than once on the Ajax client and hit the reload button (which calls the Macro), after tha reload task was done, we needed to close and reopen the document, because it stopped to work.

Thanks for your help.

jerrysvensson
Valued Contributor II

QV10 Ajax Mode - VB Script

Have a look at the settings on the document.

Document properties-Server

How the client you should update when a new version is on the server can make a difference.

Also just found out that a MsgBox (I usually use those for debug) stops the macro execution in Ajax. All popup like MsgBox InputBox and similar probably have that effect.