Skip to content

Latest commit

 

History

History
806 lines (669 loc) · 41.6 KB

CHANGELOG.md

File metadata and controls

806 lines (669 loc) · 41.6 KB
Raw

Changelog

All notable changes to this project are documented here.

The format is based on Keep a Changelog

[Unreleased]

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.

Changed

Deprecated

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.

Fixed

Security

[0.9.1]

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.

[0.9.0]

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.

[0.8.5]

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.

[0.8.4]

Changed

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

[0.8.3]

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.

[0.8.2]

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

[0.8.1]

Added

  • Importer: it is now possible to reorder source tables by dragging and dropping.
  • Importer: it is now possible to reorder mappings by dragging and dropping.
  • Importer: it is now possible to copy mappings between source tables by dragging selected mappings from Mappings list onto destination source table item.

Removed

  • Scenario active flag mappings have been removed from Importer and Exporter. The flag is not used anywhere and has not been accessible in Database editor for a long time.

[0.8.0]

Added

  • New context menu action (Select superclass) for entity class items in the entity tree.
  • Added Tool Specification type (Python, Gams, etc.) icons on Design View.
  • There is now a new filter type, Alternative filter available in Link properties. Unlike scenario filters, the execution is not parallelized. Instead, a successor item sees parameter values of all selected alternatives. Because of this behavior, alternative filters cannot be used at the same time with scenario filters. Link properties tab has a combo box that lets one choose which filter type to use.

Changed

Spine data structure

Many parts of the Spine data structure have been redesigned.

  • Entities have replaced objects and relationships. Zero-dimensional entities correspond to objects while multidimensional entities replace the former relationships. Unlike relationships, the elements of multidimensional entities can now be other multidimensional entities.
  • Simple inheritance is now supported by superclasses.
  • Tools, features and methods have been removed. The functionality that was previously implemented using the is_active parameter has been replaced by entity alternatives. Entity classes have a default setting for the entity alternative called active by default. Database migration should automatically replace tools, features and methods by entity alternatives and set active by default to whatever default value is_active or similar parameter had. The is_active parameter is not removed from entity classes but its values are.
  • Note that new zero-dimensional entity classes have active by default set to false initially. This means that the entities of those classes are hidden when using scenario filters unless specifically shown using entity alternatives.

Miscellaneous changes

  • "Rubber band" selection of items in Design and Graph views is now done with left mouse button (no need to press Ctrl anymore). The views can be dragged around by holding the right mouse button.
  • Spine Database Editor now remembers the configuration of the docs in each view for a specific URL. The docks can be reset from the hamburger menu View->Docks...->Reset docks.
  • You can now select a different Julia executable & project or Julia kernel for each Tool spec. This overrides the global setting from Toolbox Settings.
  • Headless mode now supports remote execution (see 'python -m spinetoolbox --help')
  • Commit Viewer's UI has undergone some redesigning and can now handle large databases.

Removed

  • Project dock widget
  • Dependency on Dagster

[0.7.4]

Changed

  • Microsoft build tools are not needed anymore when installing Toolbox requirements on Python 3.10 and up.

[0.7.3]

Added

  • On Toolbox startup, a link appears in Event log that opens Upgrade notification window offering information about the upcoming 0.8 update.

[0.7.2] - 2023-12-04

Added

  • Data Connection items now support schemas in database references
  • Importer Specification Editor now supports database schemas

[0.7.1] - 2023-10-06

Added

  • Allow choosing of highlight color for items found in entity graph

Fixed

  • Fixed issues when remote databases were used as references in Data Connections
  • Fixed a bug where the order of scenario alternatives would be messed up when copy-pasting the alternatives in the Scenario Tree
  • Fixed a bug with time series plots
  • Fixed issues with Pivot table

[0.7.0] - 2023-08-25

