Okey, i got this working and the powershell script is enumerating the files.
So i get an reply saying this and this file exist,
How would i proceed with this?
Session.EnumerateRemoteFiles. For example this one:
$getscriptpath = $MyInvocation.MyCommand.Path
$dir = Split-Path $getscriptpath
cd $dir
$fileDate = get-date -f yyyy-MM-dd:HH:mm
$oldfile = "$dir\REMOVED.csv"
$newfile = "$dir\REMOVED\REMOVED-$fileDate.csv"
$remotepath = "/REMOVED/REMOVED/"
Add-Type -Path "C:\Program Files (x86)\WinSCP\WinSCPnet.dll"
$sessionOptions = New-Object WinSCP.SessionOptions -Property @{
Protocol = [WinSCP.Protocol]::Sftp
HostName = "SERVER"
UserName = "USER"
Password = "PASSWORD"
SshHostKeyFingerprint = "KEY"
}
$session = New-Object WinSCP.Session
try
{
$session.Open($sessionOptions)
$Session.EnumerateRemoteFiles($Remotepath, "*", [WinSCP.EnumerationOptions]::None)
}
Finally
{
}
Customer wants the .csv file to be put in a folder called C:\Scripts\CSV
If a new file comes in, the old file gets renamed to FILENAME-$Filedate.csv and moved to C:\Scripts\CSV\Imported
*.csv. And if anything gets actually downloaded, archive the previous version of the file.
if ($session.FileExists($remotePath))
I cant get the path to work correctly, ive tried with "FILE/PATH/*.csv" but i cant get it to recognize the file.
Session.FileExists with a file mask.
Session.EnumerateRemoteFiles. See:
if ($session.FileExists($remotePath))
Session.GetFiles with your file mask?
if ($session.FileExists($remotePath))
{
Write-Host "File $remotePath exists"
# Now you can e.g. download file using session.GetFiles
exit 0
}
else
{
Write-Host "File $remotePath does not exist"
exit 1
}
$remotePath = "/file/FromIEC/*"$remotePath = "/file/FromIEC/*.*"
$remotePath = "/file/FromIEC/*.csv"
$remotePath = "/file/FromIEC/NameOfFile.csv" <-- This works, not wildcard.