Forum » Scripting / Automation »

Post a reply

Username

Subject

Message body

Font colour:

Font size:

[quote="vmsystems"]Script Type: PowerShell
Use case: For SFTP Uploads and Downloads

Hello WinSCP Team

I am using PowerShell + WinSCPnet.dll to automate a file uploads and downloads.

Problem description Upload Script:
At the start the script should check if files are present on the localpath, if yes the script should be executed to the end and if no the script should be aborted.

Problem description Download Script:
After the script has successfully established the session via SFTP to the server, the script should first check if files are available on this server or not, if the files are not available the script should be terminated and if files are available the script should be executed until the end.

Unfortunately, I have not found a simpler description in the forum how to perform a file check on a localpath and externalpath. I would like to extend this script with this function.

It is not a specific file type, but is simply to check "*" everything in the path.

Could anybody help me with this?

Code Upload Script:
[code]@powershell@
Start-Transcript %LOCALPATH%\Powershell.log

# Load WinSCP .NET assembly
Add-Type -Path "%LOCALPATH%\WinSCPnet.dll"

# Setup session options
$sessionOptions = New-Object WinSCP.SessionOptions -Property @{
    Protocol = [WinSCP.Protocol]::Sftp
    HostName = "%SERVER%"
    UserName = "%USER%"
    PrivateKeyPassphrase = "%PASSWORD PRIVATE KEY%"
    SshPrivateKeyPath = "%PRIVATE KEY%"
    SshHostKeyFingerprint = "ssh-rsa 4096"
}

$session = New-Object WinSCP.Session
$session.SessionLogPath = "%LOCALPATH%\WinSCP.log"

try
{
    # Connect
    $session.Open($sessionOptions)
    
    # Upload files & Remove original
    $session.PutFiles("%LOCALPATH%\*", "%REMOTEPATH%\", $true).Check()
}
finally
{
    # Disconnect, clean up
    $session.Dispose()
}

Stop-Transcript
[/code]
Code Download Script:
[code]@powershell@
Start-Transcript %LOCALPATH%\Powershell.log

# Load WinSCP .NET assembly
Add-Type -Path "%LOCALPATH%\WinSCPnet.dll"

$session = New-Object WinSCP.Session
$session.SessionLogPath = "%LOCALPATH%\WinSCP.log"

try
{
     # Connect
     $session.Open($sessionOptions)

# Download files
     $session.GetFiles("/%REMOTEPATH%/*", "%LOCALPATH%\*").Check()
 
     # Remove files
     $session.RemoveFiles("/%REMOTEPATH%/*")
}
finally
{
    # Disconnect, clean up
    $session.Dispose()
}

Stop-Transcript
[/code][/quote]

Options

Disable BBCode in this post

Notify me when a reply is posted (registered users only)

Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

Filename

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

File Comment

Options

Private file (available to author and site moderators only)

Topic review

martin

Re: How to check file existence on local and remote path, then stop script if it does not exist

2021-12-13

vmsystems wrote:

Problem description Upload Script:
At the start the script should check if files are present on the localpath, if yes the script should be executed to the end and if no the script should be aborted.

Checking for an existence of local files in not a WinSCP question.
Anyway, you can use Test-Path:
https://winscp.net/eng/docs/script_checking_file_existence#local

Problem description Download Script:
After the script has successfully established the session via SFTP to the server, the script should first check if files are available on this server or not, if the files are not available the script should be terminated and if files are available the script should be executed until the end.

That's exactly what your script does now. It does not need any change.
Anyway, again, see:
https://winscp.net/eng/docs/script_checking_file_existence#library

Though note that you should not use Session.GetFiles followed by Session.RemoveFiles. That's not transactionally safe. You might end up deleting files that were not downloaded. Instead use remove argument of Session.GetFiles. The same way you do with Session.PutFiles in your upload script.

$session.GetFiles("/%REMOTEPATH%/*", "%LOCALPATH%\*", $True).Check()

vmsystems

How to check file existence on local and remote path, then stop script if it does not exist

2021-12-09 15:18

Script Type: PowerShell
Use case: For SFTP Uploads and Downloads

Hello WinSCP Team

I am using PowerShell + WinSCPnet.dll to automate a file uploads and downloads.

Problem description Upload Script:
At the start the script should check if files are present on the localpath, if yes the script should be executed to the end and if no the script should be aborted.

Problem description Download Script:
After the script has successfully established the session via SFTP to the server, the script should first check if files are available on this server or not, if the files are not available the script should be terminated and if files are available the script should be executed until the end.

Unfortunately, I have not found a simpler description in the forum how to perform a file check on a localpath and externalpath. I would like to extend this script with this function.

It is not a specific file type, but is simply to check "*" everything in the path.

Could anybody help me with this?

Code Upload Script:

Start-Transcript %LOCALPATH%\Powershell.log
 
# Load WinSCP .NET assembly
Add-Type -Path "%LOCALPATH%\WinSCPnet.dll"
 
# Setup session options
$sessionOptions = New-Object WinSCP.SessionOptions -Property @{
    Protocol = [WinSCP.Protocol]::Sftp
    HostName = "%SERVER%"
    UserName = "%USER%"
    PrivateKeyPassphrase = "%PASSWORD PRIVATE KEY%"
    SshPrivateKeyPath = "%PRIVATE KEY%"
    SshHostKeyFingerprint = "ssh-rsa 4096"
}
 
$session = New-Object WinSCP.Session
$session.SessionLogPath = "%LOCALPATH%\WinSCP.log"
 
try
{
    # Connect
    $session.Open($sessionOptions)
    
    # Upload files & Remove original
    $session.PutFiles("%LOCALPATH%\*", "%REMOTEPATH%\", $true).Check()
}
finally
{
    # Disconnect, clean up
    $session.Dispose()
}  
 
Stop-Transcript

Code Download Script:

Start-Transcript %LOCALPATH%\Powershell.log
 
# Load WinSCP .NET assembly
Add-Type -Path "%LOCALPATH%\WinSCPnet.dll"
 
# Setup session options
$sessionOptions = New-Object WinSCP.SessionOptions -Property @{
    Protocol = [WinSCP.Protocol]::Sftp
    HostName = "%SERVER%"
    UserName = "%USER%"
    PrivateKeyPassphrase = "%PASSWORD PRIVATE KEY%"
    SshPrivateKeyPath = "%PRIVATE KEY%"
    SshHostKeyFingerprint = "ssh-rsa 4096"
}
 
$session = New-Object WinSCP.Session
$session.SessionLogPath = "%LOCALPATH%\WinSCP.log"
 
try
{
     # Connect
     $session.Open($sessionOptions)
 
     # Download files
     $session.GetFiles("/%REMOTEPATH%/*", "%LOCALPATH%\*").Check()
 
     # Remove files
     $session.RemoveFiles("/%REMOTEPATH%/*")
}
finally
{
    # Disconnect, clean up
    $session.Dispose()
}  
 
Stop-Transcript

Post a reply

Topic review

Re: How to check file existence on local and remote path, then stop script if it does not exist

How to check file existence on local and remote path, then stop script if it does not exist

Documentation

Support

Associations

Follow Us