Need to pick Multiple Files from SFTP Server

[former_member138523]

Hi PI Experts,

I had requirement to pick multile files from SFTP Server.

The follwing are the file Names

bai2_pd_<Date&Timestamp>.txt

bai2_pd_<Date&Timestamp>.txt

bai2_pd_<Date&Timestamp>.txt

bai2_pd_<Date&Timestamp>.txt

The only difference is Date & Timestamp changes for every File.

The file had permissions and through SFTP Channel the file got picked up successfully, If I gave Specific File name

Ex : bai2_pd_20130509040809.txt

If the Directory contains 4 files and mentioned *.txt, files are not picked up and gone through some blogs for multiple files picking through SFTP channel and I came to know I have to mention specific format as below.

As per this link http://scn.sap.com/docs/DOC-35572

EX : [a-z]*.txt

Even then the same result. Files are not picked up from SFTP Server[Bank System]

In Communication channel I am getting the log after polling interval as mentioned below

No New File

Found 0(Zero) Files

Channel needs execution, executing now, next execution is scheduled at 5/9/13 8:12 AM

However Files are there in SFTP Server.

Please help me.

Rgds,

Kumar

[ambrish_mishra]

Hi Kumar,

Did you try bai2_pd_[0-9]*.txt

Ambrish

[wolfgang_hegmann]

Hello,

I understand you want to pickup files starting with "bai2_pd_" and want to avoid picking up files which start with a different string.

Try this:

bai2_pd_.*   

Dot means any character, asterisk means "repeat".

Best regards,

Wolfgang

[Former Member]

Hi Kumar,

What happens if you try the following regexp:

([^\s]+(\.(txt))$)

If you are not sure of your regexp, you can use a few online test tools to test it first before using it in your channel.

Refer to this thread:

http://scn.sap.com/thread/3243265

Regards, Trevor

[markangelo_dihiansan]

Hello,

I'm not sure why it is not working. Can you try

bai2_pd_??????????????.txt

Regards,

Mark

[gagandeep_batra]

Hi Kumar,

on which version you are? 7.3X, because your doc refer to 7.3X

if you have seeburger SFTP then try like only * that will work

Regards

Gagan

[Former Member]

Hi  Kumar,

Try this pattern ".+\\*.txt"

It will work.

Thanks

Dhileep

[former_member184720]

Hi Kumar,

Channel should pick the files. did you try the other way i.e. bai2_pd* ?

Regards,

Hareesh

[former_member138523]

Hi Hareesh,

I tried using bai2_pd* but not working ..

This needs to handled with special format like [A-Z]*.txt ..but not wroks this option too..

Any other way ..?

rgds

Kumar

[Former Member]

Can you please post your complete channel monitoring log?

Looks like one of typical PI troubleshooting tricks might work for you i.e. Try creating the channel again and refresh the cache.