QlikView documentation and resources.
Recently, I've been writing some routines that extract data from multiple QV document and store them in excel files, which, in turn are consumed by another QV application to prepare KPIs and trends.
After successful testing and demonstration it was time to move to QV server and schedule it and this is where a plethora of problems raised. The scripts which ran just fine on Windows 2003 server (old test server), when scheduled on Windows 2008 R2 (new server) ran forever.
One of the issue was that the service account did not have necessary permissions to create "QlikTech.QlikView" object. A little surprising, considering the account had system admin rights. The other problem was the service could not export data in excel. It took about 6-7 hours of investigating the issue and finding a solution by searching the web, and Qlik community, ofcourse.
Steps to configure
The attached document has screenshots of settings that I would typically have when automating using VBScripts.
Happy Qliking
How come you didn't use nPrinting?
Am sure you already know, for Nprinting to work, user needs to be logged in all the time. You can just lock the session but not logoff from it.
But you can create a dedicated NPrinting Service Account - not sure I understand. Rebuilding a whole Extract to Excel process using VBScripts seems to be a lot of effort (let alone the maintenance of the code) - you must have had a strong point against the use of nPrinting (unless this was a one-off thing of course).