Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

raghavsurya
Valued Contributor

Macros not being launched on Qlikview server (Ajax)

Hi All,

We have written a macro to export multiple charts in a qlikview tab to excel. It works absolutely fine on the desktop. Once I launch it onto the server and view the files through "Access Point", the macros are not getting launched. We have checked the "enable macros on the server" as well.

Can you please let us know if anybody of you have faced similar issue.

Regards,

Raghav

9 Replies
Not applicable

Macros not being launched on Qlikview server (Ajax)

Hi Raghav,

I encountered a similar problem in an early release of QlikView 8.5 where no macros would work via Ajax but this was fixed in one of the later service releases. Since then no problems.

If you are drying to perform file operations it may be that the service account that runs your server service does not have the right privileges. I would recommend checking that a basic macros (i.e. one that displays a message box) works and then start trouble shooting from there.

Hope this helps.

Rod

raghavsurya
Valued Contributor

Macros not being launched on Qlikview server (Ajax)

Hi Rod,

I did the same and the simple macros like launching a chart which is minimised and vice versa is working. But the macro to export the chart to excel is not working.

Regards,

Raghav

Not applicable

Macros not being launched on Qlikview server (Ajax)

Hi Raghav,

It sounds like the Windows account used to run the QlikView Server doesn't have sufficient access to interact with the client desktop. It may be that you need to review the privileges for that account using the policy editor.

I had a client with a similar issue where they could not view Google maps through their QlikView server and the problem turned out to be the privileges for the Windows Service did not allow external web calls.

Your I.T. area/provider should be able to help you with adjusting the Windows account profile.

Hope this helps.

Rod

Not applicable

Macros not being launched on Qlikview server (Ajax)

Try doing a CTRL+SHIFT+M in Accesspoint and select 'Give System Access to Module Script' . See if that works.

Not applicable

Macros not being launched on Qlikview server (Ajax)

I'm having a similar problem. Macro runs fine using the client.

When you say ctrl+shift+M in Accesspoint, do you mean when looking at the AccessPoint Tab in the System section of the Management console?

Not applicable

Macros not being launched on Qlikview server (Ajax)

It's not in QEMC.

I was talking about opening the report in accesspoint portal and do a ctrl+shift+M

Not applicable

Macros not being launched on Qlikview server (Ajax)

Thanks - that works for me using IE and the IE plug-in version. In Ajax (using IE or Chrome) the ctrl+shift+M doesn't get any response.

Not applicable

Macros not being launched on Qlikview server (Ajax)

I had nearly the same issues and I found out that macros in AJAX are limited. Especially excel-functionality. So you can't create an Excel.Application which you need in order to edit an Excel file. It works with the IE Plugin and it works with the Desktop Application, but not with Ajax. And what you also can't do in Ajax is the CopyXToClipboard method.

In order to do an "excel export" I used a little trick. What you can do is to create a textfile on your server and write all the data from the object (e.g. from a tablebox or a chart) into this textfile. When you finished, close the file, and do a cmd-run with "WScript.Shell" and open the excel-file. In that excel-file you have to put a macro in which is automatically triggered by opening and this macro grabs your created textfile, reads the data inside and puts them into specific columns. Then you have the data successfully transferred from QlikView Ajax to Excel.

Hope that helps, it's kinda tricky, but it works really fine for me.

Not applicable

Re: Macros not being launched on Qlikview server (Ajax)

Hi Daniel_C,

I refresh this post because I have the same problem and I would like to what you say.

But how do you export a textbox into a textfile ?

Regards,

Community Browser