Script Engine

The script engine gives you the ability to edit data in Eliona using Python and SQL scripts.

The special thing about scripts is that scripts are applied repeatedly and at regular intervals to the data.

For simple data manipulations, e.g. adding values, the ↗ Calculator can be used.

Application scenarios

Here are some typical and advanced use cases in which scripts can be used effectively:

• Evaluate and reset counters

  Counters, such as people counters, must be reset regularly to ensure accurate values. Scripts can be programmed to automatically reset these counters at specified times.

• Determine maximum values

  Scripts can be used to determine the highest value from a series of values and highlight it or process it further.

• Machine learning models and predictions

  An advanced use case involves the integration of machine learning models. Scripts can be used to make predictions based on historical data, perform optimizations, or identify correlations between different datasets.

• Processing attachments

  Scripts can be programmed to automatically scan attachments when they are uploaded and write the extracted data directly into the corresponding asset.

• Plausibility checks

  Another application is the plausibility check of data. A script can verify whether the data lies within certain limits. If the data is plausible, the value 0 is set; otherwise 1.

Accepted languages

Scripts can be written in Python or SQL written.

Open script overview

1. Click on Engineering [A]

2. Click on Script Engine [B] ▷The script overview opens

Eliona comes with built-in scripts, known as system scripts.

These scripts are exclusively visible to system owner .

For all other users, these system scripts do not appear in the script overview. System scripts can be recognized by the fact that the edit option [Q] is greyed out and not available.

Details

In the script engine, you have the following options:

Element	Title	Details
[C]	Scripts section	Shows an overview of all scripts already created
[D]	Search	Opens the “Search” sidebar. There you can search specifically for individual scripts
[E]	Create new script	Click to create a new script
[F]	Pause/activate script	Click to pause a running script or reactivate a paused script
[G]	Script status	Shows whether a script is activated (“Active”) or paused (“Inactive”)
[H]	Name	Shows the name of the script. The name of the script is assigned by the user when the script is created. The name can be changed later.
[I]	Shows the description of the script.	The designation of the script is assigned by the user when they create the script. The name can be changed later.
[J]	Type	Shows whether the script was created in SQL or Python.
[K]	errors	Indicates whether there are errors in the script
[L]	Repeat	Shows the ↗ grid that was selected for this script.
[M]	Last run	Shows when the script ran last.
[N]	Next run	Shows when the script will run next.
[O]	Duration	Shows how long the last run took.
[P]	Delete	Delete the selected script.
[Q]	Edit	Click to edit the script. Opens the menu ↗ Configure script page.
[R]	errors	Indicates that there is an error with the script.

Create new script

1. Open the script overview as in ↗ Open script overview described

2. Click on [E] ▷ The window [S] opens

3. Give the script a name in field [T] . ◈ This name will later appear in field [H] displayed

4. Select in field [U]whether the script is written in Python or SQL

5. Click on [V], to create the script ▷The “Configure script” menu opens

6. Continue as in chapter ↗ Configure scripts described