Receiver file formats in XI file adapter for sending to R/3

[Former Member]

Hi All,

I want to convert the XI xml file to an excel file and send to R/3. What is the configuration i need to do in the XI receiver file adapter. And please let me know what are the different types of file formats we can convert using receiver File adapter in XI (like .txt, .xl etc). Please send across example scenarios as well to deno.abraham@yahoo.com

Appreciate a quick response

Thanks,

Deno

[Former Member]

Deno,

If you want to convert into excel then I think you need to write an Adapter Module. Go through this urls which might help you Deno.

/people/michal.krawczyk2/blog/2005/12/10/xi-generating-excel-files-without-the-java-nor-the-conversion-agent-not-possible

/people/sap.user72/blog/2005/07/04/read-excel-instead-of-xml-through-fileadapter

---Satish

[Former Member]

Hi Satish,

Thanks for the reply. The Blog contains excel conversion for sender adapter. I need the same for receiver. And the XSLT one which I am not sure whether it can be used since the alignment of fields is not correct in the output xls.

If i use a proxy for conversion of xml into excel, and send it to R3 interface program which uses excel, how much more work is involved. I am not good at Java. Thats the reason for this thought.

Thanks,

Deno

[MichalKrawczyk]

Hi Deno,

>>>>I need the same for receiver.

check this one for excel file without any java

/people/michal.krawczyk2/blog/2005/12/10/xi-generating-excel-files-without-the-java-nor-the-conversion-agent-not-possible

but most probably you shouuld use either

conversion agent or an adapter module to convert

from xml to excel - if excelt has simple

structure then one day or work

Regards,

michal

[Former Member]

Thanks for the reply Michael. I am wondering whether i can convert into .txt format without using any conversion programs.

Thanks,

Deno

[former_member206604]

Hi,

Yes you can use content conversion in the File Receiver adapter to convert the payload into Text format.

Check this blog

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

and

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

Thanks,

Prakash