[dba-VB] VB.Net - massive unzip

jwcolby jwcolby at colbyconsulting.com
Tue Jun 26 13:53:03 CDT 2007


In this specific instance I am referring to unzipping files provided to me
on a set of DVD disks.  However in the future I will also want to export
from my database to text files, then zip one or more files and upload them
to someone's ftp site.  This is not a setup situation.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Eric Barro
Sent: Tuesday, June 26, 2007 2:36 PM
To: dba-vb at databaseadvisors.com
Subject: Re: [dba-VB] VB.Net - massive unzip

Or you can create a Setup application using VS.NET and include all the files
you want in the folders you want them to be in and VS.NET can create the CAB
file for you. 

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, June 26, 2007 11:16 AM
To: dba-vb at databaseadvisors.com
Subject: [dba-VB] VB.Net - massive unzip

As you folks know, I get large flat files zipped up and stored on dvds.  In
order to import them I need to get them out of the zip files and then import
them into my database.  I have written an app to do the import but was still
missing the app to do the unzip.  

I just found one on the internet.

It is called MassiveUnzip and is a VB.Net application.

http://www.codeproject.com/useritems/MassiveUnzip.asp

It uses the SharpZipLib found on that company's web site.

http://www.sharpdevelop.net/OpenSource/SharpZipLib/Default.aspx

Click the download link about half way down to get at the zip lib download.

>From that point you need to unzip the SharpzipLib and move the DLL (at
least) to your project, then reference that lib.  I had to modify the call
to the zip lib because (apparently) the SharpZipLib authors have added a new
param to the program which the MassiveUnzip was not expecting.  

In ZipUtils.vb (compile and you will find the error)

fz.ExtractZip(zipFilename, targetDir, FastZip.Overwrite.Always, Nothing, "",
"", True)

I added the true as the last parameter.

I used this to unzip 50+ little tiny zip files in a given directory in about
10 seconds.  It is chunking away on 50 much larger files which will probably
take all afternoon.  But hey, it is my computer doing the work, not me!

If you need an "unzip all in this dir" kind of functionality, and
particularly if you want to then move that functionality into your own app
(I need to do that) then take a look at this program.  It's looking good!


John W. Colby
Colby Consulting
www.ColbyConsulting.com 

_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com


 

_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com




More information about the dba-VB mailing list