Post a reply

Options
Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

Options

Topic review

martin

Re: Automating Download from SFTP remote site

falcrawl wrote:

Thanks but this did not work.

Well, would your mind giving us more details? Describing what "does not work"? A log file? Anything?

To generate log file, use /log=path_to_log_file command-line argument. Submit the log with your post as an attachment. Note that passwords and passphrases not stored in the log. You may want to remove other data you consider sensitive though, such as host names, IP addresses, account names or file names (unless they are relevant to the problem). If you do not want to post the log publicly, you can mark the attachment as private.
falcrawl

Re: Automating Download from SFTP remote site

martin wrote:

Not sure what you mean by "verify the correct folder".

But to download files to the folder named after the current day use:

get -delete -resume -filemask="/Outbox/*.pdf" "Z:\sub1\sub2\%TIMESTAMP#mmddyyyy%\

See https://winscp.net/eng/docs/scripting#timestamp



Thanks but this did not work.
martin

Re: Automating Download from SFTP remote site

Not sure what you mean by "verify the correct folder".

But to download files to the folder named after the current day use:

get -delete -resume -filemask="/Outbox/*.pdf" "Z:\sub1\sub2\%TIMESTAMP#mmddyyyy%\

See https://winscp.net/eng/docs/scripting#timestamp
falcrawl

Automating Download from SFTP remote site

All
New to this but achieving some measure of success.
I am connecting to a sFTP site to download a bunch of files everyday to a new folder created everyday by the date stamp. (Done this with a batch file and schedule it to run everyday)
My script is as follows
option batch abort
option confirm off
open sftp://user:password@site.com -hostkey="ssh-rsa 1024 34:2b:a4:06:c7:40:ea:6c:1e:ae:b7:c2:82:34:db:ef"
get -delete -resume -filemask="/Outbox/*.pdf" "Z:\sub1\sub2\MMDDYYYY\
exit

Question.
How can I get the script to verify the correct folder and download the files to that folder for that day. The next day a new folder is created and the files for that day will be downloaded to the current folder

Thanks