Spinetoolbox

Added

- [Bundled App] **Embedded Python** now includes spinedb-api and pandas in addition to ipykernel and jill.
- Support PySide 6.8.1
- Tools now support executing programs where the main program file is not in the work directory root, but
in a subfolder. You can use this feature by setting a 'root directory path' for a Tool in **Tool Properties**.

Removed

- The Filter button has been removed from Spine Database Editor's toolbar.
The functionality was broken anyhow and has been superseded by filtering from the Scenario tree.

Changed

- **Add/Update SpineOpt** wizard in **File->Settings->Tools** now installs SpineOpt v0.9.0
from Julia's General Registry. Previously SpineOpt was installed from a custom
SpineJuliaRegistry registry.

Removed

- Removed support for MSSQL dialect. It did not work anyway.

Dropped support for Python 3.8.
This version of Spine Toolbox requires Python version from 3.9 to 3.12.

Changed

- **Add/Update SpineOpt** wizard in **File->Settings->Tools** now requires SpineOpt v0.8.3 or higher.

Changed

- Execution button shortcuts have been changed because F5 is traditionally reserved for refreshing.
The shortcuts are now:

- **Shift+F9** to execute project
- **F9** to execute selection
- **F10** to stop execution

Fixed

- Fixed a bug where scenario filters could cause Tracebacks in tools that were using ``spinedb_api``.

Changed

- ``gamsapi`` replaced the ancient ``gdxcc`` package.
You may need to have a relatively recent GAMS installed to utilize .gdx import/export functionalities.

Added

- Entity group column in *Add entities* dialog. If filled, the created entity will be added to the specified group.
If the group doesn't yet exist, it will be created.
- Native kernel (i.e. python3 for Python) can now be used in the Detached Console or in Tool execution.
- It is now possible to specify valid value types for parameters in the Parameter definition table in Database editor.
- [Bundled App] **Embedded Python** now includes pip.
- Graph view in database editor now also supports filtering by alternative and scenario tree selections.
- Option to disable auto-build in entity graph.
- Mapping Name source type in importer.
- Importer has now an option to import entity alternatives.

Changed

- Database editor's hamburger menu has been converted into a menubar beneath the tab bar. The URL toolbar has also
been replaced with a toolbar that houses different buttons.
- One dimensional entities can now also be added through *Parameter value* and *Entity alternative* tables.
- Special data types like dates, times and booleans are now properly pasted from Excel.

Fixed
- [Bundled App] Fixed execution in Jupyter Console and opening Detached Consoles by adding jupyter-client and
qtconsole packages to the bundle.
- [Bundled App] Fixed creating new kernel specs in Settings->Tools by adding ipykernel package to the
**embedded Python**.
- [Bundled App] Fixed 'Install Julia' button in Settings->Tools by adding the jill package to the **embedded Python**.