Parse the .txt file for folder name and FTP to the corrsponding folder.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Parse the .txt file for folder name and FTP to the corrsponding folder.
# 1  
Old 07-02-2007
Parse the .txt file for folder name and FTP to the corrsponding folder.

Oracle procedure create files on UNIX folder on a regular basis. I need to FTP files onto windows server and place the files, based on their name, in the corresponding folders. File name is as follows: ccyymmddfoldernamefile.txt; Folder Name length could be of any size; however, the prefix and suffix are of a fixed size.

e.g:
1) 20070701greenfieldincfile.txt (Folder Name: greenfieldinc)
2) 20070701oldenergycorpfile.txt (Folder Name: oldenergycorp)

Detailed Request:
1) Parse the Input File name and Find the name of the folder.
2) FTP to Windows server and place the text file in the corresponding folder.
3) Put the whole process in loop until it processes all files.
4) If possible any error check conditions or logs.

Thank you for your support!
# 2  
Old 07-02-2007
Try this

#!/usr/bin/ksh
ls -1 *file.txt | while read FILENAME
do
DIRNAME=`echo "$FILENAME" | sed -n 's/........\(.*\)file.txt/\1/p'`
echo "starting FTP of $FILENAME to Directory /tmp/$DIRNAME ..."
ftp -v -n host <<EOF
user user pwd
cd /tmp/$DIRNAME #destination Dir
lcd /tmp/source/ #source dir
put "$FILENAME"
bye
EOF
done
# 3  
Old 07-03-2007
Grant File privileges

The provided script did work. Thank You so much!

However, the created file hasn't been granted 'write' privileges to the user. The file is getting created through Oracle trigger and the process automatically uses 'dbadmin' user on UNIX.

Is there any way that we can force UNIX to provide 'r' & 'w' privileges to group and other members for the files that get generated through that process or files that get generated in the specified directory.

Any help is greatly appreciated.

Thanks!
# 4  
Old 07-03-2007
To set subsequently created files to a specific privileges:
Code:
man umask

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell scripting for moving folder specific files into target directory of that country folder.

I need help to write shell script to copy files from one server to another server. Source Directory UAE(inside i have another folder Misc with files inside UAE folder).I have to copy this to another server UAE folder( Files should be copied to UAE folder and Misc files should be copied in target... (3 Replies)
Discussion started by: naresh2389
3 Replies

2. Shell Programming and Scripting

read (filenam.txt) then go to folder and delete (charactername.bic)

I am hosting a nwserver.That is a Neverwinter Nights game server on linux Ubuntu 11.04 server. I need help creating a script to read a .txt and retrieving character logins and character names. The game will make a .txt in folder home/nwn/(filenam.txt). Then I will make a crontab job to... (0 Replies)
Discussion started by: 222222quick
0 Replies

3. Shell Programming and Scripting

Perl script to parse all files in the folder

Hello Smart People! I have a perl script that will import xml data into an access db. I would like to modify it so it will automatcially parse through all xml files in the folder. I swa a post but couldnt get it working. her is what my scrip looks like, i only list the top if you need more... (3 Replies)
Discussion started by: cowboymaverick
3 Replies

4. Shell Programming and Scripting

Bash script for new file in ftp folder

Hello, I'm trying to make a bash script that send me e-mail if there is any new file in my ftp folder. cat inotify.sh #!/bin/sh /usr/bin/inotifywait -e create \ -mrq /home/mrowcp | while read line; do echo -n "$line " >> /var/log/inotify.log echo `date | cut -d " " -f1-4` >>... (3 Replies)
Discussion started by: mrowcp
3 Replies

5. Shell Programming and Scripting

want to move set of file from one folder to another folder

Hi all, let me explain my requirments i am having 5 folder with different name for eg) abc , cdf , efd, rtg, ead each 5 folders contain 15 files i want to move 10 files to some other folder, remain 5 files should be there in the same folder. give me some suggestion on this. (6 Replies)
Discussion started by: natraj005
6 Replies

6. Shell Programming and Scripting

How to copy specific file.txt in specific folder?

hye there... i have a problem to copy file in specific folder that will change the name according to host,time(%m%s) and date(%Y%M%D) example folder name: host_20100531.154101801 this folder name will always change... but i just want to copy the AAA.txt and BBB.txt file.. really need... (17 Replies)
Discussion started by: annetote
17 Replies

7. Shell Programming and Scripting

File Management: How do I move all JPGS in a folder structure to a single folder?

This is the file structure: DESKTOP/Root of Photo Folders/Folder1qweqwasdfsd/*jpg DESKTOP/Root of Photo Folders/Folder2asdasdasd/*jpg DESKTOP/Root of Photo Folders/Folder3asdadfhgasdf/*jpg DESKTOP/Root of Photo Folders/Folder4qwetwdfsdfg/*jpg DESKTOP/Root of Photo... (4 Replies)
Discussion started by: guptaxpn
4 Replies

8. Shell Programming and Scripting

how to FTP a file from the local folder to unix server

Hi All, please help me to write a shell that ftp a file which is in the local (C:\) drive to a Unix server. Where as i know the IP for the Unix server. i could do this process by using ftp command. pls help me to write as Shell script. Thanks in advance for all of your answers.:b::b: (3 Replies)
Discussion started by: little_wonder
3 Replies

9. Shell Programming and Scripting

Move the file from one folder to another folder

Hi, I have a requirement to move a file from one folder(a) to another folder(b) only when folder (b) have a write permission. Folder permission is 755 If the permission is otherthan 755 we need to come out of the loop I will appreciate your help Thanks Soll (1 Reply)
Discussion started by: sollins
1 Replies

10. Shell Programming and Scripting

moving a file to a new folder and automated ftp

how to move a file to a different folder after an automated FTP . (1 Reply)
Discussion started by: dineshr85
1 Replies
Login or Register to Ask a Question