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!
Question
Question
Automate Search from Excel
Replies
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
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/91350/Workflow-and-iFilter-results
https://answers.laserfiche.com/questions/123524/MS-Office-ifilter-installation
https://learn.microsoft.com/en-us/archive/blogs/ifilter/
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.