You are viewing limited content. For full access, please sign in.

Question

Question

ocr pdf and save to excel

asked on July 22, 2019 Show version history

I am looking at getting a software product called Scanwriter to batch OCR bank statements and invoices in PDF format and convert them to Excel. The Excel files will be used to analyzed for fraud.

Can Laserfiche OCR a pdf document, then store and save the contents to a  Excel file?

Ultimately the original pdf's and converted Excel spreadsheets will be stored in Laserfiche.

0 0

Replies

replied on July 22, 2019

Hi Barry,

If I make a number of assumptions about the PDF being scanned (that it contains comma separated values) and file format you're after and the quality of the PDF, then yes.

A Workflow activity can be used to generate the text, if doesn't exists, using Distributed Processing OCR. It can then extract the text and send it an SDK Script to save as a CSV file in Laserfiche. All the processing could be done in a single SDK Script, too.

-Ben

0 0
replied on July 22, 2019

Thank you for your feedback.

 

Basically what I was thinking. Hoping for something more out of the box.

Thanks again!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.