Help needed to transfer list of files to FTP server, to different folders
Hello Unix Gurus,
Help required from you.
My requirement is something like this
I want to create a concurrenct program in Oracle Applications using shell script to transfer files from Apps Server to destination FTP server.
I have created custom program, where I will extract all the mapping details like file_names, source_path and destination_path directories and storing in a database table.
The shell script should take the file_name and transfer the file from source_path (Apps Server) to destination path (FTP server).
Since the count will be around 5000 for each program run, I think it will not a good idea to open FTP connection for each file transfer.
Appreciate If you can suggest the pseudo code (or) please send me any sample codes
My Apps server and FTP server are different servers and i want to use only Unix shell scripting (I do not know anything about php and moreever this script i want to integrate with my custom PL/SQL prog).
In my case, source and destination directories are not always same, thats the reason I am storing these values in database mapping table.
Is there any possibility like using SQL table within FTP session, something like [Please
> open FTP connection
> [SQL session open]for records in (select filename,source,dest from mytable )
> loop
> cd dest
> lcd source
> put filename
> update mytable set some_flag='Y' where file_name=filename
> end loop [close SQL session]
> close FTP session
Actually, I have mappings available in my oracle table and I will use the table data for some other validations and business logic. Will be updating the table record for the file successfully FTP'ed to the dest server
Quote:
Originally Posted by vgersh99
many ways to skin that cat - not tested....
assuming fromTo.txt:
Hi All
I need to transfer a file from a UNIX server to a windows server.
I saw that it is possible to do this using scp command by looking at the forum listed below:
... (2 Replies)
hi, i want to write a shell script code which transfers files from a directory in unix server to a directory in a windows machine.. can any1 give me a sample code which uses ftp or sftp command..
thanks very much, (3 Replies)
HI
I need to write a script in 415univ server which should go to 534unix server and move the files from there to windows server.
I am not able to get it bcoz sftp prompt is not allowing ftp command.
Can some one plz help me
Thanks in advance (3 Replies)
Hi all,
I would need a bash script to sync/transfer folders recursively via FTP/RSYNC
(I initially planned to use FTP but I heard RSYNC would fit a lot better for this job(?))
The situation:
3 different Linux servers
1. source
2. destination - Samba
3. Server where the script runs on
... (2 Replies)
Hello,
I would want to list files of an server FTP with the path of the file...
i try "ls -R" but ftp don't accept this command...
Is it possible with curl command ???
Regards. (5 Replies)
Hi everybody,
I just want to transfer files with FTP (mget and mput). The problem is that I dont want to overwrite any existing files and don't want to transfer them again (e.g. using the rename-function). So I only want to transfer new files with mget and mput.
My first idea was to create... (3 Replies)
We are backing up a oracle database by copying the datafiles from one server to another using FTP. while in the middle of the transfer the destination server closes the connection and it sort of hangs. After this we are not able to log onto the destination server using any other user apart from... (0 Replies)
Dear Friend,
I don't know much about unix.I am an VB6.0 Programmer.I need to move an text files as aaa.txt from unix server to windows "D: " driver using the FTP protocol.Is it possible to do this with help of unix shell script.If possible please give some sample codes.
Please answer as early... (1 Reply)