Skip to Content
This question has been flagged
reportxlsx10.0
2 Replies
7467 Zobrazenia
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
Zrušiť
Avatar
rainier
Autor 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
Zrušiť
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
Zrušiť
Related Posts Replies Zobrazenia Aktivita
How to add data from different models in a report?
report xlsx odoo
Avatar
Avatar
1
nov 22
4373
Freeze header column in pivot report
report pivot 10.0
Avatar
Avatar
1
aug 21
6833
How to download POS daily sales report in xlsx, csv instead of pdf.
pdf report xlsx Point Of Sale
Avatar
Avatar
1
feb 25
1622
Insert image in excel using xlsxwriter class. Odoo16 Solved
report xlsx odoo xlsxwriter
Avatar
Avatar
1
máj 23
5010
Print Excel Report, the use of partner_xlsx('report.res.partner.xlsx', 'res.partner')
report excel xlsx odoo
Avatar
0
dec 22
5297