UNZIP .txt.z files using SQL server tool

LIULIHUA,
> C:\DATA\FTP_Download\
replace the above with

 C:\DATA\FTP_Do~1\

Hi aneeshattingal,

I got same output:

  End-of-central-directory signature not found.  Either this file is not a Zip file, or it constitutes one disk of a multi-part Zip file.

Make sure that it is not a corrupted zip file, try to extract it to the same directory (not from TSQL) use the same in command prompt and / or from windows

Can you actually unzip these .z files from Winzip??? i.e. using the windows interface?

They are probably not of a kind supported by winzip.

.z and .Z are the standard extensions used by two old Unix file compression programs (pack and compress).  If these files are coming from a Unix or Linux system, I'd guess that's what they are.  I'm surprised Winzip can't handle them.  Have you tried manually using Winzip to decompress one of these files?  Maybe it's the command line addon that doesn't support them.

 If they were created by pack or compress and Winzip can't handle them for some reason, I'd suggest trying gzip (GNU zip).  It should be able to handle them.  You can get it for free from www.gzip.org .  If you're going to try it, go ahead and get the Windows version, as opposed to MS-DOS.  The Windows version should be a command line program (the standard gzip doesn't come with a GUI interface).

 If neither Winzip nor gzip can decompress the files, they may be corrupt.  Maybe you could check with the source and see if your copies match the originals.  If the files don't contain propietary information, maybe you could post one somewhere so someone else could check it.

 James

Hi, James0628

1. The fact is Winzip32 can handle .z file when I use command prompt in DOS. And it only works when I just unzip one file, that's means if I try unzip all *.z or *.txt.z files Winzip came up a box said " Cannot create new ARC, TAR, CAB, WMZ, WSZ,YES, gzip or Microsoft Compressed files."
****this one worked in DOS command prompt*****
c:\progra~1\winzip\winzip32 -e -o c:\data\ftp_download\account.txt.z c:\data\ftp_download


2. if i download the gzip MS-DOS version, can I use it with SQL batch file?

thanks.

1. Does that one work if you type this:

EXEC master.dbo.xp_cmdshell 'c:\progra~1\winzip\winzip32 -e -o c:\data\ftp_download\account.txt.z c:\data\ftp_download'


2. If it says it supports a command line interface then yes, you can use it from SQL



>> if I try unzip all *.z or *.txt.z files Winzip came up a box said " Cannot create new ARC, TAR, CAB, WMZ, WSZ,YES, gzip or Microsoft Compressed files."

So that is why your thing was freezing. It was getting to the .Z files, then coming up with a msgbox. There was no one to click OK on the message box so it just 'froze'.


The confusing thing is your code is unzipping the files one at a time so that shouldn't be happening.

Hi,

>>1. Does that one work if you type this:

EXEC master.dbo.xp_cmdshell 'c:\progra~1\winzip\winzip32 -e -o c:\data\ftp_download\account.txt.z c:\data\ftp_download'

It hang in QA when I type the code above. However, it works in MS-DOS.

I've never used the Winzip command line, so I don't know if it should be able to uncompress multiple .z files in one command.  However, it sounds like you can't even get it to uncompress a single file from SQL.  I have no idea why.

 I expect gzip will work from SQL.  The standard gzip is a command line program.  A few details:

 You'll probably want to run gunzip, as opposed to gzip.  The distribution you d/l may include a gunzip.exe, but if it doesn't, just make a copy of gzip.exe .  That's all gunzip is - A copy of gzip under a different name.  The difference is that the program uses the name it's called by to decide the default actions to take.  gzip defaults to compressing and gunzip defaults to decompressing.  You can use command line options to tell gzip to decompress, but the "norm" is to run gunzip to decompress.

 Note that the default action for gzip/gunzip is to compress/decompress the specified file(s) and then delete the original(s).  For example, if you have file.txt and run "gzip file.txt", you'll be left with file.txt.gz (.gz is the default extension for gzip) and file.txt will be gone.  Likewise, if you have file.txt.z and run "gunzip file.txt.z", you'll be left with file.txt and file.txt.z will be gone.  If you want the compressed files to remain, there may be an option to keep the original files.  Try "gzip --help" (or "gunzip --help") to see the options.  FWIW, I just checked the version I have and I didn't see an option like that, but that version is pretty old.

 James

So so far we have:

-Unzipping .ZIP files from SQL or CMD        OK
-Unzipping .Z files from CMD                      OK
-Unzipping .Z files from SQL                    HANGS


Can you verfiy, is that where we are?



I am a bit confused by this statement (a coupld of posts ago):

--
And it only works when I just unzip one file, that's means if I try unzip all *.z or *.txt.z files Winzip came up a box said " Cannot create new ARC, TAR, CAB, WMZ, WSZ,YES, gzip or Microsoft Compressed files."
--

Are you:

1. Trying to unzip multiple files from a single .Z file
2. Trying to unzip multiple .Z files at once?

Hi nmcdermaid,
Thnak you for the response, the current situation is:
****Using winzip32****
-Unzipping one .ZIP files from  CMD        OK ,  
-Unzipping multiple .Zip files from CMD will prompt out a "Add" Box saying" Adding file :c:\Data\FTP_Download\*.zip", seems want me to zipping file instead of unzipping.  
-Unzipping one .Z files from CMD                      OK
-Unzipping multiple .Z files from CMD, Winzip came up a box said " Cannot create new ARC, TAR, CAB, WMZ, WSZ,YES, gzip or Microsoft Compressed files."
-Unzipping one or multiple .ZIP files from SQL                    HANGS
-Unzipping one or multiple .Z files from SQL                    HANGS

Look like Winzip32 is totally dead in TSQL

**** Using WZUNZIP*****
-Unzipping one or multiple .ZIP files from both CMD and SQL OK
--Unzipping one or multiple .Z files from CMD get error: End-of-central-directory signature not found.  Either this file is not a Zip file, or it constitutes one disk of a multi-part Zip file.
--Unzipping one or multiple .Z files from SQL get error:

Zip file: C:\DATA\FTP_Download\account.txt.z
Searching...            
  End-of-central-directory signature not found.  Either this file is not a Zip file, or it constitutes one disk of a multi-part Zip file.
seems TSQL can read the file name, but WZUNZIP couldn't unzip it.



Thank you for the help!

nmcdermaid,

>>Forget about using winzip32 (the doco actually indicates that command line features are 'undocumented' i.e. unsupported)<<
The questioner has been told by many (including yourself) the same in numerous different occasions.  See here:

https://www.experts-exchange.com/questions/21809665/How-to-unzip-files-in-DTS-package.html#16627385
https://www.experts-exchange.com/questions/21821646/Unzipmultiple-txt-files-using-DTS.html#16512994
https://www.experts-exchange.com/questions/21842551/Unzip-hang.html#16654084
https://www.experts-exchange.com/questions/21833466/Unzip-scripts-not-stable.html#16592678

But as you can see, not much progress.

All told they have asked this smae question with different angles six times (including this thread)

hmm I think I've posted in one of those threads too.  :/

LIULIHUA I guess you should read this and the other posts carefully and see if you can identify the issue.

It works perfectly with gunzip in both CMD and TSQL. thank you all.