topic Export to excel using Server Scheduling in QlikView

Export to excel using Server Scheduling

Wed, 10 Mar 2010 18:33:57 GMT

I have a macro that exports tables to excel and it works fine using the onopen trigger.

When I schedule the document to reload via the server it does not run the macro and export the files.

If I use the trigger onpostreload it still does not work.

Does anyone know how I need to set this up to get it to work?

Regards

Adrian

Export to excel using Server Scheduling

vgutkovsky — Wed, 10 Mar 2010 18:40:43 GMT

Adrian,

I think this macro must be given system access in order to write files. If you are running from the server, you may need to enable "Unsafe Macro Execution" in your Server Settings. You're correct that you need to use onpostreload. But if it still does not work, check the log file for clues.

Regards,

Export to excel using Server Scheduling

vgutkovsky — Wed, 10 Mar 2010 19:01:39 GMT

Also make sure you upgrade to the latest release of SR3. SR2 contained a bug specifically related to OnPostReload (bug ID: 24192).

Regards,

Export to excel using Server Scheduling

Fri, 12 Mar 2010 15:38:29 GMT

Vlad,

I spoke with Qlikview support who told me that as I only had the server edition of qlikview and not the enterprise edition I can only schedule an application (running the macros is blocked).

They suggested I used the windows scheduler which I have done using a batch file to open qlikview, reload and close qlikview.

Not ideal but it works