How to get only todays file from Window 2003 from ftp?

[diwakar_4]

Hi All,
Good Morning.

I have to get only current dates csv file from Windows m/c.

1) Script i am using is:

#!/bin/sh
HOST='XXXXXXX'
USER='xxxx'
PASSWD='ppppp'
ftp -n -v $HOST > /usr/mydir/ftp.log << ENDFTP
user $USER $PASSWD
prompt off
binary
cd /wwwroot/
lcd /usr/mydir/
mget *.txt
quit
*******************************
Can some one help me to update the script ?

Thanks

[Mark McDonald_2]

Might be easier to use a CIFs mount.

OR

Get all the files in to a temp dir (assuming they are not too big) and only copy the ones you want to /ust/mydir. Then remove the temp dir?

There may be a way with ftp but I am not aware of it. Have you looked on google for options to mget?

[Mark McDonald_2]

Also

Could you have a script on the windows machine that renames the files to include the date string?

[Steven Schweda]

An easy way would be to have the file (or a
link to the file) placed on the other
(Windows) system in a date-labeled directory,
like, say, "2009-03-04". This would make it
pretty easy to find the desired file (or
files).

Otherwise, I might replace "mget *.txt" in
that script with "dir", save the result, then
look through it for files with the right
date. Finally, create a script which fetches
the desired files.

Looking through FTP directory listings can be
complex, which is one good reason to solve
the problem at the other end.

[diwakar_4]

Many thnaks,

Can i do something like?

1) Let say dir contains todays date files only. I will get all files throgh mget and then move the all the file from current dir to backup dir on windows. Then their wontbe any files left.
Bu can you help me whci command should i use to move the files to other dir.

Thanks

[Dennis Handly · Accepted solution]

>can you help me which command should I use to move the files to other dir.

ftp has a del command to remove files. I don't think it has a move command.
If this was HP-UX and both directories were in the same filesystem, you would just hardlink them before and then remove them.

[diwakar_4]

Hi Dennis,

Can we copy files from one dir to other and then delete. FtP servre in windows 2003 server?

Thanks

[Dennis Handly]

>Can we copy files from one dir to other and then delete.

Yes, you could copy from windows to HP-UX, then copy back to another folder on windows, then remove original.

[Steven Schweda]

> [...] whci command should i use to move the
> files to other dir.

> [...] I don't think it has a move command.
> [...]

"man ftp". Look for "rename". (You know,
like the RENAME command on a user-friendly
OS.) I'd expect most FTP servers to support
it well enough to rename a file to a
different directory, but I'd run the
experiment on the server in question.

[OldSchool]

....or you could consider setting up rsync on the windows server to sync up the directories....

[George Spencer_4]

Hi,

One of the problems with accessing files on windows servers it that the server can display the file information in either UNIX or Windows format. By this I mean that the information returned will either look like a ls listing or a dir listing. Either way the solution is the same.

1. Connect to windows server and request a directory listing, which you save to file; e.g. the ftp.log

2. Process the temporary log file containing the directory listing, and create a list of files to download. This will depend on the listing returned by the bimbos/windows box.

3. Reconnect to the windows server and download the required files.

You may be interested to know that the windows servers can be made to give a UNIX style directory listing, by a check box in FTP server setup (I forget the name used by Microsoft for the ftp server setup; is it IIS Server?).

Hope that helps,

George