JDBC to Mail Scenario

[Former Member]

Hi SDNers,

I am currently facing a scenario where I need to select records from a database table and then convert the resultset to CSV file (FIle which can be opened using MS Excel), this CSV file needs to be sent in a mail as an attachment.

Kindly guide me on how to achive this.

Is BPM required for this scenario?

Regards,

Gautam Purohit

[Former Member · Accepted solution]

Hi,

No BPM is required.

You can do a JDBC to Mail scenario, use XSLT mapping to create the output as excel.

I am sure there are some blogs in forum which discuss the same

Regards,

Sunil.

[former_member200962]

No BPM is required to do XML-----> Excel file conversion (since you are using Mail receiver).

The only thing that you need to take care is that you populate the Content_Type node of the receiver Mail.xsd with the proper value to convert the file into Excel..

Check this blog it will help solve your problem:

/people/community.user/blog/2006/09/08/email-report-as-attachment-excelword

Regards,

Abhishek.

[Former Member]

Hi Abhishek,

Thanks for the blog link, that helped me solve the problem

Regards,

Gautam Purohit