PowerShell script, Transfer to SFTP and then rename the local file and move to another folder
Guys, you who are great experts can you help me?
I have a set of folders with files inside and a subfolder.
etc etc.
Each parent folder contains files with a specific prefix and all ending in
These files must be sent to an SFTP every night and after they are sent I must add the date and time (timestamp) before the
and move them into the
If I can also add a email notification with the Office 365 server that would be great.
Can anyone help me as soon as possible in this?
I started from this script but I couldn't rename the file to
The move and the log I was able to do.
I have a set of folders with files inside and a subfolder.
ASSOCIATIONS_IT ArticleL1_declaration.xlsx ArticleL2_declaration.xlsx ArticleL3_declaration.xlsx ↳ ARCHIVE CATALOG ArticleL1_catalogs.xlsx ArticleL2_catalogs.xlsx ArticleL3_catalogs.xlsx ↳ ARCHIVE ITEM ArticleL1_Master_xxx.xlsx ArticleL2_Master_xxx.xlsx ArticleL3_Master_xxx.xlsx ↳ ARCHIVE
Each parent folder contains files with a specific prefix and all ending in
.xslx.
These files must be sent to an SFTP every night and after they are sent I must add the date and time (timestamp) before the
.xslx.
and move them into the
ARCHIVE child folder.
If I can also add a email notification with the Office 365 server that would be great.
Can anyone help me as soon as possible in this?
I started from this script but I couldn't rename the file to
Name.timestamp.xlsx.
The move and the log I was able to do.
param ( $localPath = "C:\WEBORDER\ASSOCIATIONS_IT\Article*.xlsx", $remotePath = "/", $backupPath = "C:\WEBORDER\ASSOCIATIONS_IT\ARCHIVE\" ) try { # Load WinSCP .NET assembly Add-Type -Path "C:\Program Files (x86)\WinSCP\WinSCPnet.dll" # Setup session options $sessionOptions = New-Object WinSCP.SessionOptions -Property @{ Protocol = [WinSCP.Protocol]::Ftp HostName = "hostftp" UserName = "username" Password = "password" } $session = New-Object WinSCP.Session $session.SessionLogPath = "C:\WEBORDER\LOGS\incremental_LOG.log" try { # Connect $session.Open($sessionOptions) # Upload files, collect results $transferResult = $session.PutFiles($localPath, $remotePath) # Iterate over every transfer foreach ($transfer in $transferResult.Transfers) { # Success or error? if ($transfer.Error -eq $Null) { Write-Host "Upload of $($transfer.FileName) succeeded, moving to backup" # Upload succeeded, move source file to backup Move-Item $transfer.FileName $backupPath } else { Write-Host "Upload of $($transfer.FileName) failed: $($transfer.Error.Message)" } } } finally { # Disconnect, clean up $session.Dispose() } exit 0 } catch { Write-Host "Error: $($_.Exception.Message)" exit 1 }
