Want to upload multiple files using SFTP to remote server :: Support Forum

skumarlingamNC Guest

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]

Reply with quote

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

Reply with quote

skumarlingamNC Guest

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

Reply with quote

skumarlingamNC Guest

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.

Reply with quote

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]

Reply with quote

skumarlingamNC Guest

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.

Reply with quote

jrp78
Joined:: 2016-10-07
Posts:: 22
Location:: SoVA

2016-10-13 01:29

Awesome. Happy to help 8)

Reply with quote

martin◆ Site Admin
Joined:: 2002-12-10
Posts:: 41,441
Location:: Prague, Czechia

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)

Reply with quote