Importing A Document into a Form

From Paper to Database

[inveni0]

Here's my huge project:

I'm to turn 1000 documents per month into digital records stored online.

I have OmniPage set up to scan and OCR the documents so that I get only the information I need.

I just need to know how to save these documents so that I can easily import the contents into the appropriate fields of my record insertion form. The more automated, the better.

Any ideas?

[inveni0]

Here's an option:

Let's say I had a form with only a text box. The text box would contain:

John Doe

346 W. Elm St.

Denver

Colorado

12345

Upon clicking submit, is there a way to load each line into its respective field on a new form?

[rocknbil]

You're going to need some server-side scripting with perl or PHP.

The way **I** would do it is OCR everything in and store the data in plain text files, then on the server (or even locally, with perl) devise a script that reads each file in the directory, builds a mysql select statement, and does the insert, completely bypassing the form. This script should also log each successful insert and each failure so you can go over the list and manually enter anything it died on.

The above skips the whole paste-into-form step, but in a form it would do the same thing, assume each line is in it's place, skip blanks, and insert each populated line in the appropriate field. just more manual labor.

Barring that ability, hopefully you charge by the hour and not a single fee for the project. :-)