Exclusion of selected file name in Sender File adapter

[Former Member]

Dear Experts,

I am working in a File -> SAP-PI -> ECC.I am able to get the files

and move it to ECC but the adapter is picking the files which I do not want..

In the source folder, i have files with name PG.xml and GY.xml. Both the files are added everyday with 
time stamp. My requirement is to pick the PG.xml file and exclude the GY.xml files.

So in the sender File, i entered the following.

File Name= *.xml

In the Advance Selection for Source file,in the Exclusion mask= G*

But still the file with name GY.xml is being picked up.

Is there any wrong in the entries made ?

Avoiding duplicity of the already processed files, I checked Enable Duplicate handling in Processing tab

Thanx

Rebecca Alice

[baskar_gopalakrishnan2 · Accepted solution]

I would not use Advance selection for this... Simple use Filename =P*.xml  assuming you append timestamp at the end of the file such as "PG04052013162332.xml"

[Former Member · Accepted solution]

Hi Bhaskar,

Ur suggestion worked in picking the file with the PG* pattern. Now the other issue cropping out of this ...

I have 3 files with PG* pattern appended every day. Now after picking the 3 files each files in 3 days, then on 4th day the Sender Cc shows error since I have checked Duplicate Handling in Processing tab. Its not picking the newly appended 4 file on the 4 day because of error sender Cc.

Any idea please suggest..

Tnx

Rebecca

[former_member223322 · Accepted solution]

If the file is getting appended, then don't use the duplicate handling.

~Srini

[Former Member · Accepted solution]

Hi Srini,

I selected Duplicate Handling option as the sender Cc will pick the files once in a day.The files are not deleted from the source folder. If the Duplicate option is not checked , then it will again pick the already processed files.

I think if I select the Processing mode as Delete / Archive then whether it help...

Regards

Rebecca

[former_member223322 · Accepted solution]

Select the processing Mode as Archive and assign a directory path for it. That helps!

~Srini

[Bhargavakrishna]

Hi Alice,

what error it is showing for that communication channel.

have you tried after unchecked the duplicate handling?

[Former Member]

Hi Bhargava,

The Sender Cc show error since it is picking the old processed files.Its shows the file is already processed.

If I dont select Duplicate option, then it will take already processed file...

Thnx

Rebecca

[Former Member]

It would be better, you archive the file into another folder. So, that new file will be picked up.

[former_member223322]

Is that time stamp added before the GY? If thats the case then try maintaining the exclusion mask as *GY*. Also why don't you just pull the files with the pattern PG*.

~Srini

[Former Member]

HI Srinivasan,

Time stamp is added after PG* i.e. PG01052013.

The source directory contains 2 file name i.e. PG01052013 and GY01052013 which is updated daily once in a day.I have created 2 sender Cc for pick up these 2 different file names.

I want to pick only PG* pattern but it is also picking GY* pattern also.

How to do that..

Tnx

Rebecca