SFXCL Batch file issues.
Hey all, I'm not a big scripter and this got thrown in my lap!
I need to automate FTP job using SFXCL and am using the "Upload .CSV file" example batch file provided in your automation tips pdf file shown below...
I have replaced C:\Out\*.CSV with the UNC path to my source file...
and have replaced sftp://user:email@example.com/In with....
sftp://myusername:mypwd@IP of my companies SFTP site/Home/MyFolder
when running my batch file the log always shows it connected for 21 seconds then changes from a Non connected state to a closed state with 0bytes transmitted. Can someone help me figure out what I'm missing here? MUCH APPRECIATED!!!!
:: GENERATE A UNIQUE LOG FILE NAME:
for /f "tokens=2-4 delims=/ " %%a in ('date /T') do set MyDate=%%c%%a%%b
for /f "tokens=1-4 delims=:. " %%a in ("%TIME%") do set MyTime=%%a%%b%%c.%%d
:: Run SFXCL - upload .CSV files from local "Out" to remote "In" folder:
SFXCL /NOPROMPT /RETRYCOUNT 0 /LOG "%LOGFILE%" \\Myserver\Share\Filetobeuploaded.csv sftp://xxxx:firstname.lastname@example.org/Home/MyFolder
:: Check for failure
if not %errorlevel%==0 goto FAILURE
:: Otherwise... Success!
echo. Transfer Failure. See %LOGFILE% for details.
echo. Transfer Success.
echo. Batch file exiting
Last edited by rtb; 06-05-2015 at 08:03 AM. Reason: This is a note for the previous edit. I turned off smiles so that the post made sense and wasn't potentially offensive.
|automate , batch , ftp , sfxcl|