Hello,
I'm trying to connect to our banks SFTP server (HSBC) via ABSI. I've configured the financial institution and the format profile to feed BAI2 bank statement files. I'm running into an issue where NS can't seem to connect to the server based on my configuration, I keep getting the following error:
"There was a problem connecting to your financial institution. Unable to establish a connection to the SFTP server. Check your SFTP connectivity configuration and ensure all fields are valid, then try again. If you continue to receive this message, contact your financial institution."
However I'm also utilizing the SFTP module to send EFT payment files to the same server using the same credentials and this works fine. Additionally, I can easily log onto the server using FileZilla. The BAI2 files are placed in the following directory: /inbox (I know in my screenshot it doesn't have forward slash, I wanted to try both ways but I get the same error)
Interestingly if I leave the directory blank I get this error instead:
"There was a problem connecting to your financial institution. No files were uploaded because the bank server directory is empty. If you continue to receive this error, contact your financial institution."
Here's a screenshot from FileZila showing the directory:
My second question is around the filename pattern. As I haven't been able to successfully connect and download any BAI2 files I'm not sure if NS would be able to recognize and download any of the files based on the filename pattern. The file naming convention is as follow:
BAI2EOD.XX.99999999999999999999999999999999999.PC00000XXXX.20211201131459002.CSV
The only variable is the sequence after the PC00000XXXX tag. It goes like this:
2021-12-01-13-14-59-002
So YYYY-MM-DD-HH-MM-SS and then last 3 digits are the interval of files produced on this giving date. In this case this is the second file for Dec 01, 2021. NS mentions how to incorporate reserved words and regular expressions for the date, but doesn't mention if timestamps etc are supported. This what I've come up with so far:
{DateToday}{HoursMinutesSeconds}{001-999}.csv
Not sure if this would work, but curious to hear feedback on this as I haven't been able to test it yet.
Thanks!