Added

  • Support for version 11 Spine Toolbox projects.
  • Executable Tool Specifications can be used to run any (shell) command. This enhancement duplicates the functionality of Gimlet project items and makes them obsolete.
  • There is now an option to select if new scenarios or tools are automatically used for filtering in Link properties.
  • The new "Filer validation" button in Link properties allows forcing at least one scenario or tool filter to be checked.
  • Python 3.11 support.
  • PySide6 support. The app has been ported from PySide2 to PySide6.
  • In addition to dragging and dropping, it is now possible to copy alternatives from Alternative tree and paste them to the scenario tree in Database editor.
  • Scenarios can now be copied and pasted between databases in Database editor.
  • Scenarios can now be duplicated in Database editor.
  • Tool project item's Python and Julia consoles can now be killed from the right-click context menu. A killed console can be restored by restarting it.
  • A new option "Kill consoles at the end of execution" has been added to Tool properties, that kills Python and Julia console processes after execution saving some memory and computing resources.
  • A new option "Log process output to a file" has been added to Tool properties, that logs all the 'console' output of the Tool to a file in the logs subfolder.
  • You can now open a 'Detached' Jupyter Console on any kernel you have installed in your system from the Consoles main window menu.
  • "Make Julia Kernel" and "Make Python Kernel" buttons in Settings->Tools page. Clicking them creates a new Julia or Python kernel based on selected Julia/Python executable on the same page if the kernel does not exist. If the kernel already exists, it is selected automatically.
  • project.json now has an experimental option ["project"]["settings"]["enable_execute_all"] which disables the Execute Project button when set to false. The option is currently not settable in the UI.
  • New context menu action (Find...) to find items by name in DB editor's entity graph.

Changed

  • The console settings of Python tools as well as the command and shell settings of executable tools are now treated as project-specific data and stored in <project root>/.spinetoolbox/local/specification_local_data.json. This should make it easier to share projects over e.g. Git.
  • Scenario and tool filters are now ON by default. If new scenario or tool is added to a database it will be automatically selected in outgoing connections. NOTE: In existing projects, if a connection did not have any scenarios/tools selected, they will all be selected when opening a project for the first time after this change. If this is not desired, the scenarios/tools need to be deselected manually before saving the project on disk.
  • Project name is now the project directory name and cannot be changed unless by moving the project to another directory manually or by using the File -> Save project as... menu item.
  • Scenario filters now filter unrelated scenarios and alternatives as well.
  • Alternative/Scenario tree in Database editor has been split into separate Alternative tree and Scenario tree docks. This will hopefully make dragging and dropping alternatives to scenarios easier.
  • Logic of executing selected project items. URL's passed by unselected Data Transformers are not included automatically into selective execution anymore. When selecting project items for execution, make sure to select also preceding Data Transformers if needed.
  • Names for duplicate items/scenarios/etc now use the format prefix (xx) instead of prefix xx. Duplicating a previously duplicated item now has the number xx incremented instead of having a new number appended.
  • "Open kernel spec editor" buttons in Settings->Tools page have been changed "Make Julia kernel" and "Make Python Kernel" buttons

Deprecated

Removed

  • Python 3.7 support
  • GdxExporter project item. Please use Exporter instead.
  • Gimlet project item. Please use Tool instead.
  • The possibility to import parameter values when importing object groups using Importer. Existing mappings will not import group parameters anymore. Please add explicit parameter import mappings if needed.
  • The possibility to export parameter values when exporting object groups using Exporter. Existing mappings will not export group parameters anymore. Please add explicit parameter export mappings if needed.
  • Execute in work setting in Tool Specification Editor. Please use Execute in work setting in Tool Properties instead.
  • Kernel Spec Editor widget and the "Open Kernel Spec Editor" button in Tool Specification Editor

Fixed

  • Deleting the last item of a mapping in the importer specification editor no longer disables the 'add' button.
  • Group Id's for Jupyter Consoles
  • Kill consoles at end of execution for Jupyter Consoles
  • Crash when typing exit, exit(), quit, or quit() into Jupyter Console

Security

[0.6.5] - 2021-09-08

Added

  • Support for loops has been added. Loops can be created using a special loop link which is initiated by holding down the Alt key while drawing a new link in Design view.
  • Performance boost for Spine Db Editor when working with large databases.

