Ubuntu – Extract data from pdf form (or other Base format) to import to Libre Base database


I created a form in Libre Base, exported that form as a pdf, and will give that form to others. How can I extract the data from the completed forms and import that data back into the original database in Libre Base? Each form should create a completely new record, it does not append data to a record.

  • How can I extract data from a completed pdf form (or other format) that I created in Libre Base and gave to others and very simply import the data from form #1 to record #1 of the original database in Libre Base?


Best Answer

There's no easy solution for this. Generally, pdftk is able to extract the form data out of a PDF form to a fdf file. But AFAIK there's no tool to import that data into LO Base. You will have to manually convert the fdf to csv, for example, so LO Base can access the data.