File Content Conversion

[Former Member]

Hi experts;

I am working on a scenario where i am getting in flat file and have to convert it to xml.

I am not much aware about File content conversion can anyone provide me some details or a weblog on the same.

Thanks Arjun

[Former Member · Accepted solution]

Hi;

Have it here

help link for Receiver file adapter (FCC) - http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

These are a collection of blogs on content conversion (both receiver and sender)

/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

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

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

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

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

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

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

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

Mudit

[Former Member]

HI

To transform a flat file into XML, you need to configure the sender file adapter with the message protocol as File Content Conversion

You must provide values to some fields in order to facilitate the conversion of a flat file to XML such as:

Document Name

Document Namespace

Recordset Name

Recorset Structure

Here one thing that you need to keep in mind is that if your recordset has some row which can occur 'n' number of times, then you need to mention the name in the parameter 'Key Field Name'

The general structure of a XML file goes like this:

<recordset>

<row>

<element 1>..... </element 1>

</row>

</recordset>

See these links.

http://help.sap.com/saphelp_nw04/helpdata/en/0b/9a50465ccf84479e39a6d50c90fb3f/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

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

/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

[santhosh_kumarv]

Hi Ajun

Go through the Wiki

<a href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/flatFILETOFLATFILE&">Flat File-XI-Flat File</a> which is more informative for beginners.

[former_member184619]

Hi Arjun,

if u are having fixed length file at source use

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

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

If CSV try this link for sender FCC

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/frameset.htm

Sachin

Message was edited by:

Sachin Dhingra