File processing in XI

[Former Member]

Hi all,

I have a question:

Can XI process records in a file with format A below, and map the fields to an XML format B?

Format A

========

<Header1>

<Body1_1>

<Body1_2>

<Body1_3>

<Body1_4>

<Trailer2>

<Header2>

<Body2_1>

<Body2_2>

<Body2_3>

<Body2_4>

<Trailer2>

Example of data in format A:

20070125151000Record1

100|200|300|400

1|2|3|0

10|20|30|40

10111|20222|30333|40444

xxxx4

20070125152000Record2

100|200|300|400

1|2|3|0

10|20|30|40

10111|20222|30333|40444

yyyy4

Each logical record in Format A, will be transformed to format B, and each mapped message will be sent to an inbound channel (E.g. SOAP)

Format B

========

<Record>

<Field1>100</Field1>

<Field2>200</Field2>

<Field3>300</Field3>

<Field4>1</Field4>

<Field5>2</Field5>

<Field6>3</Field6>

<Field7>10</Field7>

<Field8>20</Field8>

<Field9>30</Field9>

</Record>

If it can be done, please point me to one such example.

Thanks.

Ron

[former_member181955]

Hi Wee,

You also need to use Nodefunctions (Removecontext , splitbyvalue).

thanks

Prasad Nemalikanti

[prasanthi_chavala]

Hi,

Yes it can be done by using file content conversion.

Check dis links:

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/people/sap.user72/blog/2005/01/06/how-to-process-csv-data-with-xi-file-adapter

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

Hope it will be helpful.

Cheers,

Prasanthi.