GAMS MIRO 2.9.2

• Fix crash on macOS when submitting jobs to Engine.
• MIRO Pivot: Fix renderer triggered too often in certain situations resulting in view not being loaded properly.

GAMS MIRO 2.9.1

• Support PKCE extension to OpenID in MIRO Server.
• MIRO Server: Fix issue where app logo was not properly displayed when using an App ID.
• MIRO Server: Add missing documentation for some security features: same-site-cookie, secure-cookies, frame-options.
• Minor improvements to GAMSPy example models.
• Fix issue configuring widget for multi-dimensional sets.
• Fix issue where the mathematical typesetting in table labels did not work.

Breaking changes

• MIRO Server: Drop support for Windows. Existing customers can continue to update and use GAMS MIRO Server on Windows. However, we will no longer offer support for Windows for new customers.

New features

• Add support for GAMSPy. Demo models can be found here and the documentation has been updated to discuss GAMSPy as well.

Minor new features and improvements

• When adding/selecting scenario tags, existing tags are now suggested and can be selected.
• Remove the limit of max. 50 events in a Gantt chart.
• Add option to group widgets in Hypercube module.
• Allow specifying custom input widgets for scalar symbols.
• MIRO Desktop: Moved login screen for GAMS Engine from the MIRO app window to the preferences window.
• MIRO Desktop: Add support for logging in to GAMS Engine via JWT as well as LDAP, OAuth2 and OIDC identity providers.

Bug fixes

• MIRO Pivot: Fix widget getting stuck in certain situations when using domain filters.
• MIRO Pivot: Fix warning when using row summary functions.

GAMS MIRO 2.8.3

• Fix misleading handling of the slider range widget.
• Fix issue that could cause MIRO to crash in certain situations when importing job via the job list.
• Fix issue where creating Hypercube job from scenario with long name did not work.

GAMS MIRO 2.8.2

• Fix crash in mobile mode when launching deployed apps with default input tables.
• Fix crash when using the pivotCols feature in input tables in combination with Inf/-Inf values.
• Fix crash when using the pivotCols feature in input tables in combination with duplicate records. The input table is now set to read-only and a warning is issued.
• When setting custom comparison mode as default, the Synchronize tabs button was erroneously displayed.

GAMS MIRO 2.8.1

• MIRO Pivot: Fix text in view selection dropdown button overflows if view name is long.
• Fix issue where multi-dropdown menus were not working.
• MIRO Pivot: Fix issue where row summarization did not work when certain columns were aggregated.
• MIRO Pivot: Fix several issues with empty tables (no data).

Breaking changes

• Removed backward dependencies (table filters) from dropdown widgets as well as the undocumented feature of having (forward) dependencies for checkboxes. Please use custom input widgets to achieve this functionality.

New features

• MIRO now allows you to access data from any (other) input widgets (not just scalar ones) in custom input widgets.

Minor new features and improvements

• MIRO Pivot input tables now support the readonly option.
• Our scripts now use Docker Compose version 2, as version 1 has reached its end of life.
• Batch Load: MIRO now allows you to select a custom (static) prefix when using batch load columns for naming scenarios.
• Custom data connector functions now get a new argument: customRendererDir with the path to custom renderer directory.
• MIRO Pivot Tables now display the currently selected view in the view selection drop-down menu.
• Comparison modes: Allow custom comparison modules to be selected as default comparison mode. Also, the default comparison mode is now preselected when selecting scenarios in the Batch Load module.

Bug fixes

• Fix updating the logo of an existing app on MIRO Server.
• Fix issue where an error occurred when adding an app to MIRO Desktop when there were multiple files with the _logo extension in the static_<modelname> directory.
• Fix issue deploying app with custom data connectors.

GAMS MIRO 2.7.1

• Fix issue where MIRO Pivot displayed an out-of-bounds error if the table did not contain column headers.
• Fix crash when trying to load an LST file that contains non-UTF-8 characters.

Minor new features and improvements

• Add option to remove duplicate records from input data.
• MIRO Server: Add support for OpenID Connect identity providers (for authentication).
• MIRO Desktop: Add support for ARM64 (Apple silicon) processors for macOS.

Bug fixes

• MIRO Server: Fix issue where the custom page title was not applied on the login page.
• Fix regression introduced with MIRO 2.6.0 where the content of the MIRO log file was duplicated multiple times when the (normal) log file was disabled.

Minor new features and improvements

• When using GAMS MIRO with a GAMS Engine backend, the currently active job can now be detached. After detaching, the job can still be accessed via the job list.
• Accessing attachment data from custom scenario comparison modules is now possible via the new CustomComparisonData$getAttachmentData() method.
• Add settings to customize the number of tabs to display before collapsing more tabs under a More » drop-down tab in the input/output sections and in comparison modes.
• MIRO Server API: Add GET /configuration endpoint, which returns version information, and POST /login endpoint to generate an authentication token and retrieve access groups.
• Carriage returns are now correctly displayed in the logs in the GAMS interaction section (i.e. the previous line is updated instead of carriage returns being ignored).
• The appId introduced with MIRO 2.5 can now be used on MIRO Desktop and MIRO Server to register multiple MIRO apps based on the same model.

Bug fixes

• Fix issue where attachment accessibility was not updated in certain situations.
• Fix crash when deploying an app with an app info file that does not include appId field.
• When importing data from a local file (csv, gdx or xlsx) and selecting "Replace" as the import strategy, data of missing symbols is now skipped instead of being cleared.
• Fix crash in Configuration Mode when configuring graphs (value boxes) for output scalars.
• MIRO Desktop: Fix color theme selection did not work when the language was set to something other than English.
• MIRO Server: Fix issue that could cause the app logo to become corrupted.

GAMS MIRO 2.5.3

• MIRO Desktop: Fix issue introduced with MIRO 2.5.2 where updating apps did not work in certain situations.

GAMS MIRO 2.5.2

