FTP Troubles

[bigfoot]

I put this in another forum a few months ago and got no response, so since I am now into the .NET world, I'll post it here.

I have 50 salespeople FTP'ing in a zipped, small Access database into our Win2000 server running IIS. This is a VB 6 application.

Every hour or so, we run another VB 6 application to copy all of the files out and process them, i.e: unzip them to another folder and read the tables and pass the data to our AS/400.

Here is where the problems come in: I'm having a lot of files that will not unzip. The DynaZip control tells me that they are corrupted. I traced this to (I think), trying to copy the file while it is still in the process of uploading.

I think this causes corruption. I am at wits end on this. 2 years now, I have been trying to figure this out. The file has 4 small tables in it: Order header/items & and Credit header/items.

Each may only have 20 or so records. Can this be done with XML instead?

What about the FTP problems? Any way to tell if the file is done FTP'ing??

I would like to hear how you all do it, please.

(I'll give a thousand stars to anyone who can fix this)
-Gary

 

[perryf]

I've heard of others having this problem. What they've done is copy the file as filename.tmp. Then rename the file when it is done copying.

PF

 

[bigfoot]

That may work. Himmmmm.

 

[chiph]

Make sure that your users are uploading the file in binary mode (since a ZIP file is binary, unlike a .txt file).

If they're using a command-line interface to ftp, they need to issue the "binary" command after connecting. If they're using some GUI tool to do this, they need to investigate how to tell the tool that a .ZIP file is a binary file.

Chip H.

 

[bigfoot]

I'm using Dynazip for VB6, and it's defaulted to binary mode send.