FTP Transfer Concurrent Program

Submitted by code_admin on Wed, 07/11/2018 - 19:49

ftp_transfer.prog

  1. #!/bin/sh
  2. # xxgc_ftp_transfer2.prog v1.0 Thur 4 Sep 2008
  3. # Author: Robert Metcalf
  4. #
  5. # 1.0   initial version
  6. #Executable: XXGCFTPTRANS2
  7. #CR: Greenwich FTP transfer Process 2
  8. # $0 - Shellscript name
  9. # $1 - Oracle username/password
  10. # $2 - User_id
  11. # $3 - Oracle Applications username
  12. # $4 - Concurrent request id
  13.  
  14. LOGFILE=$COMMON_TOP/admin/$APPLLOG/l$4.req
  15.  
  16. OUTFILE=$COMMON_TOP/admin/$APPLOUT/o$4.out
  17. if [ $APPCPNAM = 'USER.REQID' ]; then
  18.         #Output file name is in the format USERNAME.######
  19.         #See bottom of page 8
  21.         OUTFILE=$COMMON_TOP/admin/$APPLOUT/$3.$4
  22. fi
  23.  
  24. #$5 = src dir (full path from root with trailing slash)  '/apps11i/dev/devcomn/admin/out/DEV_gchrdev/'
  25. #$6 = src file name (File name to transfer) 'o2992771.out'
  26. #$7 = Dest DIR (where to go) 'BST, Finance, HR'
  27. #$8 = dest file name
  28. #$9 = FTP Host Name:::FTP Username :::FTP Password
  29.  
  30. I_SRC_DIR=$5
  31. I_SRC_FIL=$6
  32. I_DEST_DIR=$7
  33. I_DEST_FIL=$8
  34. I_FTP_HOST=`echo $9 | awk -F ::: '{print $1}'`
  35. I_FTP_USER=`echo $9 | awk -F ::: '{print $2}'`
  36. I_FTP_PASS=`echo $9 | awk -F ::: '{print $3}'`
  37.  
  38. echo "xxgc_ftp_transfer2.prog running" >> $LOGFILE
  39. echo "script being run as:" >> $LOGFILE
  40. whoami >> $LOGFILE
  41. echo "TWO_TASK: " $TWO_TASK >> $LOGFILE
  42. echo "Source Dir: " $I_SRC_DIR >> $LOGFILE
  43. echo "Source File name: " $I_SRC_FIL >> $LOGFILE
  44. echo "Dest Dir: " $I_DEST_DIR >> $LOGFILE
  45. echo "Dest File name: " $I_DEST_FIL >> $LOGFILE
  46. echo "FTP Host: " $I_FTP_HOST >> $LOGFILE
  47. echo "FTP User: " $I_FTP_USER >> $LOGFILE
  48. echo "FTP Pass: ******" >> $LOGFILE
  49. echo "See output for processing messages" >> $LOGFILE
  50.  
  51. echo "xxgc_ftp_transfer2.prog running" >> $OUTFILE
  52. echo "script being run as:" >> $OUTFILE
  53. whoami >> $OUTFILE
  54. echo "TWO_TASK: " $TWO_TASK >> $LOGFILE
  55. echo "Source Dir: " $I_SRC_DIR >> $OUTFILE
  56. echo "Source File name: " $I_SRC_FIL >> $OUTFILE
  57. echo "Dest Dir: " $I_DEST_DIR >> $OUTFILE
  58. echo "Dest File name: " $I_DEST_FIL >> $OUTFILE
  59. echo "FTP Host: " $I_FTP_HOST >> $OUTFILE
  60. echo "FTP User: " $I_FTP_USER >> $OUTFILE
  61. echo "FTP Pass: ******" >> $OUTFILE
  62.  
  63. #Check TWO_TASK is set correctly
  64. if [ "E" = E$TWO_TASK  ]; then
  65.         echo "ERROR - TWO_TASK is not set" >> $OUTFILE
  66.         echo "TWO_TASK must be set for this command to run" >> $OUTFILE
  67.         exit 1
  68. fi
  69. loc_ok=0
  70. for X in "PROD" "TEST" "SUPPORT" "DEV" "TRAIN"
  71. do
  72.         if [ $X = $TWO_TASK ]; then
  73.                 loc_ok=1
  74.         fi      
  75. done
  76. if [ $loc_ok = 0 ]; then
  77.         echo "TWO_TASK is not correctly set." >> $OUTFILE
  78.         echo "TWO_TASK = $TWO_TASK" >> $OUTFILE
  79.         exit 1
  80. fi
  81.  
  82. TMP=`echo $I_SRC_DIR | sed -n 's/\(^.[^$]*\)\(.\{1\}$\)/\2/p'`
  83. if [ $TMP != "/" ]
  84.         then
  85.         echo "Source dir dosn't end with / (" $I_SRC_DIR ")" >> $OUTFILE
  86.         exit 1
  87. fi              
  88. TMP=`echo $I_SRC_DIR |cut -c1-1`
  89. if [ $TMP != "/" ]
  90.         then
  91.         echo "Source dir dosn't start with / (" $I_SRC_DIR ")" >> $OUTFILE
  92.         exit 1
  93. fi            
  94.  
  95. if [ "PROD" != $TWO_TASK ]
  96.         then
  97.         I_DEST_FIL="TEST_FILE_"$TWO_TASK"_"$I_DEST_FIL
  98.         echo "Non prod, changed Dest File name to: " $I_DEST_FIL >> $OUTFILE
  99. fi
  100.  
  101. if [ ! -d $I_SRC_DIR ]; then
  102.         echo "ERROR - Can't find the source directory (" $I_SRC_DIR ")" >> $OUTFILE
  103.         exit 1
  104. fi
  105.  
  106. if [ ! -f $I_SRC_DIR$I_SRC_FIL ]; then
  107.         echo "Source file does not exist (" $I_SRC_DIR$I_SRC_FIL ")" >> $OUTFILE
  108.         exit 1
  109. fi
  110.  
  111. loc_ok=0
  112. for X in "BST" "Finance" "HR"
  113. do
  114.         if [ $X = $I_DEST_DIR ]; then
  115.                 loc_ok=1
  116.         fi      
  117. done
  118. if [ $loc_ok = 0 ]; then
  119.         echo "Dest dir must be one of ""BST"" ""Finance"" ""HR""" >> $OUTFILE
  120.         echo "Dest dir = $I_DEST_DIR" >> $OUTFILE
  121.         exit 1
  122. fi
  123. I_DEST_DIR=$I_DEST_DIR "/"
  124.  
  125. echo "Checks passed, attempting transfer..." >> $OUTFILE
  126.  
  127. #************************************************END OF CHECKS ACTUALL CODE TO DO TRANSFER*****************************
  128.  
  129. $XXGC_TOP/bin/ftp_call2.sh $I_SRC_DIR $I_SRC_FIL $I_FTP_HOST $I_DEST_DIR $I_FTP_USER $I_FTP_PASS $I_DEST_FIL >> $OUTFILE
  130.  
  131. TMP=`grep "Not connected" $OUTFILE`
  132. if [ "E" != E$TMP  ]; then
  133.         echo "ERROR - is the hostname correct?" >> $OUTFILE
  134.         exit 1
  135. fi
  136. TMP=`grep "Login failed" $OUTFILE`
  137. if [ "E" != E$TMP  ]; then
  138.         echo "ERROR - the FTP login failed. Is the username and password correct?" >> $OUTFILE
  139.         exit 1
  140. fi
  141. TMP=`grep "File not found" $OUTFILE`
  142. if [ "E" != E$TMP  ]; then
  143.         echo "ERROR - File not found - Transfer failed" >> $OUTFILE
  144.         exit 1
  145. fi
  146. TMP=`grep "No such file or directory" $OUTFILE`
  147. if [ "E" != E$TMP  ]; then
  148.         echo "ERROR - No such file or directory - Transfer failed" >> $OUTFILE
  149.         exit 1
  150. fi
  151. TMP=`grep "Cannot create a file when that" $OUTFILE`
  152. if [ "E" != E$TMP  ]; then
  153.         echo "ERROR - Can't create file. Try deleting contents or ftp dir - Transfer failed" >> $OUTFILE
  154.         exit 1
  155. fi
  156. TMP=`grep "250 RNTO command successful" $OUTFILE`
  157. if [ "E" = E$TMP  ]; then
  158.         echo "ERROR - No sucessful rename found - Transfer failed" >> $OUTFILE
  159.         exit 1
  160. fi
  161. TMP=`grep "426 Connection closed; transfer aborted" $OUTFILE`
  162. if [ "E" != E$TMP  ]; then
  163.         echo "ERROR - The transfer aborted. This could be because there is not enough disk space availible" >> $OUTFILE
  164.         echo "on the ftp drive" >> $OUTFILE
  165.         echo "The FTP drive should be used as a transfer location only, not to store files" >> $OUTFILE
  166.         echo "Clear down the directory and retry" >> $OUTFILE
  167.         echo "If this does not work call system support" >> $OUTFILE
  168.         exit 1
  169. fi
  170.  
  171. echo "FTP Transfer operation completed sucessfully" >> $OUTFILE
  172.  
  173. exit 0

ftp_call2.sh

  1. #echo $username $password $target_server
  2. # start the copy
  3. cd $1
  4. USER=$5
  5. PASSWD=$6
  6. ftp -i -n -d $3 <<SCRIPT
  7. user $USER $PASSWD
  8. verbose
  9. cd $4
  10. delete "$2"
  11. delete "$7"
  12. put "$2"
  13. rename "$2" "$7"
  14. quit

SCRIPT
Misc
Note: Create this file in $XXGC_TOP/bin as ftp_transfer.prog
Then run symbolic link code

Tags

RJM Article Type
Quick Reference