Solved

Reg: How to use batch script output value  in  vbscript

Posted on 2016-10-19
10
31 Views
Last Modified: 2016-11-08
Hi All,

i have Below Batch script command

@echo off
set VAR=%errorlevel%
D:\SchedTasks\IFRS-Transfer\psftp.exe IFRS@DM3CXJ -pw XXXX -b IFRSTransfer.txt
echo %VAR%
exit /b %ERRORLEVEL%

And i wanted to use VAR value of this batch script in VBscript.

so kindly please tell me how can i use .

Thanks,
Abhishek
0
Comment
Question by:Abhishek kumar
  • 3
  • 2
  • 2
  • +2
10 Comments
 
LVL 18

Expert Comment

by:xtermie
ID: 41849602
Use the WScript.Shell object's Environment property.
Example (gets the NUMBER_OF_PROCESSORS variable, this is taken from
Windows Script Host documentation):

Set WshShell = WScript.CreateObject("WScript.Shell") 
Set WshSysEnv = WshShell.Environment("SYSTEM") 
WScript.Echo WshSysEnv("NUMBER_OF_PROCESSORS") 

Open in new window


Refer to
https://msdn.microsoft.com/en-us/library/at5ydy31(v=vs.84).aspx
https://msdn.microsoft.com/en-us/library/6s7w15a0(v=vs.84).aspx
0
 
LVL 69

Expert Comment

by:Qlemo
ID: 41849605
Why? VAR contains the error level at batch start, which is 0. This doesn''t have any "value". The exit code is important, and that is what you automatically get from the Shell.Run method calling the batch file.
0
 
LVL 84

Expert Comment

by:oBdA
ID: 41849611
You're aware that %VAR% contains the errorlevel before the psftp.exe call?
Anyway, assuming you want to call the VBScript from this batch (or are you calling the batch from VBScript? that would be rather cumbersome, because you might just as well run the psftp.exe directly from VBScript), you just pass it as command line argument:
VBS:
VAR = WScript.Arguments(0)
Wscript.Echo "VAR is " & VAR

Open in new window

Batch:
@echo off
set VAR=%errorlevel%
D:\SchedTasks\IFRS-Transfer\psftp.exe IFRS@DM3CXJ -pw XXXX -b IFRSTransfer.txt
echo %VAR%
cscript.exe //nologo "C:\Temp\Whatever.vbs" %VAR%
exit /b %ERRORLEVEL%

Open in new window

1
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 

Author Comment

by:Abhishek kumar
ID: 41849756
Hi,
Actually i wanted to use the psftp.exe exit code value in vb script for sending the mail whether file transfer is successful or Failed.

Here i am calling Batch script command inside VB Script.

So please help me how can i do this .

Thanks,
Abhishek
0
 
LVL 84

Accepted Solution

by:
oBdA earned 500 total points (awarded by participants)
ID: 41849778
Batch:
@echo off
D:\SchedTasks\IFRS-Transfer\psftp.exe IFRS@DM3CXJ -pw XXXX -b IFRSTransfer.txt
exit /b %ERRORLEVEL%

Open in new window

VBS:
Set objShell = CreateObject("WScript.Shell")
intReturn = objShell.Run(Chr(34) & "D:\Temp\Whatever.cmd" & Chr(34), 0, True)

Open in new window


Or just call psftp.exe directly from VBS:
strFtpProgram = "D:\SchedTasks\IFRS-Transfer\psftp.exe"
strFtpUser = "IFRS@DM3CXJ"
strFtpPassword = "XXXX"
strFtpFile = "IFRSTransfer.txt"

Set objShell = CreateObject("WScript.Shell")
strCommand = Chr(34) & strFtpProgram & Chr(34) & " " & strFtpUser & " -pw " & Chr(34) & strFtpPassword & Chr(34) & " -b " & Chr(34) & strFtpFile & Chr(34)
intReturn = objShell.Run(strCommand, 0, True)

Open in new window

Run Method (Windows Script Host)
https://msdn.microsoft.com/en-us/library/d5fk67ky.aspx
1
 

Author Comment

by:Abhishek kumar
ID: 41849908
Thank you so much :)

its working as expected :)
0
 

Expert Comment

by:Abhishek kumar
ID: 41851460
Hi oBdA,

For below Script

@echo off
pscp.exe -i seom.ppk D:\Informatica\9.6.1\server\infa_shared\TgtFiles\IFRS\Customer\zrrem19cus* seom@sapcir-qa.intranet.z.ca:/infiles
exit /b %ERRORLEVEL%

its not returning the Exitcode value and also the batch command is running for longer time

so kindly please help me how can i use exit code value of this batch script in VBscript.

Thanks,
Abhishek
0
 
LVL 84

Expert Comment

by:oBdA
ID: 41851467
That's not an issue with the batch file itself.
If this batch runs a long time, then it's the pscp.exe command that's taking long; the batch script will just wait until it's done.
Once pscp.exe is done, the errorlevel returned by it will be passed to the calling program just like with psftp.exe (that is, if pscp.exe returns an errorlevel to begin with - not all programs do).
1
 

Expert Comment

by:Abhishek kumar
ID: 41851531
Okay Sir.

Thank you so much :)
0
 
LVL 18

Expert Comment

by:xtermie
ID: 41878454
Solution provided
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

820 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