Question: Can I use JobBuilder to upload a file from a FTP or SFTP Site?
Answer: Yes, this can be accomplished!
For the purposes of this article, the WinSCP SFTP Client was used.
The first step is to create a script file:
A script file will be required for JobBuilder to use with WinSCP and saved as a .txt file
Example Script:
# Connect
open sftp://username:password@sftp.sftpserver.com
# Command 1 (change directory to file location)
cd /path to directory where file can be found
# Command 2 (specify local location where file should be saved)
lcd C:\Users\username\Downloads
# Select File to download
get filename.extension
JobBuilder Setup
- Set Command to Run
- Specify path to Command Line version of WinSCP
- Specify path to Script File
- Optionally run minimized
This will save the filename.extension file to the Downloads directory where it would be available for additional processing using DemandTools scenarios or other applications (such as Excel for Macro runs) also using JobBuilder.
