topic Re: execute in QlikView

execute

denis115 — Wed, 25 Nov 2020 16:16:04 GMT

Hi!

Help me please!

I want to replace my log file from folder with qvw file into folder that will be blocked for users,.

I've tryied to use execute but when I write move *.qvw.log it doesnt work, what do I need to do to reach the result?

thank you!

Re: execute

marcus_sommer — Fri, 13 Oct 2017 06:32:51 GMT

Maybe this is helpful: Re: Is that Possible to Specify Path of the "Generate Logfile"?

- Marcus

Re: execute

denis115 — Fri, 13 Oct 2017 08:33:23 GMT

from C:\Users\dcucuta\Desktop\log\test.qvw.log"; I need to replace into

C:\Users\dcucuta\Desktop\log\a";
What do I need to replace in your script?

Re: execute

marcus_sommer — Fri, 13 Oct 2017 09:01:24 GMT

You would need to change LoadLogging into a:

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

- Marcus

Re: execute

denis115 — Fri, 13 Oct 2017 09:21:17 GMT

and where wil go my log file?

If for you is not hard, where do I need to write the path where I want to save my log file?

Re: execute

marcus_sommer — Fri, 13 Oct 2017 10:12:28 GMT

The log will reside in a folder parallel to the qvw like:

...MainFolder\SubFolder\Applications\YourQVW.qvw

...MainFolder\SubFolder\LoggingLoad\YourQVW.qvw.log

but you could also choose each other exists folder like you want. Should this folder be also relative to the qvw or to something else you would need to build this path. but like you see within my example it's not very difficult with the system-variables, document-functions and a few string-functions like left/mid/index/subfield and so on - just try it out within the GUI, for example within a textbox.

- Marcus

Re: execute

denis115 — Fri, 13 Oct 2017 10:18:11 GMT

ok! It will take a time to try and understand all in your script,thank you