{"id":5845,"date":"2022-07-13T23:21:12","date_gmt":"2022-07-13T23:21:12","guid":{"rendered":"https:\/\/pariswells.com\/blog\/?p=5845"},"modified":"2022-07-13T23:27:50","modified_gmt":"2022-07-13T23:27:50","slug":"how-to-batch-upload-things-via-bat-file-or-powershell-and-winscp","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/research\/how-to-batch-upload-things-via-bat-file-or-powershell-and-winscp","title":{"rendered":"How to Batch Upload things via Bat\\Powershell to SFTP using WinSCP"},"content":{"rendered":"<p>Upload.bat<\/p><p>[pastacode lang=&#8221;markdown&#8221; manual=&#8221;%22C%3A%5CProgram%20Files%20(x86)%5CWinSCP%5CWinSCP.com%22%20%2Fscript%3D%22C%3A%5CFTP%5CConnection.txt%22%0Aif%20%25ERRORLEVEL%25%20neq%200%20goto%20error%0A%20%0Aecho%20Upload%20succeeded%2C%20Moving%20Files%20to%20Uploaded%20folder%20or%20they%20will%20reupload%0A%0AREM%20Move%20Files%0Apowershell%20-command%20%22move-item%20%22%22%22%5C%5Cfiles%5Ctest*.csv%22%22%22%20%22%22%22%5C%5Cfiles%5CUploaded%5Ctest*.csv%22%22%22%20-Force%22%0A%0Aexit%20%2Fb%200%0A%20%0A%3Aerror%0Aecho%20Upload%20failed%2C%20keeping%20local%20files%0Aexit%20%2Fb%201&#8243; message=&#8221;&#8221; highlight=&#8221;&#8221; provider=&#8221;manual&#8221;\/]<\/p><p>C:\\FTP\\Connection.txt<\/p><p>[pastacode lang=&#8221;markdown&#8221; manual=&#8221;%0Aopen%20sftp%3A%2F%2Fusername%3Apassword%40sftp.server.com%3A22%2F%0A%23Open%20Local%20Folder%0Alcd%20%22%5C%5Cfiles%5C%22%0A%0A%23Upload%20Test*.csv%0Aput%20Test*.csv%0A%0A%0A%23%20Exit%20WinSCP%0Aexit&#8221; message=&#8221;&#8221; highlight=&#8221;&#8221; provider=&#8221;manual&#8221;\/]<\/p>","protected":false},"excerpt":{"rendered":"<p>Upload.bat[pastacode lang=&#8221;markdown&#8221; manual=&#8221;%22C%3A%5CProgram%20Files%20(x86)%5CWinSCP%5CWinSCP.com%22%20%2Fscript%3D%22C%3A%5CFTP%5CConnection.txt%22%0Aif%20%25ERRORLEVEL%25%20neq%200%20goto%20error%0A%20%0Aecho%20Upload%20succeeded%2C%20Moving%20Files%20to%20Uploaded%20folder%20or%20they%20will%20reupload%0A%0AREM%20Move%20Files%0Apowershell%20-command%20%22move-item%20%22%22%22%5C%5Cfiles%5Ctest*.csv%22%22%22%20%22%22%22%5C%5Cfiles%5CUploaded%5Ctest*.csv%22%22%22%20-Force%22%0A%0Aexit%20%2Fb%200%0A%20%0A%3Aerror%0Aecho%20Upload%20failed%2C%20keeping%20local%20files%0Aexit%20%2Fb%201&#8243; message=&#8221;&#8221; highlight=&#8221;&#8221; provider=&#8221;manual&#8221;\/]C:\\FTP\\Connection.txt[pastacode lang=&#8221;markdown&#8221; manual=&#8221;%0Aopen%20sftp%3A%2F%2Fusername%3Apassword%40sftp.server.com%3A22%2F%0A%23Open%20Local%20Folder%0Alcd%20%22%5C%5Cfiles%5C%22%0A%0A%23Upload%20Test*.csv%0Aput%20Test*.csv%0A%0A%0A%23%20Exit%20WinSCP%0Aexit&#8221; message=&#8221;&#8221; highlight=&#8221;&#8221; provider=&#8221;manual&#8221;\/]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5845","post","type-post","status-publish","format-standard","hentry","category-research"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/5845","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=5845"}],"version-history":[{"count":2,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/5845\/revisions"}],"predecessor-version":[{"id":5850,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/5845\/revisions\/5850"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=5845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=5845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=5845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}