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

Question

Question

Automate Search from Excel

asked on October 30, 2024

I have, for example, an excel worksheet that is only one column and has roughly 250 unique values.  Currently I'm manually searching each value individually in our LF 11 Windows Client repository.  Is there a way to automate it and upload the list, to have LF search all of them for me and return all results (together or separately)?

Thank you!

0 0

Replies

replied on October 30, 2024 Show version history

Hi Drew,

iFilters is what you are looking for.

An IFilter is a Windows tool that Laserfiche can use to retrieve text and properties associated with an electronic file. By default, Windows provides several IFilters that allow you to retrieve text from HTML documents, XML documents, Multipurpose Internet Mail Extension (MIME) files, and Microsoft Office files. In addition to the filters provided by Windows, IFilters for other types of files exist. (IFilters are typically created by the software manufacturer of the application that created the desired file type.) To take advantage of one of these IFilters, download and install it. After an IFilter has been installed on your computer, it will be immediately available for use by Laserfiche. Text pages can be created for that type of file

https://doc.laserfiche.com/laserfiche.documentation/11/userguide/en-us/Subsystems/client_wa/Content/Extraction_and_Indexing/IFilter.htm

It requires the Windows Search service to be added to your Laserfiche Search server VIA add window features.

You can download the iFilters and updates from Microsoft's download site.

Other helpful posts around iFilters:

https://answers.laserfiche.com/questions/206310/Search-Engine-Text-Extraction--List-of-supported-file-types

https://answers.laserfiche.com/questions/91350/Workflow-and-iFilter-results

https://answers.laserfiche.com/questions/123524/MS-Office-ifilter-installation

https://learn.microsoft.com/en-us/archive/blogs/ifilter/

 

0 0
replied on November 2, 2024

Hello Drew,

When you import your file into Laserfiche, you can ask it to generate text. As a result, your list will be generated as text (see image below).

 

 

From there, use Workflow to search in the repository and fill in a token to list the missing items.

 

Then check your new list under the workflow.

 

 

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

Sign in to reply to this post.