How to send Excel file from a shared location as email attachment via XI?

[gopalkrishna_baliga]

Hi Experts,

I have a requirement where I have to send a excel file as email attachment via XI. The excel file will be stored in a shared server location. The XI engine should poll the shared server location at regular intervals. As and when it finds the excel file it should pick it and email as attachment. After sending the email the file should be deleted from the shared server location.

Can somebody advice me on how to configure such a scenario?

I have some idea but need some pointers to fix the gaps.

1. To poll the file, I will configure the sender file adapter.

2. To send email, I will configure the receiver email adapter.

3. I need to create a mapping between my file and mail message.

Can this mapping be avoided?

4. If I use XIALL in the email adapter channel, then it will send mail with 2 XML attachments. On the other hand if I use XIPAYLOAD, then it will send either attachment as TXT or in Mail BODY.

How can I send it as XLS file attachment itself?

Kindly advice!

Thanks

Gopal

[Former Member]

As an alternative, you can use the option "Additional File(s)" in the sender file adapter. Additional files will be handled as attachments right from the start, so you won't need to do any transformation.

Of course, you'd need another file as the original input file...

[bhavesh_kantilal]

Hi,

You will need a file adapter that picks this file and then an XSL Mapping will send this as an attachement.

This is a scenario which has 2 blogs accoaciated with it. Take a look at them and they solve your problem,

/people/community.user/blog/2006/09/07/email-reporting

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

Regards,

Bhavesh