🗒️Script Engine

The Script Engine offers you the possibility to edit data in Eliona using Python and SQL scripts.

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

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 person counters, must be reset regularly to ensure accurate values. Scripts can be programmed to automatically reset these counters at set times.

Determine Maximum Values

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

Machine Learning Models and Predictions

An advanced application scenario involves the integration of machine learning models. Scripts can be used to make predictions based on historical data, perform optimizations, or recognize correlations between different data sets.

Processing of Attachments

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

Plausibility Checks

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

Accepted Languages

Scripts can be written in Python or SQL.

Open Script Overview

1. Click on Engineering [A]

2. Click on Script Engine [B]

   ▷The Script Overview opens

Eliona comes with integrated scripts, so-called system scripts.

These scripts are only visible to System Owners.

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 grayed out and unavailable.

Details

In the Script Engine, you have the following options:

Element	Title	Details
[C]	"Scripts" section	Displays an overview of all already created scripts
[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 to 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 afterward.
[I]	Shows the description of the script.	The description of the script is assigned by the user when they create the script. The name can be changed afterward.
[J]	Type	Shows whether the script was created in SQL or Python.
[K]	Errors	Shows whether the script has errors
[L]	Repeat	Shows the ↗ raster that was selected for this script.
[M]	Last run	Shows when the script last ran.
[N]	Next run	Shows when the script will run next.
[O]	Duration	Shows how long the last run took.
[P]	Delete	Deletes the selected script.
[Q]	Edit	Click to edit the script. Calls up the menu ↗ Configure script.
[R]	Errors	Shows that there is an error with the script.

Create a New Script

1. Open the Script Overview as described in ↗ Open Script Overview

2. Click on [E]

   ▷ The window [S] opens

3. In field [T], give the script a name.

   ◈ This name will later be displayed in field [H]

4. In field [U], choose 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 described in chapter ↗ Configure scripts