Need File Content Conversion Help

[Former Member]

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

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

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

[Former Member]

Hi,

Refer this link for File Convertion

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

---

File content to file content

Thanks,

RamuV

[Former Member]

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

[Former Member]

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-eaed5eae... - 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-eaed5eae... - conversion agent

cheers

[former_member181962]

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

[Former Member]

use

Record.addHeaderLine = 1

For more refer

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

[Former Member]

Adding Record.addHeaderLine=1 did not help out.can someone give me an example two field structure to make me understand this

My Structure is like below

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_IDOC2FILE xmlns:ns0="http://ffvendor">

<CustomerRecords>

<Customers>

<custnumber>666</custnumber>

<country>US</country>

</Customers>

</CustomerRecords>

</ns0:MT_IDOC2FILE>

Thanks

Regards,

Karthik

[GabrielSagaya]

Recordset structure=Root,Record

Record.addHeaderLine=1

Record.fieldNames=name,mobile,email

Record.fieldSeparator=,

Record.endSeparator='nl'

Root.fieldSeparator='nl'

Root.endSeparator='nl'

[Former Member]

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

[Former Member]

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