Skip to Content
This question has been flagged
pdfattachment
11 Replies
30272 Views
Avatar
Dmitriy Krasota

I have a custom reports, which needs to be added as an attachment, no matter if Save as Attachment is set or not.
Here is code, I generate PDF with:

pdf = self.env['report'].sudo().get_pdf([invoice.id], 'account.report_invoice')

Here is how I try to create an attachment:.

self.env['ir.attachment'].create({
                        'name': 'Cats',
                        'type': 'binary',
                        'datas': pdf,
                        'mimetype': 'application/x-pdf'
                        })

It creates new attachment, but instead of expected PDF, there is just some binary file which could not be recognized into actual PDF. So is there a way to generate real PDF as attachment?

Avatar
Discard
Avatar
Axel Mendoza
Best Answer

Here is how:

import base64
pdf = self.env['report'].sudo().get_pdf([invoice.id], 'account.report_invoice')
self.env['ir.attachment'].create({
    'name': 'Cats',
    'type': 'binary',
    'datas': base64.encodestring(pdf),
    'res_model': 'account.invoice',
    'res_id': invoice.id,
    'mimetype': 'application/x-pdf'
})

The res_model and res_id in the create vals dict are needed to associate the attachment to the record


Avatar
Discard
Axel Mendoza

could you please also upvote it the answer?

MUHAMMED ASLAM

Hi Axel Mendoza,

is it doing using override the action_invoice_send function ??

Axel Mendoza

No, that code is intended to be used anywhere you need to do that, it's not something that need to be used inside an override.

Pravitha

Hello Axel, can I use this .get_pdf to print the report? If yes,how can I do that?

Axel Mendoza

Indeed... the get_pdf method of the report model will returns the pdf printed report file, that code just show how to use it by code, if you like to get the pdf report printed to be downloaded it's better to return the report action dict in order to get the odoo report download flow used. Always depending on where you put the code, normally in a button

shubhajit kushari

hi Axel..how to implement your solution in odoo v11?

Axel Mendoza

The same code will work

Axel Mendoza

Sure, Glad to read that

Yenthe Van Ginneken (Mainframe Monkey)

Just a heads-up that in Python 3 you should now use base64.encodebytes instead of base64.encodestring(pdf)

Avatar
Maxim Burinov
Best Answer

Thank you for great answer!

Avatar
Discard
Related Posts Replies Views Activity
Download pdf file on ir_attachment from other application Solved
pdf attachment controller
Avatar
Avatar
1
अग॰ 20
9825
Adding an attachment from python Solved
pdf attachment odoo11
Avatar
1
अप्रैल 20
7882
Quote Builder With Custom Rental Report (Studio)
pdf
Avatar
0
अक्तू॰ 25
539
Quote Builder With Custom Rental Report (Studio)
pdf
Avatar
0
अक्तू॰ 25
4
How to edit the header of the quote template Solved
pdf
Avatar
Avatar
Avatar
2
अग॰ 25
1333