Shell Programming and Scripting

Hi,

Here's the problem I'm facing. There's a common "sftp" script which list all the "done" files at the remote server and then "get" the corresponding data files.

Now because it has to be used by different programs the command "get" is constructed in the below manner:

Code:

 
get remote_path/remote_file1.csv* local_path
 
##The remote file that gets transferred is, say, remote_file1.csv_1000

Now I've to insert the exact remote file name in a table; but what is being inserted is "remote_file1.csv*". Is there a way to grab the exact file name (remote_file1.csv_1000) that gets transferred from remote to local path?

-dips

I am not sure if I understand your needs - you could check with a dir command or ssh ls and get the names needed(?). If you have to take the exact file name after the file(s) has been transferred, you might check your local directory to get the filenames; maybe by date or whatever distinguishes them from "old" files.

Try using mget instead of get

I'm not sure how to use mget? How'll it provide me with the exact file name transferred from remote server to local server?

I cannot change code that makes use of "sftp -b <batchfile> user@host".

This will make the code more complex. As this script runs every hour and transfer all the files that are available at the remote location. So I'll have to incorporate intelligence to check how many files were transferred and then pick only that no. of files name from the local dir matching the current date & time(in minutes). I wanted something simple and simultaneous with the transfer of files.

So I came up with the following code:

Code:

echo "get remote_path/remote_file1.csv*.zip local_path" > <batch_file>
fetchFile=`sftp -b <batch_file> USER_ID@HOST`
fileNmPath=`echo $fetchFile | sed 's/sftp>//g' | awk '{print $NF}'`
fileName=`basename $fileNmPath`

-dips

mget ist just a ftp command like get but it enables you to you use wildcards. It stands for multiple get.
But as you say you can not change any of the commands fed to the ftp client, this would not apply.
On the other hand looking at the code you posted you are in full charge of what you hand over your ftp client

Whatever - did your code work? Are you satisfied or is something still not as it should be?

When I said I cannot change the code; what I meant was that I cannot alter the way ftp-ing is happening i.e. cannot change it to scp or ssh or mget, etc......but I can write few unix commands or sftp allowed commands to get what I want. The code is already in place which use sftp with -b (batchfile) option. Sorry for any confusion it caused.

Yes, its atleast working for me. But I'm not sure if its patching up or not? and if there is a neat way to do things.

-dips