Changed

  • Installation does not require cx-Oracle and psycopg2 packages anymore.
  • install_requires and requirements.txt files have been revised.

Fixed

  • Spine Db Editor Graph View works on Python 3.7 again.
  • Spine Db Editor Graph View 'Add objects' and 'Save position' actions.
  • Export to SQLite in Spine Db Editor

[0.6.3] - 2021-09-03

Added

  • Plenty of stability improvements and bug fixes

Fixed

  • Fixed 'ImportError: DLL load failed while importing win32api' on (Conda) Python 3.8 when trying to execute Tools in Jupyter Console

[0.6.1] - 2021-06-28

Added

  • Data Transformer now supports parameter value transformations.
  • Project execution shortcuts: F5 to execute all DAGs, F6 to execute selected items and F7 to stop execution.
  • Time series, maps and other compound values have gained the ability to have names for their indexes. Index names can be edited in parameter value editors, and they are also supported by Importer and Exporter items.
  • Support for running Python Tools (specifications) in a Conda environment
  • Execution mode (kernel spec, console, interpreter) can now be selected individually for each Python Tool specification

Changed

  • Data Transformer's specification editor has now a new interface.
  • Parameter renaming in Data Transformer requires now entity class names to identify the parameters. Data Transformer's icon will show a notification if class names are missing.
  • Installation instructions advice to install directly from PyPI.
  • Stand-alone DB Editor is now opened with the spine-db-editor [URL] command
  • Python settings on the Tools page of File->Settings are now the default settings for new Python Tool specifications. I.e. they are not global settings anymore.

Deprecated

  • GdxExporter has been deprecated. Use the general purpose Exporter item instead. GdxExporter will be removed in a future release. Please replace existing items by Exporter.

[0.6.0-final.2] - 2021-06-03

Fixed

  • [win-x64] Running Python or Julia Tools does not open an extra console window anymore

Security

  • urllib3 v1.26.5 now required because of a security vulnerability in earlier versions

[0.6.0-final.1] - 2021-06-01

Fixed

  • Event Log and Item Execution Logs now automatically scroll to the bottom when there are new messages
  • [win-x64] Resolve correct GAMS, Python, and Julia paths in Settings->Tools

[0.6.0-final.0] - 2021-05-07

Added

  • Support for parallel/multicore processing
  • New project item: Data Transformer. Can be used to configure Spine database filters for successor items. Currently, it supports renaming entity classes.
  • New project item: Exporter. A general-purpose tabular data exporter.
  • Support for version 3 Spine Toolbox projects and an automatic upgrade of version 2 projects to version 3.
  • Support for version 4 Spine Toolbox projects.
  • Support for version 5 Spine Toolbox projects.
  • Support for version 6 Spine Toolbox projects.
  • Support to create sysimages for Julia tools.
  • New requirement: jill, for installing Julia.
  • The SpineOpt configuration assistant has been moved from File->Configuration assistants, to File->Settings->Tools->Julia, and renamed to SpineOpt Installer.
  • New wizard to install Julia, accessible from File->Settings->Tools->Julia.
  • File->Close project option
  • Support for Python 3.8
  • Automated kernel creation, if the user selects to run tools in console without having created a kernel.
  • Option to pack CSV resource files into one datapackage.json file for advertising, available from Link properties.
  • Option to color project item icons in the toolbar, available frm File->Settings->General.
  • Reorganize project item icons in the toolbar with drag and drop.

Changed

  • Project Item (Tool, Data Store, Importer, etc.) code has been removed from Spine Toolbox. Project Items are now in a separate package called spine_items, which is upgraded at Spine Toolbox's startup.
  • Importer item now applies the same mapping to all input files. If the user needs to apply different mappings, they need to create different Importers. The specification can be shared using the json file.
  • The .gdx exporter project item is now called GdxExporter.
  • [win-x64] Installer does not require admin rights anymore
  • [win-x64] Installer always asks for an installation directory, even if a previous installation exists
  • [win-x64] Installer wizard style changed to modern

