?
Solved

PSFTP - How Do I Detect Successful Transfer from Output File?

Posted on 2010-08-18
6
Medium Priority
?
1,946 Views
Last Modified: 2013-12-02
I have a Windows batch script (attached - UFASR03_Name_302_ftpput.bat) which PSFTP's a file to a host SFTP site.  In the batch script, I reference a batch file (attached - UFASR03_Name_302_ftpput.txt) of SFTP commands and I direct the output to a text file (attached - UFASR03_Name_302_ftpput_output.txt).  I need to report back the success or failure of the transmission to the scheduling system that initiated the batch job.  

What can I use in the output file to detect a successful transmission?  The string that I use to detect a successful transmission should only appear in the output file when the transmission is successful; never should it appear if the file was not transmitted properly.

With regular FTP, I can use the following:  findstr /c:"226 Transfer" %output%
But I can't use that "226 Transfer" string with SFTP.  It doesn't appear in the output.

As you can see from the attached output file (named UFASR03_Name_302_ftpput_output.txt), there is a string as follows:  

local:JohnDoe_201008.csv => remote:/incoming/JohnDoe_201008.csv

I believe this means the file was successfully transferred.  Can I use "=> remote" as a string to reliably indicate successful transmission 100% of the time?  Will this string ever appear if there's an error?  If not, what string should I use to detect successful transmission?
0
Comment
Question by:DoubleStroke
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 

Author Comment

by:DoubleStroke
ID: 33467600
Oops.  Here are the files.  Windows batch file is called UFASR03_Name_302_ftpput_batch.txt
UFASR03-Name-302-ftpput-batch.txt
0
 
LVL 35

Expert Comment

by:torimar
ID: 33468060
There seems to be no way for this in PSFTP, at least no documented one.

But PSCP will also try to use the SFTP protocol if possible, and you may even force it to do so by using the -sftp switch.
Unlike PSFTP, PSCP comes with a return value for successful transfers; please check "5.2.3 Return value" here:
http://the.earth.li/~sgtatham/putty/0.60/htmldoc/Chapter5.html#pscp
0
Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

 
LVL 35

Expert Comment

by:torimar
ID: 33468073
ps:

Also check "5.2.2.6 -sftp, -scp force use of particular protocol" right above the section quoted in my last comment.
0
 

Author Comment

by:DoubleStroke
ID: 33479968
Torimar, I appreciate the advise but I need to use psftp.  Thank you.
0
 
LVL 35

Accepted Solution

by:
torimar earned 2000 total points
ID: 33572516
DoubleStroke,

in your closing request you state that "no other solutions were helpful".

Please bear in mind that if the set task is impossible, there can be no helpful solutions.
Should you have found a way to do this with PSFTP, please let me know, I'd be eager to learn.
If, however, as I would expect, you haven't found a way to do this with PSFTP, neither referenced here nor elsewhere, allow me to remind you of the written rule on Experts-Exchange that sometimes the correct answer to a question is: "You can't do that." (http://www.experts-exchange.com/help.jsp#hs=29&hi=405 )

In the latter case, my comment above (ID:33468060) gave the correct answer (that there is no way to do this in PSFTP) as well as a workaround.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We all know how boring and exhausting it is to transfer huge web projects developed locally to a webserver simply via FTP. The File Transfer Protocol is a really nice solution if you need to transfer small amounts of files, but if you're plannin…
Please see preceding article here: http://www.experts-exchange.com/Networking/Operating_Systems/A_11209-Root-Bridge-Election.html Figure 1 After Root Bridge has been elected, then what?..... Let's start by defining a Root Port in la…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month10 days, 10 hours left to enroll

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question