hey all,

I'm starting my own website and I have files that are generated and stored by the site. These files are contained within numbered folders. Starting at 1 and going on forever....(i hope!)

I like to write a ftp script that when run will, connect to my site, navigate to the folder containing all the numbered folders, determain the highest number (ie, the latest folder to be created) and copy all the file within it to my machine.

Now, I never written an FTP script so I'm after some help.

This what I have so far;

batch file
Code: [Select]FTP -s:ftpscript.txt

ftpscript.txt
Code: [Select]USER MyUserId
MyPassword
cd Data

- I'm unsure how to find the highest numbered folder here

cd %to higest numbered folder%

mget *.*

- I'm unsure where the defulat download loaction would be.


I should mention that this will be started by Outlook VBA when a mail comes in, so needs to be completly automated, with no intervention by my-self.

Any help would be greatly appreciated.

Thanking you all

update;

I've decied that it would be much easier to not have to find the lastest folder on my site. I'll just keep one folder, download the data and then remove it.

so far I've got

ftp.bat
Code: [Select]@echo off
ftp -s:ftpscript.txt ftp.myhost.com
exit

ftpscript.txt
Code: [Select]cd data
mget *.*
bye

but if I run the batch file, it hangs. I've removed the @echo to de-bug but it just seems to run, "ftp -s:ftpscript.txt ftp.myhost.com" over and over again.

any ideas why??I am not sure what you are trying to do. Can you post the code you are using now and tell us what it is doing and what you want it to be doing?

sure,

At the moment all I'm trying to do is connect to a FTP site via batch. I'm trying to start the session from a batch file. (I want to add a script with commands in later, but felt it would be better to get the first step done right.)

ftp.bat
Code: [Select]@echo off
ftp ftp.myhost.com
exit

If I run this batch file I get a prompt open with a blank winodw and it hangs. If I remove the "@echo off" I can see that it is running the command over and over again very quickly and causes my machine to become very sluggish.

I hope I've given enough info, please ask if not.

(OS = XP Pro and the FTP site is on the internet, not loacl. Incase you where wondering...)
Here is a great place to start...

http://www.nsftools.com/tips/MSFTP.htm

The way I do this is to write a batch file that uses a text file for the user name and password. It ALSO has the commands to move files.

Here is a batch file:

ftp -n -s:E:\Folder\dataxfer.txt IP_Or domain name
PAUSE

Than create a txt file called dataxfer.txt and put it in E:\folder It should have your commands in it like this.

user username password
put E:\your_folder\file_name
some_other_cool_commands
bye

In my case I want to see the dos window do its stuff. If you don't want to see it run just get rid of the pause in your batch file. You will see a black box pop up and than close.

You can use your scheduler to run this for you if you need it.

Quote from: Spoiler on July 16, 2008, 08:49:13 AM

The way I do this is to write a batch file that uses a text file for the user name and password. It also has the commands to move files.

Here is a batch file:

ftp -n -s:E:\Folder\dataxfer.txt IP_Or domain name
PAUSE

Than create a txt file called dataxfer.txt and put it in E:\folder It should have your commands in it like this.

user username password
put E:\your_folder\file_name
some_other_cool_commands
bye

In my case I want to see the dos window do its stuff. If you don't want to see it run just get rid of the pause in your batch file. You will see a black box pop up and than close.

You can use your scheduler to run this for you if you need it.