Secure FTP using Windows batch script

by

First, make sure you understand, if you need to use Secure FTP (=FTPS, as per your text) or SFTP (as per tag you have used).

Neither is supported by Windows command-line ftp.exe. As you have suggested, you can use WinSCP. It supports both FTPS and SFTP.

Using WinSCP, your batch file would look like (for SFTP):

echo open sftp://ftp_user:[email protected] -hostkey="..." >> ftpcmd.dat
echo put c:\directory\%1-export-%date%.csv >> ftpcmd.dat
echo exit >> ftpcmd.dat
winscp.com /script=ftpcmd.dat
del ftpcmd.dat

And the batch file:

winscp.com /log=ftpcmd.log /script=ftpcmd.dat /parameter %1 %date%

Though using all capabilities of WinSCP (particularly providing commands directly on command-line and the %TIMESTAMP% syntax), the batch file simplifies to:

winscp.com /log=ftpcmd.log /command ^
    "open sftp://ftp_user:[email protected] -hostkey=""...""" ^
    "put c:\directory\%1-export-%%TIMESTAMP#yyyymmdd%%.csv" ^
    "exit"

For the purpose of -hostkey switch, see verifying the host key in script.

Easier than assembling the script/batch file manually is to setup and test the connection settings in WinSCP GUI and then have it generate the script or batch file for you:

Generate batch file

All you need to tweak is the source file name (use the %TIMESTAMP% syntax as shown previously) and the path to the log file.

For FTPS, replace the sftp:// in the open command with ftpes:// (explicit TLS/SSL) or ftps:// (implicit TLS/SSL). Remove the -hostkey switch.

winscp.com /log=ftpcmd.log /command ^
    "open ftps://ftp_user:[email protected] -explicit" ^
    "put c:\directory\%1-export-%%TIMESTAMP#yyyymmdd%%.csv" ^
    "exit"

You may need to add the -certificate switch, if your server’s certificate is not issued by a trusted authority.

Again, as with the SFTP, easier is to setup and test the connection settings in WinSCP GUI and then have it generate the script or batch file for you.

See a complete conversion guide from ftp.exe to WinSCP.

You should also read the Guide to automating file transfers to FTP server or SFTP server.

Note to using %TIMESTAMP#yyyymmdd% instead of %date%: A format of %date% variable value is locale-specific. So make sure you test the script on the same locale you are actually going to use the script on. For example on my Czech locale the %date% resolves to čt 06. 11. 2014, what might be problematic when used as a part of a file name.

For this reason WinSCP supports (locale-neutral) timestamp formatting natively. For example %TIMESTAMP#yyyymmdd% resolves to 20170515 on any locale.

(I’m the author of WinSCP)

More Related Contents:

  1. How to ftp with a batch file?
  2. Batch file to upload .txt to FTP
  3. How do I get current date/time on the Windows command line in a suitable format for usage in a file/folder name?
  4. Symbol equivalent to NEQ, LSS, GTR, etc. in Windows batch files
  5. How do you get the string length in a batch file?
  6. How do you loop through each line in a text file using a windows batch file?
  7. How to delete files/subfolders in a specific directory at the command prompt in Windows
  8. How do I escape ampersands in batch files?
  9. How to use random in BATCH script?
  10. Batch script: how to check for admin rights
  11. Why does %date% produce a different result in batch file executed as scheduled task?
  12. Setting a system environment variable from a Windows batch file?
  13. In Windows cmd, how do I prompt for user input and use the result in another command?
  14. Batch script loop
  15. FORFILES date -after- (date calc in cmd file)
  16. Create an empty file on the commandline in windows (like the linux touch command)
  17. XCOPY still asking (F = file, D = directory) confirmation
  18. How to prevent auto-closing of console after the execution of batch file
  19. Get current batchfile directory
  20. Redirecting Output from within Batch file
  21. Creating a file name as a timestamp in a batch job
  22. Detect whether current Windows version is 32 bit or 64 bit
  23. How to check if a service is running via batch file and start it, if it is not running?
  24. How can I run a windows batch file but hide the command window?
  25. How to list all folder with size via batch file
  26. Access clipboard in Windows batch file
  27. Rename all files in a directory with a Windows batch script
  28. Batch file encoding
  29. How do I increment a folder name using Windows batch?
  30. Using echo y as an automated response to a pcp hostkey prompt

Leave a Comment