• Fix issue on Windows that caused apps to fail to launch when GAMS path was not set and could not be found in the default location (C:\GAMS).
• Fix issue with migration wizard not working in MIRO Server.
• Fix issue with apps not launching if the main GMS file contains certain characters such as spaces. An error is now issued when trying to deploy or import such apps. To deploy such applications, the appId field must be specified manually via the app_info.json file.
• Fix Hypercube jobs not imported with correct username on MIRO Server.

GAMS MIRO 2.5.1

• Fix NA values not being ignored when calculating table summary for MIRO Pivot Tables.
• Fix filtered elements not being visible on small screens in MIRO Pivot presentation mode.

Minor new features and improvements

• MIRO Pivot Tables: Add option to show table summary (sum, mean, count, ... for rows/columns).
• MIRO Server: When a user without permissions on the MIRO Server namespace opens an application, it is now launched in read-only mode, i.e. the GAMS interaction section is hidden and the sandbox scenario cannot be saved/deleted. A new setting allows you to disable this behavior.

Bug fixes

• Fix issue in Configuration Mode where the fixed columns setting was not applied for input tables.
• Fix issue where sorting or downloading data from an editable MIRO Pivot input table could display incorrect data. However, the correct data was communicated with GAMS.
• MIRO Desktop: Fix issue where importing a MIROSCEN file by double-clicking caused an infinite loop with a prompt to overwrite the scenario if it already exists.
• MIRO Desktop: Fix issue where importing data files under Windows caused MIRO to hang indefinitely.

GAMS MIRO 2.4.1

• Fix crash when clicking button to submit a new asynchronous job.

New features

• Add option to specify custom scenario comparison modules.

Minor new features and improvements

• Access to views, attachments, and other metadata of the sandbox scenario is now possible within custom data connectors.
• Add option to use a second Y-axis as well as axis ranges for bar charts.
• A notification is now displayed when new output attachments are added.
• It is now possible to manually select specific input symbols to be imported from MIROSCEN files or database scenarios. In this case, the metadata (including views and attachments) will not be imported.
• MIRO Server: When MIRO Server is updated and custom packages are present in the additional_packages file, MIRO now asks if a new custom image should be created as part of the MIRO update.
• MIRO Server: The Dockerfile used to extend the MIRO UI image with custom packages has been updated to install the R build tools required for certain R packages.
• MIRO Server: Add new backup and restore commands to miro-server setup script to allow backing up and restoring a MIRO Server instance (Linux only).
• MIRO Pivot Tables: Symbol dimensions, which do not add data to the current view, are now slightly grayed out.

Bug fixes

• Fix issue where using a label for an output symbol caused the chart to be hidden.

GAMS MIRO 2.3.1

• MIRO Server: Third-party dependency update that includes a fix for CVE-2022-22965 (Spring RCE vulnerability). Currently, there is no known way to exploit MIRO Server. Nevertheless, we strongly recommend updating MIRO Server as soon as possible!

Breaking changes

• The remote data import and export feature has been deprecated and will be removed in one of the next MIRO releases.

New features

• Add option to specify custom data connectors.
• It is now possible to sign MIRO apps to ensure that the app was created by a verified developer. A new setting has been added in MIRO Server to force apps to be signed. This ensures that only apps from trusted developers can be imported.
• Add option to specify views globally for each scenario.

Minor new features and improvements

• Add option to show tooltips for input widgets.
• MIRO Pivot Tables: Charts can now be zoomed and panned.
• MIRO Pivot Tables: When configuring a new view, the user can now select a logarithmic scale for the y-axis.
• MIRO Pivot Tables: New renderer: time series chart.
• MIRO Pivot Tables: Stacked bar/area charts now display tooltips for all series in a chart.
• Custom renderers for input symbols can now access data from other input datasets.
• Add option to validate columns of input tables against predefined criteria.
• Add option to specify an external view as the default view for MIRO Pivot Tables. If this view is not present, MIRO Pivot falls back to the default configuration.
• Add option to specify an external view as the default view for the Pivot compare mode.
• Add various color themes that can be used for MIRO Desktop and for MIRO Server.
• Improved organization in the Configuration Mode.
  • The general settings have been revised and divided into new categories and additional subcategories.
  • The configuration of input tables is now done in section Input Widgets.
  • The option to enable/disable manual column resizing in input tables has been removed (always enabled).

Bug fixes

• Fix issue importing Excel spreadsheet with index that contains neither rdim nor cdim information.
• Fix issue displaying large text entries via job list section.
• MIRO Pivot tables: Fix issue where editable tables were not correctly marked as "read-only"/"editable" in certain situations.
• Compare mode: Fix crash when using scalar input symbols in custom input widget.
• Fix issue where downloading attachments did not work in certain situations.
• Fix issue where attachments were duplicated in certain situations.
• Fix issue where MIRO crashed when starting Configuration Mode with certain dropdown configurations.
• Fix issue with integer column names in GAMS symbol headers (e.g. a GAMS table with dimensions "i", "1", "2").
• Fix issue where an incorrect symbol alias was used in some situations when saving a new GAMS option or double dash parameter in Configuration Mode.
• Fix issue where an incorrect label was used in some situations when saving a graph configuration in Configuration Mode.

GAMS MIRO 2.2.2

• Support assigning a machine instance to be used for a job when submitting it to GAMS Engine.
• A warning is now issued when running out of quotas soon when submitting to GAMS Engine. If the quotas are exceeded, a more informative error is displayed.
• Fix issue saving scenario of a model without solve statement but with the saveTraceFile option enabled.
• Fix several issues related to keyboard shortcuts.
• Server: Fix crash in admin panel when app is updated and the database needs to be migrated.

GAMS MIRO 2.2.1

• Fix issue where the MIRO window did not open in development mode (e.g. when launched via GAMS Studio) when using the built-in browser.
• Configuration Mode: Fix issue where communication of additional input datasets with a custom renderer did not work properly in certain situations.

Breaking changes

• The Hypercube Mode was removed. You can now submit Hypercube jobs from the Base Mode if you are using GAMS MIRO with a GAMS Engine backend (GAMS MIRO Server or GAMS MIRO Desktop - boosted by GAMS Engine).
• An error is now issued if the MIRO app name (filename of the main .gms file) starts with: '~$'.

