Receiver File Content Conversion

[former_member190313]

Hello,

I have the following structure to be converted to text through FIle Receiver Adapter .

Input structure

ns0:MT_Sender_Final xmlns:ns0="urn:MsgMap">

- <RecordSet>

- <Row>

<TradeType>IM</TradeType>

<TradeDate>10/30/2003</TradeDate>

<Currency>INR</Currency>

</Row>

- <Row>

<TradeType>ID</TradeType>

<TradeDate>10/30/2003</TradeDate>

<Currency>INR</Currency>

</Row>

</RecordSet>

</ns0:MT_Sender_Final>

In the Content Conversion parameter. I have given the filename as

Recordset Structure --> Row

Row.addHeaderLine --> 0

Row.fieldSeparator --> ,

Row.endSeparator --> 'nl'

Current Output:-

IM,ID

expected ouput

IM,10/30/2003,INR

ID,10/30/2003,INR

As mentioned I am getting output as only the first columnn and not the entire row..

It would be really very helpful if someone cud throw some light on that.

Regards,

Sheetal Deodhar

[Former Member]

Hi Sheethal,

Can you just try this out

RecordSet Structure: RecordSet,Row

RecordSet.fieldNames Row

RecordSet.fieldSeparator 'nl'

Row.fieldSeparator ,

Row.fieldNames TradeType,TradeDate,Currency

Row.endSeparator 'nl'

thanks and regards

Ramana

[justin_santhanam]

raMana,

All the parameters are correct. But there is no need for fieldNames in receiver content conversion.

Best regards,

raj.

[Former Member]

Raj,

You are right. But that gives more clarity to people who look at it and who r going to make corrections, if any, in the future..

thanks,

Ramana

[Former Member]

Hi,

did u mentioned the field names in the CC Parameter list.

Row.fieldnames TradeType,TradeDate,Currency

try this one it should work out.

Regards

Shaik

[santhosh_kumarv]

Hi Sheetal

See to the blog

<a href="/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion Receiver with Content Conversion</a> by Arpith

Regards

Santhosh

*If found useful reward points*

[justin_santhanam]

Sheetal,

Try the below option. I'm sure it will work

<b>Receiver Comm.Channel</b>

Recordset Structure : RecordSet,Row

Row.fieldSeparator : ,

Row.endSeparator : 'nl'

Best regards,

raj.

[Former Member]

hi sheetal,

plz try with trhese params:

Document name: MT_Sender_Final

Documant namespace: urn:MsgMap

Recordsetname: RecordSet

Recordset Structure: Row,*

Row.fieldseparator: ,

Row.enSeparator: 'nl'

Row.fieldNames: TradeType,TradeDate,Currency

hope it helps.

regards,

latika.

[former_member190313]

Hello Latika,

The parameters u have specified is for sender <b>Not for Receiver</b>

kindly help me out for the receiver File Adapter..

Regards,

Sheetal Deodhar

[Former Member]

Deodhar,

Check this weblogs where he has mentioned the similar scenario:

/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

Also can you give your target structure so that somebody can help you out with content conversion parameters.

Regards,

---Satish

[former_member529475]

HI Sheetal

Have a look at the this blog by Arpit Seth ... its all about FCC at receiver side...

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

Also have a look at this thread.. might be helps you....

Cheers..

Vasu

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

[Former Member]

hi sheetal,

i jus tried the same scenario as urs and it wrks fine!!

plz check ur mapping once if its rite as for this requirement that u specified FCC params u gave seem fine.plz ensure ur mapping isnt suppressing the other values.

regards,

latika.