Skip to main content

Hi everyone,
I would like to automatically import files from an SFTP server to then automatically create a external supplier invoice.
I've configured a new SFTP Reader in IFS Cloud to read files from an SFTP server. After setting up the reader, I created a Routing Rule with location-based conditions for the new SFTP Reader.


The files are successfully being picked up by the reader, but they aren’t being connected to the routing rule I defined. Instead, when a file is imported into the SFTP, I see two error messages under Application Messages, and I suspect it’s because the routing rule isn’t being applied. Could there be a missing step in connecting the reader with the routing rule?


Any insights or troubleshooting suggestions would be greatly appreciated!

Thanks in advance!

Hi ​@InfShemaG,

 

I’m not sure if the file path in the routing rule is correct. I have never used it so can’t comment on the format. Instead, you can leave it blank and have only the location type and the see if it works first.

Alternatively you can add a content based condition to check if a certain field exist in the file.

 

Second application message is a result due to the create response checkbox in the SFTP reader. you can switch it off to get rid of it :)

 

Hope it helps!

Damith


Hi ​@dsj ,

Thanks for the suggestion. The issue was caused by the file path format .

I left it blank and updated the reader's message selector to (regexp:Manual\s+Export\s.*.csv) since I needed to filter the files being processed by file name. That solved the problem :)


Hi InfShemaG,

I have a similar problem (we use IFS Cloud 24R2 and I will use the SFTP Reader) and I don't know what the format of the sftp_knownhosts file should look like. Can you give me an example of which entries have to be specified there and in which order?
I have currently tried the following format:
DNS name rsa key
LALALA.XX.DE 57:8a:d9:32:67...
I know that the DNS name is important, the rsa key (which I created with puttygen) as well.

In Application Messages there is no entry to check is there anybody issues

Thanks in advance.


Hi ​@ant ,
Don't manually create the knownhosts file. Use the IFS-provided Java command to generate it automatically:

java -cp C:\...\jar\ifs-fnd-connect.jar;C:\...\jar\jsch-0.2.17.jar ifs.fnd.connect.ftp.SftpClient -CreateKnownHosts=C:\...\knownhost.txt -hostname=YOUR_SFTP_HOST -username=YOUR_USERNAME -password=YOUR_PASSWORD

Replace the paths and credentials with your actual values. You can run this on cmd. You'll need both JAR files and working SFTP login details:

Check the IFS Cloud technical documentation for detailed steps:
https://docs.ifs.com/techdocs/24r2/030_administration/030_integration/300_ifs_connect/010_configure_connect/060_transport_connectors/configure_sftp_transport_connector/#remote_directory_or_path_names_on_a_sftp_server

Hope this helps:)


Thanks for response, I will check this.


Reply