Question

Scanning Hard Copy Sheets, OCR Content and Save it into SQL Database or CSV File

Laserfiche Workflow Scanning

Updated February 3, 2021

asked on February 3, 2021 • Show version history

Hi,

I have hard copy surveys that have been completed by hundreds of clients. I was wondering whether it is possible to scan the hard copies and then using OCR functionality, extract the data and save it in an SQL Database or a CSV File. I am wondering whether it is possible to create the following workflow in Laserfiche. Any suggestion would help. Thank you.

Workflow:

Scan hard copy survey using a scanner
Perform OCR on the scanned image
Assign the values of OCRed elements into variables (Maybe as part of a Template)
Save the outcome into an SQL database or a CSV File
Save the original scanned document into Laserfiche Repository

Sincerely,

Wissam

0 0

Replies

replied on February 3, 2021

For a form with structure, I'd want to use Quick Fields all day.

I'd rather use Zone OCR to collect my tokens and feed them to a workflow to handle the database or csv processing.

Otherwise, trying to do pattern matching (Regular Expressions) from an entire form thats OCR'ed is probably going to result in a constant maintenance issue because of OCR impurities and the regular expression headaches from acting on an entire form, as opposed to a targeted (zone ocr'ed) portion of the form.

3 0

replied on February 3, 2021

Hi,

I would select all the scanned copies and perform manual OCR on them, but not with a workflow. Once they are OCR'd all workflow processes you're looking into could be performed after. For any future scans I'd set the OCR in configuration pane, image processing. 3-5 can all be done through workflow.

0 0

replied on February 3, 2021

You can use Distributed Computing Cluster to set up OCR in Workflow.

0 0

You are not allowed to follow up in this post.

Question

Question

Scanning Hard Copy Sheets, OCR Content and Save it into SQL Database or CSV File

Replies

Sign in to reply to this post.