flat file to XML

[Former Member]

Hi,

I have a flat file for example:

H,1100,2005020254377650_1

L,V,1,

L,V,1,

H,1100,2005020254377650_1

L,V,1,

L,V,1,

and i want to creat different XML files where the root element is always the line that starts with the H

and the lines that start with the L

How can i do it?

[Former Member · Accepted solution]

Hi Mushon,

YOu can do this using 1:N mapping in message mapping.

Please can you have a look at this.

http://help.sap.com/saphelp_nw04/helpdata/en/42/f3b31d48fb1bc8e10000000a11466f/content.htm

Regards

Vijaya

[STALANKI]

can u please tell me ur support pack level?

[STALANKI]

chk thz out

/people/sudharshan.aravamudan/blog/2005/12/01/illustration-of-multi-mapping-and-message-split-using-bpm-in-sap-exchange-infrastructure

[Former Member]

Hi,

You can do using collect pattern of ccBPM. Check this weblog for the splitting of messages.

/people/sudharshan.aravamudan/blog/2005/12/01/illustration-of-multi-mapping-and-message-split-using-bpm-in-sap-exchange-infrastructure

Thanks,

Prateek

[STALANKI]

Can you be bit clear abt your req?I safely assume that you want to split the flat for every H as an XML and you definetly can do through multimapping.

You can check out the collect pattern in ccBPM for getting an overview.It is available in SAP BASIS SWCV.

If you are using sp level >=14..you do not require ccbpm..you can check the option rb_split in the interface determination and do it.

Let me know if you are not familiar with multimapping..check out on sdn and you can definetly find some good docs regarding the same.

[Former Member]

Thank you all ,

sravaya , you are right , i want to split every H to a different XML file and i prefere not using ccBPM.

can you guide me ?

[Former Member]

Mushon

You can go through the below urls and try to configure your scenario. If you get any error messages from SXMB_MONI post the errors here:

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

Regards,

---Mohan