JeenLeen
2020-08-28, 11:20 PM
I'd like to do this in SAS, but R or Python are also options.
EDIT: VBA is also an option. Probably second after SAS, as I have some code in SAS to write and execute VBA scripts, so I could essentially run it in my language-of-choice.
Goal: to have a program that logs into an online SFTP site (I have the URL, and my username and password. Once 'logged in', it goes straight to the folder I want to load the files to), then uploads a file on my computer to it.
Reason for goal: I need to automate creating and uploading files to an SFTP site. I got the creating the files automated, but I still have to manually log into the SFTP site and upload them. Since ideally I'd be regenerating the files daily, rather get around the manual part.
Issues: I'd like to do this without any third-party software or extra-programming-language stuff. I found a way to probably do it with SAS, but SAS doesn't support password-login with SFTP (why!?) and instead requires me to make a primary-public key setup with the SFTP server; I'd like to avoid that. I found the RCurl package in R which seems likely to do that, but am having some issues with installing the package AND realized it requires another software to be installed to work. I haven't looked into Python yet, but I've got Anaconda installed so I could use it.
Any advice?
EDIT: VBA is also an option. Probably second after SAS, as I have some code in SAS to write and execute VBA scripts, so I could essentially run it in my language-of-choice.
Goal: to have a program that logs into an online SFTP site (I have the URL, and my username and password. Once 'logged in', it goes straight to the folder I want to load the files to), then uploads a file on my computer to it.
Reason for goal: I need to automate creating and uploading files to an SFTP site. I got the creating the files automated, but I still have to manually log into the SFTP site and upload them. Since ideally I'd be regenerating the files daily, rather get around the manual part.
Issues: I'd like to do this without any third-party software or extra-programming-language stuff. I found a way to probably do it with SAS, but SAS doesn't support password-login with SFTP (why!?) and instead requires me to make a primary-public key setup with the SFTP server; I'd like to avoid that. I found the RCurl package in R which seems likely to do that, but am having some issues with installing the package AND realized it requires another software to be installed to work. I haven't looked into Python yet, but I've got Anaconda installed so I could use it.
Any advice?