New features

• You can now define a custom input widget for multiple symbols.
• Apps and scenarios in MIRO Server can now be managed via a new REST API. Note: If you plan to update your MIRO Server instance to use this new API, the auth section of the docker-compose.yml file must also be updated. You can download the latest docker-compose.yml file here.

Minor new features and improvements

• The appearance of MIRO on devices with small screens (smartphones) has been significantly improved. In addition to general improvements, there are the following changes on small screens (<768px width):
  • Big data tables are now displayed by default for input symbols.
  • In MIRO Pivot tables, columns are not fixed anymore.
• When importing data from local files (CSV, Excel or GDX), users now have the option to choose whether to replace existing data or merge the new data with the existing data.
• Add option to show/hide fixed columns in MIRO pivot.
• MIRO now allows you to add a custom web app manifest to your app to customize the logo and title when your app is added to a user's home screen on mobile devices.
• The custom renderer editor in Configuration Mode now supports full-screen mode.
• Output renderers can now be annotated with Markdown.
• Log/MIRO log and lst files can now be downloaded directly from the GAMS interaction section.
• MIRO now supports reading domain sets (dSet) from Excel files.
• With custom renderers and custom input widgets you can now add and access attachments.
• It is now possible to update an app: Simply drag&drop an app onto an existing one or double-click a MIROAPP file.
• It is now possible to add scenario data (gdx/csv/xls/miroscen) to an existing app via drag&drop.
• It is now possible to add a custom stylesheet to a MIRO app.
• MIRO Server: Improve visibility and accessibility of the navigation bar.
• MIRO Server: Remove 'Containers' panel for admin users.
• MIRO Server: Groups that contain uppercase letters in their name are now ignored by MIRO Server because they are currently not supported.

Bug fixes

• Fix issue in Configuration Mode where the option to enable pivot presentation mode by default was not applied correctly.
• Fix issue with the Batch Load module when singleton sets but no scalars are defined.
• Linux: Fix title and icon of the application.
• Fix issue where attachments in the sandbox were incorrectly overwritten with attachments from the database in certain situations.
• Fix issue where attachments in the sandbox were not cleaned up properly in certain situations.
• Fix issue where downloading CSV from MIRO Pivot did not work when presentation mode was enabled by default.
• Fix issue in MIRO Server where sharing scenarios with groups whose names contain uppercase letters did not work. Groups are case-insensitive in GAMS MIRO Server and are always displayed with lowercase letters.
• MIRO Server: Fix issue where the navigation bar was not visible on mobile devices.
• Fix issue where valid MIROSCEN files were not imported in certain situations.
• Fix issue in Configuration Mode where the configuration for output tables without graphics to display was not saved correctly in some situations.
• Fix issue in the Batch Load module where fetching data caused an error when using multiple empty condition blocks.

GAMS MIRO 2.1.3

• MIRO Server: Fix issue that caused MIRO to hang in certain situations when adding new MIRO applications.
• Migration Wizard: Fix issue that caused database migration to fail in certain situations.
• Fix out-of-bounds error when reading from Excel sheets.
• Fix issue with empty default input tables.

GAMS MIRO 2.1.2

• Fix issue importing data from Excel with multiple rdim AND cdim.
• Fix unnecessary warning when importing data from empty Excel sheets.
• Fix issue where existing attachments were removed when the maximum number of attachments was exceeded.
• Custom scripts are now automatically included when the MIRO app is deployed and no longer need to be manually added to the model assembly file.
• Linux: Fix issue opening MIRO in default browser.
• Linux: Fix issue displaying charts in MIRO Pivot.
• Fix issue where the MIRO Pivot table was not updated after editing in large input tables was enabled.

GAMS MIRO 2.1.1

• Empty rows in default input tables are now ignored.
• Fix issue where reading data with 0 records from Excel would not work in certain situations.
• Fix issue with default input tables that caused old data to be communicated in certain situations.
• Fix issue with migrating old database schemas to MIRO 2.0 when database contains Hypercube scalars.
• Fix issue where incorrect filter elements were displayed in MIRO Pivot presentation mode in certain situations.
• MIRO Server: Fix issue where collapsed navigation bar would not open on mobile devices.

Deprecated features

• The Hypercube Mode is deprecated and will be removed in a future version of GAMS MIRO. You can now submit Hypercube jobs from the Base Mode if you are using GAMS MIRO with a GAMS Engine backend (GAMS MIRO Server or GAMS MIRO Desktop - boosted by GAMS Engine).

New features

• Hypercube jobs can now be submitted and imported from the Base Mode if MIRO is connected to GAMS Engine.

Minor new features and improvements

• MIRO Pivot Tables: When adding new views for bar charts, stacked bar charts, line charts and radar charts, you now have the option to assign custom colors to the different series.
• MIRO Pivot Tables: Views can now be edited.
• MIRO Pivot Tables: When downloading a CSV file while the switch to hide empty columns is active, hidden columns are not exported.
• MIRO Pivot Tables: New presentation mode that hides all pivot controls and puts more focus on the actual chart or table.
• MIRO Pivot Tables: New aggregation function: standard deviation.
• MIRO Pivot Tables: New renderers: scatter chart, area chart and stacked area chart.
• It is now possible to overwrite aliases of scalars in Configuration Mode.
• It is now possible to specify the number of decimal places per numeric column of default input tables in Configuration Mode.
• Whitespace and comments are now preserved when a custom renderer is saved via the custom renderer editor in Configuration Mode.
• When downloading scenarios via the Batch Load module, you can now select the file format from a drop-down menu rather than via a new dialog.
• When adding a MIRO app to the library that requires additional R packages from CRAN, the user is now prompted before these packages are installed.
• When logging into GAMS Engine and using a registered model, MIRO now also checks if the model exists in the namespace to provide a more informative error message.
• MIRO Server: Users who do not have permissions in the Engine namespace associated with MIRO Server are now authenticated when they can see some models. Users who do not have permissions in the namespace can see a model if they can see a group that is associated with a model in the namespace. Assigning models to groups is supported in Engine version 21.09.14 and later.
• Aliases for widgets are removed from Configuration Mode. The symbol aliases defined in the General settings section are used instead.
• Scenarios loaded from the Batch Load module into the comparison modes can now be named based on one or more columns of the Batch Load table.
• Importing Excel files is now significantly faster when there are many symbols on a worksheet.

