Skip to Content
Menu
This question has been flagged
2 Replies
11077 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
2
Dec 24
114
2
Oct 24
254
0
Feb 18
2669
0
Nov 16
4963
1
Sep 16
3108