How to create an attachment from a report programmably (odoo v12)

attachment

2 Antwoorden

9953 Weergaven

Gleb

For example, there is a sale order report and it's id = "action_report_saleorder",
consequently REPORT_ID in example = sale.action_report_saleorder 
 (Example odoo v11)
def action_generate_attachment(self):        """ this method called from button action in view xml """        # generate pdf from report, use report's id as reference        REPORT_ID = 'some_report_id'        pdf = self.env.ref(REPORT_ID).render_qweb_pdf(self.ids)        # pdf result is a list        b64_pdf = base64.b64encode(pdf[0]) # save pdf as attachment        ATTACHMENT_NAME = "My Attachment Name"        return self.env['ir.attachment'].create({            'name': ATTACHMENT_NAME,            'type': 'binary',            'datas': b64_pdf,            'datas_fname': ATTACHMENT_NAME + '.pdf',            'store_fname': ATTACHMENT_NAME,            'res_model': self._name,            'res_id': self.id,            'mimetype': 'application/x-pdf'        })Why when I perform a similar action, nothing works for me? 
Can you explain what this method render_qweb_pdf( ) means and what is the difference between id and res_id? 
class AttachSaleOrderFile(models.Model):
   _inherit='sale.order'
   @api.multi
   def action_generate_attachment(self):
   .....

   .....

Thanks!

Sehrish

Look into odoo tips, may be its helpful: https://learnopenerp.tumblr.com/

Hilar Andikkadavath

Hi,

While you doing this operation, a pdf report will be stored under ir_attachment table. Here the res_model and res_id will be the reference for attachment for relating with a record. Here let's take sale.order of id 20, here you need to attach the pdf report with the current sale order then we will give res_model as sale.order and res_id as 20.

here the self._name will the current model name.

Update:-

render_qweb_pdf render the HTML content defined in the report template and returns a pdf file. If you call the function with the param res_ids then it will automatically save the attachment with pdf content.

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
this is my travel agency and we are a travel manager attachment	0 nov. 25	3
View attachment within the browser attachment	5 mei 23	17996
How to remove attachment? attachment	2 dec. 23	8384
ValueError: Expected singleton: ir.attachment(195806, 195805) Opgelost attachment	1 mei 22	4526
How manage attachement file in back'end code ODOO chatter attachment	0 apr. 22	3896

Deze vraag is gerapporteerd

For example, there is a sale order report and it's id = "action_report_saleorder",

consequently REPORT_ID in example = sale.action_report_saleorder

(Example odoo v11)

def action_generate_attachment(self):

""" this method called from button action in view xml """

# generate pdf from report, use report's id as reference

REPORT_ID = 'some_report_id'

pdf = self.env.ref(REPORT_ID).render_qweb_pdf(self.ids)

# pdf result is a list

b64_pdf = base64.b64encode(pdf[0])

# save pdf as attachment

ATTACHMENT_NAME = "My Attachment Name"

return self.env['ir.attachment'].create({

'name': ATTACHMENT_NAME,

'type': 'binary',

'datas': b64_pdf,

'datas_fname': ATTACHMENT_NAME + '.pdf',

'store_fname': ATTACHMENT_NAME,

'res_model': self._name,

'res_id': self.id,

'mimetype': 'application/x-pdf'

})

Why when I perform a similar action, nothing works for me? Can you explain what this method render_qweb_pdf( ) means and what is the difference between id and res_id?

class AttachSaleOrderFile(models.Model): _inherit='sale.order' @api.multi def action_generate_attachment(self):

..... .....

Thanks!

render_qweb_pdf render the HTML content defined in the report template and returns a pdf file. If you call the function with the param res_ids then it will automatically save the attachment with pdf content.

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Why when I perform a similar action, nothing works for me?
Can you explain what this method render_qweb_pdf( ) means and what is the difference between id and res_id?

class AttachSaleOrderFile(models.Model):
_inherit='sale.order'
@api.multi
def action_generate_attachment(self):

.....

.....