topic Re: Log Files in QlikView

Log Files

Fri, 19 Feb 2016 09:00:36 GMT

Dear Community,

I want to reach log files and load this files in qlikview to make reports. Is there any easy way to do this?

Cause right now, i always do convert .log files to .csv files and adding commas & prepare to read. But this must be automatically done. Waiting for your comments and answer.

Re: Log Files

Gysbert_Wassenaar — Fri, 19 Feb 2016 10:57:30 GMT

What kind of log files? If you're talking about the log files Qlikview creates then have a look at the Governance Dashboard.

Re: Log Files

Fri, 19 Feb 2016 11:16:51 GMT

I'm not talking about QlikView's log files, my log files that created by server or any other program that i used.

Re: Log Files

Gysbert_Wassenaar — Fri, 19 Feb 2016 12:13:30 GMT

There are thousands of applications and systems that generate log files and most log files are completely different from each other. You'll have to create a specific load script for each type of log file. Since that's largely text processing you may look around for specific log parsing tools before trying to implement everything in Qlikview.

Re: Log Files

Fri, 19 Feb 2016 12:22:29 GMT

Ok. I solved reading .log file. I have another issue right now.

LOAD [@1:3] AS xGUN,

[@5:7] AS xAY,

[@9:10] AS xGUNSAYI,

[@12:13] AS xSAAT,

[@15:16] AS xDAKIKA,

[@25:28] AS xYIL,

IF(@39 = '/' , [@37:38],[@37:39]) AS xKULLANICI,

IF(@39 = '/' , [@40:42],[@41:43]) AS xKOTA

FROM

[LICENCE_STATUS_LOG.log]

(fix, utf8);

This is my LOAD script but it doesnt work when i add IF statements. Do you now why?

Thanks for replies btw.

Re: Log Files

quwok — Fri, 19 Feb 2016 12:48:13 GMT

Since log files are generally very structured, you should be able to automate the loading of log files. But without further details, we would not be able to tell you how complex it would be. Try playing around with the settings in the file load wizard to see if you can get the raw log file loaded

Re: Log Files

Gysbert_Wassenaar — Fri, 19 Feb 2016 13:04:11 GMT

Maybe this works: IF([@39:39] = '/' , [@37:38],[@37:39]) AS xKULLANICI,

Re: Log Files

Fri, 19 Feb 2016 14:02:53 GMT

Nop. It doesnt work

Re: Log Files

Fri, 19 Feb 2016 15:18:21 GMT

It works. Thank you