Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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
Contributor III
Contributor III

Does somebody find a solution for this problem?