Power Platform Community Forum Thread Details

Hello! I am very new to PAD and need some help uzipping .gz files.

I am having PAD download the files from a SFTP server and onto my hard drive - this runs perfectly. There are 16 zip files of which each has one folder, and then one file in each folder. The files are rather large (one is almost 170,000 KB). I've tried renaming the extension to the more accepted ".zip", but it still won't work. I keep getting the "...isn't a valid zip archive or a parameter isn't set" error. The files are not password protected. Would love some help. Thanks!

Categories:

Power Automate Desktop

7zip is by far the best unzip program I know of. Free and trusted. It also has a command line feature which makes it great for PAD as PAD can just call a command line to unzip files.

I had ChatGPT help me with the command line:

my prompt: 7zip also has command lines. Please provide the command line to unzip a .gz file with the following address: C:/Documents/folder.gz

ChatGPT

If you want to extract a .gz file using the command line with 7-Zip, you need to know the location of the 7-Zip executable file (7z.exe). This file is usually located in the 7-Zip folder in Program Files.

Assuming that 7-Zip is installed in the default location, the command to extract your .gz file would look something like this:

"C:\Program Files\7-Zip\7z.exe" e "C:\Documents\folder.gz" -o"C:\Documents"

Here's what the different parts of this command do:

"C:\Program Files\7-Zip\7z.exe": This is the path to the 7-Zip executable. The quotation marks are necessary because the path contains spaces.
e: This tells 7-Zip to extract files from an archive.
"C:\Documents\folder.gz": This is the path to the .gz file that you want to extract. Again, the quotation marks are necessary because the path contains spaces.
-o"C:\Documents": This specifies the output directory where the extracted files should be placed. The -o is followed immediately by the path to the directory (with no space in between). If the path to the directory contains spaces, you would need to put it in quotation marks.
Remember to replace the paths in this command with the actual paths on your computer if they're different. If you're not sure where 7-Zip is installed, you can use the search function in Windows to find it.