Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Execute 7zip with parameter

Hi Friends,

I am facing problem while trying to run Execute command with parameter. The content of the parameter is Filename

Let File='FileName.gz';

Execute 7z.exe x 'C:\junk\'$(File) -oC:\junk\;

The above statement does not work whereas if I replace the parameter with FileName it works

Execute lib://Raw_Files/7z.exe x "C:\junk\FileName*" -o"C:\junk\";

My question is how to use parameter on the second statement

Thanks, Deb

Tags (3)
8 Replies

Re: Execute 7zip with parameter

The statements are quite different. The second also uses the Library and double quotes around the file name. Have you tried Execute lib://Raw_Files/7z.exe x "C:\junk\'$(File)'*" -o"C:\junk\";?


talk is cheap, supply exceeds demand
Not applicable

Re: Execute 7zip with parameter

No Gysbert, this statement didn't work

Not applicable

Re: Execute 7zip with parameter

Try like below:

SET File=FileName.gz;

Execute 7z.exe x C:\junk\$(File) -oC:\junk\;

Not applicable

Re: Execute 7zip with parameter

nope

Re: Execute 7zip with parameter

Not entirely unexpected. Have you tried enabling the Legacy script mode? See http://help.qlik.com/sense/2.1/en-US/online/#../Subsystems/Hub/Content/LoadData/disable-standard-mod...


talk is cheap, supply exceeds demand
Not applicable

Re: Execute 7zip with parameter

Yes, I did that before. This is my entry of system.ini file

[Settings 7]

InterfaceLanguage=English

NumberOfDocuments=0

DocumentTimeout=60

StandardReload=0

MarginTop=20

CurrentQVConnect64Loc=C:\Users\IBM_AD~1\AppData\Local\Temp\QVConnect\2.1.1\QvConnect64.EXE

CurrentQVConnect32Loc=C:\Users\IBM_AD~1\AppData\Local\Temp\QVConnect\2.1.1\QvConnect32.EXE

Not applicable

Re: Execute 7zip with parameter

Hello Gysbert,

I tried to create and run batch file. But that too didn't work. Any other alternative to this?

Execute cmd /C C:\junk\Unzipping.bat FileName*;

C:\junk>type unzipping.bat

7z.exe x "C:\junk\%1" -o"C:\junk\"

Not applicable

Re: Execute 7zip with parameter

Any solution is highly appreciated

Community Browser