cancel
Showing results for 
Search instead for 
Did you mean: 

How to add header line in a file from XI system using file adapters

Former Member
0 Kudos

Hi All,

I need to add header line (Column names) in a file coming from XI system.

I am using file adapters.

Thanks & Regards,

Gaurav Mittal

Accepted Solutions (0)

Answers (2)

Answers (2)

GabrielSagaya
Active Contributor
0 Kudos

In Receiver File Adapter choose File content conversion and advanced mode,

add

Row.addHeaderLine=1

Row.fieldNames=col1,col2,col3

Row.fieldSeparator=,

Row.endSepararor='nl'

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

Former Member
0 Kudos

Hi Gabriel,

Please tell me what all i need to specify in content conversion tab and what in advanced tab.

Thanks,

Gaurav Mittal

GabrielSagaya
Active Contributor
0 Kudos

The Receiver File Adapter is configured, using the following settings:

1) Choose File Content Conversion as the Message Protocol.

2) You give the ‘addHeaderLine’ parameter as 1

3) For the ‘fieldSeparator’ parameter you need to give field separator for both list and substructure (referring to the data type above). For eg: it may be a ‘,’ (comma) for substructure in a comma separated file.

4) The ‘endSeparator’ parameter needs to given for substructure only. For eg: it may be a ‘nl’ (new line)

5) Give the file name, the directory and the Construction mode. Activate all the settings. Receiver File Adapter with F.C.C. is configured.

please visit the blog.

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

/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

Former Member
0 Kudos
Former Member
0 Kudos

Hi,

I have used the same but it was adding header line for BOF structure.

Regards,

Gaurav Mittal