Problem with File Content Conversion (Receiver FIle Adapter)

[Former Member]

I would like to perform FCC to convert XML file below to flat file. Record is 0..Unbounded

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_Rec xmlns:ns0="http://sap.com/xi/TT">

<RecordSet>

<Record>

<field1>3</field1>

<field2></field1>

<field3></field1>

<field4></field1>

<field5></field1>

<field6></field1>

</Record>

<Record>

<field1>1</field1>

<field2>C</field1>

<field3>D</field1>

<field4>E</field1>

<field5>F</field1>

<field6>G</field1>

</Record>

<Record>

<field1>2</field1>

<field2>C</field1>

<field3>D</field1>

<field4>E</field1>

<field5></field1>

<field6>G</field1>

</Record>

<Record>

<field1>3</field1>

<field2>C</field1>

<field3>D</field1>

<field4></field1>

<field5></field1>

<field6>G</field1>

</Record>

</RecordSet>

Here is my Content Conversion Parameters,

Recordset Structure: Record

Record.fieldSeparator= ,

Record.endSeparator='nl'

I expect to get output below,

3

1,C,D,E,F,G

2,C,D,E,,G

3,C,D,,,G

But I keep getting output below,

3,1,2,3

Is something wrong with my FCC parameters?

[former_member463616 · Accepted solution]

Hi,

You have to specify File Content Conversions like this.

You have to specify Recordset Structure: RecordSet,Record

Then,

Record.addHeaderLine = 0

Record.fieldSeparator = ,

RecordSet.fieldSeparator = 'nl'

Record.endSeparator = 'nl'

Hope this helps to you.

Regards,

P.Rajesh

[baskar_gopalakrishnan2 · Accepted solution]

You have to specify Recordset Structure: RecordSet,Record
Then,
Record.addHeaderLine = 0
Record.fieldSeparator = ,
RecordSet.fieldSeparator = 'nl'
Record.endSeparator = 'nl'

In addition to above Rajesh mentioned, add below parameters ..

Record.fieldNames = field1,field2,field3,field4,field5,field6
//Looks like field1 is key field and mandatory.. if so add below line too ..
Record.keyFieldValue = field1

[Former Member]

chk this:

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

[Former Member]

Hi,

Specify the field name parameters in the content conversion parameters...

HTH

Rajesh

Edited by: Rajesh on Apr 22, 2011 11:23 AM