extract pdf file contents in a binary filed

Question

The scenario is this,
I have a class with binary field,
*file_to_import = fields.Binary('File')*
*file_to_import_fname = fields.Char('Filename')*
The file to be submitted to this field is in predefine format and if of type PDF.*
*
I have a button next to the binary field in view*, Import. *The related action uses tabula, parse through file and retrieve table contents in it and create records.*
*
*How do I pass the base64 encoded string to Tabula. The line to read PDF contents in tabula is,
*
*df

Sri Ramadoss M · Accepted Answer

I can read the contents of the file with this technique.
pdf_file = open('/tmp/pdffile.pdf','w')
pdf_file.write((base64.b64decode(obj.file_to_import)))
pdf_file.close()
df = tabula.read_pdf("/tmp/pdffile.pdf", output_format="json", pages="all")

Chris Gayle · Answer

That's a very good trick. I will try that on. Thanks.

Related Posts	Odgovori	Prikazi
pdf format problem pdf	0 apr. 25	496
website watermark pdf	1 apr. 25	495
How to Edit Out the Blank Space in the Quote/Order Confirmation PDFs? pdf	1 feb. 25	563
delivery notice - change of PDF attachment Solved pdf	1 jan. 25	688
Odoo 18 report, calculated sum of raw_line.product_uom_qty Solved pdf	2 jan. 25	581

This question has been flagged

Enjoying the discussion? Don't just read, join in!