Removed

  • Combiner project item. The same functionality can be achieved by connecting a Data Store to another Data Store.
  • Upgrade support for original (.proj file based) Spine Toolbox projects.
  • Python 3.6 is no longer supported.
  • The Spine Datapackage Editor is gone. There wasn't enough reason to keep this widget
  • The app no longer checks that Spine dependencies are up to date. Users are asked to follow the upgrade procedure which involves manually upgrading requirements after pulling the latest master branch.

Fixed

  • [win-x64] returning_process.py when frozen
  • Traceback in GdxExporter when there are indexing settings for a parameter that is not in the database
  • Bug in installing Plugins
  • Traceback when removing Plugins

[0.5.0-final.1] - 2020-02-03

Added

  • Tutorial for case study A5 in the documentation

Fixed

  • [win-x64] Fixed /tools/python.exe by adding sitecustomize.py and a missing python37.dll

[0.5.0-final.0] - 2020-12-14

Added

  • Exporting graphs as PDF files from the Graph menu in the Data Store form.
  • Pruning entire classes from the graph view. The option is available both from the Graph menu and from Entity Graph context menus. Also, pruned items can be restored gradually.
  • A new Input type Indexed parameter expansion is now available in Data Store view's Pivot table. In this Input type the indexes, e.g. time stamps of time series get expanded as a new dimension in the table.
  • Import editor now has a new Source type: Table name. It can be used e.g. to pick an Excel sheet's or GAMS domain's name as the object class name.
  • Import editor now supports multidimensional maps. The number of dimensions can be set using the Map dimensions spin box in mappings options.
  • Executing a project from the command line without opening the Toolbox GUI (i.e. headless execution). The headless execution is enabled by the new command line option --execute-only.
  • Toolbox now supports scenarios and alternatives. They can be accessed via Data store view's new Alternative tree.
  • New Project Item: Gimlet. Can be used to run any command as part of the workflow with or without a shell. Supported shells at the moment are cmd and powershell for Windows and bash for other OS's.
  • Python and Julia Kernel spec Editor. Provides the means to make new kernel specs for Python Console and Julia Console without leaving Spine Toolbox. Kernel (spec) Editor can be found in Settings->Tools tab.
  • [win-x64] Includes Tools/python.exe for running Python Tools for systems that do not have a Python installation. Also, pyvenv.cfg and path.pth files for configuring the included python.exe.

Fixed

  • Signal disconnection issue in Graph View
  • Bugs in removing objects and object classes in Spine db editor's Graph View

Changed

  • Data Store Form is now called 'Spine database editor'
  • Spine db editor Graph View behavior. Now selecting objects in the object tree not only shows those objects but also all the cascading relationships. One can still go back to the previous behavior in Settings.
  • Moving object items in the graph view also causes relationship icons to follow. This behavior can be disabled in the Settings.
  • Required PySide2 version is now 5.14. The version is checked at startup.
  • Indexed parameter handling has been overhauled in Exporter allowing parameters to share indexing domains. Note: Due to numerous changes in the backend, Exporters in old project files will not load properly and need to be re-configured.
  • The way Exporter handles missing parameter values and None values has changed. The item now ignores missing values instead of replacing them by the default value. Further, there is a new option to replace None values by the default value and another option to replace Nones by not-a-numbers or skip exporting them.
  • The numerical indicator on the upper left corner of project items no longer indicates the execution order for each individual item because the exact order is not know before the Execute button is actually clicked. The number still indicates the execution order but may show the same numbers for items in different parallel branches.
  • Project.json file format has been upgraded to version 2. Version 1 project.json files are upgraded to version 2 automatically when a project is opened.
  • Default Python interpreter is now {sys.executable} i.e. the one that was used in launching the app. This affects the Python used by Python Tool specifications and the PyCall used by SpineOpt.jl configuration assistant.
  • [win-x64] Default Python interpreter is the Python in user's PATH if available. If Python is not defined in user's PATH, the default Python interpreter is the <app_install_dir>/Tools/python.exe.
  • User's now need to explicitly choose the kernel specs for the Python Console and the Julia Console. They are not chosen (nor created) automatically anymore. The kernel specs can be selected in the drop-down menus in application Settings->Tools.
  • Database revision handling has been improved. Id est, the app does not offer to upgrade databases that are more recent than the current version of Spine Toolbox can handle.
  • Links to User Guide and Getting Started documents open only the online versions. The docs have been published on readthedocs.org.
  • Clearing the line edits for Julia executable and Python Interpreter (in Settings->Tools) shows the full paths to their respective files as placeholder text.

