gerlines.blogg.se

# Check if the required number of Files available for download $matches=select-string -pattern "BRAE_GE_*" C:\logs\$file_log # Connect to Remote Server and get file listingįtp -n -v -s:C:\Clover\scripts\fc.txt 10.129.120.31 > C:\logs\$file_log # Dynamically create the FTP Command to get a list of files fromĮcho "Call function that creates a FTP Command " # Change location to folder where the files need to be downloaded

$file_pattern = "BRAE_GE_*" + $yesterday_fmt + "*.csv" $yesterday_fmt = date $yesterday -format "yyyyMMdd" Write-output quit | out-file -filepath C:\fc.txt -encoding ASCII -Append Write-output "ls $p_file_pattern" | out-file -filepath C:\fc.txt -encoding ASCII -Append Write-output "mget $p_file_pattern" | out-file -filepath C:\fc.txt -encoding ASCII -Append

Write-output "prompt" | out-file -filepath C:\fc.txt -encoding ASCII -Append Write-output "ASCII" | out-file -filepath C:\fc.txt -encoding ASCII -Append Write-output "password" | out-file -filepath C:\fc.txt -encoding ASCII -Append Write-output "ftpusername" | out-file -filepath C:\fc.txt -encoding ASCII -Append Write-output "USER" | out-file -filepath C:\fc.txt -encoding ASCII # we need to make sure we create an ASCII file. # Unicode command files are not compatible with FTP so # PowerShell default encoding is Unicode. # The file needs to be prepared daily because the # This function dynamically prepares the FTP file. function make_ftp_command_file($p_file_pattern,$mget_flag) I run this from a Windows Server 2008 connecting to a Windows XP remote server. If they I invoked the FTP the second time with an Mget. I first checked if the requisite number of files existed. I did not need to download any additional components. As I needed to download a file based on a pattern I dynamically created a command file and then let ftp do the rest. You can use PowerShell as well this is what I did. If not you just launch the batchfile and provide the name of the file to get as an argument. If you are always getting the same file you can replace the %1 with the file name. Replace servername, username, and password with your details and the batch file will generate the script as temp.txt launch ftp with the script and then delete the script. The documentation specifically points out that you should not try to pipe input into the FTP client with a temp.txt

Using the Windows FTP client you would want to use the -s:filename option to specify a script for the FTP client to run.