topic Re: Macro Issue ??! in QlikView

Macro Issue ??!

Anonymous — Mon, 18 Feb 2013 10:42:21 GMT

hi guys.
I have a problem in QlikView and I do not understand or it may come from.
I created a macro to export fields in a csv file.
I did several test on my test server and my production server, here are the results:

Test server:

in heavy client: it works
in heavy client web view: it does not work
on the portal: it works

Production server:

In heavy client: it works
in heavy client web view: it does not work
on the portal does not work

I have verified that this is the same config between the two servers, and also that my macro is compatible ajax /

an idea?

sub ExtractCSV
set cs = ActiveDocument.GetSheetObject("CH44")
cs.export "\\10.200.132.32\partage\Marketing Clients\"&ActiveDocument.Variables("Event_ID").GetContent.String&".csv" , ","
end sub

Re: Macro Issue ??!

jerrysvensson — Mon, 18 Feb 2013 12:12:06 GMT

Macros in Webview runs serverside.

Make sure that the QlikView service account has access to :\\10.200.132.32\partage\Marketing

Re: Macro Issue ??!

Anonymous — Mon, 18 Feb 2013 12:39:41 GMT

the same :

sub ExtractCSV
set cs = ActiveDocument.GetSheetObject("CH44")
cs.ServerSideExportEx "\\10.200.132.32\partage\Marketing Clients\"&ActiveDocument.Variables("Event_ID").GetContent.String&".csv" , ","
end sub

Re: Macro Issue ??!

jerrysvensson — Mon, 18 Feb 2013 12:42:19 GMT

Yes.

But if you log on to the QVS using the service account, do you have write access to share?

Re: Macro Issue ??!

Anonymous — Mon, 18 Feb 2013 12:42:25 GMT

and my QVSVC has the write to access & share to the target folder

Re: Macro Issue ??!

jerrysvensson — Mon, 18 Feb 2013 12:51:43 GMT

Have you checked the setting "Allow unsafe macros" on the server?

It should be enabled.

Re: Macro Issue ??!

Anonymous — Mon, 18 Feb 2013 12:52:19 GMT

option enabled.

Re: Macro Issue ??!

jerrysvensson — Tue, 19 Feb 2013 14:31:18 GMT

Have you looked at trusted sites settings in Internet Explorer?

Sometimes you need to add the QVS to the clients trusted sites.

Also try adding \\10.200.132.32 to trusted sites.

Re: Macro Issue ??!

Anonymous — Tue, 19 Feb 2013 14:33:33 GMT

The macro worked well under IE, the problem is i'm under firefox.

Re: Macro Issue ??!

jerrysvensson — Tue, 19 Feb 2013 14:53:30 GMT

Are you running Ajax in both IE and FF?

Re: Macro Issue ??!

Anonymous — Tue, 19 Feb 2013 15:00:02 GMT

I run only under FF.

the macro works on my test server but not on my prod server

Re: Macro Issue ??!

jerrysvensson — Tue, 19 Feb 2013 15:05:18 GMT

You wrote that it worked under IE, my question: Are you running Ajax (WebView) in IE when it works?

Re: Macro Issue ??!

Anonymous — Tue, 19 Feb 2013 15:22:45 GMT

ahh ok.

i doesnt work under IE with ajax plugin.

Re: Macro Issue ??!

Anonymous — Tue, 26 Feb 2013 10:13:29 GMT

I found the problem dudes.

i juste upgrade QV 11282 to 11440.

and now it works perfectly

thanks

Re: Macro Issue ??!

stvn_003 — Fri, 27 Dec 2019 14:45:26 GMT

I have a problem running the macros, when I run a macro for the first time, it works very well, but then they are all disabled and I can no longer run any, I have to close the file and reopen it.