Skip to main content
  • EN

I have been tasked to set up an automation that will FTP a file from a State-supported site to our network.

I have been advised to use the FTPCaller transformation to achieve this.

 

I have the specifics to the State-supported site and, using WINSCP, can manually download the file. In order to do this, In WinSCP, I supply the host name, the port, and a username supplied by the State. Additionally, I have to click on the Advanced button, then under SSH click on the Authentication text, click on the ellipsis (...) under Private Key File I enter the name of a Putty file (that was given to me by the FME Administrator) The file is sent by FTP using this manual method.

 

At this point I am trying to automate the process so that the FME, using FTPCaller as advised, will achieve the same transfer. However, I am not clear how-to setup the FTPCaller to incorporate all of the parameters (host name, port, username, Putty file) that I have been given for the manual transfer.

Can I get some advice on how to setup the FTPCaller transformer to achieve the download?

Thanks.

 

Maybe this article will help you?

https://community.safe.com/s/article/Using-a-private-SSH-key-with-FTPCaller-to-authenticate-an-SFTP-Connection-on-FME-Server-and-FME-Desktop

 

I have been using the article as a guide but still not getting the login to the remote site to work. When I manually login with WinSCP the login works.

I contacted the State agency and a new Private and Public key were created. I sent the State the Public key and they acknowledged that it was ready for testing.

One issue that concerns me is that the FME job is trying to open the ppk file during processing, with Adobe Acrobat.

Regardless, I am getting the message that the Login is failing.

I have been using the article as a guide but still not getting the login to the remote site to work. When I manually login with WinSCP the login works.

I contacted the State agency and a new Private and Public key were created. I sent the State the Public key and they acknowledged that it was ready for testing.

One issue that concerns me is that the FME job is trying to open the ppk file during processing, with Adobe Acrobat.

Regardless, I am getting the message that the Login is failing.

I am able to login to the State site but instead of downloading the data in the file I keep getting the attributes of the files available to download, not the data in the file itself. I am trying to download a specific file from the State site.Setup

I am able to login to the State site but instead of downloading the data in the file I keep getting the attributes of the files available to download, not the data in the file itself.   I am trying to download a specific file from the State site.Setup

What you need to do is put the path to the file in the URL field. For example:

sftp://downloads.company.com/export/test.csv

Or, if you want to do it dynamic:

sftp://downloads.company.com/export/@Value(_filename)

 

Thank you all for the assistance. Adding the file name worked, both in downloading one file and uploading in another FME in the same application.

Reply


Community Stats

30,364
Posts
115,373
Replies
38,151
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.