Log Files

[#1]

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.

[Gysbert_Wassenaar]

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

[#3]

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

[Gysbert_Wassenaar]

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.

[#5]

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.

[quwok]

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

[Gysbert_Wassenaar · Accepted solution]

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

[#8]

Nop. It doesnt work

[#9]

It works. Thank you