cancel
Showing results for 
Search instead for 
Did you mean: 

Condition Editor for unwanted files

AlexanderApel
Participant
0 Kudos

Hi Experts,

i want to use the Condition Editor for unwanted files in a file to IDoc Scenario.

Files in the list may not be processed. Can it work?

Greetings,

Alex

Accepted Solutions (0)

Answers (5)

Answers (5)

xinjiang_li
Active Participant
0 Kudos

Hi Alex,

Have you tested your scenario?  Can the unequal operator be used together with * character? I think you may need to use EX operator and use XPATH to make it work.

Regards.

AlexanderApel
Participant
0 Kudos

Hi,

my scenario is in Test, i will post the result.

Regards,

Alex

AlexanderApel
Participant
0 Kudos

Hi,

bad news from my tests... it does not work.

Now i´ll try Raghu proposal

Regards

naveen_chichili
Active Contributor
0 Kudos

Hi Alex,

The condition will work.

Thanks and Regards,

Naveen

RaghuVamseedhar
Active Contributor
0 Kudos
engswee
Active Contributor
0 Kudos

Good one Raghu, thinking out of the box Definitely better to prevent a message from entering the system first!

AlexanderApel
Participant
0 Kudos

Hi Raghu,

i tried the Exclusion mask but it does not work.

Channel:

Message Monitor:

any ideas?

Regards,

Alex

RaghuVamseedhar
Active Contributor
0 Kudos

Alex,

Please try, these exclusion mask

.*4399902061636.*

.*8014347000007.*

OR

.*?4399902061636.*

.*?8014347000007.*

engswee
Active Contributor
0 Kudos

I think the values in column "File Name Mask" should be invoice*.xml instead of GLN.

Currently your additional selection is only configured for files named GLN - not even files with GLN as prefix there isn't even a wildcard * after GLN.

AlexanderApel
Participant
0 Kudos

Hi Raghu,

Hi Eng,

i tryed your both offer without success.

any other idears?

Regards,

Alex

iaki_vila
Active Contributor
0 Kudos

Hi Alexander,

Following with Eng suggestion, Have you tried to let the Exclusion Mask box empty?.

Regards.

AlexanderApel
Participant
0 Kudos

Hi,

yes i tried this befor... with an emtpy exclusion mask all massages will be processed.

Regards,

Alex

RaghuVamseedhar
Active Contributor
0 Kudos

Alexander,

I think the regular expression match in file channel has limitation, to use only ? or *.

Is it possible to request source system to name file like this (starting with required comp number)?

8014347000007_invoic4104420000001_20150212_1501641_380_1300821.xml

Then you can use exclusion mask.

iaki_vila
Active Contributor
0 Kudos

Hi,

I think Raghu has found the key problem if you read carefully the documentation:


To select a list of files for processing, you can specify placeholders (* ?) for exactly one character in the File Name.

Only one * or one ?.

Good observation!.

Regards.

engswee
Active Contributor
0 Kudos

Nice spot Raghu! I've never really had to use more than one wildcard myself so did not know this limitation.

Fortunately, these days I work on the SFTP adapter more which has superior regex capability - it's just another one of those puzzles why SAP does not provide similar capability for the File adapter ... oh well...

AlexanderApel
Participant
0 Kudos

Hi Raghu,

i try our offer and post the result.

Here the options:

And here is a sample filename for one unwanted file:

20150227-155047-791_invoic4104420000001_4010160000006_1314405.xml

Regards,

Alex

AlexanderApel
Participant
0 Kudos

Hi,

no success 😞

All massages are processed.

Regards,

Alex

iaki_vila
Active Contributor
0 Kudos

Hi Alexander,

According with Raghu suggestion you can set only one wildcard in your exclusion mask and you have set two.

Regards.

AlexanderApel
Participant
0 Kudos

Ok, then i have to find another solution because i have to set 2 wildcard´s

one after invoic4104420000001 and one before time stamp.


EDIT:

same result with one wildcard - all messages are processed





Message was edited by: Alexander Apel

former_member181985
Active Contributor
0 Kudos

Hi Alex,

Yes it will work.

But you should remove double quotes " for value in Right Operand

Sorry, I misread * as "

Best Regards,

Praveen Gujjeti

Message was edited by: Praveen Gujjeti

engswee
Active Contributor
0 Kudos

Hi Alex

I suggest you just try it out and see what happens during runtime.

Btw, I think you need an "AND" join between the two conditions.

test123456 will fail the first condition, but pass the second condition, so it will still go through.

An example data with Filename = test123456 will fail the first condition, but pass the second condition, so it will still go through.

Rgds

Eng Swee

Message was edited by: Eng Swee Yeoh