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