How to do FCC to bring child nodes on next line????

[Former Member]

Hi,

My output recorset xml struc is:

<Recordset>

<Header>

<Version>1</Version>

<Count>1</Count>

</Header>

<P_Recordset>

<State>WW </State>

<Zip>333</Zip>

<R_Header>

<Remit_Rec_ID>300</Remit_Rec_ID>

</R_Header>

<R_Recordset>

<Rec_ID>310</Rec_ID>

<Date>20101004</Date>

<Description>1900000013</Description>

</R_Recordset>

</P_Recordset>

</Recordset>

I need to do FCC on receiver side to convert it to .csv file:

1,1

WW,333

300

310,20101004,1900000013

How to do FCC to bring child nodes on next line????

Plzz help.....

[Former Member · Accepted solution]

Hi,

Your reciver content convertion should look like this

Recordset Structure-> <YourMessage type>,Recordset,Header,P_Recordset,R_Header,R_Recordset

YourMessageType.endSeparator 'nl'

Recordset.fieldSeparator ,

Recordset.endSeparator 'nl'

Header.fieldSeparator ,

Header.endSeparator 'nl'

P_Recordset.fieldSeparator ,

P_Recordset.endSeparator 'nl'

R_Header.fieldSeparator ,

R_Header.endSeparator 'nl'

R_Recordset.fieldSeparator ,

R_Recordset.endSeparator 'nl'

Try this... It should work.

Thanks,

Sonalisa

[Former Member]

Create another Data Type structure that bring all the conents in same levels,

add additional mapping program, map to to it, then FCC is very simple based on new structure.

Regards

Liang