Reload documents on server with unsafe macro

[Anonymous]

Hello,

I've application with VBS macro for generate PDF a mailing. After reload is generating report. On QV Desktop running on server is all ready: I have PDF and mail with attachment.

When server reloads this application, any PDF and any mail. It's the same server and QlikView services are running under same user, which is run QV Desktop.

I have set:

DOCUMENTS:

- in Module: - Requested Module Security - System Access, Current Local Security - Allow System Access

- I did Cltr-Shift-M - Give System Acces to Module Script

SERVER:

- Setup - Security - Allow macro execution on server, Allow unsafe macro execution on server

What another I have to set for runnning macro after server reload?

Many thanks, a lot of hours, lot of script languages and result for automation: 0!

O.

[magavi_framsteg · Accepted solution]

Hi qvhlaold0.

When QVP or QVS does reloads, it does not trigger Document.OnPostReload.

Document.OnPostReload is only triggered when reloading through QV Desktop.

If you really want it to trigger, you can always schedule an "External Task" to run qv.exe /r DriveLetter:\path_to_document.qvw

Kind regards

Magnus Åvitsland

BI Architect Consultant

Framsteg Business Intelligence Corp.

[Anonymous]

Hi Magnus,

many thanks, good message!

And is another event or way to universal running macro after reload - from Desktop and from server too? Desktop is'nt so important. When I want to use QlikView Management Console for planning reloads. Or is possible only command line and Windows Scheduled Tasks?

Thanks for answer,

Olda

[#4]

Hi Magnus,

I am trying to access Query String from the URL and assign to a List Box. I am storing this value in a variable.

Now, I want to pass this variable to the stored procedures and Reload the Dashboard based on the variable value.

Please let me know if anyone has worked on such scenarios.

Thanks

Sai Krishna

[#5]

Hi Magnus Åvitsland

I have set:

DOCUMENTS:

- in Module: - Requested Module Security - System Access, Current Local Security -Allow System Access

- I did Cltr-Shift-M - Give System Acces to Module Script

SERVER:

- Setup - Security - Allow macro execution on server, Allow unsafe macro execution on server

but still my macro is not working on access point in production macro is working but in access point it is not working.

Please help me please....

Thanks in advance

Sher Bahadur

[kamakshisuram]

Hi,

I too facing the problem with Reload trigger in QVP. Can you please tell me where is external task and how to set this?

Thanks in advance.