Powershell - using WINSCP to submit files to Filetype = JES

[DBDivaAuto]

Hi Everyone,

I am trying to automate a process that I think should be possible in Powershell using the WINSCP as a mediator.

The line in question is

"call `"`"site filetype=JES`"`"" `

which I also tried

"call site filetype=JES" `

# PowerShell >=7.3

$PSNativeCommandArgumentPassing = "Legacy"

& "C:\Program Files (x86)\WinSCP\WinSCP.com" `
  /log="C:\IPM\FTPLogs\WinSCP.log" /ini=nul `
  /Command  "open ftps://USERNAME:PW@SOMESITE.hhsc.texas.gov/" `
    "lcd c:\CareUpload\" `
   [b] "call `"`"site filetype=JES`"`"" `[/b]
    "mput -nopreservetime -nopermissions  CB%TIMESTAMP#yymmdd%" `
    "exit"

$winscpResult = $LastExitCode
if ($winscpResult -eq 0)
{
  Write-Host "Success"
}
else
{
  Write-Host "Error"
}

The code runs and returns the following:

PS C:\Windows\system32> C:\Scripts\PutCareBatch.ps1
Connecting to SOMESITE.hhsc.texas.gov:990 ...
TLS connection established. Waiting for welcome message...
Connected
Starting the session...
Session started.
Active session: [1] LOGIN@SOMESITE.hhsc.texas.gov
c:\CareUpload
200 SITE command was accepted
CB230331 | 84 KB | 270.5 KB/s | binary | 100%
Success

The session is starting, the login is accepted, I am passing the site command and the file name and size is there correctly but it is not landing in the Site Filetype = JES area.

Does anyone have code for something similar?

 

[mikrom]

IMO it should be

"call site filetype=JES" `

 

[DBDivaAuto]

Mikrom - one would think. The code runs and gives the verification that the SITE command was accepted but the file is not making it up to the remote server. I am wondering if it's a time issue. Like the time between the verification and the transfer of the file needs a little break in between.

 

[mikrom]

and are you sure that this mput works ?:

"mput -nopreservetime -nopermissions  CB%TIMESTAMP#yymmdd%" `

Have you tried instead only simple put like this if it works or not ?:

"put only_one_file" `

 

[DBDivaAuto]

I will try that this afternoon. Another restraint here is that I can only test in a little window everyday because you get 1 batch upload per day. I will let you know if it works.