Need help with FTP script 1

staffordwarren · Jul 21, 2000

I want to create a script that gets a file from a Unix server and moves it to my Sun box each night. I currently have a script that looks like this: ftp -n -v << EndFTP open <system name> user <user/pwd> ascii cd sales_reports get Report-20000706-052148.csv close EndFTP Notice that in the file name, there is a date-timestamp string.  What I need to do is to pick up files (and there may be multiples) that match an inputted date string.  What I'd like to do is use a wildcard character in the file-spec, but that doesn't seem to work.  As a second approach, can I list the files (with ls) that exist, capture the response in an array and then get the names from the array? Any help is much appreciated! Stafford Warren

MikeLacey · Jul 22, 2000

Hi Stafford, Here's a short perl script that does the job, would have written in ksh or sh but don't have that at home :-( so if you have perl this will do fine - post back if you don't and I'm sure someone will post a ksh version. The script generates an ftp script for you. You may need to modify the first line so that it matches where the perl executable lives on your system. You can find that out by typing 'whence perl' or 'which perl' on the unix command line. If you haven't got perl or it's not in your $PATH the whence and which commands won't display anything. Copy the script below into a file (mkftpscript.pl for example), make it executable (chmod +x mkftpscript.pl) and run it like this: ./mkftpscript.pl > ftpscript chmod +x ftpscript ./ftpscript #!/usr/bin/perl # go to the correct directory chdir "c:\\work"; # get the current date (and other things I don't care about) my($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime(time); # .. because Perl years start from 1900 - ho hum $year+=1900; # .. because Perl months count from zero $mon++; # stick a zero in front of month and day if I need to $mon = "0$mon" if length($mon)==1; $day = "0$day" if length($day)==1; # print the ftp script on STDOUT print "ftp -v -n <<EndFtp open <system name> user <user/pwd> ascii cd sales_reports "; # loop thru (sic) the files for today while(<Report-$year$mon$day*.csv&gt

{ print "get $_\n"; } # and finish off the ftp script print "close EndFtp "; Mike <a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a> <a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a>

AndyBo · Jul 24, 2000

If you wanted to go down the "listing of files and grabbing a name" route, Expect might do the job for you.  Details at <A HREF="

http://expect.nist.gov/"

TARGET="_new">

http://expect.nist.gov/</A> One

caveat - you will also need TCL available, so it might be more effort than it's worth. <a href=mailto: > </a> <a href= > </a> -- 
0 1 - Just my two bits

staffordwarren · Jul 24, 2000

Actually, I read up a little over the weekend on ftp, and I think I can get what I need by using the mget command. thanks for your suggestions.

Caliban · Jul 24, 2000

Yes -- mget is what you want.  Use: ftp -n -v << EndFTP open <system name> user <user/pwd> ascii cd sales_reports prompt mget Report-20000706*.csv close EndFTP

ElgisRamon · Aug 4, 2000

You can automate the inputting of the date using the date command... thus: TheDate=`date +"%Y%m%d"` ftp -n -v << *EOI open <system name> user <user/pwd> ascii cd sales_reports prompt mget Report-$TheDate*.csv close *EOI I hope it works...

MikeLacey · Aug 4, 2000

Elgis - that is cool. That one goes into my tool-box. Mike <a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a> <a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a>

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Need help with FTP script 1

staffordwarren

Technical User

MikeLacey

MIS

AndyBo

MIS

staffordwarren

Technical User

Caliban

MIS

ElgisRamon

MIS

MikeLacey

MIS

Similar threads

Part and Inventory Search

Sponsor