topic Execute Various Lines in same cmd sesion in QlikView

Execute Various Lines in same cmd sesion

Anonymous — Tue, 24 Apr 2018 08:46:58 GMT

Hello everyone,

I want to use the Execute comand of QV in order to copy a file from one path to another but I have 2 problems:

1- My path contains spaces

2- My file has dinamical name such as Name(Date).

3- I have to set a proxy to acces to the DB.

I tryed to create a . bat file but since my path contains spaces and i have to create the file dinamicaly Is not possible. The reason is that QV is adding extra " on the path and then the console does not recognize it as a path. I have read Extra double quotes when store as TXT | Qlik Community but using a .xml file i have then to convert it to .bat in order to use us it bu I can't do that becaus the path contains spaces.

I think that the simplest way to do this is with various lines in the same comand sesion:

EXECUTE cmd.exe /C set ProxyVar=ProxyPath

ExacutableFile.bat

Is it possible? There is a way to save the .bat file without the extra "?

Thank you

Re: Execute Various Lines in same cmd sesion

marcus_sommer — Tue, 24 Apr 2018 11:30:50 GMT

You could try this: Re: Writing .bat file through script

- Marcus

Re: Execute Various Lines in same cmd sesion

olivierrobin — Tue, 24 Apr 2018 12:11:10 GMT

hello

you can concatenate your commands with && so they execute in sequence only if the previous one succeeded

Re: Execute Various Lines in same cmd sesion

Anonymous — Wed, 25 Apr 2018 08:49:36 GMT

Thank you both for your responses, both worked for the problem.

As for the && which is what I wanted in order to ease the script I see 2 limitations:

1- You can not use the a QV variable inside the execute so you have to whrite the absolut path (which is a problem)

2- All commands must be in the same line in order in order to be interpreted.

The 1 limitation is something that is kind of a limitation for the marcus_sommer‌ solution because in order to execute the bat file I need to hardcode the path of the file.

Re: Execute Various Lines in same cmd sesion

olivierrobin — Wed, 25 Apr 2018 08:58:51 GMT

for the 1st point, when you construct your commanf, you can use the $() syntax

say :

let vPath='c:\temp';

execute 'cmd /c del' & $(vPath)&'\*.qvd';

Re: Execute Various Lines in same cmd sesion

marcus_sommer — Wed, 25 Apr 2018 09:12:16 GMT

Three thoughts:

one - no outsourcing into an external bat-file else everything is executed directly from the qvw-script

two - switching the kind of batch-file to vbs might be useful to apply multiple actions

three - various parameters could be stored within text-files and read again from the batch-file to adress your dynamic requirements

It's not quite the same but it might be nevertheless helpful: Re: Stop Task from Command Line (cmd.exe)

- Marcus

Re: Execute Various Lines in same cmd sesion

Anonymous — Wed, 25 Apr 2018 10:06:44 GMT

Did you test this?

The simple ' are a problem for QV. Even the script: EXECUTE 'cmd.exe /c pause'; Gives me a "General Error" in response.

Also I have an other problem with the &&. When I use a script like:

Execute cmd.exe pause && copy FromPath ToPath && pause

Works but when I set a variable (in my case a proxy) does not give me an error but it is also not coping the file.

Execute cmd.exe set HTTPS_PROXY=SomPath && copy FromPath ToPath

Re: Execute Various Lines in same cmd sesion

olivierrobin — Wed, 25 Apr 2018 10:11:08 GMT

put the command into double quotes

try

execute "cmd.exe set HTTPS_PROXY=$(SomPath) && copy FromPath ToPath "

assuming SomPath is a Qlik variable

Re: Execute Various Lines in same cmd sesion

Anonymous — Wed, 25 Apr 2018 11:33:44 GMT

I tryed an it's not woerking, even if I use: execute "cmd.exe pause && copy FromPath ToPath" and is giving me "general error"

Re: Execute Various Lines in same cmd sesion

olivierrobin — Wed, 25 Apr 2018 11:41:26 GMT

try this syntax

execute cmd /c "your commands ..."

ex:

execute cmd /c "pause && pause";

Re: Execute Various Lines in same cmd sesion

Anonymous — Thu, 26 Apr 2018 10:15:04 GMT

Seems like QV does not like to concatenate the Set proxy statement because :

execute cmd /c "pause && pause";

Works but not:

execute cmd /c "set Proxy=ProxyWebPath && pause";

Re: Execute Various Lines in same cmd sesion

olivierrobin — Thu, 26 Apr 2018 11:21:23 GMT

the two variables are defined in your Windows environment ?

Re: Execute Various Lines in same cmd sesion

Anonymous — Tue, 08 May 2018 08:24:44 GMT

Finaly I got to a solution:

Given a Bat File like:

Set Proxy=ProxyWebPath

Copy FromPath\Filename%1 FromPath\Filename%1

Where %1 is a variable that can be introduced to the .bat file after executing the bat file and with a space in between like:

BatFilePaht\Document.bat VariableValue

So the solution is:

Execute cmd /c " "BatFilePaht\Save.bat" $(vDateText) ";

Thank You both for your help