Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- for /f "delims=" %%x in (config.bat) do (set "%%x")
- echo Start[%time%] >> "%primefolder%TimeRun.log"
- REM --------------------------------------------------------------------------------------------
- REM Import .csv from the ftp server - csv imported to local directory
- REM Ftpcmd.txt connects to the ftp server and copies the .csv file to a local directory
- REM --------------------------------------------------------------------------------------------
- echo open %FTPIP%> %primefolder%ftpcmd.txt
- echo %FTPUsername%>> %primefolder%ftpcmd.txt
- echo %FTPPassword%>> %primefolder%ftpcmd.txt
- echo cd %FTPPrimary%>> %primefolder%ftpcmd.txt
- echo binary>> %primefolder%ftpcmd.txt
- echo lcd /D "%offload%" >> %primefolder%ftpcmd.txt
- echo mget %Filename%>> %primefolder%ftpcmd.txt
- echo disconnect>> %primefolder%ftpcmd.txt
- echo quit>> %primefolder%ftpcmd.txt
- REM -----------------------------------------------------------------------------------------------------------------------------
- REM Call and execute the FTP command text document (ftpcmd.txt)
- REM This Code calls the file which establishes a connection and then copies the file to a local directory
- REM Dynamic FTP command file is created and populated.
- REM -----------------------------------------------------------------------------------------------------------------------------
- ftp -i -s:"%primefolder%ftpcmd.txt" >"%primefolder%logsftpinport.log" 2>>"%primefolder%logsftperr.log"
- echo[%date% - %time%] >> "%primefolder%logsftpinport.log"
- ftp -i -d -s:%primefolder%ftpcmd.txt
- for /f "tokens=*" %%a in (%primefolder%logsftperr.log) do (echo [%date% - %time%] [Error Level: 1][Issue Location:FTP][Error:%%a] >> "%primefolder%logserror.log")
- primefolder=C:scripts
- FTPIP=111.11.1.1
- FTPUsername=User
- FTPPassword=test
- Filename=User.csv
- FTPPrimary=CSV
- FTPArchive=CSVArchive
- offload=\test.orgtest_thisImplementationNew ProjectsNewInterface
- ftp> open 111.11.1.1
- Connected to 111.11.1.1.
- 220 Welcome to Code-Crafters Ability FTP Server.
- User (111.11.1.1:(none)):
- 331 Please send PASS now.
- 230-Welcome "User".
- 230-There are currently 1 of 100 users logged onto this server.
- 230-There are currently 1 users logged onto this account.
- 230-You have unlimited KB of account allocation left.
- 230-You have 0 transfer credits remaining.
- 230-You lose 0 credits per KB downloaded.
- 230-You lose 0 credits per KB uploaded.
- 230 You are currently in directory "/".
- ftp> cd CSV
- 250 "/CSV" is current directory.
- ftp> binary
- 200 Type set to 'I' (IMAGE).
- ftp> get User.csv \test.orgtest_thisImplementationNew ProjectsNewInterfaceUser.csv
- 200 PORT command successful.
- 150 Data connection established, beginning transfer.
- 226 Transfer complete.
- ftp: 1277532 bytes received in 2.64Seconds 483.91Kbytes/sec.
- ftp> disconnect
- 221 Thanks for visiting.
- ftp> quit
- ftp> open 111.11.1.1
- Connected to 111.11.1.1
- 220 Welcome to Code-Crafters Ability FTP Server.
- User (111.11.1.1:(none)):
- 331 Please send PASS now.
- 230-Welcome "User".
- 230-There are currently 2 of 100 users logged onto this server.
- 230-There are currently 1 users logged onto this account.
- 230-You have unlimited KB of account allocation left.
- 230-You have 0 transfer credits remaining.
- 230-You lose 0 credits per KB downloaded.
- 230-You lose 0 credits per KB uploaded.
- 230 You are currently in directory "/".
- ftp> cd CSV
- 250 "/CSV" is current directory.
- ftp> binary
- 200 Type set to 'I' (IMAGE).
- ftp> get User.csv \test.orgtest_thisImplementationNew ProjectsNewInterfaceUser.csv
- 200 PORT command successful.
- 150 Data connection established, beginning transfer.
- > R:I/O Error
- 226 Transfer complete.
- ftp: 1277532 bytes received in 2.84Seconds 449.20Kbytes/sec.
- ftp> disconnect
- 221 Thanks for visiting.
- ftp> quit
- echo get %Filename% "%offload%%Filename%" >> %primefolder%ftpcmd.txt
- echo lcd /D "%offload%" >> %primefolder%ftpcmd.txt
- winscp.com /log=winscp.log /command ^
- "open ftp://%FTPUsername%:%FTPPassword%@%FTPIP%/" ^
- "cd %FTPPrimary%" ^
- "get %Filename% %offload%" ^
- "exit" > "%primefolder%logsftpinport.log"
Add Comment
Please, Sign In to add comment