Receiver File content conversion.

[Former Member]

Hello I have a structure like

<root>

<nameA>

<value1>value</value1>

<value2>value</value2>

<value3>value</value3>

<nameB>

<value4>value</value4>

<value5>value</value5>

</nameB>

</nameA>

</root>

Here I am not getting the fields (value4 and value5) in the output file. What could be the receiver content conversion parameters?

Please help me. Thanks in advance.

-kanth.

[Former Member]

srikanth ,

you sender file adapter cant create that file stucture you specified. you nedd to change inpur sturture.

[Former Member]

HI,

In receiver side the structure is

<root>

<nameA>

<value1>value</value1>

<value2>value</value2>

<value3>value</value3>

<nameB>

<value4>value</value4>

<value5>value</value5>

</nameB>

</nameA>

</root>

So , before proceed to above solution , you would have the no of occurrences for each node and field.

Please see the below links ..

http://help.sap.com/saphelp_nw2004s/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter - FCC

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter - FCC

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns - FCC

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file - FCC

/people/harrison.holland5/blog/2006/12/20/xi-configuration-for-mdm-integration--sample-scenario - FCC

/people/shabarish.vijayakumar/blog/2006/04/03/xi-in-the-role-of-a-ftp - FCC

/people/prateek.shah/blog/2005/06/14/file-to-r3-via-abap-proxy - FCC

/people/mickael.huchet/blog/2006/09/18/xipi-how-to-exclude-files-in-a-sender-file-adapter - EOIO - File

http://help.sap.com/saphelp_nw04/helpdata/en/ee/c9f0b4925af54cb17c454788d8e466/frameset.htm - cc

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/da1e7c16-0c01-0010-278a-eaed5eae... - conversion agent

use fixedfieldlength or

nameA.field separator is ","

nameA.ignorerecordset is true.

nameA.endseperator : 'nl'

nameB.field separator is ","

nameB.ignorerecordset is true.

nameB.endseperator : 'nl'

Other wise keep entire structure under one recordset node and use that nodefor content conversion.

Regards

Chilla...

[Former Member]

Hi,

name.keyFieldName :

name.keyFieldValue :

nameA.fieldSeparator : ,

nameA.endSeparator : 'nl'

nameB.fieldSeparator : ,

nameB.endSeparator : 'nl'

Regards

Hemant

[bhavesh_kantilal]

File Adapter does not support the strcuture ,

<root>
<nameA>
<value1>value</value1>
<value2>value</value2>
<value3>value</value3>
<nameB>
<value4>value</value4>
<value5>value</value5>
</nameB>
</nameA>
</root>

You will have to make the strucutre as,

<root>

<nameA>

<value1>value</value1>

<value2>value</value2>

<value3>value</value3>

<b></nameA></b>

<b><nameB></b>

<value4>value</value4>

<value5>value</value5>

<b></nameB></b>

</root>

And then use the Content Conversion as shown in my previous reply to achieve this.

The exisiting strcuture will only create the fields under the nameA and not under nameB.

Regards

Bhavesh

[bhavesh_kantilal]

Hi,

What is the Current Content Conversion Parameters.

The values should be,

Recorset Structure : nameA,nameB

nameA.fieldSeparator : ,
nameA.endSeparator : 'nl'
nameB.fieldSeparator : ,
nameB.endSeparator : 'nl'

Try with these parameters and chekc. It should work fine.

Regards

Bhavesh