Issue with File to Mail Interface ?

[former_member454912]

Hi,

I have to send a file as an attachment through email and attachment should be convert it into ".xlsx" format(in mail attachment file should be .xlsx formate) in Pi 7.31 sp 10

1.In sender side we have .txt file - we are using File FCC

2.In receiver side we have to get an attachment as .xlsx - we are using Mail adapter

3.In mapping we did one to one mapping

and in receiver module we use "localejbs/AF_Modules/MessageTransformBean"

So we converted the file into .xlsx format but we are unable to open the file.

Can any buddy help me out how to resolve this issue..

Thanks,

Siva

[manoj_khavatkopp]

You will find a lots of refrence try to search below are few :

https://blogs.sap.com/2014/11/03/exceltransformbean-part-2-convert-simple-xml-to-various-excel-forma...

https://blogs.sap.com/2012/09/08/convert-incoming-xml-to-excel-sheet/

https://blogs.sap.com/2012/09/16/convert-incoming-xml-to-excel-or-excel-xml-part-1-xslt-way/

[manoj_khavatkopp]

Siva,

The 0x09 works only for excel file with .xls extension . For .xlsx you need to use custom java / module.

Try renaming the filename extension to .xls

Br,

Manoj

[former_member454912]

Hi Manoj, Could you please provide any reference for the same as i am new to java/ module

Thanks,

Siva

[manoj_khavatkopp]

Please find below reference :

https://blogs.sap.com/2012/09/08/convert-incoming-xml-to-excel-sheet/

https://blogs.sap.com/2014/11/03/exceltransformbean-part-2-convert-simple-xml-to-various-excel-forma...

[former_member454912]

Hi Manoj,

Sorry for the late reply, i tried with this link
https://blogs.sap.com/2014/11/03/exceltransformbean-part-2-convert-simple-xml-to-various-excel-forma...

in out put we are getting xml format as output but we need in .xlsx format.

I need clarify one more thing Our Current SAP PI version is 7.31 SP10 is it possible to convert the file in .xlsx format with this version ?

Thanks,

Siva

[manoj_khavatkopp]

Siva,

That's custom module . Have you deployed EAR file from that blog into your PI system?

Br,

Manoj

[former_member454912]

Hi Manoj,

EAR Files are deployed properly but unable to convert the .xlsx file, But when i did File to File using Format conversion bean it able to create .xlsx file and able to open normally.

Thanks,

Siva

[manoj_khavatkopp]

Siva,

Use scenario one from this blog :https://blogs.sap.com/2016/03/10/stop-using-mail-package-simplify-your-mail-receiver-adapter-scenarios/

Br,

Manoj