DWUTKA at marlow.com
DWUTKA at marlow.com
Wed Apr 27 17:18:14 CDT 2005
Sorry for the delay.....but I've been a little swamped during this thread. Ironically, I am rebuilding an application that 'auto' extracts files from zips. It's probably more complex then what you are looking for though. I host a realty website (remax realtors). It has a ton of properties, which are updated regularly. The updates are posted to an FTP site, and are zipped. The zip files contain both delimited text files with the property information, and .jpg files with images for the property. My original application used the INet control in VB, to download the files to a directory. Then I would shell (and wait) to a command line that unzipped all of the files to that folder. That was actually pretty easy to do. The REAL fun part was then to extract all of the information from the unzipped text files, update the database, and then sort all the pictures (and create thumbnails for them). The only trick on the first part was the unzipping. I found and Add-on for WinZip, which works perfectly, but the only catch is that you have to have a registered version of WinZip for it to truly work automated. If it's not registered, the command line prompts you for things...which is a little quirky for an 'automated' system. So I splurged on the $29 to register WinZip. It was money well spent. The command line works wonderfully, and better yet, the registered version of WinZip has a lot of neat features to use. The reason I am rebuilding this application, is because I spent the last few weeks rebuilding my home network. Now that I have everything setup at home (almost), I want to improve this process. It's downloading about 1.5 gigs worth of zip files, which even over my 3 megabit connection, takes a while. Then it unzips them (which can take just as long, or longer), then it runs the 'update' process. During the download, doing anything on my own crawls to dialup speed sometimes. During the rest, that server is pretty tied up. I decided to change the download/unzip process, and also modify the update process, so that my customers will be able to track what has been updated. In the download/unzip phase, I was using the INet control, which is quirky, and the way I had it setup, I knew what file was downloading, but not how big it was, or how fast it was downloading, and I couldn't pause it, only kill the whole process. So the new process (which I have the dl/unzip phase done, working on the new update process) downloads everything using API calls, and not only shows the file size, but how much has been downloaded and even has pause and cancel buttons. (Can't pause it forever, because the FTP site will time out, but I'm going to fix that too.....). So now, if I want to use the net at high speeds, when this thing is running, I can just go to the server, and pause the process. I also made a modification to the zip process. Instead of one big unzip '*.zip' command line, I have the VB program start a new thread, and that thread starts runs the unzip process for one zip file. Works like a charm. (It's all event driven too, so when the last zip thread is done, it raises an event the main process can use to launch the update process). Drew -----Original Message----- From: Mark A Matte [mailto:markamatte at hotmail.com] Sent: Wednesday, April 27, 2005 3:29 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Unzip Files Brett, Thanks for the shortcut...I was able to get to the link from home. What I'm actually searching for is a way to use the 'uncompress or extract' feature that is part of Windows XP. I found the 'expand' command line...but it only seems to work for .cab files, not .zip. Unless I got the syntax wrong...it only copies the .zip files. I've searched the web and found the same question asked over and over again...but no answers. Any ideas of a command line or api or something to utilize this 'unzip' function built into Windows XP without any additional software? Thanks, Mark A. Matte >From: "Brett Barabash" <BBarabash at tappeconstruction.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "Access Developers discussion and problem >solving"<accessd at databaseadvisors.com> >Subject: RE: [AccessD] Unzip Files >Date: Tue, 26 Apr 2005 11:07:30 -0500 > >I just clicked on the link and it worked for me. > >I recall our old corporate firewall would block or mangle this site, >particularily when browsing with IE. But then I upgraded to Firefox. >BIG improvement. No looking back! > >Here's a Google cache of the page I mentioned: >http://tinyurl.com/b9jho > >Let me know if you need the source files. I can send them to you >offline. > > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte >Sent: Tuesday, April 26, 2005 10:43 AM >To: accessd at databaseadvisors.com >Subject: RE: [AccessD] Unzip Files > >I've had a few people suggest this site... but I can't hit the site. I >even tried the main page http://www.vbaccelerator.com, Has the site >moved? > >Thanks, > >Mark > > > > >From: "Brett Barabash" <BBarabash at tappeconstruction.com> > >Reply-To: Access Developers discussion and problem > >solving<accessd at databaseadvisors.com> > >To: "Access Developers discussion and problem > >solving"<accessd at databaseadvisors.com> > >Subject: RE: [AccessD] Unzip Files > >Date: Tue, 26 Apr 2005 08:38:10 -0500 > > > >I've played around with the vbAccelerator project: > >http://www.vbaccelerator.com/home/VB/Utilities/VBPZip/article.asp > > > >It requires a few external libraries, which AFAIK are all freely > >distributable. > > > > > >-----Original Message----- > >From: accessd-bounces at databaseadvisors.com > >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte > >Sent: Tuesday, April 26, 2005 8:16 AM > >To: accessd at databaseadvisors.com > >Subject: RE: [AccessD] Unzip Files > > > >Hello All, > > > >The app I'm working on is personal...not for distribution...so I'm not > >worried about using on a different machine. The OS is XP Pro...and it > >allows me to unzip/decompress .zip files...is there any way to call > >this function from Access/vba/api or something? > > > >Thanks, > > > >Mark > > > > >From: "Bobby Heid" <bheid at appdevgrp.com> > > >Reply-To: Access Developers discussion and problem > > >solving<ac >essd at databaseadvisors.com> > > >To: "'Access Developers discussion and problem > > >solving'"<accessd at databaseadvisors.com> > > >Subject: RE: [AccessD] Unzip Files > > >Date: Mon, 25 Apr 2005 13:36:38 -0400 > > > > > >If you do not want to use any libraries, I would probably shell out > > >to WinZip using the command line interface to WinZip. > > > > > >Otherwise, there are several free/paid libraries out there. I have > > >not > > > > >used any of these libraries, so I cannot comment on them. > > > > > >Bobby > > > > > >-----Original Message----- > > >From: accessd-bounces at databaseadvisors.com > > >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A > > >Matte > > >Sent: Monday, April 25, 2005 1:22 PM > > >To: accessd at databaseadvisors.com > > >Subject: [AccessD] Unzip Files > > > > > > > > >Hello All, > > > > > >Any suggested on easiest/best way to have Access Unzip files? I'm > > >receiving > > > > > >a number of files that I want the db to find,unzip, and import > > >automatically. > > > > > >Thanks, > > > > > >Mark > > > > >--------------------------------------------------------------------------- ----------------------------------------- >The information in this email may contain confidential information that >is legally privileged. The information is only for the use of the intended >recipient(s) named above. If you are not the intended recipient(s), you >are hereby notified that any disclosure, copying, distribution, or the >taking >of any action in regard to the content of this email is strictly >prohibited. If >transmission is incorrect, unclear, or incomplete, please notify the sender >immediately. The authorized recipient(s) of this information is/are >prohibited >from disclosing this information to any other party and is/are required to >destroy the information after its stated need has been fulfilled. > >Any views expressed in this message are those of the individual >sender, except where the sender specifies and with authority, >states them to be the views of Tappe Construction Co. > >This footer also confi >n scanned >for the presence of computer viruses.Scanning of this message and >addition of this footer is performed by SurfControl E-mail Filter software >in conjunction with virus detection software. > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com