Hi Question 1: I have a Zip file with name 1.zip , placed in "D:\Test". Can anyone help me in VB scripting to extract(unzip) this file in the same location. Although i have Winzip in my system, i am unsure that will it be available in the system we going to use this. Is there is any general way to extract without using 3rd party software.Question 2: I have script to open a folder which has password. But the Test complete script records the password characters.... But i dont want the script to show the password character, Is there any way where we can encrypt this in script. Original is "Call dlgnewfolder.Edit.SetText("cocunuttree")" I need something like "Call dlgnewfolder.Edit.SetText("********")" Thanks in Advance

Hi Rajesh,the zip has password. so when i run the script i get a window popup asking for password.The problem is that the object (Shell.Application) I used in the script below doesn't allow using passwords. So, you cannot modify it to accomplish the task you need.I have only two suggestions:1. Search the VBScript forums for another approach that can be used to extract files from password-protected archives. Maybe, there is a solution, but, unfortunately, I don't know it.2. As an alternative, you can use an additional tool (like WinZip, 7-Zip or another) and create a script that will call it from the command line with the needed parameters. I know that you didn't want to use this approach, but I cannot suggest you any alternative.

How to extract a zip file and Can we hide the password that we enter in script ?

11 Replies

irina_lukina

Super Contributor

14 years ago

Hi Rajesh,

Is there is any general way to extract without using 3rd party software?

TestComplete doesn't provide such functionality. However, you can do this using the built-in objects and methods of VBScript&colon;



Sub Test

  'Specifies the location of the zip file. 

  ZipFile="D:\Test\Test.zip" 

  'Specifies the folder the contents should be extracted to. 

  ExtractTo="D:\Test\"  

  'If the extraction location does not exist, create it. 

  Set fso = CreateObject("Scripting.FileSystemObject") 

  If NOT fso.FolderExists(ExtractTo) Then    

    fso.CreateFolder(ExtractTo) 

  End If  

  'Extract the contents of the zip file. 

  set objShell = CreateObject("Shell.Application") 

  set FilesInZip=objShell.NameSpace(ZipFile).items 

  objShell.NameSpace(ExtractTo).CopyHere(FilesInZip) 

  Set fso = Nothing 

  Set objShell = Nothing

End Sub

Is there any way where we can encrypt this in script?

Try using the script provided in the following How To entry:

Working with encrypted data storage

BTW, in the future, please create different forum threads for different questions. It will be easier for us to reply to them and for other users to search for the threads that may assist in solving their problems.

Thanks :)

sergi
Contributor
13 years ago
Thanks for the code Irina.

If anyone's interested, here it is in JScript.

//Specifies the location of the zip file.

var ZipFile = "D:\\Test\\Test.zip";

//Specifies the folder the contents should be extracted to.

var ExtractTo = "D:\\Test";

// If the extraction location does not exist, create it.

var fso = new ActiveXObject("Scripting.FileSystemObject");

if ( !fso.FolderExists(ExtractTo) ){

fso.CreateFolder(ExtractTo);

}

//Extract the contents of the zip file.

var objShell = new ActiveXObject("Shell.Application");

var FilesInZip = objShell.NameSpace(ZipFile).Items();

objShell.NameSpace(ExtractTo).CopyHere(FilesInZip);

fso = null;

objShell = null;
irina_lukina
Super Contributor
14 years ago
Hi Rajesh,

the zip has password. so when i run the script i get a window popup asking for password.

The problem is that the object (Shell.Application) I used in the script below doesn't allow using passwords. So, you cannot modify it to accomplish the task you need.

I have only two suggestions:

1. Search the VBScript forums for another approach that can be used to extract files from password-protected archives. Maybe, there is a solution, but, unfortunately, I don't know it.

2. As an alternative, you can use an additional tool (like WinZip, 7-Zip or another) and create a script that will call it from the command line with the needed parameters. I know that you didn't want to use this approach, but I cannot suggest you any alternative.

irina_lukina

Super Contributor

14 years ago

Hi Ofer,

I guess, it's something like this:



  //Specifies the location of the zip file. 

  var ZipFile = "D:\\Test\\Test.zip"; 

  //Specifies the folder the contents should be extracted to. 

  var ExtractTo = "D:\\Test";

  // If the extraction location does not exist, create it. 

  var fso = new ActiveXObject("Scripting.FileSystemObject"); 

  if ( !fso["FolderExists"](ExtractTo) ) then    

    fso["CreateFolder"](ExtractTo); 

  //Extract the contents of the zip file. 

  var objShell = new ActiveXObject("Shell.Application"); 

  var FilesInZip = objShell["NameSpace"](ZipFile)["items"]();

  objShell["NameSpace"](ExtractTo)["CopyHere"](FilesInZip); 

  fso = null;

  objShell = null;