Deprecated

  • CustomQtKernelManager class

Removed

  • python_repl_widget.py
  • julia_repl_widget.py

[0.4.0-final.0] - 2020-04-03

Added

  • A small notification icon is painted next to project items in the design view whenever they are missing some configuration. Hovering the icon shows tips for completing the configuration.
  • A small icon is painted next to the project items in the design view to show the order in which they will be executed
  • Main Window menu 'File -> Open recent'. Shortcut for opening a recent project.
  • A new project item Exporter allows a database contained in a Data Store to be exported as GAMS .gdx file.
  • It is now possible to copy and paste project items for example between projects.
  • It is now possible to duplicate project items.
  • Changes made in the tree view are also seen in the graph view and viceversa.
  • New Setting: Sticky selection in Graph View. Enables users to select if they want to use multi-selection or single selection in the Graph view Object tree when selecting items with the left-mouse button.
  • Projects can be saved to any directory
  • Project name can be changed in Settings
  • The graph view features a short live demonstration that new users can follow to discover the basic functionality.
  • New Setting: Curved links. When active, links on the Design View follow a smooth curve rather than a straight line.
  • When execution traverses a link, a small animation is played to denote the flow of data. Users can set how quick they want this animation to be in Settings. The fastest setting effectively disables the animation.
  • Special 'tag' command line arguments are now available in Tool Specification which expand to, for example, input database URLS or paths to optional input files when a Tool is executed.
  • It is now possible to undo/redo database changes in the Data Store form.
  • It is now possible to visualize the history of database changes in the Data Store form. The option is available in the Session menu.
  • Support for Tool command line arguments. You can now give Tool (project item) command line arguments in addition to Tool Specification command line arguments.
  • Undo/Redo in Design View
  • It is now possible to add new plots to existing plot windows in Data Store View.
  • Objects in Data Store's Tree View are sorted alphabetically
  • A new parameter value type, map has been added. There is now a dedicated editor to modify maps. Plotting of non-nested maps is supported, as well.
  • [win-x64] importer_program.py has been built as an independent application. This program is now distributed with the Spine Toolbox single-file installer. When installing Spine Toolbox, the Importer Program app can be found in the Spine Toolbox install directory (/importer_program).
  • Import preview window now supports copy-pasting mappings and options from a source table to another
  • Import preview window header context-menus for the preview table which, allows users to change all data types at once.
  • Provide data for EditRole for nicer editor experience in MappingSpecModel.
  • Red background is displayed for invalid values in MappingSpecModel
  • Object tooltips now show the descriptions Data Store view's

Fixed

  • Data advertised by a project item during execution is only accessible by its direct successors. In other words, resources are passed to the next items in line but not beyond.
  • [win-x64] Executing the Importer project item has been fixed on Windows release version
  • Bug fixes for Data Store View
    • Disappearing object names in entity graph
    • Spine db manager error dialogs
  • Tool configuration assistant for SpineModel.jl
  • [win-x64] A problem with displaying special characters in Process Log when executing the Importer project item.
  • The context menu in Graph view's pivot table resulted in a traceback when an entity class did not have parameter definitions.
  • Combobox delegate in Import preview window had wrong list of choices.
  • Don't set mapping to NoneMapping if user gives a None value.
  • Exporter now also exports empty object classes and empty parameters into GDX files
  • A bug that sometimes made duplicate entries to File->Open recents menu
  • Bug where an Excel import with empty rows would return a None in it's get_data_iterator
  • [win-x64] Executing Julia tools in the embedded Julia Console
  • [win-x64] Setting up Python Console. Installing ipykernel and kernel specs now works.
  • [win-x64] Setting up Julia Console. Installing IJulia and kernel specs now works.
  • Column indexing in Import Editor. When entering a time or time pattern index column manually in Import Editor's lower right corner table, the colors in the preview table failed to update. This should fix the bug and allow column selection both by column index or column header text.

