Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
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

10 Replies
Gysbert_Wassenaar

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
Author

No Gysbert, this statement didn't work

Not applicable
Author

Try like below:

SET File=FileName.gz;

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

Not applicable
Author

nope

Gysbert_Wassenaar

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
Author

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
Author

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
Author

Any solution is highly appreciated

vasilev
Creator
Creator

Does somebody find a solution for this problem?