HKosova

Alumni

11 years ago

You'll need an external tool like 7-Zip to handle password-protected files, because Windows doesn't have built-in scripting functionality for that. 7-Zip has a standalone command-line version that you can store along with your test assets, or on a shared network drive.

The 7za unzipping syntax is:

7za.exe x archive.zip -oOutDir -pPassword

You can script it like this:



// JScript

function Test()

{

  var strArc = "C:\\MyFile.zip";

  var strPassword = "password";

  var strOutDir = "C:\\MyFolder";



  var exitCode = UnzipWithPassword(strArc, strOutDir, strPassword);

  if (res != 0)

    Log.Error("An error occurred while unpacking. Exit code " + res);

}



function UnzipWithPassword(ArchiveFileName, OutputDir, Password)

{

  var str7za = "C:\\Work\\7za.exe"; // Replace with your 7za path

  var oShell = Sys.OleObject("WScript.Shell");



  var strCommand = aqString.Format("\"%s\" x \"%s\" -o\"%s\" -p\"%s\"", str7za, ArchiveFileName, OutputDir, Password);

  return oShell.Run(strCommand, 0, true);

}

rajeshthomas
Contributor
14 years ago
Hi

Thanks for the Instant reply...

Regarding the Zip file extracting, i am able to extract it thru code but the problem is the zip has password. so when i run the script i get a window popup asking for password. How can modify the script to enter password automatically. I tried the methods i know, but when the password window pops out, the command to enter the password in the next line given my me is not reached. Please refer the attached screen shot for more clarity.

Script

  'Extracting Secu_bottom

    'Specifies the location of the zip file.

    secu_Bottom_ZipFile="D:\Test\secu_Bottom.zip"

    'If the extraction location does not exist, create it.

    Set fso = CreateObject("Scripting.FileSystemObject")

    If NOT fso.FolderExists(ExtractTo) Then

      fso.CreateFolder(ExtractTo)

    End If

    'Extract the contents of the zip file.

    set objShell = CreateObject("Shell.Application")

      set FilesInZip=objShell.NameSpace(secu_Bottom_ZipFile).items

      objShell.NameSpace(ExtractTo).CopyHere(FilesInZip) -----> Here is where i get a window asking password.

  Set fso = Nothing

  Set objShell = Nothing

Thanks in Advance
Oferv
Super Contributor
14 years ago
Hi Irina,

i always get to the same point where i find solutions people posted but it's in vbscript what makes it harder/impossible to run in c#script

can you please convert this code to something i'll be able to run in c#script?

'Specifies the location of the zip file.

ZipFile="D:\Test\Test.zip"

'Specifies the folder the contents should be extracted to.

ExtractTo="D:\Test\"

'If the extraction location does not exist, create it.

Set fso = CreateObject("Scripting.FileSystemObject")

If NOT fso.FolderExists(ExtractTo) Then

    fso.CreateFolder(ExtractTo)

End If

'Extract the contents of the zip file.

set objShell = CreateObject("Shell.Application")

set FilesInZip=objShell.NameSpace(ZipFile).items

objShell.NameSpace(ExtractTo).CopyHere(FilesInZip)

Set fso = Nothing

Set objShell = Nothing

Thanks
e_ganesh2
12 years ago
How to zip a Folder and Protected with password that we enter in script ?

Please help me
jorgesimoes1983
Regular Contributor
12 years ago
Just an idea... you can create a .bat file, and the run it (with password as an argument) in testcomplete (you can add it as a new testedapp).

The .bat file can be inspired here:

http://blog.dantup.com/2011/02/compressing-folders-into-individual-encrypted-7-zip-files-from-the-command-line/
federico_falasc
New Contributor
12 years ago

Hi Irina

Related to this post, there's a way for Testcomplete to wait until the extraction process is finished?

Thanks!

Forum Discussion

How to extract a zip file and Can we hide the password that we enter in script ?

11 Replies

Recent Discussions

Testexecute not possible to select tests if tesexec plan exists

Sys.OleObject. Microsoft Office (Word, Excel)

'Project not defined' errors after updating to 15.77.6.7

Related Content

Getting error with dynamic extractions in Groovy script

Encrypt passwords and master password?

SessionCreator - password encryption in command?