Optimizing a large script for FTP File downloads (~1100 lines)
I'm having a bit of trouble with running a .NET Assembly Powershell script. .NET Assembly and C code is very new to me, excuse my lack of knowledge. It takes ages and sometimes will timeout on various blocks of code, despite almost every script having a or more.
I have a large FTP structure and I need certain files from certain subfolders. I have broken it up into many blocks like this, all with different filemasks and root/local folder parameters:
I am wondering how to make it more efficient. It takes a while for just one block to run, given the sheer scale of the subfolder and file structure, but, is there any way to make it more 'efficient'? Tips, ideas? .NET Assembly and C code are very new to me, excuse my lack of knowledge. I stashed all of them in a PowerShell ISE editor and run them all there.
$session.Timeout = New-TimeSpan -Seconds 600
I have a large FTP structure and I need certain files from certain subfolders. I have broken it up into many blocks like this, all with different filemasks and root/local folder parameters:
# Load WinSCP .NET assembly Add-Type -Path "WinSCPnet.dll" # Set up session options $sessionOptions = New-Object WinSCP.SessionOptions -Property @{ Protocol = [WinSCP.Protocol]::Ftp HostName = "x" UserName = "x" Password = "x" FtpSecure = [WinSCP.FtpSecure]::Implicit } $session = New-Object WinSCP.Session $remotePath = "/FTPFolder1/Subfolder1/Subf2/" $localPath = "C:\Users\ABBBB\xxxxxx\xxxxxxx\xxxxxxx\xxxxxx\xxxxxxxx\" try { # Connect $session.Open($sessionOptions) $session.Timeout = New-TimeSpan -Seconds 600 # Masking $transferOptions = New-Object WinSCP.TransferOptions $transferOptions.FileMask = "Census Data Files/*/*.xlsx" # Download files $transferOptions.AddRawSettings("ExcludeEmptyDirectories", "1") $session.GetFiles($remotePath, $localPath, $False, $transferOptions).Check() } finally { # Disconnect, clean up $session.Dispose() }
