AI Productivity Helpers: Difference between revisions

From Grooper Wiki
Line 49: Line 49:
=== AI Query Helper (for Search page queries) ===
=== AI Query Helper (for Search page queries) ===


[[File:AIQueryHelper-prompt-01.png|left|Example prompt. The AI Query Helper also lists all fields in the search index.|class=simpleborder simpleshadow|400px]]
[[File:AIQueryHelper-prompt-01.png|left|frame|Example prompt. The AI Query Helper also lists all fields in the search index.]]
 
[[File:AIQueryHelper-searchfilled.png|right|class=simpleborder simpleshadow|920px]]
 


The Grooper [[Search Page]] is a powerful document search and retrieval tool. Part of its power lies in the specialized syntaxes used in the search parameters. This can be challenging for novice users.
The Grooper [[Search Page]] is a powerful document search and retrieval tool. Part of its power lies in the specialized syntaxes used in the search parameters. This can be challenging for novice users.
Line 61: Line 58:
: Example Prompt: ''Find invoices greater than $10,000 from before 2020. Only show me the invoice number, invoice date, and invoice amount. Sort by the largest invoice amount.''
: Example Prompt: ''Find invoices greater than $10,000 from before 2020. Only show me the invoice number, invoice date, and invoice amount. Sort by the largest invoice amount.''


 
[[File:AIQueryHelper-searchfilled.png|right|class=simpleborder simpleshadow|920px]]
The AI Query Helper hands the prompt and a description of the fields in the search index to a large language model (LLM) AI. With that in hand, it crafts the search query for you and fills in the Query Editor. All you have to do from there is hit the Search button!
The AI Query Helper hands the prompt and a description of the fields in the search index to a large language model (LLM) AI. With that in hand, it crafts the search query for you and fills in the Query Editor. All you have to do from there is hit the Search button!
<br clear=all>
<br clear=all>

Revision as of 11:27, 27 June 2025

This article is about the current version of Grooper.

Note that some content may still need to be updated.

2025


There are several productivity features in Grooper that use large language models (LLMs) to simplify a users work in Grooper. LLMs (such as OpenAI's GPT models) allow users to tell Grooper what to do using a natural language text prompt. There are currently six (6) of these features in Grooper version 2025.

  • BE AWARE! For each of these features to work, users must first have an LLM Connector configured at the Grooper Root node and a "Tools Chat Model" configured.

List of AI productivity tools:

  • AI Generated Schema Importer
  • AI Query Helper
  • AI Expression Helper
  • Db Lookup Helper
  • XSLT Helper
  • AI Helper


Data Model Schema Importer: AI Generated

Grooper's "Schema Importers" generate data_table Data Models from various sources, such as database schemas or XML schemas. The "AI Generated" importer generates a Data Model from a natural language prompt using an LLM.

This Data Model was generated using the following simple prompt:

Create a Data Model for invoice processing.

AI Generated created a simple Data Model for processing invoices. However, more specific prompts will yield more specific results. If you tell the LLM more specifically what fields you want to add, it will do so. You can even paste a document's full OCR text into the prompt and tell it "Make a Data Model for this document".

Furthermore, when it determines a Data Field or Data Column should be a datetime or numeric type (double, decimal, int16, etc.), it will adjust its Value Type configuration accordingly.

The AI Generated importer will even add brief descriptions to the Data Elements it creates in some cases.



To use the AI Generated importer:

  1. Right-click a Data Model in the node tree.
  2. Select the "Import Schema..." command.
  3. Expand the "Source" dropdown (Press the "☰" button).
  4. Select "AI Generated".
  5. Open the "Instructions" editor (Press the"..." button).
  6. In the Instructions editor, enter a prompt for what you want to create.
    • Example: Create a Data Model for invoice processing.
    • Example: Create a Data Model for processing student transcripts.
    • Example: Create a Data Model for this document: (Then paste a document's text into the Instructions editor)
  7. When finished, press "OK" to exit the Instructions editor.
  8. Press the "Execute" button in the "Import Schema" window to generate the Data Model.

AI Query Helper (for Search page queries)

Example prompt. The AI Query Helper also lists all fields in the search index.

The Grooper Search Page is a powerful document search and retrieval tool. Part of its power lies in the specialized syntaxes used in the search parameters. This can be challenging for novice users.

What if you need help making a search query? The "AI Query Helper" can help!

The AI Query Helper allows any user to return a document set using a simple text prompt. This helper is accessed in the Search Page using the "AI Query Helper" button (cognition).

Example Prompt: Find invoices greater than $10,000 from before 2020. Only show me the invoice number, invoice date, and invoice amount. Sort by the largest invoice amount.

The AI Query Helper hands the prompt and a description of the fields in the search index to a large language model (LLM) AI. With that in hand, it crafts the search query for you and fills in the Query Editor. All you have to do from there is hit the Search button!

AI Expression Helper (for Pattern Match regular expressions)

Regular expression (regex) patterns are powerful tools used to find patterns in text. Grooper's Pattern Match extractor uses regular expressions to match text and return them as results in a result set. Pattern Match extractors are often key in one component of a users document processing solution (be it in document separation, classification, data extraction or some other area).

What if you don't know how to write a regex pattern? The "AI Expression Helper" is here to help!

The AI Expression Helper can be accessed in the Pattern Match editor. Tell it what kind of pattern you want using simple natural language.

Example: Generate a pattern that matches common date formats.
Example Result: (\b(?<Month>0?[1-9]|1[0-2])[\/\-](?<Day>0?[1-9]|[12][0-9]|3[01])[\/\-](?<Year>\d{4})\b
  • AI responses are varied! Because this helper uses generative AI, the expression will likely be someone different even if you ask the same question. Ask multiple times to try out variations on the same pattern!

The helper automatically configures the Pattern Match editor for you. Even if the pattern isn't exactly what you want, it a great starting point to get extracting results quickly.


To use the AI Expression Helper:

  1. Open a "Pattern Match" extractor editor (Press the "..." button).
  2. Press the "AI Expression Helper" button (cognition).
  3. In the editor, enter a prompt for the regular expression pattern you want.
    • Example: Generate a pattern that matches common date formats.
    • Example: Show me the money. (It will match currency values)
  4. Press the "OK" button when finished.
  5. The helper will fill in the expression.
  6. When satisfied with the expression, press "OK" to exit the Pattern Match extractor editor.

Db Lookup Helper (for Database Lookup SQL queries)

XSLT Helper (for creating XSLT transforms for XML Transform)

AI Helper (general purpose helper available to many editors in Grooper)

  • Get help creating list entries for List Match.
  • Get help with Grooper code expressions (Default Value, Calculated Value etc).
  • Get help making instructions for AI Extract.
  • Get help making a Description for a Grooper node.