Automating FTP PUT Jobs from UNIX to a Windows FTP Server

Last month I had to find a way to automate the transfer of files from a UNIX database server to a Windows fileshare via the pre-existing FTP method. This was previously executed manually. The trouble I ran into was passing the FTP commands from a UNIX shell script to the Windows FTP server (specifically, user credentials) correctly. Second, I also wanted to automate the process of archiving these files to a new directory after transfer. Here's what I came up with, variables requiring your modification in bold:
################################################################################
#*************************  Script Title   ******************************
#
# Script Name:     FTP PUT TO WINDOWS FTP SERVER
# Script Filename: FTP_PUT_TO_WINFTPSERVER.sh
#
#
#*********************  Script Description  ************************************
#
# This shell script will look for files matching 'FTP_*.dat' and FTP any
# found to a Windows FTP server, then archive them in a folder named
# the current date.
#
#*************************  Modification Log     *******************************
#
#      Date             Name             Description
#_____________________________________________________________________________
#
#   10/19/2011       Bryce Baker        Original script
#
#*******************************************************************************
################################################################################

#!bin/sh
#***** Set local working directory *****
cd /path/to/script/and/files

#***** Set ftp server, credentials, and file(s) to search for *****
HOST='SERVERADDRESS'
USER='FTPUSERNAME'
PASSWD='FTPPASSWORD'
FILE='FTP_*.dat'

#***** Send files to FTP server *****
ftp -vn $HOST <<END_SCRIPT
quote USER $USER
quote PASS $PASSWD
prompt n
mput $FILE
quit
END_SCRIPT

#***** Archive files *****
#***** Set DATE variable to current date *****
DATE='20'`date '+%y%m%d'`
mkdir $DATE
mv $FILE /path/to/archive/folder/$DATE/

exit 0

Comments

  1. srivathsaMarch 19, 2014 at 10:01 AM

    what is the destination location of the transferred file? how can we specify it in this code?

    ReplyDelete
  2. LikeableBiasMarch 19, 2014 at 8:37 PM

    The destination is the root of the FTP directory on the destination server. You can change the directory by doing a change directory (cd) before the mput command:

    cd /path/to/file/

    ReplyDelete

Post a Comment

Popular posts from this blog

Continuously Monitor Folder for New Files with PowerShell as a WindowsService

Recently encountered an old-school application that used a cobbled-together external service to generate reports and deliver to end-users in PDF format. Unfortunately, this service didn't have any error handling other than dropping the intended source content into a flat file in an error directory on the local disk. No monitoring, no notification, just fail and pretend it never happened. As these reports are critical to end users, I needed a way to monitor this directory for any new files and notify someone so that the report could be manually re-generated. After some initial Googling, I decided a quick PowerShell script would be the easiest method to continuously monitor the directory and fire off a notification when a new file is found. I'm admittedly an extreme PowerShell newbie, so I'm sure there are better, cleaner ways to do this, but this works nicely and is stable enough for now until my legacy system is retired in a few months. The below PowerShell script will inst...
Read more

Unprotect All Excel Sheets for All Workbooks in a Directory

This Excel macro came in very handy when I had a set of workbooks in a folder (and subfolders) that all needed unprotected before running another macro to combine all of the workbooks into a single file. Be sure to update the bolded variables below.  Source . Const cStartFolder = " C:\Documents and Settings\UserName\My Documents\Spreadsheets " 'no slash at end Const cFileFilter = " *.xlsx " Const cPassword = " CleverPassword " 'use empty quotes if blank Sub UnprotectAllWorksheets() Dim i As Long, j As Long, arr() As String, wkb As Workbook, wks As Worksheet ExtractFolder cStartFolder, arr() On Error Resume Next j = -1: j = UBound(arr) On Error GoTo 0 For i = 0 To j Set wkb = Workbooks.Open(arr(i), False) For Each wks In wkb.Worksheets wks.Unprotect cPassword Next wkb.Save wkb.Close Next End Sub Sub ExtractFolder(Folder As String, arr() As String) Dim i As Long, objF...
Read more

ChromeOS Flow by Hexxeh Install to HDD

I finally decided to pull out the netbook again and check out the ChromeOS release of Flow by Hexxeh . I got the image downloaded, untar'd and imaged to the thumbdrive. Now comes the part when I want to actually install it to the solid-state disk in my Asus EeePC, right? Well, online sources said to just run /usr/sbin/chromeos-install and it would be taken care of. It kept erroring with "Attempt to install to a removable device: /dev/sda". Of course, this is my thumbdrive so that would make sense. Since it took me some digging to figure this one out, I thought I'd throw up the solution here to make it a little more visible on the Interwebs. Instead, run this command: /usr/sbin/chromeos-install /dev/sdb This should work if your internal device is at least 8gb. Unfortunately for me, mine is 4gb and my source media is 2gb. Instead, I ended up just copying the entire live image from my thumbdrive to the hard drive. Whatever works, right? Run this command instead of the ab...
Read more