File Adapter : Sequence Check

[Former Member]

Hello,

I'm facing the following issue: We receive files from a trade parter. These files have a sequence number in their file name. Eg. utilmd001.txt. We need to send these files as idocs to our SAP system. But we can only process a file if the previous file is already processed. Eg. utilmd003.txt can only be processed if utilmd002.txt is processed. Any idea on how to incorporate this in the file/FTP Adapter? Also note that we cannot assume that utilmd002.txt arrives before utilmd003.txt.

Any ideas?

Greetings,

Bart

[Former Member · Accepted solution]

Hi Bart,

An option could be to store incoming messages on a intermediate folder, and have the file adapter of XI listening for incoming files at another folder where files are placed (by a custom written Java application or some FTP/Batch procedure..that keeps the sequence of received files in memory or a file) one by one in the correct sequence.

In this way you are always sure that XI only process those files in the correct sequence.

Cheers,

Roberto

[Former Member · Accepted solution]

Hello Roberto,

Thanks for your answer. Good idea but I would like to have this custom written program in XI. Maybe some kind of module that does the sequence check against the db and then stops the message processing when the check fails. I tried using a moduleException, but the processing just goes on

Any ideas on how to do this?

Greetings,

Bart

[Former Member · Accepted solution]

Hi Bart,

I know it is possible to define generic modules (here is where the Java function comes into the picture) for each adapter in the module processor to enhance the adapter with additional functionality (e.g. SequenceCheck). I haven't tried before but you can always try. The FTP/batch commands alternative is a workaround that is simply and fast (without knowing your specific requirements) to implement.

Check this link for more info on the module processor: http://help.sap.com/saphelp_nw04/helpdata/en/f4/8620c6b58c422c960c53f3ed71b432/frameset.htm

And

This one for more info related to the development of your own modules: http://help.sap.com/saphelp_nw04/helpdata/en/f4/8620c6b58c422c960c53f3ed71b432/frameset.htm

Cheers,

R.