Receiver File content conversion for multi level hireachy

[vidyadhar2k2]

Receiver channel file content conversion..

this is SAP proxy to FIle Scenario, which will get invoice details from SAP along with multiple invoice texts for each invoice.

I would like to have below mentioned payload at Target side,

<MT_Invoice>

<File Header> 1...1

<f1> customer invoices </f1>

<f2> 12/02/2010 </f2>

</File Header>

<Invocie header>

<f1> Invoice number1 </f1>

<f2> customer number1 </f2>

</Invoice header>

<Invoice text>

<f1> Inovice no1-text1 </f1>

</Invoice text>

<Invoice text>

<f1> Inovice no1-text2 </f1>

</Invoice text>

.

.

.

.

<Invocie header>

<f1> Invoice number2 </f1>

<f2> customer number2 </f2>

</Invoice header>

<Invoice text>

<f1> Inovice no2-text1 </f1>

</Invoice text>

<Invoice text>

<f1> Inovice no2-text2 </f1>

</Invoice text>

<Invocie header>

<f1> Invoice number3 </f1>

<f2> customer number3 </f2>

</Invoice header>

<Invoice text>

<f1> Inovice no3-text1 </f1>

</Invoice text>

<Footer> 1..1

<f1> have a great day </f1>

</footer>

</MT_Invoice>

for the above payload file should come as mentioned below

customer invoices 12/02/2010

invocie number1 customer no 1

invoice no1-text1

invoice no1-text2

invocie number2 customer no 2

invoice no2-text1

invoice no2-text2

invoice no2-text3

invocie number3 customer no 3

invoice no3-text1

have a great day

For to get the above payloadI have create a message type like

MT_invoice

header 1...1

f1 1

f2 1

invoice details 0... unbound

f1 1

f2 1

invoice text 0.... unbound

f1

footer 1...1

f1 1

Please correct me if my message type declaration was wrong...

Please suggest how do i need to approach for message mapping and as well as FCC in File adapter...

Edited by: Vidyadhar Kurmala on Dec 2, 2010 10:28 AM

[stefan_grube]

It is not possible to create alternating nodes in graphical mapping tool.

I recommend using the MessageTransformBean for FCC, as this supports a 2-level hierarchy.

Then you add a node record like this:

<MT_Invoice>

<Record>

<File Header> 1...1

<f1> customer invoices </f1>

<f2> 12/02/2010 </f2>

</File Header>

</Record>

<Record>

<Invocie header>

<f1> Invoice number1 </f1>

<f2> customer number1 </f2>

</Invoice header>

<Invoice text>

<f1> Inovice no1-text1 </f1>

</Invoice text>

<Invoice text>

<f1> Inovice no1-text2 </f1>

</Invoice text>

</Record>

.

.

.

.

<Record>

<Invocie header>

<f1> Invoice number2 </f1>

<f2> customer number2 </f2>

</Invoice header>

<Invoice text>

<f1> Inovice no2-text1 </f1>

</Invoice text>

<Invoice text>

<f1> Inovice no2-text2 </f1>

</Invoice text>

<Invocie header>

<f1> Invoice number3 </f1>

<f2> customer number3 </f2>

</Invoice header>

<Invoice text>

<f1> Inovice no3-text1 </f1>

</Invoice text>

</Record>

<Record>

<Footer> 1..1

<f1> have a great day </f1>

</footer>

</Record>

</MT_Invoice>

[Former Member]

Hi Vidhyadhar,

FCC is possible till 3 levels and hence in your case the normal FCC will not work.. I will suggest you to look into this link and do some workaround like that mentioned in the blog

/people/karthiknarayan.kesavan2/blog/2007/08/22/file-content-conversion-for-multi-hierarchical-structure

Thanks,