Forum » Scripting / Automation »

Execute WinSCP from a batch file

Quickdeveloper Guest

Execute WinSCP from a batch file

2012-04-25 03:41

Hi

I want to execute winscp script from a batch file.

Assume the following contents are in C:\MYFILE.BAT

echo " OPENING THE SESSION "
winscp.com /console /command:"open xyz:abc@ipaddress" 
echo "CONNECTED TO THE VM "
 
REM   delete old files 
rm file1.tar

when I run C:\>MYFILE.BAT, I am able to connect to unix vm, however it goes into shell mode and second command (deleting file1.tar won't get executed). do we need to give any other parameter?

I know we can execute batchfile itself from winscp directory (eg: winscp.com /script:filename.bat) but in that case i can't check errors with if/ else conditions in batch file since winscp doesn't recognise the if/else.

Any suggestions please? i don't want to use xml logging as it looks too complicated for my use.

Thanks

Reply with quote

quickdeveloper
Joined:: 2012-04-25
Posts:: 2

WinSCP from batch file

2012-04-25 04:16

Please also note that i am using winscp.com to redirect the output to a text file.

The only other option would be to open a new winscp session in each command line of batch file which involves more cost.

Reply with quote

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

Re: Execute WinSCP from a batch file

2012-04-26

You have to put WinSCP command to a separate script file.
Please read scripting guide:
https://winscp.net/eng/docs/guide_automation

Reply with quote

quickdeveloper
Joined:: 2012-04-25
Posts:: 2

Execute WinSCP from a batch file

2012-04-27 06:32

Thanks Martin,i checked it.

I have used C# with WinSCP dll and accomplished the task.

I realized it's much easier and faster that way in terms of exception handling :D

Thanks!

Reply with quote

atchere Guest

Re: Execute WinSCP from a batch file

2013-01-25 22:09

Question I am having trouble getting WINSCP to take a password in the batch mode what is the correct syntex to make this happen

atc

Reply with quote

Prasadhello Guest

Winscp from bat file

2013-12-31 13:03

I am trying to run winscp from bat file and with xp_cmdshell in sql server. However when I run it keeps running forever. I have put exit in bat file. Anybody aware of this issue?

Also is there any way to capture winscp dir results in sql server table or like normal result set instead of XML.

Reply with quote

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

Re: Winscp from bat file

2014-01-02

Prasadhello wrote:

I am trying to run winscp from bat file and with xp_cmdshell in sql server. However when I run it keeps running forever. I have put exit in bat file. Anybody aware of this issue?

Please start a new thread and attach a full log file showing the problem (using the latest version of WinSCP).

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 may email it to me. You will find my address (if you log in) in my forum profile. Please include link back to this topic in your email. Also note in this topic that you have emailed the log.

Reply with quote

Mahmoud Guest

send file to sftp server

2014-09-18 07:39

Hi all,

I did the following batch file to send file to sftp server, but the put command (or any commands) after sftp session opeded didn't work:

cd C:\Program Files\prog1\output1
WinSCP.exe username@x.x.x.x/example/test
put %file%
close
exit

can any one help?

thanks

Reply with quote

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

Re: send file to sftp server

2014-09-18

Mahmoud wrote:

I did the following batch file to send file to sftp server, but the put command (or any commands) after sftp session opeded didn't work:

You are obviously combining Windows and WinSCP commands in a single file. You cannot do this.
Read https://winscp.net/eng/docs/guide_automation
Also https://winscp.net/eng/docs/faq_batch_file#cmd

Reply with quote

Fairfielder
Joined:: 2015-12-31
Posts:: 1

Re: send file to sftp server

2015-12-31 21:41

I don't understand. On the following page it shows this example batch file, which combines WinSCP and Windows commands:
https://winscp.net/eng/docs/guide_automation

Here's the example batch file:

winscp.com /script=example.txt
if %ERRORLEVEL% neq 0 goto error
 
echo Success
sendmail.exe -t < success_mail.txt
exit 0
 
:error
echo Error!
sendmail.exe -t < error_mail.txt
exit 1

Reply with quote

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

Re: send file to sftp server

2016-01-04

Fairfielder wrote:

I don't understand. On the following page it shows this example batch file, which combines WinSCP and Windows commands:
https://winscp.net/eng/docs/guide_automation

There's no WinSCP command it that batch file. The WinSCP commands are in example.txt.

Reply with quote

Madhu Guest

Scripting Public key authentication passphrase

2016-05-27 19:38

Hi

I am trying to get file using SFTP. My set up was authentication with public key Passphrase.

Here is my script file name getfile.txt

open xxxxxx (site already stored with host name, port and username)
passphrase
get *.txt to c:\*.txt
Close
exit

Created download.bat file as follows:

@echo off
winscp.com /script=getfile.txt

both the files are saved at WinSCP folder.

When download.bat file run, the script did not take Passphrase as per second line and come out without further execution.
Can anyone help how input Passphrase.

Thanks
Madhu

Reply with quote

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

Re: Scripting Public key authentication passphrase

2016-05-30

Use the -passphrase switch:

open xxxxxx -passphrase=mypassphrase

See https://winscp.net/eng/docs/scriptcommand_open

Note that it is generally not recommended to use stored site in script.
See https://winscp.net/eng/docs/scripting#configuration

Reply with quote

Guest

Re: Winscp from bat file

2016-11-30 23:17

Prasadhello wrote:

I am trying to run winscp from bat file and with xp_cmdshell in sql server. However when I run it keeps running forever. I have put exit in bat file. Anybody aware of this issue?

Also is there any way to capture winscp dir results in sql server table or like normal result set instead of XML.

Did you ever resolve this issue? I am experiencing the same issue - no log files to give me a hint at the problem.

How did you resolve this issue??

Reply with quote

martin◆ Site Admin

Re: Winscp from bat file

2016-12-01

Did you ever resolve this issue? I am experiencing the same issue - no log files to give me a hint at the problem.

What did you try to get the logs?

Reply with quote

Guest

Re: Winscp from bat file

2016-12-01 14:56

martin wrote:

What did you try to get the logs?

Nothing was in the logs. My xp_cmdshell query just runs...the same issue you reported experiencing.

Reply with quote

martin◆ Site Admin

Re: Winscp from bat file

2016-12-05

I'm sorry, but I do not understand your response.

I have asked: What did you try to get the logs?

Reply with quote

Mark9999 Guest

can winscp.com select query to linux-mysql database?

2017-07-20 09:18

can winscp.com select query to linux-mysql database?

Reply with quote

optimus Guest

Re: Execute WinSCP from a batch file

2020-11-03 05:56

quickdeveloper wrote:

Thanks Martin,i checked it.

I have used C# with WinSCP dll and accomplished the task.

I realized it's much easier and faster that way in terms of exception handling :D

Thanks!

can u share the code

Reply with quote

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

Re: Execute WinSCP from a batch file

2020-11-03

optimus wrote:

can u share the code

What code? There are zillions of examples on this site:
https://winscp.net/eng/docs/library#example

Reply with quote

You can post new topics in this forum