RECEIVER file CONTENT CONVERSION

[#1]

Hello friends,

I have the following structure,

<root>

<nameA>

<value1>value</value1>

<value2>value</value2>

<value3>value</value3>

<nameB>

<value4>value</value4>

<value5>value</value5>

</nameB>

</nameA>

</root>

Here I need to convert this structure into a flat file. Here I am using RECEIVER FILE CONTENT CONVERSION to create a CSV file.

Can any help me in content conversion?

Thanks in advance,

-kanth.

[Former Member]

HI,

I hope this is repeating question..

The same structure was given in help.sap.com for file adapter content conversion receiver side.. please see that help , sure you will get an idea..

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>

Recordset and record structure names are the same root .Use this name..

Or try to pull this structure into under one more recordstructure node then you can do it..

Actually it depends upon the imput file structure also.

try..

nameA.field separator is ","

nameA.ignorerecordset is true.

nameA.endseperator : 'nl'

nameB.field separator is ","

nameB.ignorerecordset is true.

nameB.endseperator : 'nl'

or use fixedfieldlength and give the field lengths.. instead above fieldseparator,endseparator..

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

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

Regards

Chilla..

<i>Points rewarded if it is helpful..</i>

[bhavesh_kantilal]

><i>The same structure was given in help.sap.com for file adapter content conversion receiver side.. please see that help , sure you will get an idea..</i>

The Strcutres are different,

Help.sap. strcuture is,

<root>

<nameA>

<value1>value</value1>

<value2>value</value2>

<value3>value</value3>

<b></nameA>

<nameB></b>

<value4>value</value4>

<value5>value</value5>

</nameB>

</root>

His Receiver Strcuture is,

<root>

<nameA>

<value1>value</value1>

<value2>value</value2>

<value3>value</value3>

<b><nameB></b>

<value4>value</value4>

<value5>value</value5>

<b></nameB>

</nameA></b>

</root>

As far as I know this strucutre is not supported by the Receiver File adapter and the strcuture would need to be changed as per help.sap. and then the content conversion parametrs provided above will work fine.

Regards

Bhavesh