This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I was not able to solve the issue using Alteryx download tool feature from alteryx,but was able to connect to FTPS and upload a file to the same by using WINSCP and batch script. Here are the steps if you are interested in trying out the mentioned method:
1.Install Winscp in your machine.
2.Create a batch script calling winscp.com and a .txt file as arguments to the WINSCP.
3.The .txt file will contain the connection parameters.
4.Finally call the batch script from "Run Command" tool in alteryx.
Please let me know if you any need additional details.
Can you share more details on how to built the script? I have the same issue with the download tool just giving an access denied error while I can connect using WIN SCP w/o issues to (SFTP). I ran wireshark and see the the SFTP is working SSH and Alteryx with TLS
Here is a template that I use for WINSCP batch file:
option echo off
option batch on
#dir command below should be replaced with users specified SFTP commands (get, put, etc..)
#<SFTP Command Placeholder>
I then use a series of Find Replace tools to substitute in the various code stubs in the template (marked by the <...> tags).
I have attached a package that contains the macro that I created and includes the template for the WINSCP script and the windows batch file. Hopefully this gets you pointed in the right direction.
Hi, I'm trying to adapt your script and I'm wondering if I'm missing something? I can't seem to find or understand the SFTP Configuration Constants template file. I don't see it in the "Input" directory in the package above. Did I miss something? Thanks, -Hayes
1.Create a .txt file with the following code(please change the required parts):
option echo off option batch on option confirm off open ftp://username:email@example.com/ -explicit cd /folder put -nopermissions -nopreservetime "D:\Users\User1\Test Files\Tesfile*.csv" exit
2.Create a batch file(.bat file) which calls the above mentioned text file:
@Echo off REM CD "C:\..\WinSCP\" "C:\..\WinSCP\WinSCP.com" /script="C:\Users\User1\ftpscript.txt"
The script part should call the .txt file created in the first script.Once you run the batch file created in the second step,the file should be updated to respective FTP. Please note that above script is a rough one and there should be a better way to do the same.
Please let us know if you were able to get your code working.