Macros not being launched on Qlikview server (Ajax)

[raghavsurya]

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

[#2]

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]

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

[#4]

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

[#5]

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

[#6]

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?

[#7]

It's not in QEMC.

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

[#8]

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.

[#9]

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.

[#10]

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,