AI Productivity Helpers

From Grooper Wiki
Revision as of 16:23, 25 June 2025 by Dgreenwood (talk | contribs)

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.

It is obviously a simple, generic 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.

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)

The AI Query Helper uses an LLM to help users craft a search query from the Search Page. These queries use specialized syntaxes which can be challenging for novice users. The AI Query Helper allows any user to return a document set using a simple text prompt.

The AI Query Helper can be accessed by clicking the "AI Query Helper" button at the top of the Query Editor.

In the example below, we used the AI Query Helper to return a set of invoice documents that meet some criteria based on their extracted data. This is the prompt we used:

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


The LLM takes that prompt and Grooper's programed understanding of the query syntaxes, the search index and its elements and fills in the Query Editor's fields. From there, the user can edit the query if needed and hit the search button to execute the query.

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.