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

Question

Question

Is the text extracted from documents stored in a database?

asked on July 11

We would like to try to find some specific data (an account number) from the Text that is extracted from a document.  Here is a portion of the data from the Text Pane

 

TEXT Data.png
TEXT Data.png (8.58 KB)
0 0

Answer

APPROVED ANSWER SELECTED ANSWER
replied on July 11

Hi Lisa,

No, document text isn't stored in the database. It's stored in "text pages" which are txt files within a repository volume that get indexed by the Laserfiche Full-Text Search service. See:

 

Laserfiche Workflow has a Retrieve Document Text activity you can use to get the text for a document and then parse it for the data value you're looking for.

2 0

Replies

replied on July 18

Since the extracted Text data is not stored in a database, is there a way to perform a search for a value, like an account number, to find the document from which the data was extracted?  I can manually search the text in Laserfiche and get a result but am looking for a way to automate the search to use a list of values vs. manually searching one at a time.

TEXT Search.png
0 0
replied on July 18

Yes. You can use a Workflow Search activity and provide advanced search syntax for a full-text search. 

This is the most comprehensive reference on advanced search syntax: Advanced Search Syntax 10.3 (everything within is still valid for Laserfiche 11 and 12 as far as I'm aware). 

This is the simplified online reference in the Laserfiche 12 docs: Search Syntax

0 0
replied on July 21

Samuel - Thank you so much for the information as well as the document.  smiley

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

Sign in to reply to this post.