Message splitting without ccBPM

[Former Member]

My scenario is as follows

FILE ---> XI ---> FILE

The data is exchanged as XML. The structure is pretty simple, multiple records exist in a file and each record has multiple columns.

No mapping required. This interface is currently in production in our environment.

We have a requirement now to split the target file into multiple files by date. The data is a column in the payload. So we need to combine all records that have the same date into their own separate target files.

I dont want to use ccBPM due to the performance overhead it has. I dont have any other mapping requirements other than this.

Does anyone have any idea on how this can be done?

Regards

Haseeb

[nisarkhan_n · Accepted solution]

We have a requirement now to split the target file into multiple files by date. The data is a column in the payload. So we need to combine all records that have the same date into their own separate target files.

use the variable substution selecte date field as the file name and file const modechoose append:

this will put all the records which has same date in the one file...

this should work out

Message was edited by:

n Khan

[former_member189558 · Accepted solution]

THis is a brilliant idea....

[Former Member · Accepted solution]

Khan,

yes,really a great idea. I was thinking just around the multimapping with or without BPM.

this is more efficient way.

really a good idea....

Babu Sri

[Former Member · Accepted solution]

Khan,

As some other have said I was leaning towards multi mapping too.

But let me give a shot to your idea.

If it works it will be excellent.

I have rewarded you points, if it solves it, more on the way.

Regards

Haseeb

[nisarkhan_n · Accepted solution]

I had implemented this, let me know if this doesn;'t wrk for you wil try to put more inputs.

[Former Member · Accepted solution]

Khan,

Can you provide more details of your solution.

This can help me and others understand it better.

Based on your previous suggestion, I have tried it and it doesnt solve my problem exactly in my scenario.In my case, I have a single message which needs to be split into multiple messages based on the date in the payload. The file name for each message split need to have the date from the payload.

Anyway, your solution in detail can help me understand if I am missing anything.

Regards

Haseeb

[former_member189558]

You have to handle this in mapping. You do not need to use BPM.

This will be better handled if you use ABAP / JAVA Mapping instead of graphical.

Thanks and Regards,

Himadri

[Former Member]

Hi,

May not be a good solution but analyse and try to implement.

in general for a message

root node -- 1..1 or 0..1 as occurrences

recordset -- 0..unbound as occurrences

Now Change it to

Message1 -

---

0..unbound to come (optional)

root node -- 0..unbound as occurrences

recordset -- 0..unbound as occurrences

Before doing the below you need to do the sortind based on the date and per eache message one date records shhould be populated.. handle in UDF

message should be created multiple times.. .. no need to handle in adapter level , you need to handle in interface determination level.. check the below link

it will be created multiple..

see the below link

http://help.sap.com/saphelp_nw70/helpdata/en/42/ed364cf8593eebe10000000a1553f7/content.htm

Chilla