Skip to Content
Menu
This question has been flagged
2 Replies
12054 Views

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 = tabula.read_pdf(file_to_import, output_format="json", pages="all")

Avatar
Discard
Author Best 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")

Avatar
Discard
Best Answer

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

Avatar
Discard
Related Posts Replies Views Activity
0
Apr 25
496
1
Apr 25
494
1
Feb 25
563
1
Jan 25
686
2
Jan 25
581