Mergeing files of same structure to one file without BPM

[Former Member]

Hi XI Gurus,

I want to merge various xml files having same structures(coming as separate files in source directory) to a one file. I want to do it without using BPM.I need this Final structure as an input to another scenario to post an idoc.

e.g -->

<i>File1</i>:

<AR_Posting>

<currency_line_item>1<currency_line_item>

<tax_line_item>2<tax_line_item>

<customer_line_item>3<customer_line_item>

<AR_Posting>

<i>File 2</i>:

<AR_Posting>

<currency_line_item>11<currency_line_item>

<tax_line_item>22<tax_line_item>

<customer_line_item>33<customer_line_item>

<AR_Posting>

<i>File 3</i> :

<AR_Posting>

<currency_line_item>111<currency_line_item>

<tax_line_item>222<tax_line_item>

<customer_line_item>333<customer_line_item>

<AR_Posting>

Target:

<Recordset>

<AR_Posting>

<currency_line_item>1<currency_line_item>

<tax_line_item>2<tax_line_item>

<customer_line_item>3<customer_line_item>

<AR_Posting>

<AR_Posting>

<currency_line_item>11<currency_line_item>

<tax_line_item>22<tax_line_item>

<customer_line_item>33<customer_line_item>

<AR_Posting>

<AR_Posting>

<currency_line_item>111<currency_line_item>

<tax_line_item>222<tax_line_item>

<customer_line_item>333<customer_line_item>

<AR_Posting>

<Recordset>

Please suggest any solution to achieve this.

[Former Member · Accepted solution]

Hi Anurag,

Without BPM i dont think that is possible.

What you can do is create a simple scenario of file to file. You read the source file one by one and in the target file append the records.

Regards,

Sumit

[Former Member · Accepted solution]

Hi Sumit,

How we can append the records automatically ?.

Please explain this aproach in steps.

[Former Member · Accepted solution]

Hi Anurag,

There will be a receiver file adapter which will create the file. Right?

in that file adapter there is a option where in you can specify append.

Regards,

Sumit

ps ; reward points if that helped u .

[Former Member]

Hi Anurag,,

I guess what Sumit is aiming for, is that if you don't want to use a BPM you will need a two step solution.

Step one:

If the different files have the same structure, read them with a sending file adapter and route the to an receiving file adapter which appends all messages to a new combined file.

Step two:

Read the new combined file with a sending file adapter and route the messages to your target interface.

This approach of-course means that you can not do any correlations as you can in BPM. I.e. you will not "know" when all three files have arrived but just simply read the combined files at certain times and pick-up whatever content it holds.

rgds Johan

[Former Member]

Look at the SAP examples of BPMs.

SAP BASIS > SAP BASIS x.xx

Integration Processes

BpmPatternCollectXXXXXXXXX

There's no reason you'd need to deviate from this approach, and I know of no other way (XI 7.0 SPS 12) to do this without the BPE.

Hope that helps,

James.

[former_member529475]

HI Anurag

you need to use a BPM which will wait for multiple files to start (fork step) and then you can merge them in a transformation step

Cheers..

Vasu

<i>** Reward Points if found useful **</i>

[Former Member]

Hi anurag,

U can use multi mapping for the same .As multimapping is supported on XI without BPM also .

Just check what SP are you using as It is supported by SP14 and above of XI 3.0

Regards,

**grant points if info is helpful

[Former Member]

Hi Amit,

thanks a lot for quick response.. Actually i am using service pack 06 which supports 1:n,N:M but does not supports N:1 multimapping .I have already checked that .Is there any other way to do this .?

Is there any parameter in Sender FILE Adapter by which we can achieve this?

Shall i consider the proxies to do this?