topic Loading TaskLog.txt Files in QlikView

Loading TaskLog.txt Files

Anonymous — Tue, 25 Jan 2011 19:31:39 GMT

Has anyone created a script for loading TaskLog.txt log files?

These files are located at ...\ProgramData\QlikTech\DistributionService\1\Log\<date>\<qvw name>\TaskLog.txt

I'm trying to get some stats about a particular task that gets run every morning. Specifically, when it starts and when it ends.The Operations Monitor application doesn't grab these files. The problem, as I see it, is getting the script to load these files in a loop given the path structure above. Right now I'm just manually maintaining a spreadsheet by getting the log details from the Management Console each morning, but I'd like to automate this and put a .QVW out on the AccessPoint.

Loading TaskLog.txt Files

rwunderlich — Tue, 25 Jan 2011 19:50:49 GMT

Brian,

Attached is a script I use to read the TaskLog files (V9) and create QVDs for Tasks and the Raw log messages. Setup instructions are in the script.

Make sure you pre create the QVD directory it expects -- currently a subdirectoy "QVD" under the qvw.

-Rob

Loading TaskLog.txt Files

Anonymous — Tue, 25 Jan 2011 22:13:34 GMT

Fantastic Rob, thanks!