Spinetoolbox

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**.

Added

- A button next to each entity class in **Entity Tree** that opens the *Add entities* dialog.
- Alternative -column in *Add entities* dialog. If filled, the created entity will be set active in that alternative.

Changed

- Python 3.12 and later is now supported.
- When exporting GAMS `.gdx` files with Exporter, special values 10^-10 and `EPS`
now get converted to GAMS Eps (epsilon).