Macro Issue ??!

[Anonymous]

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

[jerrysvensson]

Macros in Webview runs serverside.

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

[Anonymous]

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

[jerrysvensson]

Yes.

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

[Anonymous]

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

[jerrysvensson]

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

It should be enabled.

[Anonymous]

option enabled.

[jerrysvensson]

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.

[Anonymous]

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

[jerrysvensson]

Are you running Ajax in both IE and FF?