sender mail adapter

[Former Member]

Dear Gems,

I got a scenario(EMAIL to JDBC) where i will get 2 attachements(pdf,xls) as emai to PI.Here my concerns are..

1. I have to read only xls from two attachements..how can i?

2.convert excel to xml.i have the code to convert,but where should i use it Adapter module or mapping?

3.i have to read email from only one sender?

Can u suggest?

Thanks

Prabhakar

[Former Member]

Resolved:

[Former Member]

Hi Prabhakar,

You can use conversion agent, check the below link:

http://help.sap.com/saphelp_nw04/helpdata/en/43/4c38c4cf105f85e10000000a1553f6/content.htm

For more details and for downloading Conversion Agent(CA) check out this URL...

/people/william.li/blog/2006/03/17/how-to-get-started-using-conversion-agent-from-itemfield

For generating excel file without using CA or writing adapter moduel you can refer this Michals blog..

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

For reading xls file check out this thread which I have used while generating module..

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3bdc14e1-0901-0010-b5a9-a01e29d7...

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

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/02706f11-0d01-0010-e5ae-ac2...

In case if you are planning to write adapter module...you might need to debug your code...here is a thread which shows how to debug code..

[Former Member]

guys,

i still struggle to read only xls file my two attachments(pdf,xls)

can we idetify with MIME/file name?

[Former Member]

Hi,

why cannot u check for the MIME type, and differentiate the attachments in coimng..

please go through this link

http://www.w3schools.com/media/media_mimeref.asp

Babu

[Former Member]

Hi,

1. I have to read only xls from two attachements..how can i?

U can read the required attachment out of coming attachments in the Adapter Module code.

2.convert excel to xml.i have the code to convert,but where should i use it Adapter module or mapping?

For this u need to write an adapter module code. I think there is already a lot of blogs and code snippets present in SDN.

Please search and let us know if u face any problem.

U need to deploy this adapter module code in J2EE server, and call the same in Modules execution pipeline.

3.i have to read email from only one sender?

U can do it by configuring the Sender mail adapter to the given Mail ID.

Babu