Changed

  • spinetoolbox is now a Python package. To start the app, use command python -m spinetoolbox or python spinetoolbox.py as spinetoolbox.py has been moved to repository root.
  • Tool templates are now called Tool specifications
  • File->Open Project opens a file dialog, where you can open projects by selecting an old <project_name>.proj file or a Spine Toolbox Project directory. Valid Spine Toolbox projects are decorated with the Spine logo.
  • Old style projects (.proj files) cannot be opened anymore. The old style projects need to be upgraded before opening. You can upgrade your .proj file projects into new ones with Project Upgrade Wizard found in File->Upgrade project menu item.
  • Project information is not saved to a <project_name>.proj file anymore. This information is now located in file <project_dir>/.spinetoolbox/project.json. Every Spine Toolbox project has this file.
  • Work directory is now a global setting instead of a project setting
  • Renamed Data Interface project item to Importer. The corresponding category Data Importers was renamed to Importers.
  • Tree, graph, and tabular views have been merged into one consolidated view. You can choose your preferred style from the Data Store View's View menu.
  • The graph view behavior has changed. Now selecting objects in the object tree not only shows those objects but also all the cascading relationships. This is to facilitate exploring the system without a previous knowledge.
  • importer_program.py now uses the Python interpreter that the app was started with and not the one that is given by user in Settings -> Tools.
  • Importer now uses QProcessExecutionManager for running the importer_program.py

Removed

  • The status bar of the Data store view is gone. Instead, notifications are printed in a box on the right side of the form.
  • Saving project information to .proj files is not happening anymore

[0.3] - 2019-09-06

Added

  • Welcome message including a link to Getting Started guide.
  • Zooming (by using the mouse wheel) is now enabled in Design View. You can also select multiple project. items by pressing the Ctrl-key down and dragging the mouse.
  • New project item icons on Design View.
  • Two options for the Design View background (grid or solid). See Settings (F1).
  • Python Console (menu View -> Dock Widgets -> Python Console).
  • Python interpreter can be selected in Settings (Also Python 2.7 supported).
  • Support for Python Tool templates
  • Python Tool execution using the command line approach.
  • Python Tool execution using the embedded Python Console (checkbox in Settings)
  • The Data Store treeview now also has a relationship tree.
  • Support for reordering columns in the treeview.
  • Selecting 'edit object classes' in the treeview now also allows the icon to be selected.
  • Play button to main window Toolbar that executes all Directed Acyclic Graphs in the Project one after another.
  • Another Play button to main window Toolbar to execute selected Directed Acyclic Graph. Selecting a DAG happens by selecting one or more project items belonging to the wanted DAG in the Design View or in Project Items list.
  • Stop button to main window Toolbar, which terminates execution.
  • Possibility to specify a dedicated Julia project or environment for Spine Toolbox in the settings.
  • Feature to Export project to GraphML format. Each graph in Design View is written to its own file. To do this, just select Export project to GraphML from the Project Item list context-menu or from File -> Export project to GraphML.
  • New project item: Data Interface
  • Parameter and relationship parameter values can now be edited in a dedicated editor window in Tree, Graph and Tabular views. The editor is accessible by right-clicking a value and selecting Open in editor....
  • It is now possible to plot parameter and relationship parameter values in Tree, Graph and Tabular views.

Fixed

  • There is now an upper limit on how much text is logged in Event Log and Process Log. The oldest lines are removed if the limit is exceeded. This fixes a problem with excessive memory usage when running long processes.
  • Mouse click problems in Design View
  • Mouse cursor problem in Tool Configuration Assistant
  • Welcome message is now shown for first time users
  • NameError: SpineDBAPIError when executing Data Stores.
  • .py files in spinedb_api\alembic\versions are now copied to the installation bundle without compiling them to .pyc files first. Also, if there's a previous version installed, spinedb_api\alembic directory is deleted before installation begins [Win-x64].
  • Added missing modules from spinedb_api\alembic\versions package into installation bundle [Win-x64].
  • numpy is now deleted before installation begins so installing over an existing installation of Spine Toolbox works again [Win-x64].
  • packaging and appdirs packages are now included in the installation bundle [Win-x64].

