Forum » Scripting / Automation »

Post a reply

Username

Subject

Message body

Font colour:

Font size:

Options

Disable BBCode in this post

Notify me when a reply is posted (registered users only)

Add an Attachment

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

Filename

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

File Comment

Options

Private file (available to author and site moderators only)

Topic review

skumarlingamNC

Want to upload multiple files using SFTP to remote server

2016-10-17 16:17

Worked like a charm; Thank you.

martin

Re: Want to upload multiple files using SFTP to remote server

2016-10-17

This should work:

put V:\*.csv /XYZ/WVW_to_User/*_%TIMESTAMP#DD_MM_YYYY% -nopreservetime

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

skumarlingamNC

Want to upload multiple files using SFTP to remote server

2016-10-14 15:33

sorry for late reply.

Correct. below line is enough to upload multiple files via sftp.

-nopreservetime

thank you though for helping me.

Is that possible after uploading files on remote server can we suffix today's(current) datetime to each file

(example file name: XYZ_10_14_2016.csv)

Please let me know if you want me to open in spread thread.

Thank you in advance.

martin

Re: Want to upload multiple files using SFTP to remote server

2016-10-13

There's hardly any difference between put V:\*.csv and lcd V:\ + put *.csv.

It actually looks like the problem was this one, right?
https://winscp.net/eng/docs/message_preserve_time_perm

If that's the case, this is the only needed change:

put V:\*.csv /XYZ/WVW_to_User/ -nopreservetime

(the -nopermissions is the default)

jrp78

2016-10-13 01:29

Awesome. Happy to help 8)

skumarlingamNC

Want to upload multiple files using SFTP to remote server

2016-10-13 01:26

You are my hero Thank you. Finally I can upload all my multiple files.

here is the code the one suggested by you.

# Connect to SFTP server using a password 

open sftp://username:password;fingerprint=ssh-**s-**-**-**-**-**-**-**-**-**-**-**-**-**-**-**-**@sftp.**.com/XYZ/WVW_to_User/ 

# Upload file 

lcd V:\ 

put *.csv /XYZ/WVW_to_User/ -nopreservetime -nopermissions 

EXIT

Thank you once again.

Guest

Re: Want to upload multiple files using SFTP to remote server

2016-10-12 16:41

It must be erroring out. I would enable logging to see what exactly is happening. You can also try disabling the permission and timestamp setting to see if that's the problem. https://winscp.net/eng/docs/message_preserve_time_perm

# Connect to SFTP server using a password
open sftp://username:password;fingerprint=ssh-**s-**-**-**-**-**-**-**-**-**-**-**-**-**-**-**-**@sftp.**.com/XYZ/WVW_to_User/
# Upload file
lcd V:\
put *.csv /XYZ/WVW_to_User/ -nopreservetime -nopermissions
EXIT[/quote][/quote]

skumarlingamNC

Want to upload multiple files using SFTP to remote server

2016-10-12 16:19

sorry I changed code as per your suggestion. batch script picking first file and uploading on remote server. not picking other files.

Thank you in advance.

skumarlingamNC

Want to upload multiple files using SFTP to remote server

2016-10-12 16:05

Thank you my friend.

I will try and let you know the progress.

Thank you in advance.

Anonymous wrote:

I think you can try doing an LCD to change the directory then try the transfer.

# Connect to SFTP server using a password
open sftp://username:password;fingerprint=ssh-**s-**-**-**-**-**-**-**-**-**-**-**-**-**-**-**-**@sftp.**.com/XYZ/WVW_to_User/
# Upload file
lcd V:\
put *.csv /XYZ/WVW_to_User/
EXIT

Guest

2016-10-12 15:42

I think you can try doing an LCD to change the directory then try the transfer.

# Connect to SFTP server using a password
open sftp://username:password;fingerprint=ssh-**s-**-**-**-**-**-**-**-**-**-**-**-**-**-**-**-**@sftp.**.com/XYZ/WVW_to_User/
# Upload file
lcd V:\
put *.csv /XYZ/WVW_to_User/
EXIT

skumarlingamNC

Want to upload multiple files using SFTP to remote server

2016-10-12 11:32

Hello Experts,

I am trying to upload multiple files using below script, somehow batch script picking only first file out of multiple files from local drive and uploads on remote server.

WinScp version 5.9.2

batch command

"C:\Program Files (x86)\WinSCP\WinSCP.exe" /log= V:\BatchScripts\File_Put.log /script=V:\BatchScripts\File_Put.txt

File_Put.txt

# Connect to SFTP server using a password

open sftp://username:password;fingerprint=ssh-**s-**-**-**-**-**-**-**-**-**-**-**-**-**-**-**-**@sftp.**.com/XYZ/WVW_to_User/

# Upload file

put V:\*.csv /XYZ/WVW_to_User/

exit

Please let me know is there any wrong with script.

Thank you in advance.
[/code]