topic Re: Script from Logfile in QlikView

Script from Logfile

Anonymous — Wed, 21 Mar 2018 10:07:59 GMT

Hi All,

Is there any way to get script of qlik app from its logfile? if possible please suggest.

Re: Script from Logfile

olivierrobin — Wed, 21 Mar 2018 16:11:44 GMT

hello

you can have part of it.

everything outside a loop OR not containing substitution variable is ok

BUT

as it is a log, all loops are executed n times ans traced

and substitution variables are expanded

for 2 those 2 parts, you have to rewrite the original code by analyzing loops

Re: Script from Logfile

Anonymous — Wed, 21 Mar 2018 19:29:26 GMT

Hi Thanks for the reply.but how do we remove the date and timestamp which is a part of log file and also log file is of text format.pleaee suggest

Re: Script from Logfile

olivierrobin — Thu, 22 Mar 2018 09:18:27 GMT

you can use Notepad++ for example and its column mode to remove the first columns of the row

after that, you copy all the text and paste it into qlikview script editor

Re: Script from Logfile

Peter_Cammaert — Thu, 22 Mar 2018 09:24:37 GMT

To cut the timestamp from the front of a log file, see Olivier Robin's suggestion: Re: Script from Logfile

A Load script is always text, whether embedded inside a QVW document, or as content of an external script file. When you finished formatting and cleaning up your source, either copy the resulting text block in the script editor of a new document, or save the result as a .qvs file and $(Include=...) it in your target document.

Re: Script from Logfile

Anonymous — Thu, 22 Mar 2018 10:52:03 GMT

Is there any way to do that in qlikview itself without using notepad++.

Re: Script from Logfile

olivierrobin — Thu, 22 Mar 2018 10:55:22 GMT

you can paste all in Qlik and use Qlik Editor to remove date ans tile from eache line

but it wont't be as easy as with Notepad++

Re: Script from Logfile

Anonymous — Thu, 22 Mar 2018 10:59:39 GMT

Thanks Olivier.

Re: Script from Logfile

Peter_Cammaert — Thu, 22 Mar 2018 12:16:38 GMT

Yes, there is and it is extremely easy (and rather funny)

Under the motto "You can use QlikView for (almost) anything", create a new document, open script editor and create a LOAD statement for your log file as a fixed width source file. Something like:

ScriptLines:

LOAD RecNo() AS LineNo,

[@27:n] AS ScriptLine

FROM [YourLogFile.log] (fix, unicode);

Reload and place a Table Box on the Main sheet with two columns and sort according to LineNo to get the correct order. Check whether everything is correctly read and correct your LOAD options where needed.

You may want to skip the first 24 lines (check first, it may be different for your version of QV Desktop)

Then use a STORE statement to write back to a .qvs file.

Note that you'll still need to remove (probably manually) the table load comments and one or more terminating lines ("Execution finished")

Re: Script from Logfile

olivierrobin — Thu, 22 Mar 2018 12:37:55 GMT

be careful with the limit at 27. in QV12, line numbers may be shifted to the right when if a if of for strucutre

example behind :

2018-03-21 10:31:05 0023 NEXT j

2018-03-21 10:31:05 0024

2018-03-21 10:31:05 0017 FIELD_LIST:

2018-03-21 10:31:05 0018 LOAD

2018-03-21 10:31:05 0019 TableName(0) as TableName,

2018-03-21 10:31:05 0020 FieldName(4,TableName(0)) as Champs

2018-03-21 10:31:05 0021 AutoGenerate 1

2018-03-21 10:31:05

Re: Script from Logfile

Anonymous — Thu, 22 Mar 2018 12:49:40 GMT

Thanks a lot Peter,It's very simple

Re: Script from Logfile

Peter_Cammaert — Thu, 22 Mar 2018 12:59:34 GMT

Oh Great! Another one of those v12 "improvements". Can we switch it off?

OTOH, we're not easily discouraged and still firmly believe in "You can use QlikView for (almost) anything" (although it may be easier to do it in 11.20 than in 12.xx). So what about this one :

ScriptLines:

LOAD LineNo, Mid(ScriptLine, 26) AS ScriptLine;

LOAD RecNo() AS LineNo,

Trim([@1:n]) AS ScriptLine

FROM [YourLogFile.log] (fix, utf8);

Fortunately v12 doesn't wrap extremely wide lines anymore.

Re: Script from Logfile

Peter_Cammaert — Thu, 22 Mar 2018 13:06:12 GMT

If you want to skip the first 32 lines, add

header is 32 lines

to the LOAD options