topic Re: Is that Possible to Specify Path of the "Generate Logfile"? in QlikView

Is that Possible to Specify Path of the "Generate Logfile"?

Mon, 13 Apr 2015 07:29:10 GMT

Hi Guys,

I am trying to give my own path for "Generate Logfile" Properties.

Is this possible or not? By default It is saving on path where my .QVW file is located

Re: Is that Possible to Specify Path of the "Generate Logfile"?

awhitfield — Mon, 13 Apr 2015 10:41:00 GMT

Hi Shivendoo,

the path is fixed, you could always use a .bat file to archive the log files elsewhere, or un-tick 'Timestamp in Log file name' so that I get's overwritten after each reload.

Regards Any

Re: Is that Possible to Specify Path of the "Generate Logfile"?

jagan — Mon, 13 Apr 2015 10:52:24 GMT

Hi Shivendoo,

There is no such configuration, by default the log file is generated in the same directory where qlikview file resides.

Regards,

Jagan.

Re: Is that Possible to Specify Path of the "Generate Logfile"?

Mon, 13 Apr 2015 11:02:24 GMT

Hi Shivendoo,

Not possible I'm afraid. You could potentially create a supporting task in your QMC which triggers after your task, to copy the log to a new location and delete old file.

Hope that helps

Joe

Re: Is that Possible to Specify Path of the "Generate Logfile"?

Mon, 13 Apr 2015 11:22:42 GMT

Thank you all for rapid response.

Joe, Could you please let me know the script to move the files from one folder to another.

Re: Is that Possible to Specify Path of the "Generate Logfile"?

Mon, 13 Apr 2015 11:50:04 GMT

have a look at the supporting task tab, you can see under external programs you are able to run a commandline statement.

If it's just a single copy command you want to do, you should be able to just put this within the task itself.

Copy xxxexistinglogfilexxxx yyynewfilelocationyyyy /y

if you need to execute a few commands then just put these within a bat file and call that instead.

Hope that helps

Joe

Re: Is that Possible to Specify Path of the "Generate Logfile"?

marcus_sommer — Mon, 13 Apr 2015 12:00:02 GMT

I use this in a include-variable:

sub CopyLogFile

let vLogFile = '"' & DocumentName() & '.log"';

let vLogPath = '"' & left(QvWorkPath, index(QvWorkPath, '\', -1)) & 'LoggingLoad\' & DocumentName() & '.log"';

execute cmd.exe /C copy $(vLogFile) $(vLogPath);

let vLogFile = null(); let vLogPath = null();

end sub

and call then in the last script-row which copied the script-log in log-folder on the same level at my app-folder:

call CopyLogFile

- Marcus

Re: Is that Possible to Specify Path of the "Generate Logfile"?

Mon, 13 Apr 2015 12:13:56 GMT

this works too, only thing is you'd get a slightly cut-off logfile then though right?

Re: Is that Possible to Specify Path of the "Generate Logfile"?

marcus_sommer — Mon, 13 Apr 2015 12:26:27 GMT

Yes, you are right. The last part from the copy-routine is cut off. But that isn't very important for me. I like it inside the script to avoid external scripts and triggers.

- Marcus

Re: Is that Possible to Specify Path of the "Generate Logfile"?

Mon, 13 Apr 2015 12:47:32 GMT

yea makes sense, I think my picky side wouldn't like not seeing the complete log but I see the point of it

Re: Is that Possible to Specify Path of the "Generate Logfile"?

stantrolav — Tue, 19 Jul 2016 15:33:49 GMT

If you run such thing in load script statment you must use additional rights. Some times it's bad for administrators. This quest can be solved in macro:

1. Trigger on end of reload in self-application, that run macro:

Sub RunCMDComand

CMDCommand = ActiveDocument.Variables("RunCMD").GetContent.String

set objShell = CreateObject("WScript.Shell")

objShell.run CMDCommand,0,true

end sub

2. Make variable RunCMD like this:

='CMD /C MOVE ' & SubField(DocumentPath(), '.', 1) & '*.log ' & Replace(DocumentPath(), DocumentName(), 'Log')

3. Be alerted that you MUST CREATE FOLDER "Log" in the folder that .QVW is in.

Macro would run after App is reloaded in full-client app either by server.