Changed

  • Selecting the Julia environment in Settings now requires picking the Julia interpreter file (e.g. julia.exe on Windows) instead of the directory where the Julia interpreter is located.
  • Selecting the GAMS program (file) in Settings now requires picking the GAMS program (e.g. gams.exe on Windows) instead of the directory where the GAMS program is located.
  • All application Settings are now saved using Qt's QSettings class. Old configuration file, conf/settings.conf file has been removed.
  • New Spine databases can be created in any backend supported by spinedb_api. The Data Store item properties have been changed to allow for this.
  • Executing Directed Acyclic Graphs instead of just Tools.
  • Executing project items does not happen from the Tool Properties anymore. It happens instead by pressing the Play button in the main window Toolbar.

Removed

  • An unnecessary error dialog in Import Preview widget.
  • ConfigurationParser class in configuration.py.
  • Execute button in Tool Properties.
  • Stop button in Tool Properties.
  • Console window that opened in addition to the application window is not shown anymore [Win-x64].

[0.2] - 2019-01-17

Added

  • New Setting. You can now select whether to delete project item's data directory when removing a project item.
  • Graph View is also available from Data Store items, allowing to insert new relationships more graphically.
  • You can now execute Tools in the work directory or the source directory (where the main program file is located). The Setting is in the Tool template editor and in Tool properties.
  • Tabular view: New view for Data Store items, allowing to view and edit data in a pivot table.
  • Tool Properties now shows all information about the attached Tool template
  • Context-menus for Data Connection Properties, Tool Properties, and View Properties
  • Support for optional input files for Tool templates. You can now use Unix style wildcards (* and ?) to specify the optional files that a Tool may exploit, e.g. *.csv.
  • Wildcard support for Tool template output files
  • Tool template output files now support subdirectories
  • You can now create a new (blank) main program file in the Tool template editor by pressing the the + button and selecting Make new main program
  • A shortcut to Tool template main directory, accessible e.g. in Tool Properties context-menu
  • New Setting. You can select whether the zoom in the Graph view is smooth or discrete
  • Windows installer default location is /Program Files/SpineToolbox/. When new versions are released, the installer will automatically upgrade Spine Toolbox to a new version in that directory.
  • Support for executing Executable type tools in Linux&Mac. (Windows support was added previously)
  • Tool configuration assistant. Available in menu File->Tool configuration assistant. Checks automatically if the Julia you have selected in Settings supports running Spine Model. If not, the required packages are automatically installed.

Fixed

  • Better support for scaling screen resolutions
  • Exporting a datapackage to Spine format failed if datapackage.json was not explicitly saved

Changed

  • Importing items with names into a spinedatabase moved to spinedatabase_api to allow for easier adding of new import formats in future versions.
  • Tool template list is now located in the Project dock widget below the list of Project items
  • New look for Spine Datapackage editor

Removed

  • Templates tab in Project dock widget.

[0.1.75] - 2018-11-23

Added

  • New Setting (F1). You can now select whether to delete project item's data directory when removing a project item.
  • Application icon (Spine symbol)
  • New installer for 64-bit Windows:
    • Installation file extension is now .exe instead of .msi
    • Show license file before installation (users must agree to continue)
    • Default install folder is now C:\Program Files\ .
    • No need to Run as Administrator even if installed to the default location because write permissions for sub-folders that need them (\conf, \projects, \work) are set automatically
    • Create a shortcut on desktop (if wanted)
    • Create a Start Menu folder (if wanted)
    • Uninstaller. Available in the Start Menu folder or in Windows Add/Remove Programs
    • Remove app related registry entries when uninstalling (if wanted)

