SFTP Sender channel issue

[former_member200386]

Dear Experts,

I am working in SFTP to file scenario. where i need to pick all .csv files from source SFTP server . In the SFTP channel configuaration source parameters  i mentioned filename as *.csv then i am getting error.

Exception received: java.util.regex.PatternSyntaxException: Dangling meta character '*' near index 0 *.csv ^
Directory under file Path returned 3. These include directories and links.

please find the screen shots for more reference.

Thanks & Regards,

Pavan

[gagandeep_batra · Accepted solution]

Hi Pavan,

did you try with * also,

check once that ,

i think *.CSV should work.

in our case it work like that:

Regards

Gagan

[former_member200386 · Accepted solution]

Hi Gagan,

Thank you very much for your help. I tried with '*' only , then SFTP channel started polling. Issue resolved.

Thanks & Regards,

Pavan

[former_member278111 · Accepted solution]

Hi,

I am unable to pick the files from SFTP server in PI 7.31.

Sender channel is working fine with green status & below is the message which i received in RWB channel monitoring.

Does any one came across this issue?

Thanks & Regards

Anil Kumar

[Former Member · Accepted solution]

Just in case someone wonders why *.csv cannot work:

In the SFTP-Adapter you got to use a regular expression, not a commandline filepattern as in the file adapter.

Meaning, to select all csv files, you got to enter: .*\.csv

. = any character

* = any occurrency

\. = a period

csv = csv

Check your regex for example with Regex Tester

Actually, I wonder why plain * works, but that's a different story.

[Former Member · Accepted solution]

it works man, thanks a lots

[Former Member · Accepted solution]

Anil,

Try this note

1850220 - usePathForLs Attribute and additional files

[former_member278111 · Accepted solution]

Hi,

Issue got resolved by applying latest patch of SFTP adapter.

Thanks & Regards

Anil Kumar