topic Re: Re: SendToExcel and DialogPrint macros not working on server in QlikView

SendToExcel and DialogPrint macros not working on server

Mon, 29 Sep 2014 16:34:46 GMT

I created two macros, one for SendToExcel and one for DialogPrint and added them as actions to text objects. They work very well when on the desktop client. However, when in web view or on the server, they do not work at all. Why is this happening? Is it because they are unsafe macros? What makes a macro unsafe?

Is there any way to achieve the same result of using buttons for SendToExcel or DialogPrint without using macros?

Re: SendToExcel and DialogPrint macros not working on server

Anonymous — Mon, 29 Sep 2014 16:39:09 GMT

Is that QlikSense or QlikView ?

Re: SendToExcel and DialogPrint macros not working on server

Mon, 29 Sep 2014 16:41:20 GMT

This is QlikView

Re: SendToExcel and DialogPrint macros not working on server

Anonymous — Mon, 29 Sep 2014 16:51:42 GMT

Your macros.png image confused me as it don't look like QlikView.

Anyway I personally avoid macros, not least because they do not work with the Ajax client but only with the IE plugin.

I would use the <Right Click> and the <Print> / <Send to Excel> functionality available out of the QlikView box.

Re: SendToExcel and DialogPrint macros not working on server

fkeuroglian — Mon, 29 Sep 2014 16:53:42 GMT

Hi Rachael

There are a lot of macros that do not work in webview, when you try to exec in the acces point.

problably you are using Full browser, not internet plugin, dont you?

if you want to run this macros that you create to export you will have to install the internet explorer plugin localy in your pc

try this and tell me if you have any problem

hope help

Fernando

Re: SendToExcel and DialogPrint macros not working on server

Mon, 29 Sep 2014 17:03:40 GMT

Hi Fernando,

Our users access the QlikView application on a browser and I think that has an IE plugin. Should that work for macros?

Thanks!

Re: SendToExcel and DialogPrint macros not working on server

fkeuroglian — Mon, 29 Sep 2014 17:08:04 GMT

Rachel, do you download and install the ie plugin en every local pc?

if you have installed, should work

if you can cut and put an image of your browser in the acces point

Re: SendToExcel and DialogPrint macros not working on server

Mon, 29 Sep 2014 17:12:25 GMT

I am not very sure about the ie plugins, but this is what it looks like on my browser.

Re: SendToExcel and DialogPrint macros not working on server

fkeuroglian — Mon, 29 Sep 2014 17:28:23 GMT

Rachael, for the img that you attached, you dont have IE Plugin installed, try to download and the install in your pc

you will see the menu different

when you acces to the acces point, in the right part of the screen (at the top) there are a link to download it,

install and the you will have to "open with" ie plugin, there would be a new option in the acces point before enter to the document

Re: SendToExcel and DialogPrint macros not working on server

Mon, 29 Sep 2014 17:42:25 GMT

Thanks, Fernando! Where exactly do I locate the download link? Can you show me a screenshot? I assume every user will have to download this ie plugin as well?

Re: Re: SendToExcel and DialogPrint macros not working on server

fkeuroglian — Mon, 29 Sep 2014 17:46:45 GMT

Rachael, see the picture attached, you have to download in the acces point.

every user that will be export and use the macro you create, will have to install local the ie plugin

tell me if you need something

Fernando

Re: SendToExcel and DialogPrint macros not working on server

Thu, 09 Oct 2014 19:51:02 GMT

Fernando,

I downloaded and installed the plugin but somehow it doesn't seem to have connected to my Internet Explorer. I don't see it in my add-ons when I go into my IE settings. Do you know if this has something to do with system administrator rights on my computer? I am trying to get this to work on my work computer so I might not have full system administrator rights.

Also, how do you know when you have the plugin properly installed? You said you could tell by looking at my browser window? Will an icon show up somewhere?

Thanks for answering my many questions!

Re: Re: SendToExcel and DialogPrint macros not working on server

fkeuroglian — Fri, 10 Oct 2014 16:28:23 GMT

Dear Rachael

see the image attached, when you acces to the acces point, there will be an option to enter to the web document via internet explorer plugin.

do you install local in your pc? do you have admin permiss? try "run as administrator" the iexplorer installer

tell me if you need something