Creating a folder to download into :: Support Forum

Shay_
Joined:: 2021-03-28
Posts:: 4

Creating a folder to download into

2021-03-28 21:16

As title says, is it possible to have the batch file create a folder and download files into it so I can have multiple backups?
Also is it possible to download into a compressed zip file?

Reply with quote

martin◆ Site Admin
Joined:: 2002-12-10
Posts:: 41,468
Location:: Prague, Czechia

Re: Creating a folder to download into

2021-03-29

Create the folder in the batch file using mkdir command. And then execute WinSCP from the same batch file for the download.

Similarly, if you want to ZIP the downloaded files, execute the "zip" after WinSCP finishes with the download.

Reply with quote

Shay_
Joined:: 2021-03-28
Posts:: 4

2021-03-29 22:49

Sorry, I'm really new to all this. Could I get an example with my batch code?
If I do zip files, I'm hoping it'll create a zip each time with a timestamp so they're easy to track.

@echo off
 
"C:\Program Files (x86)\WinSCP\WinSCP.com" ^
  /log="C:\WinSCP.log" /ini=nul ^
  /command ^
    "open sftp://stuff@stuff/ -hostkey="""" -rawsettings FSProtocol=2 ProxyPort=0" ^
    "cd /17539" ^
    "lcd C:\Backups" ^
    "get folder" ^
    "get folder" ^
    "exit"
 
set WINSCP_RESULT=%ERRORLEVEL%
if %WINSCP_RESULT% equ 0 (
  echo Success
) else (
  echo Error
)
 
exit /b %WINSCP_RESULT%

Reply with quote

martin◆ Site Admin
Joined:: 2002-12-10
Posts:: 41,468
Location:: Prague, Czechia

2021-04-04

Example of what? Using the mkdir?

mkdir C:\Backups
 
"C:\Program Files (x86)\WinSCP\WinSCP.com" ^
...

Reply with quote

Shay_
Joined:: 2021-03-28
Posts:: 4

2021-04-05 08:42

An example if I were to use the zip command. You said execute zip once the download finishes right? So would it be something like this?

@echo off
 
"C:\Program Files (x86)\WinSCP\WinSCP.com" ^
  /log="C:\WinSCP.log" /ini=nul ^
  /command ^
    "open sftp://stuff@stuff/ -hostkey="""" -rawsettings FSProtocol=2 ProxyPort=0" ^
    "cd /17539" ^
    "lcd C:\Backups" ^
    "get folder" ^
    "get folder" ^
    "zip -r "backup-`date +%Y%m%d%H%M`.zip" "backup/"" ^
    "exit"
 
set WINSCP_RESULT=%ERRORLEVEL%
if %WINSCP_RESULT% equ 0 (
  echo Success
) else (
  echo Error
)
 
exit /b %WINSCP_RESULT%

I saw the command in another thread, but I'm not sure if it's the exact one I need to use. Right now I just want to download two folders and zip them into the directory with a timestamp.

Reply with quote

martin◆ Site Admin

2021-04-07

Where the echo Success is.

Though `date +%Y%m%d%H%M` is a *nix construct, it won't work on Windows. This may help you: https://winscp.net/eng/docs/script_formatting_timestamp_batch_file

Reply with quote

Shay_
Joined:: 2021-03-28
Posts:: 4

2021-04-08 06:43

@echo off
 
"C:\Program Files (x86)\WinSCP\WinSCP.com" ^
  /log="C:\WinSCP.log" /ini=nul ^
  /command ^
    "open sftp://stuff@stuff/ -hostkey="""" -rawsettings FSProtocol=2 ProxyPort=0" ^
    "cd /17539" ^
    "lcd C:\Backups" ^
    "get folder" ^
    "get folder" ^
    "exit"
 
set WINSCP_RESULT=%ERRORLEVEL%
if %WINSCP_RESULT% equ 0 (
  echo Success
    "zip -r "backup.zip" "!/"" ^
    "set TIMESTAMP_FORMAT=yyyy-mm-dd
winscp.com /command "echo %%TIMESTAMP#%TIMESTAMP_FORMAT%%%" "exit""
) else (
  echo Error
)
 
exit /b %WINSCP_RESULT%

Did I do this correctly?

Reply with quote

martin◆ Site Admin
Joined:: 2002-12-10
Posts:: 41,468
Location:: Prague, Czechia

2021-04-09

No. That's not the code from the article, it should be like:

set TIMESTAMP_FORMAT=yyyy-mm-dd
 
for /F "tokens=* USEBACKQ" %%F in (
    `winscp.com /command "echo %%TIMESTAMP#%TIMESTAMP_FORMAT%%%" "exit"`
) do set TIMESTAMP=%%F
 
zip -r "backup-%TIMESTAMP%.zip" C:\Backups

I do not know about the zip commandline syntax, that depends on what implementation of ZIP you have. And that's not a WinSCP question anyway.

Reply with quote

Creating a folder to download into

Creating a folder to download into

Re: Creating a folder to download into

Documentation

Support

Associations

Follow Us