These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

scanning data into database via interactive form

ameabaspy
Registered: May 22 2007
Posts: 4

I've created an interactive form out of a hardcopied history document with Designer 7.0. My question is: What is the best/most efficient way to scan all previous hardcopied data of the document, process the data via the interactive form, and insert them into a database (SQL)?

My Product Information:
Acrobat Pro 7.0.4, Windows
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
This is not a trivial task, but the first part is easy. Scan and OCR the paper documents. The better the scan the easier the second part will be. You need to write a script that searches all the text on the OCR'd documents and captures those bits that you need inserted in a database. To do this you need some way of identifying the text, location on the page, proximity to other text, etc. This is the difficult part. But once you have the script written, capturing the data is easy. For the scripting you'll need the "doc.getPageNthWord()" and "doc.getPageNthWordQuad()" functions for capturing text and the ADBC object for Database access.

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script

ameabaspy
Registered: May 22 2007
Posts: 4
Thanks Thom,

My next questions are:
1.) Where should I place and/or what program should I write the scripts? VB.NET, ASP/ASP.NET?
2.) Do you have any samples or reference links to samples of the scripts?