I needed to automate the upload of csv files to an SFTP server for print fulfilment. It was a bit trickier than I thought it would be so I recorded what I did in case I need to do it again someday.

1)     Download and install WinSCP from here: http://winscp.net

2)     Create a folder where files will be uploaded from and a sub folder called Archive

3)     Open WinSCP go to Options Select Storage and Set Configuration Storage to INI file (WinSCP.ini), close WinSCP.

4)     Add a the PATH to the WinSCP install folder in the Environment Variables

5)     Create a file in the upload folder called SftpScript.txt

6)     Create a .cmd file and add the following command, modify the path to SftpScript.txt

      winscp.com /console /script=C:\Files\PrintFulfilment\SftpScript.txt >> SftpUpload.log

7)     Add the following code to SftpScript.txt, update the parameters highlighted in red.

# Automatically answer all prompts negatively not to stall the script on errors

option batch on

# Disable overwrite confirmations that conflict with the previous

option confirm off

# Connect using a password

open user:password@ftp.somewhere.com

# Force binary mode transfer

option transfer binary

# Change to home directory

cd

# Upload the file to current working directory

put C:\Files\PrintFulfilment\*.csv

# Disconnect

close

# Exit WinSCP

Exit

8)     To prevent the same file being uploaded next time the command runs add the following to the .cmd File, updating the file mask and archive folder path.

MOVE *.csv C:\Files\PrintFulfilment\Archive\