Fixed

  • Data Package editor. Some files were missing from the tabulator package.
  • Bug when exiting the app when there is no project open in close_view_forms() when exiting the application without a project open

Changed

  • settings.conf file is now in /conf directory

[0.1.71] - 2018-11-19

Added

  • Added PyMySQL package, which was missing from the previous release
  • Improved Graph View for the View project item (work in progress)

Changed

  • Some main window components have been renamed
    • Main view is now called Design View
    • Julia REPL is now called Julia Console
    • Subprocess Output is now called Process Log
    • Project item info window is now called Properties

[0.1.7] - 2018-11-01

Added

  • New option to refresh the data store tree view and get latest changes from the database.
  • Several performance enhancements in tree view form (accessing internal data more efficiently, optimizing queries to the database.)
  • Now the data store tree view offers to commit pending changes at exit.
  • Better support for batch operations in data store tree view.
  • data store tree view can be fully operated by using the keyboard.
  • New options to edit object tree items in the data store tree view, including changing the objects involved in a relationship.
  • The dialogs to add/edit tree view items are not closed in case of an error, so the user can adjust their choices and try again.
  • Stop button now terminates tool execution.
  • New context menu options to fully expand and collapse object tree items in the data store tree view.
  • The autofilter in the data store tree view now also filters work in progress rows.
  • In the Data store item controls, the path to the SQLite file can be specified by dropping a file.
  • Parameter and parameter value tables in the data store tree view now have an empty row at the end, which can be used to enter data more easily.
  • JSON data can be visualized and edited more easily in the data store tree view.
  • Tools can now execute (Windows) batch files and other executables (.exe). Linux support pending.
  • About Qt dialog added to Help menu

Fixed

  • Clicking on the open treeview button while the data store tree view is open now raises it, rather than opening a second one.
  • Work folder is not created for Tools if the Tool template requirements are not met.
  • Result folder is not created if the Tool template fails to start.
  • The embedded Julia REPL now uses the Julia that is given in application Settings (F1). Previously, this used the default Julia of your OS.

Removed

  • Connections tab has been removed (actually, it is just hidden and can be restored with a keyboard shortcut)
  • Refresh Tools button on Templates tab has been removed as it was not needed anymore
  • Set Debug message level in Settings has been removed

[0.1.5] - 2018-09-28

Added

  • Advanced copy/pasting and multiple selection support for the data store tree view.
  • Import data from Excel files into the data store tree view.
  • Export Spine database from the data store tree view into an Excel file.
  • Save at exit prompt.
  • Import data from datapackage into the data store tree view.
  • Restore Dock Widgets in the main window.
  • Parameter tables can be filtered by clicking on their headings in the data store tree view.
  • Parameter and parameter values are added and edited directly in the data store tree view, without need for an additional dialog.
  • On-the-fly creation of necessary relationships when entering parameters in data store tree view.
  • View item feature for visualizing networks from a Spine database. A view item can visualize databases from all data store items connected to it.
  • Packages numpy, scipy, and matplotlib are now mandatory requirements.
  • Drag files between data connections. File items can be dragged from the references and data lists. Data connection items can be selected by hovering them while dragging a file. Dropping files onto a Data Connection item copies them to its data directory.
  • datapackage.json files in data connections are now opened with the Spine datapackage form. This is a dedicated interface to prepare the datapackage for importing in the data store tree view.
  • The data store tree view does not lock the database when there are uncommitted changes anymore.

Changed

  • Changed DBAPI package mysqlclient (GPL license, not good) to pymysql (MIT license, good)
  • spinedatabase_api is not included in Spine Toolbox repository anymore. It is a required package from now on.
  • Data Store item can have only one database, not many. When opening a project created with a previous version, the first database in the list of saved references will be loaded for each Data Store.
  • In the data store tree view, the object tree presents all relationship classes at the same level, regardless of how many object classes are involved. The same applies for relationships and objects.
  • In the data store tree view, the relationship parameter value view now has different columns for each object in the relationship.

[0.1] - 2018-08-20

Added

  • Basic functionality