Yep that did it for me to generate a date for my logfile.
Thank you for you tip! :-)@echo off
@For /F "tokens=2,3,4 delims=/ " %%A in ('Date /t') do @(
Set Month=%%A
Set Day=%%B
Set Year=%%C
Set Logfile="%Year%%Month%%Day%_winSCP.log"
)
"F:\WinSCP\WinSCP.com" ^
/log=E:\Log\%Logfile% /ini=nul ^
/log=E:\Log\!Y!M!D_WinSCP.log
Here is what I did in case this helps anyone out. When i get some time i want to add functionality to fire off an email if they download or fail so the user knows. Great program, glad I found it. Saved me a lot of time.
I am using a batch file, to download 3 different files, each that contains the current date in it. After i connect i change to a different folder then download each file and disconnect.
[/code]@echo off
@For /F "tokens=2,3,4 delims=/ " %%A in ('Date /t') do @(
Set Month=%%A
Set Day=%%B
Set Year=%%C
set file1=company.%Year%%Month%%Day%.x.pdf
set file2=company.%Year%%Month%%Day%.y.pdf
set file3=company.%Year%%Month%%Day%.z.pdf
)
cd "c:\Program Files\WinSCP"
WinSCP.com /console /command "option batch on" "option confirm off" "open user:password@SomeDomain.com" "cd /daily/files/" "get %file1% c:\download\" "get %file2% c:\download\" "get %file3% c:\download\" "exit"
exit
@echo off
@For /F "tokens=2,3,4 delims=/ " %%A in ('Date /t') do @(
Set Month=%%A
Set Day=%%B
Set Year=%%C
Set Logfile="%Year%%Month%%Day%_winSCP.log"
)
"F:\WinSCP\WinSCP.com" ^
/log=E:\Log\%Logfile% /ini=nul ^
// Function to figure out the date of the previous business day
// in the format YYYYMMDD including place holding zeros.
function PreviousBizDay() {
function D2( val ) {
return ( ( val < 10 ) ? '0' : '' ) + val;
}
var today = new Date();
today.setDate( today.getDate() - 1 ); // Yesterday...
while ( ( today.getDay() < 1 ) || ( today.getDay() > 5 ) ) {
today.setDate( today.getDate() - 1 ); // Previous day
}
return today.getFullYear() + D2( today.getMonth() + 1 ) + D2( today.getDate() )
}
// Local path to download to (MUST keep trailing slashes)
var LOCALPATH = "c:\\folder\\";
// Remote path to search in (MUST keep trailing slash)
var REMOTEPATH = "/daily/downloads";
// Session to connect to
var SESSION = "username:password@someserver.com";
// Path to winscp.com (MUST keep trailing slashes)
var WINSCP = "c:\\program files\\winscp\\winscp.com";
var filesys = WScript.CreateObject("Scripting.FileSystemObject");
var shell = WScript.CreateObject("WScript.Shell");
var FILE1 = "file." + PreviousBizDay() + ".example.pdf";
var FILE2 = "file." + PreviousBizDay() + ".example.doc";
var FILE3 = "file." + PreviousBizDay() + ".example.xls"
var exec;
// Run WINSCP and download the 3 files, then exit
exec = shell.Exec("\"" + WINSCP + "\"");
exec.StdIn.Write(
"option batch abort\n" +
"option confirm off\n" +
"open \"" + SESSION + "\"\n" +
"get \"" + REMOTEPATH + FILE1 + "\" \"" + LOCALPATH + "\"\n" +
"get \"" + REMOTEPATH + FILE2 + "\" \"" + LOCALPATH + "\"\n" +
"get \"" + REMOTEPATH + FILE3 + "\" \"" + LOCALPATH + "\"\n" +
"exit\n");
Also read documentation.
@echo off
@For /F "tokens=2,3,4 delims=/ " %%A in ('Date /t') do @(
Set Month=%%A
Set Day=%%B
Set Year=%%C
set file1=company.%Year%%Month%%Day%.x.pdf
set file2=company.%Year%%Month%%Day%.y.pdf
set file3=company.%Year%%Month%%Day%.z.pdf
)
cd "c:\Program Files\WinSCP"
WinSCP.com /console /command "option batch on" "option confirm off" "open user:password@SomeDomain.com" "cd /daily/files/" "get %file1% c:\download\" "get %file2% c:\download\" "get %file3% c:\download\" "exit"
exit