Skip to main content
nikkim67018642
Participant
October 19, 2018
Question

Wanting to automate pdf form extraction data into database?

  • October 19, 2018
  • 3 replies
  • 1220 views

We use lots of various forms to collect data and have several hundred to a couple thousand responses to forms. Looking for a better, more efficient, automated way to extract the pdf form data into a database. What are some ideas to help with this? Thank you.

This topic has been closed for replies.

3 replies

Thom Parker
Community Expert
Community Expert
November 8, 2018

Acrobat is actually quite good at collecting and organizing data. But talking to a specific data source is not it's thing. For that you need another tool. The intended method for handling form data is to submit it to a server script. Then the server script stores the data in a DB.  Unfortunately there are few good out of the box products/services out there for handling this type of activity.  The best one is FormRouter www.formrouter.com.   But you could also write your own custom server script, and there are a myriad of other ways to handle data. But all of them require an external tool.

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often
try67
Community Expert
Community Expert
October 19, 2018

Acrobat is not a very suitable tool for this task, if you want to automate it. A better approach is to use a stand-alone application to extract the data from the PDFs, and even insert it directly into your database.

I've developed similar tools in the past so if you're interested in hiring someone to do it for you, feel free to contact me privately (try6767 at gmail.com).

Inspiring
October 19, 2018

ADBC, Acrobat Data Base Connectivity, was removed from Acrobat starting with Version X. You can write a plug-in to add to Acrobat/Reader. It is also possible to submit a PDF to a scripted web server page that then processes the passed data to a database.