Skip to Content
This question has been flagged
reportxlsx10.0
2 Replies
5329 Views
Avatar
rainier

Hello,

I am trying to generate a xlsx report using scheduled actions.

The report saves all sale orders confirmed in a week in a xlsx file.

The report could be generated using print button but not from scheduled action.

Can someone help? 

I have written a method as follows - 

class 

def generate_report(self):

            ret =  self.env['report'].get_action(self, 'so_xlsx')

I have defined the action in xml file.

Thanks in advance!


I could run other simple functions from scheduled action like printing in a logfile.

 

Avatar
Discard
Avatar
rainier
Author Best Answer

Hello Jainesh,

Thank you for your answer. Could you tell me -

1. What is the type of xlsx_report ? ie. What should be returned by  extract_spreadsheet() ?

2.   What exactly happens in following statment ? What is 6 ?
email_template.attachment_ids = [(6, 0, attachment_id.ids)]

Thanks once again!


Avatar
Discard
Jainesh Shah(Aktiv Software)

Hello Rainier,

This xlsx_report type is .xlsx and the extract_spreadsheet is the function where you can write your report logic(i.e sales order which is confirmed).

Regarding this statement - email_template.attachment_ids = [(6, 0, attachment_id.ids)], You are able to send email with attachment(your xlsx report) and [(6, 0, ids)] is used for appending attachments in email.

Avatar
Jainesh Shah(Aktiv Software)
Best Answer

Hello Rainier,


For sending an xlsx report using scheduled actions you need to follow listed things,


extract_spreadsheet - this is your function where you are creating xlsx report with your logic.


def _cron_send_xlsx(self):

xlsx_report = self.env['object.object'].extract_spreadsheet()

attachment = xlsx_report.get('attachment_id')

attachment_id = self.env['ir.attachment'].browse(attachment)

    email_template = self.env.ref('module_name.email_template')

    email_template.attachment_ids = [(6, 0, attachment_id.ids)]

    email_template.write({'email_from': your_email_from, 

                          'email_to': your_email_to,

    email_template.with_context(ctx).send_mail(

        self.id, raise_exception=False, force_send=True)



Using this way you can send an email with Xlsx report.

Regards,




Email:      odoo@aktivsoftware.com  

Skype: kalpeshmaheshwari

   

Avatar
Discard
Related Posts Replies Views Activity
How to add data from different models in a report?
report xlsx odoo
Avatar
Avatar
1
Nov 22
2435
Freeze header column in pivot report
report pivot 10.0
Avatar
Avatar
1
Aug 21
5300
Insert image in excel using xlsxwriter class. Odoo16 Solved
report xlsx odoo xlsxwriter
Avatar
Avatar
1
May 23
2526
Print Excel Report, the use of partner_xlsx('report.res.partner.xlsx', 'res.partner')
report excel xlsx odoo
Avatar
0
Dec 22
3494
How to attach system generated xlsx report to purchase order
report attachments xlsx odoo11
Avatar
Avatar
2
Jul 20
2582