OnPostReload doesn't work in server

[#1]

Hi,

I am using QlikView SR5. And in my application I am using a macro as follows;

------------------------------------------------------------------------------------------------------------

Sub SendInventory

set tb1 = ActiveDocument.GetSheetObject("INVENTORYAGINGQTY")

tb1.ServerSideExportEx "INVENTORYAGINGQTY.QVD", 4

End Sub

----------------------------------------------------------------------------------------------------------

When using the OnPostReload in server it doesn't work.!

Please help me on this

Regards

Nilupa

[#2 · Accepted solution]

Macros will not run in Publisher.

You need to use batch reload of you want a macro to run Post Reload.

qv.exe /r app.qvw

See documentation for more information.

[#3]

Hi Jerry,

Thanks for your response.. You mean do I need to do use a batch reload to do this...

I want to deploy this application in Qlikview Server and schedule reload in the server... and using OnPost reload I want to save QVD s in a folder located in the server..

If you have any suggestion, you are welcome...

Thanks

Nilupa

[jonathandienst]

Why not do the QVD save in the reload script?

STORE INVENTORYAGINGQTY INTO INVENTORYAGINGQTY.QVD;

Jonathan

[#5]

Hi Jonathan,

Thanks for your reply....

Actually I want to save a Sheet Object's (Straight Table) data into a separate qvd after reloading...

For that I am using the following macro....

---------------------------------------------------------------------------------------------------------------------

Sub SendInventory

set tb1 = ActiveDocument.GetSheetObject("INVENTORYAGINGQTY")

tb1.ServerSideExportEx "INVENTORYAGINGQTY.QVD", 4

End Sub

-----------------------------------------------------------------------------------------------------------------------

Is there any possible way to achieve this?

Thanks!

[#6]

Hi

The only way to achieve what you want, is as Jerry wrote, by using "qv.exe /r app.qvw". You could trigger this from the publisher if you create a supporting task.

If you want to save a straight table into a seperate QVD, you really should consider to store this during the reload with STORE table INTO file.qvd.

/Martin

[#7]

Thank You all ..........!!!

[#8]

Hi,

Can you please explain me how to write a batch file to achieve this....

Thanks