on 07-06-2007 12:46 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.