We have a requirement wherein the user wants to update few templates provided to different departments within the organization and click on a button to get the data loaded onto qlikview application.
Can anybody share with me any macro to enable Reload into Qlikview.
With a bit of clever configuration, it should be possible to trigger reloads without the need for Publisher/EDX etc..
What I have done is schedule a simple qvw (let's call it a 'control' qvw) to run every minute. All it does is look for the existence of a txt file on the server. The txt file is generated using a macro with ServerSideExport of a simple object in the document I want to be triggered and in my document this is called from a button.
When the scheduled control qvw doesn't find the file (use an 'if FileSize(file)>0' statement in the load script), it just completes normally. If it DOES find the file, make the load script do something that will fail, such as 'Load NonField resident NonTable'. The document you DO want to reload needs to be set up to run only when the control document fails. You will also need to delete (EXECUTE cmd.exe \c del) the file to prevent the control app from continuously failing - just do this in the control app just before you set the fail script.
For the issue where you want to reload a failed document reload, you might be better to store a counter in the text file so that you can control a maximum number of times a reload is attempted, and read the value back on each attempt.
Yes, this is another option. Even a continuous QVW file checking for a value in field stored in a QVD file with a timestamp can give you more control on what is happening.
.png "Miguel_Angel_Baeyens"){kind=avatar}
