Skip to Content
author's profile photo Former Member
Former Member

Need File Content Conversion Help

Hi,

With the help of the SDNers i was able to create the proper structure for FCC.Now i want to have the column names been listed as part of the final file content.with the current structure i could get only the data and not the coulmnheaders

The structure used is as below:

Recordset structure=Root,Record

Record.addHeaderLine=0

Record.fieldNames=name,mobile,email

Record.fieldSeparator=,

Record.endSeparator='nl'

Root.fieldSeparator=,

Root.fieldSeparator='nl'

Pls help me solve this.

Regards,

Karthik

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

8 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 02:23 PM

    Hi,

    Simplest Solution would be to have another field in your data type and map it to a constant header.

    and in structure

    remove

    Root.fieldSeparator=,

    because Root node have records and that records have fields.

    Reward points if help ful.

    Regards,

    Pradeep A.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I was able to create the Column headers and i followed the following procedure:

      1)Added one Node by name "Header" and added all the column names as Constant elements.

      2)In the Record Structure i added Header as one of the Record Strurture and added the details Header.fieldNames,Header.fieldSeparator and Header.endSeparator as CC parameters.

      Is what i did is correct or will it pose any problems.Please do verify

      Regards,

      Karthik

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 02:32 PM

    HI

    refer the following links

    File Content prameters for the Receiver Adapter

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

    File Content prameters for the Sender Adapter

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

    Refer

    File Receiver with Content Conversion

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

    Configuring the Receiver File/FTP Adapter

    http://help.sap.com/saphelp_nw04/helpdata/en/95/bb623c6369f454e10000000a114084/frameset.htm

    File content conversion sites

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

    Please see the below links for file content conversion..

    /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

    File Content Conversion for Unequal Number of Columns

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

    Content Conversion (Pattern/Random content in input file)

    /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 - MDM

    XI in the role of a FTP

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

    File to R/3 via ABAP Proxy

    /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

    http://help.sap.com/saphelp_erp2005vp/helpdata/en/95/bb623c6369f454e10000000a114084/content.htm - fcc cOUNTER

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

    File Content prameters for the Receiver Adapter

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

    File Content prameters for the Sender Adapter

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

    Refer

    File Receiver with Content Conversion

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

    Configuring the Receiver File/FTP Adapter

    http://help.sap.com/saphelp_nw04/helpdata/en/95/bb623c6369f454e10000000a114084/frameset.htm

    File content conversion sites

    /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/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

    /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/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

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

    Please see the below links for file content conversion..

    /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

    File Content Conversion for Unequal Number of Columns

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

    Content Conversion (Pattern/Random content in input file)

    /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 - MDM

    XI in the role of a FTP

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

    File to R/3 via ABAP Proxy

    /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

    http://help.sap.com/saphelp_erp2005vp/helpdata/en/95/bb623c6369f454e10000000a114084/content.htm - fcc cOUNTER

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

    cheers

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 02:14 PM

    hi

    Set these parameters

    NameA.addHeaderLine

    Specify whether the text file will have a header line with column names. The following values are permitted:

    · 0 u2013 No header line

    · 1 u2013 Header line with column names from the XML document

    · 2 u2013 As for 1, followed by a blank line

    · 3 u2013 Header line is stored as NameA.headerLine in the configuration and is applied

    · 4 u2013 As for 3, followed by a blank line

    This specification is only permitted if exactly one structure is defined.

    NameA.headerLine

    Specify the header line that is generated in the text file if NameA.addHeaderLine has the value 3 or 4. This specification is mandatory in this case.

    rgds

    Arun

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 02:14 PM

    Karthik,

    Use parameter as "NameA.headerLine" for defining the header.

    refer to below link for detail

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

    Gaurav Jain

    Points if answer is helpful

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 02:15 PM
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 16, 2008 at 02:15 PM

    Hi Karthikeyan,

    I do not know if you have gone through this link.

    http://help.sap.com/saphelp_nw04/helpdata/en/0d/00453c91f37151e10000000a11402f/content.htm

    Search for the text "Column name"

    Regards,

    Ravi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 02:41 PM

    Specify CC parameters as

    Recordset structure=Root,Record

    Root.addHeaderLine=1

    Record.addHeaderLine=1

    Record.fieldSeparator=,

    Root.fieldSeparator='nl'

    Record.endSeparator='nl'

    Record.endSeparator='nl'

    In reeceiver content conversion, giving fieldNames is of no use...

    i am assuming that Root and Record are the nodes that contain some child element

    Edited by: Mugdha Kulkarni on Jun 16, 2008 4:46 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 03:04 PM

    Hi,

    Refer this link for File Convertion

    https://www.sdn.sap.com/irj/sdn/wiki -


    File content to file content

    Thanks,

    RamuV

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.