Problem with File content conversion and parameters

[gopalkrishna_baliga]

Hi experts,

What is the use of file content conversion that is available in file adapter? For what cases we can use it?

What do the different content conversion parameters mean?

Kindly help

Thanks

Gopal

[Former Member]

Hi Gopal,

XI can understand only XML messages. So what ever may be your input you need to convert it into XML format by using adapters.

so in File adapter these content conversion parameters are used for this purpose.

coming to different parameters involved in content conversion, we have different file types like csv, tab separated, flat file etc.

mandatory parameters are

1. fieldFixedLenghts or fieldSeparator

2. fieldNames

we use fieldFixedLengths in case of flat file. in case of csv or tabseparated file we use fieldSeparator parameters.

all others should be used as the requierment suggests.

for details you can follow the link:http://help.sap.com/saphelp_nw04/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm

Regards,

Pavani

[former_member184619]

Hi Gopalkrishna,

What is the use of file content conversion that is available in file adapter? For what cases we can use it?

FCC is used to send and receive the files which are having complex structures.

CSV - Comma separated file or fixed lenght

in which fields are separated by , or some other delimiter like TAB or having a fised lenght fields.

to convert such files into XML we use FCC

What do the different content conversion parameters mean?

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

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

Sachin

[Former Member]

Hi,

We use the file content convertion to conver the flat file that is text file into XML,

File adapter cant understand the format the file is,so we have to declare the content convertion parameters.

Check some links which will tell how the convertion is done.

/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

Regards,

Phani

Reward points if helpful

[GabrielSagaya]

If you have selected File Content Conversion under Message Protocol, a) you can convert a table in XML format to pure text format.

b) you can convert a text file containing complex structures into an XML source format

The different FCC parameters are

fieldSeparator

endSeparator

FieldFixedLength

fieldnames

addheaderline

ignorerecordset

processconfiguration

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

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