Bug fixes

• Fix several issues with MIRO apps without external input data.
• Fix issues with configuring MIRO Pivot Tables in Configuration Mode: configuration was reset if a different aggregation function was specified and aggregation functions were not complete in certain situations.
• Fix wrong aggregation functions for input/output scalars in the Pivot compare mode.
• Fix issue with view IDs containing whitespace characters at the beginning or end.
• Fix incomplete error checks for defaut views for MIRO Pivot renderers.
• Fix issues with installing additional packages that contain precompiled binaries on macOS.
• Configuration Mode: Hidden output scalars were not correctly forwarded to the chart preview, which caused errors when trying to access them.
• Fix an issue where hidden output scalars were not transmitted/saved in certain situations.
• Fix an issue with launching some MIRO applications that were deployed with MIRO 1.x.
• Fix issue where MIRO would not start when a set was configured to use the MIRO pivot renderer.
• Fix issue where row order was not preserved when loading views in MIRO Pivot renderers.
• Fix issue where incorrect column headers were displayed in output tables.
• When loading scenarios in split/tab comparison mode, scenarios that have already been loaded are now filtered out.
• Fix issue with exporting GDX files via the Batch Load module in certain situations.
• Fix issue with detecting CSV delimiter in certain situations.
• Fix issue saving views in pivot comparison mode when some output symbols are hidden.
• Fix issue where dirty flag would not be set in certain situations.

GAMS MIRO 2.0.1

• Fix issue with loading values of slider ranges via the Batch Load module.
• Fix issue where the model sometimes did not terminate when the log file was hidden.
• Some internal database changes for MIRO Server.

Breaking changes

• The database layout that MIRO uses internally has been changed significantly. At the first start MIRO checks if there is an existing MIRO database and tries to migrate this database automatically to the new layout. A backup of the old database is kept in case something goes wrong. Some data can not be migrated automatically. The first time you start your MIRO app, you will be prompted with a migration dialog if some data needs to be migrated manually. Sliders that have been expanded in Hypercube Mode job configurations cannot be migrated!
• An error is now issued if the MIRO app name (filename of the main .gms file) is longer than 60 characters.
• Apps that use the (previously undocumented) dropdown columns feature in input tables must be redeployed.

Deprecated features

• The API for custom input widgets has been updated. Data is now passed in the form of reactive expressions instead of tibbles. The old API version is still the default for backward compatibility. However, you will now receive a deprecation warning if you are not using the new API version. The old API will be removed in a future MIRO release.

New features

• MIRO Server is officially released.
• Custom renderers can now be edited with a live preview via the Configuration Mode. This should increase productivity when developing custom renderers. Your existing renderers will still work, but will not be recognized by this new editor. To learn how to migrate them to be compatible with the new editor, see here.
• Scenarios in Base Mode can now be queried, loaded and exported via the new Batch Load module that was previously only available in Hypercube Mode.

Minor new features and improvements

• Migrating database tables is now significantly more powerful thanks to the new Migration Wizard.
• MIRO Pivot Tables: Aggregation function: min also added for sets.
• MIRO Pivot Tables: It is now possible to select and drag multiple indexes at once.
• MIRO Pivot Tables: The maximum number of rendered columns has been reduced from 500 to 300.
• The error message reporting duplicate records when exporting a GDX file now shows the symbol alias instead of the symbol name and is localized.
• Input/output groups with more than 6 tabs now get a "More..." tab that combines subsequent tabs.
• MIRO Pivot Tables: When adding new views, existing views with the same name can now be overwritten.
• MIRO Pivot Tables: When adding new views for bar charts, stacked bar charts or line charts, you now have the option to assign a chart title as well as labels for the x- and y-axis.
• Improve performance when starting MIRO: input graphs/output tables are now generated dynamically.
• Improve performance when loading scenarios in scenario comparison mode: Data is now only fetched and graphs only rendered when required.
• Add "Close All" button in the tab view comparison mode to close all currently opened scenarios.
• Windows: Removed progress bar when starting MIRO.
• When submitting a job to GAMS Engine, the MIRO sandbox is now restored when importing the results. This means that attachments, views, tags, etc. are preserved.
• You can now select the default renderer for all output data via the Configuration Mode (pivot table or table).
• Changing only the views of a scenario in the data_<modelname> folder now updates the scenario in the database.
• The new custom input widget API now passes data wrapped in reactive expressions. Also, access to values from scalar widgets is now supported.
• In addition to HTML, MIRO can now display Markdown files generated by custom analysis scripts.
• It is now possible to select and download multiple files from the temporary directory.
• Add option to fix table columns to the left when scrolling horizontally.
• You can now specify a custom environment for your MIRO apps.
• Scenario name and tags can now be edited via the Batch Load module.

Bug fixes

• MIRO Pivot Tables: Fix initialization issue that caused incorrect table layout in certain situations.
• Fix crash in metadata dialog that occurred when a MIRO app was configured without tabular input symbols.
• Fix issue where switching to the table or heatmap renderer in MIRO Pivot did not work in certain situations.
• When loading a view with heatmap renderer in MIRO Pivot, "Table" was incorrectly selected as renderer.
• Fix issue where keyboard shortcuts to navigate tabset panels in pivot view comparison mode did not work.

GAMS MIRO 1.3.2

• Fix crash in Configuration Mode when adding output groups.

GAMS MIRO 1.3.1

• Fix issue with downloading attachmets from sandbox in certain situations.
• Fix issue with detecting inconsistent database tables when running on MIRO Server.
• Jobs that failed to produce any output (e.g. due to a GAMS compilation error) can now still be downloaded when run on MIRO Server.
• Remove job results from GAMS Engine when job is discarded via job list.
• Jobs that are queued and not yet running are now shown as such in the job list.
• If the sandbox is changed while a (synchronous) job is running, a warning is now displayed before the results are imported into the sandbox.
• Fix issue when importing apps deployed with the "single user" or "local multi-user" option into the MIRO library.
• Fix issue with attaching the log file of a model containing uppercase letters on case-sensitive file systems.
• Closing a scenario now clears MIRO log errors and the GAMS interaction section.
• Fix issue with reading an Excel workbook without cdim declared in index sheet.
• When finding empty records in an Excel workbook, the value cells are now ignored. This is consistent with the behavior of GDXXRW.
• It is now possible to import xlsm files as well.
• Symbols that are not mentioned in the index sheet when importing an Excel workbook are now skipped. Previously they were imported as empty tables.
• Increase maximum size for attachments to 50MB.
• Increase the contrast of the charts in MIRO pivot tables in dark mode.
• The button for selecting the comparison mode now shows the currently active mode.
• Reading symbol names from the Excel layout sheet is now case-insensitive.

Breaking changes

• When writing sets/parameters with duplicate records to GDX file, an error is now issued instead of silently ignoring the duplicates.
• MIRO Pivot Tables: Scalar tables are no longer treated as sets (Scalar Value column is treated as set text column). Instead, scalar values are converted to floating point values. Note that values of singleton sets that cannot be converted to a floating point value become NA.

New features

• MIRO scenarios can now be imported and exported as MIROSCEN files. In contrast to other supported data files like GDX or Excel, a MIROSCEN file contains all scenario metadata like views and attachments.
• Views can now be used in pivot view comparison mode.
• MIRO now supports importing Excel (xls/xlsx) files with an index sheet. The syntax is very similar to GDXXRW. Read here for more details.
• MIRO now supports delimited text files other than CSV. Currently supported delimiters are: , tab ; | :. MIRO tries to detect the delimiter automatically and resorts to manual selection if it cannot uniquely determine the delimiter. In addition, MIRO supports the selection of a user-defined mapping of column headings from the delimited text file to symbol headings.

Minor new features and improvements

• MIRO Pivot Tables: Add option to export charts as PNG.
• MIRO Pivot Tables: Add option to visualize data as heatmap.
• MIRO Pivot Tables: Add option to hide empty columns. This option is also available in the Pivot compare mode.
• MIRO Pivot Tables: If a view is loaded with a filter value that is not found in the current scenario, an info box is now displayed.
• Dropdown menus in the input/output tab "More..." and the view list in MIRO Pivot can now be filtered.
• Sandbox scenario can now be loaded in tab view and pivot view comparison modes.
• Add button to refresh sandbox scenario in comparison mode.
• Remove results from GAMS Engine after they are downloaded, freeing up resources.
• Increase timeout when downloading results from GAMS Engine to 10 hours.
• Rename Compare mode button to Synchronize tabs.
• Move group domain option in graph configuration to section ydata.
• When comparing base scenarios in Hypercube Mode, they now get the names assigned to them in Base Mode.
• When comparing scenarios generated in Hypercube Mode, they now get the names: HC (1), HC (2) etc.
• Add a dropdown button to select between tab and pivot comparison modes when comparing scenarios in Hypercube Mode.
• When exporting spreadsheets, MIRO now attaches an index sheet with the layout of the exported data.
• In a custom renderer, the values of all output scalars can now be accessed via the argument outputScalarsFull.
• It is now possible to pivot columns in output tables as well.
• Show "More..." tab only if there are at least 2 tabs in this group.
• An empty textinput widget for a scalar GAMS symbol is now always communicated as empty string.
• An empty numeric input widget is now always communicated with its default value. A placeholder is displayed if no value has been set.
• Custom aliases for GAMS symbols as well as symbol domains are now automatically removed when the Configuration Mode is started and the symbols for these custom aliases are no longer part of the data contract.
• Results of Hypercube jobs solved on GAMS Engine are now deleted after download.
• Add new example app: Cutting Stock Problem.

Bug fixes

• Fix issue where views of a scenario were not loaded in tab/split comparison mode.
• Fix memory leak with views opened in tab/split comparison mode.
• Fix issue where the y2 (right) axis of a time series diagram was not visible when using the group domain option.
• Fix rare case where a confusing error message appeared in the log after solving the model.
• MIRO Pivot: Fix issue where only "count" was selectable as aggregation function for variables and equations.
• Fix incorrect switch to pivot view when comparing scenarios in Hypercube Mode and the current mode is split view. Now switches to tab view correctly.
• Fix issue with solving Hypercube jobs with attachments.
• Fix issue with solving Hypercube jobs with the clearValue option.
• The pivot comparison mode is now better integrated into the Hypercube Mode.
• Fix issue when importing/exporting slider and dropdown data from Hypercube job configurations.
• Fix import of a single scalar from CSV file.
• Fix issue where a numeric input widget would send wrong values in certain situations.
• Configuration Mode: When adding a new input widget group, the group name was not added to the list of input tabs used to set the tab order.
• Fix issue in Configuration Mode where the wrong widgets ended up in a widget group in certain situations.
• Date and date range widgets without selected date return an empty string now instead of NA.
• Fix checkbox return value to be 1/0 instead of TRUE/FALSE in Hypercube Mode.
• Fix job status and import of Hypercube jobs when using GAMS Engine in Hypercube Mode.
• Fix issue where submitting a Hypercube job caused an error when having configured slider that is not expanded in Hypercube Mode.
• Fix issue where numericinput would send wrong values in certain situatios.
• Fix issue where custom R packages were reinstalled every time MIRO was restarted.
• Fix issue where setting custom MIRO app/log paths did not work.
• Fix issue where scrollbar was not visible in MIRO library on Windows.
• Fix issue on macOS that caused an error when trying to deploy apps in both modes.

GAMS MIRO 1.2.3

• Fix issue with arrays (e.g. y-data in a bar chart) in Configuration Mode sometimes not expanding.
• Fix regression introduced with MIRO 1.2: In Hypercube Mode, scenarios loaded in the Tab View would not appear in the "Local" tab in the Split View.
• Fix issue in Pivot Compare mode where domains were displayed as "NA" in the scalar input table in certain situations.
• Improve validation of Engine URL.

GAMS MIRO 1.2.2

• Fix issue with views whose names are longer than 54 characters.
• Fix issue with scenario comparison when scalars table and widgets are in separate input groups.
• Fix issue where dialogs for adding/renaming columns in standard input tables did not work in the integrated browser.
• MIRO Pivot: Improve layout if there are many views (> 15).
• Fix a race condition that could cause stale input data to be sent to custom renderer functions.
• Fix issue when column in default input table was both pivoted and declared as readonly.
• Fix issue with input widgets being part of input groups.
• Fix a rare case where scalars were not imported when importing data from local files.
• Force the tab comparison mode the default comparison mode in Hypercube Mode because the scenarios selected for comparison will be loaded in this mode (this overwrites the defCompMode setting).
• Fix issue where downloading attachments did not work properly in certain situations.

GAMS MIRO 1.2.1

• Add option to configure a custom icon for a valuebox by adding a new choice to the dropdown menu.
• Improve readability of symbol configuration in Configuration Mode.
• Fix issue where import of data from GDX for a dropdown with clearValue option set to TRUE did not work.
• Fix issues with remote execution on GAMS Engine and uppercase letters in main GMS file.
• Fix issue in Configuration Mode (valuebox configuration) where the user gets an error when clicking on save twice.
• When removing database tables, show only one dialog instead of two.
• Fix issue in the MIRO Pivot renderer where filter dropdown would be irresponsive after loading view with unknown filters.
• Fix issue in the MIRO Pivot renderer where table/charts would be rendered more often than necessary.
• MIRO Pivot renderer: Change the settings of bar charts so that they always start at 0, and of line charts so that they have no interpolation.
• Fix issue that caused MIRO to crash when loading app with default scalars table on first tab.
• Fix issue that caused multiple symbols in custom renderers not to work properly.
• Fix issue that caused path to custom renderer function not to be passed correctly.
• Fix issue in Configuration Mode that caused MIRO to crash in some situations when resetting a table configuration for a symbol.
• Fix issue in Configuration Mode that caused label of tables not to be applied in certain situations.
• Numbers in default input tables with pivoted columns are now formatted correctly.

Breaking changes

• Additional packages in custom renderers are now installed in the MIRO workspace. These packages are no longer attached because this could lead to conflicts with packages required by MIRO. Read here for more details.

New features

• MIRO Pivot Tables introduced with MIRO 1.1 can now also be used for data input.
• Input widgets can now be grouped, and the order of widgets within a group can be changed.
• Views can now be attached to a scenario. A view is a JSON encoded configuration of some renderer. The first renderer to support this new feature is the MIRO pivot table renderer.
• New scenario comparison mode: pivot view. This mode allows you to merge datasets of multiple scenarios and analyze them with the pivot table renderer.

Minor new features and improvements

• Settings for output tables can now be configured symbol-specific. Read more here.
• Add option to specify default app title and description when deploying MIRO apps. Read more here.
• Besides GAMS tables now also normal parameters and sets can be configured as maps.
• Add option for text input widgets that causes element label of a singleton set to be the empty string. The idea is to use singleton sets to define compile-time variables in the GAMS model (read more here). Note that this is currently not supported in Hypercube Mode.
• Handsontables (default input tables) can now be searched. Matching results are highlighted and the viewport is changed to show the first result. You can move to the next result by pressing Enter and move to the previous result by pressing Shift + Enter.
• Remove unnecessary options for global input table settings in Configuration Mode.
• The filters in the MIRO pivot renderer now remain expanded even after selecting a new element.
• Improve accessibility of MIRO apps.
• Development mode: New data is now only imported if the file has changed since the last start of MIRO.
• Added option to enable a column visibility button which allows to hide columns in big data tables.
• Increase maximum number of scenario attachments from 5 to 7.
• Input tables can now be annotated with Markdown.
• Big Data Tables now support adding/removing rows.
• Value boxes can now be configured individually for each scalar value.
• Live preview of the graphics configuration can now be viewed in full screen.

Bug fixes

• Fix major issue that could result in wrong input data being stored after solving a model.
• Improve support of non-ASCII characters in file paths on Windows.
• In Configuration Mode, allow symbols with multiple header aliases of the same name to be saved.
• Fix issue where stale data would be displayed when loading scenario while an input chart of the previous scenario was still open.
• Fix issue where wrong files could be deleted when a scenario was removed from the sandbox.
• Fix issue with downloading results after solving a job asynchronously.
• Fix issue that occurred when several asynchronously solved scenarios were downloaded one after the other and then imported into the sandbox.
• Fix issue that occurred when trying to display logs of two different asynchronously solved scenarios one after the other.
• Fix issue where removing and then adding attachments again would cause an unexpected error.
• Fix bug on Windows with local attachments.
• Fix issue where multiple flows could not be displayed on one map - only the last flow was visible.

GAMS MIRO 1.1.3

• Add C:\GAMS\XX to the list of paths searched under Windows to find GAMS versions >=32 installed in the default location.
• Fix issue where discarding attachments when saving a scenario would not work properly if an existing scenario had to be overwritten.
• Fix issue where having GAMS not in the PATH on Windows would result in an error message in the log.
• Fix issue where non-zero exit code was not redirected to the parent process when deploying a MIRO application.
• Fix issue where apps deployed as single-user could not be imported to the library.
• Fix issue with Studio always showing success message when deploying a MIRO app, even when there were problems.

GAMS MIRO 1.1.2

• Fix bug where no groups specified in map configuration would lead to crash on next startup of Configuration Mode.
• Fix set configuration: Only show those tools that can be configured with with a set
• Fix bugs in Configuration mode with animation options.
• Fix bug that caused a line chart configuration to not be recognized as such in some situations when using a GAMS table symbol.
• Fix bug that caused empty xaxis title to be overwritten on next startup of Configuration Mode.
• Fix bug that caused slider range preview to fail when configuring a dynamic limit.
• Fix bug that caused configured checkbox starting value to be overwritten on next start of Configuration Mode.
• Fix bug in date & date range selector configuration that caused startview and weekstart option to be overwritten on next start of Configuration Mode.
• Fix bug in the configuration schema of the texinput widget that caused an error when configuring an empty starting value or placeholder.

GAMS MIRO 1.1.1

• Fixed an issue where numericinput would send wrong values in certain situations

New features

• New pivot table renderer: An all new pivot table renderer can now be selected for input and/or output charts. This renderer is designed for large datasets (> 1 million elements) and will replace the old pivot table renderer. The old renderer is still going to work, but you can not configure it via the Configuration Mode any longer. In a future release, we might deprecate this old pivot table renderer, so please migrate to the new one! This new renderer is the default renderer for input and output symbols. This will make the default configuration of MIRO even more powerful!
• Configuration Mode: Graphics configuration now loaded at next start.
• Two GAMS symbols can now be displayed in the same tab (side by side) when grouped.
• Add option to specify files that should be attached to a scenario after a GAMS run executes successfully. This allows you to add additional data to the data displayed in the user interface and add states to your scenarios to implement processes. You can find further information here.
• Add option to include TeX notation in README files via the enableMath switch. Wrap your TeX formulas in $ tags for inline rendering or between $$ for rendering as a formula block. Find more information about this feature here.
• The text input widget can now be configured for Singleton Sets.
• Multiple GAMS symbols can now be used in one custom renderer.

Minor new features and improvements

• Tabs for output symbols can now be hidden. This can be useful, for example, if you include a GAMS symbol in MIRO only for the purpose of using its data together with another symbol in a custom renderer (see above).
• Symbol metadata (symtype and headers) are now passed to the custom renderer/custom widget via the options list. The nested list can be accessed via the key options[["_metadata_"]].
• The MIRO log can now be used as an alternative to the GAMS log. This means that it will update while the model is running.
• Add option to define the decimal separator character and the thousand groups separator character for numeric inputs.
• Add legend configuration options to time series diagrams.
• Add option for static event lines to time series diagrams.
• Add option for dropdown menus that causes element label of a singleton set to be the empty string. This is only supported if aliases are defined. Also note that this is currently not supported in Hypercube Mode.
• Add option to hide indexing column in input tables. Only available for default input tables and not for big data tables.
• Minor UI adjustments in input widgets tab
• Add caching for deployed apps which drastically increases their startup performance.
• Increase startup performance for the Configuration Mode.
• R is now bundled with MIRO on MacOS.
• Data is now imported when a new MIRO application is added to the library instead of at the first start of the application.
• When a new MIRO application is added to the library, the database tables are now checked for consistency.
• Add option to remove database tables when removing a MIRO application from the library.

Bug fixes

• Fix issue with validating GAMS on Linux.
• Configuration Mode: Fixed a bug that caused adding a script with an already existing id not to be validated properly in certain situations.
• Configuration Mode: Fixed a bug where an incorrect widget configuration was displayed for symbols with a JSON configuration that is not (yet) supported by Configuration Mode.
• Orphaned tables were not found when model name includes underscores.
• An error that should only occur if the list/log file exceeds a certain file size was incorrectly displayed when starting a new GAMS run.
• Model names that included an underscore "_" caused MIRO to throw an exception when downloading scenario data in Hyperube Mode.
• Did not properly set idir when running Hypercube jobs locally (currently, model has to be adjusted to work with idir).
• Fix bug that caused Hypercube to crash when configuring a dropdown menu that is not expanded in Hypercube Mode.
• Fix bug that caused Hypercube job to fail when a multi dropdown menu is empty.
• Fix bug that caused wrong value to be written to GDX when having an empty multi-dropown menu (no elements selected)
• Fix bug that caused datatables without numeric columns to throw an error (e.g. for sets)
• Fix bug where attachments with execute permissions were not extracted in workdir with SQLite database backend (default on MIRO Desktop)
• Fix bug that caused empty sets not to show up in GDX and therefore to throw an error on the GAMS side.
• Fix problem with Safari browser where marked text in the GAMS interaction section was unreadable.

GAMS MIRO 1.0.3

• macOS: Fixed a bug that caused GAMS versions >= 31.x to be rejected.
• Fixed a bug that caused csv files with filename equal to the dataset name not being imported. The dataset had to be selected manually.

GAMS MIRO 1.0.2

• Fixed bug in Configuration Mode that caused custom table headers to be reverted to their defaults the next time Configuration Mode was started.
• Fixed a bug in Configuration Mode that caused custom scripts arguments not to be displayed correctly at the next start.

GAMS MIRO 1.0.1

• Fixed bug that caused MIRO apps with same version as currently installed to be falsely rejected by library.

New features

• New deployment environment for configured MIRO applications. You can find more information about this here. The --mkapp=1 option (shortcut creation) is no longer supported.
• MIRO now comes as an independent installer on the platforms Windows, macOS and Linux. The installation is independent from the GAMS system. All GAMS versions 30.2 or later support GAMS MIRO.
• [MIRO:table] syntax for pivoting a table column in MIRO is no longer supported. Instead, a symbol can now simply be declared as a table. Read more here.
• Added ability to pivot tables in MIRO via the Configuration Mode. Unlike the table statement in the GAMS model itself, this option does not affect the data contract between GAMS and MIRO resulting in variable columns.
• Full dark mode support.
• Added miro log option for custom logs and input validation
• Added support for an individual README starting page (markdown document) which is displayed in the input section. The Readme file can be added/edited in Configuration Mode.
• Added support for own custom scripts for analysis purposes in Base and Hypercube Mode.
• New widget type: numeric Input.
• One-dimensional sets can now be configured as dropdown menu.
• New widget type: Multi-dropdown menu for one-dimensional, dynamic sets.
• Added support for custom input widgets.
• Added support for remote data import and export: users can import/export data from/to external sources via REST API.
• Symbol links: Data of output symbols can now be used to populate tables of input symbols.
• Sandbox scenarios:
  • The MIRO user interface can be seen as a sandbox. Data that is loaded into the interface is therefore located in this sandbox as a sandbox scenario. The data of the sandbox scenario can come from the MIRO database, external databases, GDX containers, excel files, or can be entered manually.
  • File attachments are part of a scenario. If attachments are added to a sandbox scenario, they are included when saving this scenario.
  • Sandbox scenarios can be loaded in scenario comparison via load active button.
• Added filter option for graphs: One dimension of a symbol visualized as a graphic can be configured as a filter dimension. Its elements can then be selected via a (multi-)drop-down menu. Only the data belonging to this selection is displayed in the graphic.

Minor new features and improvements

• Bug fixes
• New MIRO logo (Thank you Melina Steimel!)
• Full Chinese language support (Thank you Ying Deng!)
• Completely restructured Hypercube Mode. This includes the change from CSV to GDX file format for scenario input and output data. This is especially relevant for the manual job submission.
• Changed directory name for custom renderers from customRenderer to renderer_<modelname>
• Changed directory name for configuration files from conf to conf_<modelname>
• Improved performance on startup of MIRO Base/Hypercube Mode
• Added Link to GAMS World Forum in help section.
• Stop button in GAMS interaction now with soft kill first, then hard kill.
• Scenario comparison: input and output symbol tabs are now displayed in different colors.
• Added option to edit scenario access permissions.
• When creating new scenario via Save as dialog, attachments of currently active scenario can now be duplicated. This does not apply to scenario access permissions.
• Element text of singleton sets can now be appended with a double pipe ("||") and will be aggregated/disaggregated when loaded/stored from GDX. The value and/or the element text of a singleton Set can be used in the eval.Set option to evaluate the value/text at compile time and place it into a scoped compile-time variable. This is useful any information about double-dash parameters and GAMS options configured via Configuration Mode gets lost when exporting a scenario as a GDX file. Read more here.
• Changed prefix for double-dash parameters and GAMS options from GMSPAR_ / GMSOPT_ to _gmspar_ / _gmsopt_.
• Double-dash parameters and GAMS options can now have the same name as GAMS symbols.
• Maximum number of symbol tabs visible in Inpupt/Output section set to 5 (rest available via dropdown).
• Bootstrap dropdown menus are now right aligned per default. They will be left-aligned when space on left is not sufficient.
• "More" dropdown menu (visible when more than 5 input or output tabs are shown in MIRO) will now show currently active tab.
• First two columns (symbol name and symbol text) of scalar input table are now automatically set to readonly.
• Import data via spreadsheet: Added possibility to use a sheet dedicated to a single scalar with the sheet name being the name of the scalar and its value being in column A1.
• When importing scenarios from data_<modelname> folder, these scenarios can now be read and executed by all users within the same user group as the user importing them. Before, only the user importing them could read and execute them.
• Adding/removing rows is now no longer allowed when at least one column is readonly.
• Variables and equations can now be exported via GDX.
• Changed handling of NAs, zeros and EPS. Numeric NAs are not converted to 0 anymore; Zeros are now written to GDX as 0 instead of being squeezed out.
• Increased precision of numeric values input tables to maximum precision.
• Custom renderer functions are now extended with ellipsis arguments to make sure they are compatible with future MIRO versions.
• Configuration Mode:
• New structure and design.
• Added option to rename tab titles and symbol headers.
• Added option to change the application title.
• Added option to reorder symbol tabs.
• Removed option to (de)activate the scenario functionality (e.g. save scenarios in database). Is always activated now.
• Removed comment functionality in input tables.
• Input scalars can now be used in charts as well.
• Charts configuration has now access to MIRO database. Previously saved scenario data can now be used for the graphics configuration (besides the local file upload).
• Added option to display graphic and table in split-screen for pie charts, maps and gantt charts.
• Added option to remove invalid widget/graph configuration in Configuration Mode
• Added custom renderer option for graphics.
• Added support for multiple pie charts via subplots
• Added support for heatmaps (input tables).
• Bar chart, Line chart, Scatter, plot, Bubble chart: Order logic of axis elements can now be adjusted.
• Map: Markers can now be customized (icon, icon color, marker color).
• Added option to set a fixed height and/or width for pie chart, donut chart, bar chart, histogram, scatter plot, line chart, bubble chart.
• Added option to render a static picture instead of an interactive plot for pie chart, donut chart, bar chart, histogram, scatter plot, line chart, bubble chart.
• Added option to set the axis scale ratio for line chart, scatter plot, bubble chart.
• Added option 'area' and 'diameter' for bubble chart size measurement
• Valuebox: Number of boxes in a row can now be customized.
• Added option to configure number of decimal places for numericInput
• Removed remote Execution setting from Configuration Mode. Moved to preferences that are accessible via the MIRO library.

• MIRO Configuration Mode: The GAMS MIRO Configuration Mode can be used to change the settings of your MIRO app as well as to generate new widgets and charts. When configuring your widgets and charts, you get a live preview so that you immediately see the results of your configuration. You don't need to touch JSON code anymore.
• New data import mechanism: Instead of creating an Excel file that the user then has to upload in order to get the first data into MIRO, data relevant to MIRO is automatically extracted from your model and stored in the MIRO database.
• Tab grouping: Group multiple input tabs and output tabs together.
• Automated loading of data on startup: Automatically load data when your MIRO app launches, so tables won’t start out empty.
• Automated scenario import into DB: GDX files that you place in the data_<modelname> folder of your MIRO app will be automatically imported into the MIRO database the next time you launch your app.
• Improved UTF-8 support: You can now use non-ASCII characters throughout MIRO
• Chinese language support (note that the MIRO Configuration Mode is not yet translated, though).
• Import and export of GDX files: Besides Excel spreadsheets you can now also import and export GDX containers.
• GAMS Studio toolbar to launch MIRO.
• Experimental support for Gantt charts.
• Bug fixes and performance improvements.

Initial release