Friday, 21 November 2008

Sysadmin: FTP scripts


@echo off
setlocal

::---------------------------------
:: Start Logging
::---------------------------------

set logfile="C:\_Job_Import_Export\EC\FTP Log\ECLicence.Log"

::---------------------------------
:: Setup Variables
::---------------------------------

set f=%temp%\ftpc.txt

::---------------------------------
:: Compose ftp commands file
::---------------------------------

echo open 192.168.0.1>>%f%
echo user username password>>%f%
echo binary>>%f%
echo cd _job_import_export>>%f%
echo cd "EC">>%f%
echo mput "C:\data\location\*.csv">>%f%
echo bye>>%f%

::---------------------------------
:: Execute ftp command
:: Use "-d" key for verbose output
:: Use "-i" key no interactive mode
::---------------------------------

echo ------------------------>>%logfile%
echo %date% %time% : Start FTP job>>%logfile%
echo ------------------------>>%logfile%
ftp -n -d -i -s:%f% >> %logfile%

::---------------------------------
:: Cleanup temp script
::---------------------------------

del /f /q %f%

::---------------------------------
:: %date% %time% : Backup files
::---------------------------------

L:
cd\
cd "data\location"
echo ------------------------>>%logfile%
echo %date% %time% : Backing Up Files>>%logfile%
echo ------------------------>>%logfile%
move *.csv "backups">>%logfile%
echo ------------------------>>%logfile%
echo %date% %time% : Job Completed>>%logfile%
echo ------------------------>>%logfile%
echo =-=-=-=-=-=-=-=-=-=-=-=->>%logfile%

endlocal

No comments: