Release notes Indicium 2022.2.14

Hello everyone,In this sprint, we changed the process flow behavior when this flow is marked as Deep linking allowed. Also, we made some logging improvements, and we added a session variable for the actual logged-in user.You can read more about Indicium's features in the Indicium user manual.We will keep you updated regularly about Indicium's progress.About IndiciumTwo types of the Thinkwise Indicium Application Tier are available: Indicium Basic: for use with the Windows GUI and Mobile GUI. This basic version does not support, for example, system flows and OpenID. Indicium: for use with the Universal GUI and via APIs. This version uses the full range of Indicium functionality.Download Indicium release 2022.2.14 here. Contents of this releaseAbout Indicium Breaking Process flows behavior when marked as Deep linking allowed Indicium - New Logging improvements New session variable for the actual logged-in user Indicium - Changed Process flow behavior when canceled by the user  BreakingProcess flows behavior when marked as Deep linking allowedProcess flows marked as Deep linking allowed were never intended to be started automatically by their start actions: a task or adding a record should never start the process flow.These process flows were not started automatically in the Thinkwise Windows and Web GUIs, as intended.However, Indicium was inconsistent in this matter and this has been corrected in this release. Deep links must be started via an API call to the process flow itself, which initiates the process flow start action in the GUI. While this was always the intent of the feature, this is a breaking change for Indicium, so please be aware of this change.Indicium - NewLogging improvementsIn this release, we have added more logging functionality to make troubleshooting easier.When a default procedure sets a value for a lookup property that is not hidden from the user, and the value is outside of this user's mandatory lookup prefilters, Indicium would reject this value and set the lookup property to null. Since it was difficult to see why this was happening, we added an error log message for this. All log messages related to process flows now also contain the application ID to which the process flow belongs. This is especially useful when troubleshooting scheduled system flows.New session variable for the actual logged-in userWhen simulating users, you can now use the tsf_original_login session variable to retrieve the user who initially logged in. In this release, you can use this session variable as follows:On SQL Server: select SESSION_CONTEXT(N'tsf_original_login') On Oracle: select sys_context('session_vars', 'tsf_original_login') from dual;Indicium - ChangedProcess flow behavior when canceled by the userIn a process flow, when the first action is a task or report, and the user cancels the popup dialog, until now, the process flow was not started. Indicium will now continue the process flow if the last process action was not successful (marked by a red arrow), and indicates that the result of the task is "User canceled".

Related products:Indicium Service Tier

Release notes Universal GUI 2022.2.14 BETA

Hello everyone,In this sprint, we made it possible to add or copy a row in a pinned top row of a grid, and we slightly changed the refresh functionality. Also, we started with a UI/UX design for advanced filters.In these release notes you will find a full overview of these main features and all minor features and tasks.As always, we have made a demo for you: try it here. Before trying it out, press 'Clear Cache' on the login screen. You can read the GUI user manual to get familiar with the Universal GUI.We will keep you updated regularly about Universal's progress.Universal GUI version 2022.2.14 BETADo not forget the documentation and be sure to keep the following in mind:A modern browser is required to access the Universal GUI, e.g., a recent version of Chrome, Firefox, Edge, or Safari mobile. Using the Universal GUI with IE is not supported. The Universal GUI must be deployed on the same server as Indicium or an allowed origin in appsettings.json. The Universal GUI only works with version 2021.1 and up of the Thinkwise Platform. Make sure you run all hotfixes on the IAM and SF that you plan to use for the Universal GUI. Make sure you are using the latest version of Indicium Universal.Download the Universal GUI version 2022.2.14 BETA here  This is a beta release, which can be used to test the new features. This release is not suitable for use in a production environment. The full release will be available this Friday. Contents of this releaseUniversal GUI version 2022.2.14 BETA New Adding a row in a pinned top row of a grid Refresh functionality Improvement when forgetting your password Activate the Maps component from a process flow UI/UX design for advanced filters Other fixes and tasks What we will be working on next sprint NewAdding a row in a pinned top row of a gridAs of this version, in an editable grid, you can now add or copy a row by using a pinned top row.Adding a row in a pinned top row in a grid Refresh functionalityThe refresh functionality has changed. In previous versions, we supported most refresh options for task execution and editing. The refresh row option refreshed the entire subject.Now, the refresh row option is not only supported for tasks, but also after updating a single record.The refresh options for a task are available in menu Processes > Tasks > tab Default/Variants > tab Table tasks > tab Form > tab Table task. The refresh options for a row are available in menu User interface > Subjects > tab Default > tab Settings > tab Performance.Improvement when forgetting your passwordWhen you enter your username in the login screen, and then click Forgot your password?, your username will now be filled in automatically on the next screen.Activate the Maps component from a process flowYou can now activate the Maps component from a process flow. You can now also use input parameters to change the zoom level and navigate to a specific location on the map.UI/UX design for advanced filtersTo help you get an overview of what is coming up in the Universal GUI, we will, from now on, include new component designs in the release notes. In this sprint, we dived into the advanced filters.According to our design, it becomes possible to set up your own specific set of filter criteria and filter with different filter operators (such as 'Starts with', 'Between', or 'Is not empty'). You can open the advanced filter popup using a button in the filter bar's overflow menu or a shortcut key.My customers advanced filterAfter this action, a popup opens, in which a user can add or remove filter criteria. In the Software Factory, you can specify a filter configuration for a subject, and add filter criteria. These criteria, if any, are then displayed in the filter popup in the application, and can be changed.Example of an advanced filter Other fixes and tasksIn some languages, the toolbar label would overlap the toolbar's action buttons. This has been fixed. When quickly changing the sorting order of multiple columns in a grid, some columns could incorrectly change position. This has been fixed. When counting the number of records in a grid summary row, the result was not displayed, only the label. This has been fixed. If the Show label option was disabled for a grouped tree, the label was still displayed. This has been fixed. In process flows, specific process actions did not provide active record information to Indicium, preventing the process flow from using this information. This has been fixed. In a card list, the labels did not get the specific card list translation but the general translation. This has been fixed when connected to the Software Factory. This issue has not yet been fixed when connected to IAM. A software Factory hotfix will be available in the near future to solve this. On a mobile device, when switching to edit mode, the size of detail tiles could change, resulting in the tiles changing position. This has been fixed. When a grid or form was open while a process flow was active, the flow waited for a tab change before continuing. However, a tab change did not always happen, causing the flow to stop and remain active. This has been fixed. In a conditional layout, for fields that had both a conditional background color and a text color defined, only the conditional background color was applied. This has been fixed. When switching between rows with multiple views of a cube displayed simultaneously, inactive cube views did not refresh. This has been fixed. Some specific screen type configurations could cause misalignment between vertical and horizontal tab strips. The horizontal tab strip would then be displayed in an undesirable location on the screen and become unusable. This has been fixed.What we will be working on next sprintThe next sprint we will be working on:When selecting or clearing a checkbox in a grid, this change is currently not immediately visible. This will be improved. Process flow action Activate scheduler - With this process flow action you can activate the scheduler component, similar to Activate grid and Activate form. Technical design New HTML Component. Select all records on the current page using the shortcut key Ctrl + A. In a card list, double-clicking a card will execute the corresponding table task, if any. In a grouped tree, double-clicking a tree item will execute the corresponding table task, if any.

Related products:Universal GUI

Release notes Universal GUI (2022.2.13.0)

 September 16, 2022:Changed beta release to the full version: 2022.2.13.0 Improvements for issues found in the previous beta release: In a grid, when the Edit in grid option was disabled, it was still possible to edit if the corresponding form was also available. This has been fixed. In a subject with the Auto-save option enabled, it was not possible to execute a task or open a report after making changes in edit mode. This has been fixed. The row is now saved, and the task is executed, or the report is opened.  Hello everyone,As of this sprint, the resource scheduler remembers the selected timescale. Also, performance has been improved, and you can now apply a filter by pressing [Enter] when focused on a field.In these release notes you will find a full overview of these main features and all minor features and tasks.As always, we have made a demo for you: try it here. Before trying it out, press 'Clear Cache' on the login screen. You can read the GUI user manual to get familiar with the Universal GUI.We will keep you updated regularly about Universal's progress.Universal GUI version 2022.2.13.0Do not forget the documentation  and be sure to keep the following in mind:A modern browser is required to access the Universal GUI, e.g., a recent version of Chrome, Firefox, Edge, or Safari mobile. Using the Universal GUI with IE is not supported. The Universal GUI must be deployed on the same server as Indicium or an allowed origin in appsettings.json. The Universal GUI only works with version 2021.1 and up of the Thinkwise Platform. Make sure you run all hotfixes on the IAM and SF that you plan to use for the Universal GUI. Make sure you are using the latest version of Indicium Universal.Download the Universal GUI version 2022.2.13.0 here  Contents of this releaseUniversal GUI version 2022.2.13.0 Breaking Thinkwise Platform support release 2020.2 is ending New Resource scheduler remembers the selected timescale Formlist with Combo and Image Combo elements Changed Performance improved when first opening a subject Default editable grid performance improved Filters applied with the 'Enter' key in a Filter component Minor fixes and tasks What we will be working on next sprint BreakingThinkwise Platform support release 2020.2 is endingIn accordance with our Lifecycle policy , Universal GUI support for Thinkwise Platform release 2020.2 is ending. Please upgrade to at least Software Factory release 2021.1 to use this Universal GUI 2022.2.13 release.NewResource scheduler remembers the selected timescaleThe resource scheduler now remembers the timescale the user selected: When reopening the scheduler window, the last timescale chosen is displayed. This preference is saved in the browser (for example, Google Chrome on your device) but is not persisted across browsers or devices.Formlist with Combo and Image Combo elementsThe Formlist component now supports Combo and Image Combo controls, using domain elements (as items to choose).ChangedPerformance improved when first opening a subjectWhen opening a subject for the first time in a session, the performance has been improved by loading the subjects' model data in parallel. As background information: A session starts when opening the Universal GUI. This session ends when refreshing or closing the Universal GUI browser tab.Default editable grid performance improvedTo improve the performance of the default editable grid, we changed the way it works. Previously, the Universal GUI was locked until the active row was saved and error-free. This made switching between rows very slow because committing the previous record and then setting the new row in edit mode was a sequence of actions.As of this version, a user can start editing the next row while the previously edited row(s) are still waiting for the commit. If an error occurs in a previous row, the user receives a message and visual help about it but can continue to edit the row they are working on and fix the error later.Filters applied with the 'Enter' key in a Filter componentIn a filter component, you can now apply a filter by pressing [Enter] when focused on a field. Previously, the filter would only apply after removing focus from the field ([Tab]).Minor fixes and tasks For a grid with a row group, double-clicking a row group header would also incorrectly execute the double-click task assigned to a selected record within the group. This has been fixed. Importing records into a detail subject or lookup subject from Excel failed because the data was tried to be imported into the main subject. This has been fixed. When editing in a default editable grid and selecting another record, the grid could scroll unnecessarily. This could result in the edited record not being visible in the current view. This has been fixed. When executing a task on multiple records, the execution order was sometimes incorrect compared to the order in which the records were displayed. This has been fixed. In charts, translated domain elements were not shown. This has been fixed. We fixed a bug where the splitter content width exceeded its limits. Before this release, this could, for example, result in action bar buttons not appearing on the screen: Incorrect action bar buttonsThis has been fixed: Correct action bar buttonsWhat we will be working on next sprintThe next sprint we will be working on:Technical research: Deep link to process flow - A deep link to a process flow allows the developer to create links that can be sent via email or otherwise. These links start the Universal GUI and then a process flow. In the technical research, we design the underlying functionality. Activate maps process flow action - This process flow action allows you to activate the Maps component for the user, similar to the Activate grid and Activate form process actions. Activate scheduler process flow action - This process flow action allows you to activate the Scheduler component for the user, similar to the Activate grid and Activate form process actions. Add row in grid - The ability to add a row directly in a pinned top row of a grid. Refresh row functionality - The refresh row option will be supported for tasks and after inserting, updating, or copying a record. UI/UX design for advanced filter popup - The advanced filter option will be available as a popup to all users and offers more complex options than the current filter form. This functionality will become the basis for the user-defined prefilters.

Related products:Universal GUI

Release notes Universal GUI 2022.2.13 BETA

Hello everyone,As of this sprint, the resource scheduler remembers the selected timescale. Also, performance has been improved, and you can now apply a filter by pressing [Enter] when focused on a field.In these release notes you will find a full overview of these main features and all minor features and tasks.As always, we have made a demo for you: try it here. Before trying it out, press 'Clear Cache' on the login screen. You can read the GUI user manual to get familiar with the Universal GUI.We will keep you updated regularly about Universal's progress.Universal GUI version 2022.2.13 BETADo not forget the documentation  and be sure to keep the following in mind:A modern browser is required to access the Universal GUI, e.g., a recent version of Chrome, Firefox, Edge, or Safari mobile. Using the Universal GUI with IE is not supported. The Universal GUI must be deployed on the same server as Indicium or an allowed origin in appsettings.json. The Universal GUI only works with version 2021.1 and up of the Thinkwise Platform. Make sure you run all hotfixes on the IAM and SF that you plan to use for the Universal GUI. Make sure you are using the latest version of Indicium Universal.Download the Universal GUI version 2022.2.13 BETA here  This is a beta release, which can be used to test the new features. This release is not suitable for use in a production environment. The full release will be available this Friday. Contents of this releaseUniversal GUI version 2022.2.13 BETA Breaking Thinkwise Platform support release 2020.2 is ending New Resource scheduler remembers the selected timescale Formlist with Combo and Image Combo elements Changed Performance improved when first opening a subject Default editable grid performance improved Filters applied with the 'Enter' key in a Filter component Minor fixes and tasks Known issues in this release What we will be working on next sprint BreakingThinkwise Platform support release 2020.2 is endingIn accordance with our Lifecycle policy , Universal GUI support for Thinkwise Platform release 2020.2 is ending. Please upgrade to at least Software Factory release 2021.1 to use this Universal GUI 2022.2.13 release.NewResource scheduler remembers the selected timescaleThe resource scheduler now remembers the timescale the user selected: When reopening the scheduler window, the last timescale chosen is displayed. This preference is saved in the browser (for example, Google Chrome on your device) but is not persisted across browsers or devices.Formlist with Combo and Image Combo elementsThe Formlist component now supports Combo and Image Combo controls, using domain elements (as items to choose).ChangedPerformance improved when first opening a subjectWhen opening a subject for the first time in a session, the performance has been improved by loading the subjects' model data in parallel. As background information: A session starts when opening the Universal GUI. This session ends when refreshing or closing the Universal GUI browser tab.Default editable grid performance improvedTo improve the performance of the default editable grid, we changed the way it works. Previously, the Universal GUI was locked until the active row was saved and error-free. This made switching between rows very slow because committing the previous record and then setting the new row in edit mode was a sequence of actions.As of this version, a user can start editing the next row while the previously edited row(s) are still waiting for the commit. If an error occurs in a previous row, the user receives a message and visual help about it but can continue to edit the row they are working on and fix the error later.Filters applied with the 'Enter' key in a Filter componentIn a filter component, you can now apply a filter by pressing [Enter] when focused on a field. Previously, the filter would only apply after removing focus from the field ([Tab]).Minor fixes and tasks For a grid with a row group, double-clicking a row group header would also incorrectly execute the double-click task assigned to a selected record within the group. This has been fixed. Importing records into a detail subject or lookup subject from Excel failed because the data was tried to be imported into the main subject. This has been fixed. When editing in a default editable grid and selecting another record, the grid could scroll unnecessarily. This could result in the edited record not being visible in the current view. This has been fixed. When executing a task on multiple records, the execution order was sometimes incorrect compared to the order in which the records were displayed. This has been fixed. In charts, translated domain elements were not shown. This has been fixed. We fixed a bug where the splitter content width exceeded its limits. Before this release, this could, for example, result in action bar buttons not appearing on the screen: Incorrect action bar buttonsThis has been fixed: Correct action bar buttonsKnown issues in this releaseIn a grid component, editing is always possible, even if you have set the Edit (allowed) setting to No.What we will be working on next sprintThe next sprint we will be working on:Technical research: Deep link to process flow - A deep link to a process flow allows the developer to create links that can be sent via email or otherwise. These links start the Universal GUI and then a process flow. In the technical research, we design the underlying functionality. Activate maps process flow action - This process flow action allows you to activate the Maps component for the user, similar to the Activate grid and Activate form process actions. Activate scheduler process flow action - This process flow action allows you to activate the Scheduler component for the user, similar to the Activate grid and Activate form process actions. Add row in grid - The ability to add a row directly in a pinned top row of a grid. Refresh row functionality - The refresh row option will be supported for tasks and after inserting, updating, or copying a record. UI/UX design for advanced filter popup - The advanced filter option will be available as a popup to all users and offers more complex options than the current filter form. This functionality will become the basis for the user-defined prefilters.

Related products:Universal GUI

Release notes Indicium 2022.2.13

Hello everyone,In this sprint, Indicium can periodically remove unused application models from memory.Furthermore, you can now log to AWS CloudWatch, and the internal OpenAPI specification has been improved.You can read more about Indicium's features in the Indicium user manual.We will keep you updated regularly about Indicium's progress. About IndiciumFor this version, one type of the Thinkwise Indicium Application Tier is available: Indicium: for use with the Universal GUI and via APIs. This version uses the full range of Indicium functionality.Download Indicium release 2022.2.13 here.  Contents of this releaseAbout Indicium Indicium - New Periodic removal of unused application models from memory Logging to AWS CloudWatch Indicium - Changes Indicium OpenAPI specification improved Minor fixes and tasks  Indicium - New Periodic removal of unused application models from memoryIndiciumAs of this release, Indicium can periodically remove unused application models from memory.An application model is considered unused when:It has not received any API calls during the specified time. There has been no active system flow during the specified time. It has not been marked as a preloaded application model.We have added a new configuration option for this feature that you can set in the appsettings.json. Please note that "Applications" is the same configuration section as the "Applications" section mentioned in preloaded application model."Applications": { "RemoveUnusedModelAfterHours": 72}The default (and recommended) value of this setting is 72 hours. This may feel like a long time to keep unused application models in memory, but the goal is not to clear the memory as quickly and often as possible. After all, it is a cache that serves an important purpose. The performance-memory trade-off needs to be considered because once an application model is removed from memory and requested again through an API call, it needs to be loaded from the database, which will be a performance hit on that API call.The main goal of this feature is to ensure that Indicium instances that are rarely restarted, for example, because they are in use 24/7, don't gradually use more and more memory for 'dead' application models that have not been used for weeks.We recommend to lower this value only if all of the points below are true:Indicium is restarted rarely. Many applications are used for a short time within a short time. Indicium's memory usage is noticeably growing to several gigabytes within the 72-hours.Logging to AWS CloudWatchIndiciumWhen running Indicium on AWS, you can now log to AWS CloudWatch. This AWS functionality makes it easier to monitor the behavior and performance of your Indicium instance. For example, you can show the logs on your AWS dashboard or create an alarm based on a log pattern.To enable AWS CloudWatch, add the following code to the appsettings.json configuration file, under the "Logging" section: "AWSCloudWatch": { "LogGroup": "indicium-tst" }To get access to AWS CloudWatch, your EC2 instance needs to have the following policy attached to it:{ "Version": "2012-10-17", "Statement": [ { "Sid": "VisualEditor0", "Effect": "Allow", "Action": "logs:DescribeLogGroups", "Resource": "*" }, { "Sid": "VisualEditor1", "Effect": "Allow", "Action": [ "logs:CreateLogStream", "logs:CreateLogGroup", "logs:PutLogEvents" ], "Resource": "arn:aws:logs:<location>:<account-number>:log-group:indicium-tst:*" } ]}In this code fragment, replace indicium-tst with the name of your log group in appsettings.json and specify your account-number and location.To add the logs to your AWS CloudWatch Dashboard:Open the AWS console. Open the AWS CloudWatch dashboard. Click Add widget. Select Logs table. In Logs Insights, select Log group. This is the name of the log group in appsettings.json. Add the following query to the log to show, for example, the last 20 items:fields @timestamp, @message| sort @timestamp desc| limit 20Click Create widget to show your logs on the dashboard.Indicium - ChangesIndicium OpenAPI specification improvedIndicium In this release, the internal OpenAPI specification has been improved. This API specification can be used by a third-party code generation tool like NSwagStudio or Swagger to call or to display the Indicium API. These third-party tools can then generate higher quality code with improved readability.Minor fixes and tasksIndicium Filter conditions containing a negation (for example, not equal to, does not start with, does not contain) were not handled correctly. For example, the condition <some_column> not equal to 1  would result in false when <some_column> was NULL. This has been fixed.

Related products:Indicium Service Tier

Release notes Universal GUI (2022.2.12.0)

 August 26, 2022:Changed beta release to the full version: 2022.2.12.0 Improvements for issues found in the previous beta release: In the Preview component, images that were too large for the available space were not displayed. In the Preview component, TXT and JSON files were not displayed. Both issues have been fixed.  Hello everyone,As of this sprint, passwords will no longer be shown in plain text in the GUI. Instead, we have added a visibility icon to the PASSWORD control. We have also added a change detector to the Preview component and improved the way incoming process flows work.In these release notes you will find a full overview of these main features and all minor features and tasks.As always, we have made a demo for you: try it here. Before trying it out, press 'Clear Cache' on the login screen. You can read the GUI user manual to get familiar with the Universal GUI.We will keep you updated regularly about Universal's progress. Universal GUI version 2022.2.12.0Do not forget the documentation and be sure to keep the following in mind:A modern browser is required to access the Universal GUI, e.g., a recent version of Chrome, Firefox, Edge, or Safari mobile. Using the Universal GUI with IE is not supported. The Universal GUI must be deployed on the same server as Indicium or an allowed origin in appsettings.json. The Universal GUI only works with version 2021.1 and up of the Thinkwise Platform. Make sure you run all hotfixes on the IAM and SF that you plan to use for the Universal GUI. Make sure you are using the latest version of Indicium Universal.Download the Universal GUI version 2022.2.12.0 here Contents of this releaseUniversal GUI version 2022.2.12.0 New Password visibility Version recorded in IAM Changed Smart remote file change detection for preview component Incoming process flow allowed Minor fixes and tasks Known issues in this release What we will be working on next sprint New Password visibilityIn password control fields, passwords will no longer be shown in plain text in the GUI. A user can now use the 'visibility' icon to hide the password from view or display it in plain text. The PASSWORD control is set for a column at the domain level. It is available in grid, form, and card list components.When a password field is non-editable or read-only, the visibility icon is hidden, and the number of characters is set to 8 instead of revealing the password length.CautionPasswords are not sent or stored encrypted, so this feature only protects against being displayed in plain text.A user can display or hide their password Version recorded in IAMAfter loading the application, the used Universal GUI version will now be recorded in IAM. Changed Smart remote file change detection for preview componentThe Preview component will now check whether the previewed file has been changed remotely. A check occurs when a user manually refreshes the document or the subject's data is updated due to another cause. If the content of a previewed file has been changed remotely, it will be reloaded.This is only available for File type preview columns. URL type columns will show the content from the given web address as is. Incoming process flow allowedIf a process flow was running and a new flow came in for the same subject, the Universal GUI used to ignore the incoming flow. From now on, it will stop the running flow and start the incoming flow.This change also fixes that a new process flow could not start when another process flow got stuck due to an action that was unable to execute. In the next sprint, we will continue our work on preventing stuck process flows. Minor fixes and tasksIn a Maps component with markers and popups, when you moved the position of the map and changed it to a different record, the map would not center correctly on the marker. This has been fixed. The process flow was not started when using a process flow to set filters in combination with the Start empty with filter setting. This has been fixed. When clicking on a field in a default editable grid, it did not get the focus. You had to click it again to start editing. Universal GUI will now put the focus on the field you actually clicked. One limitation: a cursor_to_col will always be performed in the form. When dragging events in the resource scheduler, sometimes duplicate events would be created. These were not stored in the database since they would be gone after closing and reopening the subject. This issue happened when auto-refresh had been enabled, and the user dragged an event during an auto-refresh. It has been fixed now. If the active record changed in the resource scheduler, the scheduler would jump to the current date. Now, the scrollbar will stay in the same position. We have improved the performance when switching to an already opened subject or an already opened detail tab. When expanding a cube row based on elements, the Universal GUI would give a bad request. This has been fixed. We have resolved an error shown in snack bar messages when navigating between records in a detail subject with another detail subject underneath. Because of this error, the lowest set would not refresh. We have resolved a crash that occurred after opening an application with a task as a start object. Known issues in this releaseSometimes, when a pivot is opened for the first time it shows no data and the text 'This pivot type is not supported'. What we will be working on next sprintThe next sprint we will be working on:Add row in grid - The ability to add a row directly in the grid. Refresh row update strategy. Activate Maps and Scheduler components from a process flow Scheduler component remembers time scale selected by the user.

Related products:Universal GUI

Release notes Indicium 2022.2.12

Hello everyone,In this sprint, we have added support for environment variables in File System storage configurations.We have also improved model loading in general and for system flows specifically.You can read more about Indicium's features in the Indicium user manual.We will keep you updated regularly about Indicium's progress. About IndiciumTwo types of the Thinkwise Indicium Application Tier are available: Indicium Basic: for use with the Windows GUI and Mobile GUI. This basic version does not support, for example, system flows and OpenID.Download Indicium Basic release 2022.2.12 here. Indicium: for use with the Universal GUI and via APIs. This version uses the full range of Indicium functionality.Download Indicium release 2022.2.12 here.  Contents of this releaseAbout Indicium Indicium - New Support for environment variables in File System storage configurations Indicium - Changes Improved model loading Minor fixes and tasks Indicium - New Support for environment variables in File System storage configurationsIndiciumFile system storage configurations now support environment variables in their base path (for example, %TEMP%). These variables are also supported by process actions that use these file system storage configurations.ExampleD:\files\%FileLocation%\file.txtwhere %FileLocation% is, for example, thinkwise/textfiles. Indicium - Changes Improved model loadingIndiciumIn this release, we have tremendously improved the loading of application models.If multiple applications (IAM) or runtime configurations (Software Factory) are based on the same project and project version, the application model will only be present in memory once.  The only exceptions are those parts of the application model that can be overridden per application or runtime configuration, such as storage configurations or extended properties. Application models containing Azure/AWS/FTP storage configurations that are used many times across different columns, task/report parameters, and process variables will load significantly faster now. On adding an extended property or overriding a storage/OAuth configuration for an application or runtime configuration, Indicium will no longer refresh the entire application model. Minor fixes and tasksIndicium We fixed an issue where a process flow would not start correctly if the start action was a Start table task or Start table report on a variant. Indicium Indicium Basic We fixed an issue for DevExpress reports where parameters could not intentionally be left or set to null even if "Allow null values" had been turned on for said parameter. Indicium  We have fixed an issue regarding user provisioning and claim types with multiple values. When an Identity Provider supplied an array of claim values for a single claim type, Indicium would only send the first of these values to IAM for user provisioning. An example of this for Azure AD is the "groups" claim, which can contain an array of GUIDs, one for each group of which the user is a part. These claims will now be sent correctly to IAM as a JSON array.

Related products:Indicium Service Tier

Release notes Universal GUI 2022.2.12 BETA

Hello everyone,As of this sprint, passwords will no longer be shown in plain text in the GUI. Instead, we have added a visibility icon to the PASSWORD control. We have also added a change detector to the Preview component and improved the way incoming process flows work.In these release notes you will find a full overview of these main features and all minor features and tasks.As always, we have made a demo for you: try it here. Before trying it out, press 'Clear Cache' on the login screen. You can read the GUI user manual to get familiar with the Universal GUI.We will keep you updated regularly about Universal's progress. Universal GUI version 2022.2.12 BETADo not forget the documentation and be sure to keep the following in mind:A modern browser is required to access the Universal GUI, e.g., a recent version of Chrome, Firefox, Edge, or Safari mobile. Using the Universal GUI with IE is not supported. The Universal GUI must be deployed on the same server as Indicium or an allowed origin in appsettings.json. The Universal GUI only works with version 2021.1 and up of the Thinkwise Platform. Make sure you run all hotfixes on the IAM and SF that you plan to use for the Universal GUI. Make sure you are using the latest version of Indicium Universal.Download the Universal GUI version 2022.2.12 hereThis is a beta release, which can be used to test the new features. This release is not suitable for use in a production environment. The full release will be available this Friday. Contents of this releaseUniversal GUI version 2022.2.12 BETA New Password visibility Version recorded in IAM Changed Smart remote file change detection for preview component Incoming process flow allowed Minor fixes and tasks Known issues in this beta release What we will be working on next sprint New Password visibilityIn password control fields, passwords will no longer be shown in plain text in the GUI. A user can now use the 'visibility' icon to hide the password from view or display it in plain text. The PASSWORD control is set for a column at the domain level. It is available in grid, form, and card list components.When a password field is non-editable or read-only, the visibility icon is hidden, and the number of characters is set to 8 instead of revealing the password length.CautionPasswords are not sent or stored encrypted, so this feature only protects against being displayed in plain text.A user can display or hide their password Version recorded in IAMAfter loading the application, the used Universal GUI version will now be recorded in IAM. Changed Smart remote file change detection for preview componentThe Preview component will now check whether the previewed file has been changed remotely. A change occurs when a user manually refreshes the document or the subject's data is updated due to another cause. If the content of a previewed file has been changed remotely, it will be reloaded.This is only available for File type preview columns. URL type columns will show the content from the given web address as is. Incoming process flow allowedIf a process flow was running and a new flow came in for the same subject, the Universal GUI used to ignore the incoming flow. From now on, it will stop the running flow and start the incoming flow.This change also fixes that a new process flow could not start when another process flow got stuck due to an action that was unable to execute. In the next sprint, we will continue our work on preventing stuck process flows. Minor fixes and tasksIn a Maps component with markers and popups, when you moved the position of the map and changed it to a different record, the map would not center correctly on the marker. This has been fixed. The process flow was not started when using a process flow to set filters in combination with the Start empty with filter setting. This has been fixed. When clicking on a field in a default editable grid, it did not get the focus. You had to click it again to start editing. Universal GUI will now put the focus on the field you actually clicked. One limitation: a cursor_to_col will always be performed in the form. When dragging events in the resource scheduler, sometimes duplicate events would be created. These were not stored in the database since they would be gone after closing and reopening the subject. This issue happened when auto-refresh had been enabled, and the user dragged an event during an auto-refresh. It has been fixed now. If the active record changed in the resource scheduler, the scheduler would jump to the current date. Now, the scrollbar will stay in the same position. We have improved the performance when switching to an already opened subject or an already opened detail tab. When expanding a cube row based on elements, the Universal GUI would give a bad request. This has been fixed. We have resolved an error shown in snack bar messages when navigating between records in a detail subject with another detail subject underneath. Because of this error, the lowest set would not refresh. We have resolved a crash that occurred after opening an application with a task as a start object. Known issues in this beta releaseImage preview does not show images that are higher or wider than the available space (and require scrollbars). Sometimes, when a pivot is opened for the first time it shows no data and the text 'This pivot type is not supported'. What we will be working on next sprintThe next sprint we will be working on:Add row in grid - The ability to add a row directly in the grid. Refresh row update strategy.

Related products:Universal GUI

Release notes Universal GUI (2022.2.11.0)

 August 5, 2022:Changed beta release to the full version: 2022.2.11.0 Improvements for issues found in the previous beta release: When selecting multiple records in a grid and then clicking a task button, only the active row was displayed as part of the selection. The task was still executed for all selected records, but this was unclear to users. This has been fixed. The selection remains visible until the task is executed.  Hello everyone,In this sprint, we made it possible to resize grid columns, and when opening the scheduler component, the displayed period now starts from the previous month instead of the current day.As always, we have made a demo for you: try it here. Before trying it out, press 'Clear Cache' on the login screen. You can read the GUI user manual to get familiar with the Universal GUI.We will keep you updated regularly about Universal's progress.Universal GUI version 2022.2.11.0Do not forget the documentation and be sure to keep the following in mind:A modern browser is required to access the Universal GUI, e.g., a recent version of Chrome, Firefox, Edge, or Safari mobile. Using the Universal GUI with IE is not supported. The Universal GUI must be deployed on the same server as Indicium or an allowed origin in appsettings.json. The Universal GUI only works with version 2021.1 and up of the Thinkwise Platform. Make sure you run all hotfixes on the IAM and SF that you plan to use for the Universal GUI. Make sure you are using the latest version of Indicium Universal.Download the Universal GUI version 2022.2.11.0 here  Contents of this releaseUniversal GUI version 2022.2.11.0 New Resizable grid columns Changed Displayed period in Scheduler component Minor fixes and tasks What we will be working on next sprintNewResizable grid columnsYou can now resize grid columns and change the column width manually. The column widths are retained after closing and reopening a document and after a refresh.ChangedDisplayed period in Scheduler componentWhen opening the Scheduler component, the displayed period started with the current day. If you wanted to view the previous week, you had to navigate back. This behavior was not desired. As of this version, when opening the scheduler component, the displayed period starts from the previous month.Minor fixes and tasksIn certain time zones (for example, GMT-12), when choosing a date using the date picker icon, for example, July 28th, an incorrect date value (July 27th) was used. This has been fixed. In default edit mode, when a user did not modify the record, they had to cancel edit mode before executing a task or report. This has been fixed. Now, when executing a task or report, edit mode is automatically canceled if the user has not modified the record. After adding or copying a record, the edit, delete, and copy buttons were available too early. This would result in a "bad request" message when quickly trying to perform any of these actions after adding or copying. These three buttons are now disabled until they can be used. When executing a task containing a file upload, the application could stop responding. This has been fixed. When a parent grid was in edit mode, it was incorrectly allowed to switch between rows in a child subject. When a child subject was in edit mode, it was also incorrectly allowed to switch rows in the parent grid. This has been fixed. In both cases, switching between rows is no longer allowed. Loading lookup translations used to fail if there were 800 or more filter conditions. This situation could occur, for example, if there were 800 rows with only one primary key or 400 records with two primary keys. This has been fixed by splitting the lookup translations into multiple requests if there are many filter conditions.What we will be working on next sprintIn the next sprint, we will be working on: Ensure that a new process flow always starts. This prevents the user from getting stuck in an old process flow. Asynchronous editing in grids. New Password control. Research performance rendering nested details. In progress: Drag and drop records UI/UX.

Related products:Universal GUI

Release notes Indicium (2022.2.11.0)

Hello everyone,In this sprint, we updated Indicium to .NET 6. Furthermore, you can now use Windows command tasks to open URIs in the Universal GUI, and use the Print File process action to print PDF files on a Windows platform.You can read more about Indicium's features in the Indicium user manual.We will keep you updated regularly about Indicium's progress. About IndiciumTwo types of the Thinkwise Indicium Application Tier are available: Indicium Basic: for use with the Windows GUI and Mobile GUI. This basic version does not support, for example, system flows and OpenID.Download Indicium Basic release 2022.2.11.0 here.   Indicium: for use with the Universal GUI and via APIs. This version uses the full range of Indicium functionality.Download Indicium release 2022.2.11.0 here.  Contents of this releaseAbout Indicium Breaking Update to .NET 6 Thinkwise Platform support release 2020.2 is ending Indicium Print File process action supported Use Windows command tasks to open URIs Minor fixes and tasks BreakingUpdate to .NET 6As of this version, Indicium requires .NET 6. This requirement aligns with the .NET lifecycle policy and ensures that you receive security updates.Important: To run Indicium Universal on IIS, you must install the ASP.NET  Core Runtime 6.0.7 Hosting Bundle: https://dotnet.microsoft.com/en-us/download/dotnet/6.0 Thinkwise Platform support release 2020.2 is endingIn accordance with our Lifecycle policy, Indicium support for Thinkwise Platform release 2020.2 is ending. Please upgrade to at least release 2021.1 to use this release of Indicium.IndiciumPrint File process action supportedAs of this release, Indicium supports the 2022.2 Print File process action.Please note that currently, you can only print files in PDF format on a Windows platform, and the printer must be installed on the web server.Use Windows command tasks to open URIsYou can now use Windows command tasks to open URIs in the Universal GUI, as follows: In the Task logic type field, specify 'Windows command':   In the Object name field, specify the URI to open:   When executing this task in the Universal GUI, the corresponding URI is opened in the browser. You can also use dynamic URIs via task parameters.Please refer to the Thinkwise documentation for more information about Windows Command tasks, with the following limitations:This implementation only supports opening URIs and not executing Windows commands. Windows command tasks cannot be used in process flows.Minor fixes and tasksIn a database storage configuration, the BLOB data column was not always cleared when clearing the corresponding file column. This has been fixed.

Related products:Indicium Service Tier

Release notes Universal GUI (2022.2.11 BETA)

Hello everyone,In this sprint, we made it possible to resize grid columns, and when opening the scheduler component, the displayed period now starts from the previous month instead of the current day.As always, we have made a demo for you: try it here. Before trying it out, press 'Clear Cache' on the login screen. You can read the GUI user manual  to get familiar with the Universal GUI.We will keep you updated regularly about Universal's progress.Universal GUI version 2022.2.11 BETADo not forget the documentation  and be sure to keep the following in mind:A modern browser is required to access the Universal GUI, e.g., a recent version of Chrome, Firefox, Edge, or Safari mobile. Using the Universal GUI with IE is not supported. The Universal GUI must be deployed on the same server as Indicium or an allowed origin in appsettings.json. The Universal GUI only works with version 2021.1 and up of the Thinkwise Platform. Make sure you run all hotfixes on the IAM and SF that you plan to use for the Universal GUI. Make sure you are using the latest version of Indicium Universal.Download the Universal GUI version 2022.2.11 BETA here  This is a beta release, which can be used to test the new features. This release is not suitable for use in a production environment. The full release will be available this Friday. Contents of this releaseUniversal GUI version 2022.2.11 BETA New Resizable grid columns Changed Displayed period in Scheduler component Minor fixes and tasks What we will be working on next sprintNewResizable grid columnsYou can now resize grid columns and change the column width manually. The column widths are retained after closing and reopening a document and after a refresh.ChangedDisplayed period in Scheduler componentWhen opening the Scheduler component, the displayed period started with the current day. If you wanted to view the previous week, you had to navigate back. This behavior was not desired. As of this version, when opening the scheduler component, the displayed period starts from the previous month.Minor fixes and tasksIn certain time zones (for example, GMT-12), when choosing a date using the date picker icon, for example, July 28th, an incorrect date value (July 27th) was used. This has been fixed. In default edit mode, when a user did not modify the record, they had to cancel edit mode before executing a task or report. This has been fixed. Now, when executing a task or report, edit mode is automatically canceled if the user has not modified the record. After adding or copying a record, the edit, delete, and copy buttons were available too early. This would result in a "bad request" message when quickly trying to perform any of these actions after adding or copying. These three buttons are now disabled until they can be used. When executing a task containing a file upload, the application could stop responding. This has been fixed. When a parent grid was in edit mode, it was incorrectly allowed to switch between rows in a child subject. When a child subject was in edit mode, it was also incorrectly allowed to switch rows in the parent grid. This has been fixed. In both cases, switching between rows is no longer allowed. Loading lookup translations used to fail if there were 800 or more filter conditions. This situation could occur, for example, if there were 800 rows with only one primary key or 400 records with two primary keys. This has been fixed by splitting the lookup translations into multiple requests if there are many filter conditions.What we will be working on next sprintIn the next sprint, we will be working on: Ensure that a new process flow always starts. This prevents the user from getting stuck in an old process flow. Asynchronous editing in grids. New Password control. Research performance rendering nested details. In progress: Drag and drop records UI/UX.

Related products:Universal GUI

🚀 Platform improvements for week 29

Hi everyone!We’ve released the following platform improvements this week:SF 2022.2 Correction in upgrade script: renamed icons with duplicate names not reconnected to their objects During the upgrade to the 2022.2, all icons are placed in the new icon repository. After this, the icon is reconnected again to its corresponding objects. A problem occurred in the upgrade code that reconnects those icons having duplicate names to their corresponding objects. This resulted in these objects losing their icon. This has been fixed in the Upgrade script. Unfortunately, existing installations can not be fixed retroactively. In case you haven't started using the 2022.2, it is advised to redownload the Installation package from TCP. Otherwise, the affected objects should be manually linked to the correct icon again. We apologize for any inconvenience this may cause. 20220718 - Default database collation for new temp tables In the 2022.2 release, the code responsible for generating source code has been extended with two new temporary tables. These tables were not provided with a default database collation, which could result in an error while generating source code when the collation of the temp table was different from the collation of the database. This has now been fixed. 20220721 - Correct path for imported projects Used folder and file specification paths for Thinkwise base projects have been revised as there was a mismatch between them. This has been resolved. SF 2022.1 20220721 - Unlock imported project version before updates Due to locking the imported project version during the import of a model.dat file, some triggers did not trigger as intended. The project version will now be unlocked before these update statements.

Related products:Software FactoryIntelligent Application Manager

Release notes Universal GUI (2022.2.10.0)

 July 15, 2022:Changed beta release to the full version: 2022.2.10.0 Improvements for issues found in the previous beta release: In grids, the left and right arrow keys to switch between cells and the up and down arrow keys to switch between rows did not work. This has been fixed.  Hello everyone,In this sprint, among other things, we completed support for the Download file process action, and users can see the date and time in their local time zone. Furthermore, we now support vertical tabs, and we have improved the styling of read-only controls.As always, we have made a demo for you: try it here. Before trying it out, press 'Clear Cache' on the login screen. You can read the GUI user manual to get familiar with the Universal GUI.We will keep you updated regularly about Universal's progress.Universal GUI version 2022.2.10.0Do not forget the documentation  and be sure to keep the following in mind:A modern browser is required to access the Universal GUI, e.g., a recent version of Chrome, Firefox, Edge, or Safari mobile. Using the Universal GUI with IE is not supported. The Universal GUI must be deployed on the same server as Indicium or an allowed origin in appsettings.json. The Universal GUI only works with version 2019.2 and up of the Thinkwise Platform. Make sure you run all hotfixes on the IAM and SF that you plan to use for the Universal GUI. Make sure you are using the latest version of Indicium Universal.Download the Universal GUI version 2022.2.10.0 here  Contents of this releaseUniversal GUI version 2022.2.10.0 New Thinkwise Platform release 2022.2 support Subject variants support Process flow action: download file Process flow action: send user notification Display the date and time in the time zone of a user Vertical tabs Changed Improved styling of read-only controls Start empty with filter functionality Minor fixes and tasks What we will be working on next sprintNewThinkwise Platform release 2022.2 supportWe are currently working on support for:Activate Maps process action. Activate Scheduler process action. Play a sound after a message popups up.We have already completed support for:Subject variants (see below). Process flow action: download file (see below). Process flow action: send user notification (see below). Display the date and time in the time zone of a user (see below).Subject variants supportAs of Thinkwise Platform version 2022.2, Indicium can handle subject variants and variant-specific settings from the Software Factory. For example:Provide default values while editing. Apply the correct set of prefilters. Apply process flow rights. Use the correct set of columns in a combined filter.The current Universal GUI 2022.2.10.0 release informs Indicium which subject variant is involved in a user action. This makes the Universal GUI release dependent on the 2022.2.10 release of Indicium:If you install this Universal 2022.2.10.0 release, you must also install the Indicium 2022.2.10 release.Process flow action: download fileAs of Thinkwise Platform release 2022.2, the Universal GUI supports the new Download file process flow action.You can set process variables and use them in the input parameters to make a file available for download to the end-user. The file can originate, for example, from a database, or from file storage using a Read file connector, or it can be the result of a Generate report connector.Process flow action: send user notificationAs of Thinkwise Platform version 2022.2, a user can send a notification message to a specific user from a process flow. The Universal GUI receives this notification after the next request to Indicium and displays this notification as a snack bar message at the bottom of the screen.Display the date and time in the time zone of a userAs of Thinkwise Platform version 2022.2, a user will be able to see the date and time in their local time zone. The Universal GUI will support this.You can enable the local time zone for users in a control. When you select a control for a domain that shows a DateTime value, you can choose whether it should display the time for the user's current time zone or as stored in the database (Software Factory > menu Data > Domains > tab Form).The time zone for a new user will be set to Etc/UTC by default but can be changed in IAM, in menu Authorization > Users > tab Form > tab User > group User preferences > field Time zone.Vertical tabsThe Universal GUI now supports a new type of tabs called vertical tabs. This gives a new look to your screen types and looks like a small submenu within the related subject. The list of tabs that would by default appear horizontally side by side can now be displayed stacked on top of each other.To convert a (horizontal) tab panel in the Tab container component of a screen type to a vertical tab panel, change the Tab orientation property in the screen type modeler in the Software Factory to Vertical:(menu User interface > Screen types > tab Design. The Tab page properties are on the right-hand side.) Tab orientation property in the screen type modeler  Horizontal tabs example  Vertical tabs exampleKnown issue: If a vertical tab label is too long and cut off by ellipsis (...), a badge behind it, as shown in the EMAILS tab in the screenshot, will not be displayed.ChangedImproved styling of read-only controlsWe improved the styling of read-only controls: In a form, a control's background color can be affected by a Conditional layout. If no conditional text color is specified, the displayed value now has a contrasting color. The control label already behaves like this. When the control is disabled, the opacity of the contrast color is reduced so the value appears slightly gray. On a form component in edit mode, read-only fields were not consistently grayed out, making them appear editable. That has been corrected, so all read-only fields look the same now.  Name field before Name field afterStart empty with filter functionalityThe existing Start empty with filter option specifies that subjects are opened without data, and the filter pop-up is activated automatically. This configuration option was applied to main subjects and detail subjects. However, this functionality is unnecessary for detail subjects, as a detail already shows a limited list of records. As of this version, the Start empty with filter option will only be applied to the main subject.Minor fixes and tasksWhen adding a record in a non-editable grid, with Form and detail subjects on a separate tab, the Form tab was activated and incorrect detail data were displayed in some cases. This has been fixed.What we will be working on next sprintIn the next sprint, we will be working on: Asynchronous editing in a grid - To improve grid edit mode performance, we plan to have multiple records in edit mode behind the scenes. This allows the user to proceed while records are being saved in the background. Resizable grid columns - Users can resize the grid column width. Formlist domain control - Implementation of the domain control in the Formlist. Password control In progress: Drag and drop records UI/UX. Add row in grid.

Related products:Universal GUI

Release notes Thinkwise Upcycler 2022.2

Hello everyone,In this release, we have added steps to enrich your upcycled project, new technical Upcyclers, and extractors for Oracle and MySQL. In addition, it is now mandatory to enter a reason when you add a step or a variation to a technology or application. We have also added a default value for the application database server and name, made some changes and solved some issues.You can download the latest version of the Upcycler in TCP.  ContentsContents Requirements New Enrich your upcycled project Upcyclers and extractors for Oracle and MySQL Mandatory reason for creating (variation on) a step Default values for the application database server and name Changed Fields and tabs hidden when irrelevant DB2 Upcycler and extractor enhanced Minor fixes and tasks New and changed in Upcycle steps Upcycle step 2000 Source model loader Upcycle step 3000 Cleaner: Remove logicals Upcycle step 3400 Cleaner: Object identifiers Upcycle step 3500 Cleaner: Expression defaults Upcycle step 4500 Pre-processor: Assign new domains Upcycle step 5110 Transform Check constraints Upcycle step 5260 Fix: Code for changed table names Upcycle step 5261 Fix: Code for changed column names Upcycle step 5050 Transform Domains Upcycle step 5300 Transform List bar items Upcycle step 5400 Transform Transl objects Upcycle step 5410 Transform Transl objects Upcycle steps 6000-6999 Prepare data Upcycle step 7600 Update: Remove superfluous domains Data import step 1000 Drop temporary tables Data import step 2000 Source Model Loader Data import step 5000 Migrate to SF schema Data import step 6000 Create transfer steps Data model changes New tables Renamed tables Column changes  RequirementsSoftware Factory 2022.2 or higher is required. New Enrich your upcycled projectAfter you have created your application and imported data, you can now enhance your application with several enrichments, if necessary.To support you in this step, Enrichment runs are available.Enrichments are a way to automatically enhance an application.Some examples are to put an EMAIL control on all columns containing an email address, add a row count to the first column in a grid, or set main screen typesfor tables.These and many more enrichments are available by default.If they do not suffice, you can create variations on existing ones at the technology or application level or create your own.The enrichment process consists of two phases.First, you need to execute an analysis run. This run inspects both the model and data and produces a list of proposed actions. The proposed actions can contain updates to both the model and the data. Next, you can review the list, select the actions you wish to apply and execute the action run.The analysis run in the enrichment procesThe action run in the enrichment proces Upcyclers and extractors for Oracle and MySQLIn this version, we have added Upcyclers and extractors for Oracle and MySQL. Mandatory reason for creating (variation on) a stepWhen you add a step or a variation on a step to a technology or application, it is now mandatory to enter a Reason. This will highly improve the reporting of your Upcyclers.When upgrading your Upcycler with this version, the new field is filled with a default value.You can find the Reason fields in:menu Upcycle > Upcycle runs > tab Application upcycle steps > tab Form menu Upcycle > Data import runs > tab Application data import steps > tab Form menu Definition > Technology Upcyclers > tab Technology upcycle steps > tab Form menu Definition > Technology Upcyclers > tab Technology data import steps > tab Form. Default values for the application database server and nameWe have added default values for the application database server and name.The default value for the application database server is the current server (menu Upcycle > Applications > tab Form > field Application database server).The default value for the application database name is the application's name, in uppercase, with the illegal characters replaced (menu Upcycle > Applications > tab Form > field Application database server). Changed Fields and tabs hidden when irrelevantTo make it easier to find what you are looking for, some fields and tabs are now hidden when they are irrelevant. An example is the Transfer code. DB2 Upcycler and extractor enhancedThe DB2 Upcycler has been enhanced. It now generates descriptions and translations for tables and columns, and it no longer creates Views for DB2 Logicals.The DB2 Extractor has been enhanced to extract translations for tables and columns. Minor fixes and tasksThe default value for encoding model and data files when adding a new technology was UTF-16. Since the Extractor produces UTF-8 BOM files, the default has been changed to UTF-8 BOM. In the Technology Upcyclers, the encoding of model and data files was UTF-16. This has been changed to UTF-8 (already available in a hotfix). The Transfer code tab was editable (menu Upcycler > Data import runs > tab Application > tab Executed data import steps > tab Transfer code). This has been fixed. Data import runs would not start. The flow `system_execute_import_data_run` was not set to active in IAM (already available in a hotfix). New and changed in Upcycle steps Upcycle step 2000 Source model loaderWe have added loading of the extracted translations for DB2.Step New or changed Generic step Unchanged Variation for DB2 for iSeries Added: loading translations Variation for PostgreSQL Generic Variation for Progress OpenEdge Unchanged Variation for SQL Server Generic Variation for Uniface Unchanged  Upcycle step 3000 Cleaner: Remove logicalsWe have added a specific step for DB2.Step New or changed Generic step Not applicable Variation for DB2 for iSeries Specific. Stop DB2 Logicals from becoming Views Variation for PostgreSQL Not applicable Variation for Progress OpenEdge Not applicable Variation for SQL Server Not applicable Variation for Uniface Not applicable  Upcycle step 3400 Cleaner: Object identifiersIn Software Factory release 2022.2, the maximum length for an object name (for example, a table or a column) has been increased to 128.Step New or changed Generic step Changed Variation for DB2 for iSeries Generic Variation for PostgreSQL Generic Variation for Progress OpenEdge Added Variation for SQL Server Changed Variation for Uniface Changed  Upcycle step 3500 Cleaner: Expression defaultsIn MS SQL Server, the built-in functions newid(), newsequentialid(), rand() and textprt() are not allowed in a user-defined function. The Software Factory generates user-defined functions for expression defaults. Therefore, table creation will fail when column defaults that contain these built-in functions have been upcycled.As of Software Factory release 2022.2, an expression default that contains the function newid() is generated as default on the column, instead of a user-defined function, so the creation of the table does not fail. This used to be a Generic step, but it was for MS SQL Server specifically. This has been rectified.The Upcyclers have been updated accordingly.Step New or changed Generic step Removed Variation for DB2 for iSeries Implicitly removed Variation for PostgreSQL Implicitly removed Variation for Progress OpenEdge Was deactivated, now removed Variation for SQL Server Updated and now a Technology specific step Variation for Uniface Was deactivated, now removed  Upcycle step 4500 Pre-processor: Assign new domainsWe have made a small improvement to the coding of this step.Step New or changed Generic step Changed Variation for DB2 for iSeries Generic Variation for PostgreSQL Generic Variation for Progress OpenEdge Still deactivated Variation for SQL Server Generic Variation for Uniface Still deactivated  Upcycle step 5110 Transform Check constraintsIn Software Factory release 2022.2, the maximum length for a check constraint has been removed. It used to be 4000. The check on that length in this step has been removed.In MS SQL Server, the code of a check constraint is in round brackets. This is specific to this technology.Step New or changed Generic step Changed Variation for DB2 for iSeries Removed Variation for PostgreSQL Changed Variation for Progress OpenEdge Generic Variation for SQL Server Added Variation for Uniface Still deactivated  Upcycle step 5260 Fix: Code for changed table namesThe Upcycler changes the name of a table if it contains illegal characters, is too long, or when it occurs in multiple schemas. These changes are also made in all the upcycled code as a 'best effort' action.This step is now slightly more ‘aggressive’ to get a better balance between automatic changes and manual corrections. It now also processes the check constraints.Step New or changed Generic step Changed Variation for DB2 for iSeries Still deactivated Variation for PostgreSQL Generic Variation for Progress OpenEdge Still deactivated Variation for SQL Server Generic Variation for Uniface Still deactivated  Upcycle step 5261 Fix: Code for changed column namesThe Upcycler changes the column name if it contains illegal characters or if it is too long. Now, the column name is also changed in all the upcycled code as a 'best effort' action. This new step processes the control procedure templates and the check constraints.Step New or changed Generic step Added Variation for DB2 for iSeries Still deactivated Variation for PostgreSQL Generic Variation for Progress OpenEdge Still deactivated Variation for SQL Server Generic Variation for Uniface Still deactivated  Upcycle step 5050 Transform DomainsFor MS SQL Server, we have added the transformation of datatype rowversion.Step New or changed Generic step Unchanged Variation for DB2 for iSeries Unchanged Variation for PostgreSQL Unchanged Variation for Progress OpenEdge Still deactivated Variation for SQL Server Changed Variation for Uniface Unchanged  Upcycle step 5300 Transform List bar itemsThe Generic step has been improved, so it will also work for Oracle and Progress OpenEdge.Step New or changed Generic step Changed Variation for DB2 for iSeries Still generic Variation for PostgreSQL Still generic Variation for Progress OpenEdge Now generic Variation for SQL Server Still generic Variation for Uniface Unchanged  Upcycle step 5400 Transform Transl objectsWe have added table and column translations for DB2.Step New or changed Generic step Not applicable Variation for DB2 for iSeries Table and column translations Variation for PostgreSQL Not applicable Variation for Progress OpenEdge Not applicable Variation for SQL Server Not applicable Variation for Uniface Not applicable  Upcycle step 5410 Transform Transl objectsWe have added table and column translations for DB2. This step also fills the descriptions for tables and columns.Step New or changed Generic step Not applicable Variation for DB2 for iSeries Table and column translations Variation for PostgreSQL Not applicable Variation for Progress OpenEdge Not applicable Variation for SQL Server Not applicable Variation for Uniface Not applicable  Upcycle steps 6000-6999 Prepare dataTo ease the development of new Upcyclers, the Generic steps have been improved so it is no longer necessary to deactivate and activate the steps while you are incrementally developing an Upcycler.Step New or changed Generic step Changed Variation for DB2 for iSeries Still generic Variation for PostgreSQL Still generic Variation for Progress OpenEdge Now, all Prepare steps are generic Variation for SQL Server Still generic Variation for Uniface Unchanged  Upcycle step 7600 Update: Remove superfluous domainsThe Generic step has been improved so it will also work for Uniface.Step New or changed Generic step Changed Variation for DB2 for iSeries Still generic Variation for PostgreSQL Still generic Variation for Progress OpenEdge Still generic Variation for SQL Server Still generic Variation for Uniface Now generic  Data import step 1000 Drop temporary tablesThis step was not necessary and has been removed.Step New or changed Generic step Removed Variation for DB2 for iSeries Was generic, so automatically removed Variation for PostgreSQL Was generic, so automatically removed Variation for Progress OpenEdge Removed Variation for SQL Server Was generic, so automatically removed Variation for Uniface Removed  Data import step 2000 Source Model LoaderWe have added the column is_nullable when loading columns, to make it possible for the MySQL Upcycler to use the generic step.Step New or changed Generic step Changed Variation for DB2 for iSeries Generic Variation for PostgreSQL Generic Variation for Progress OpenEdge Unchanged Variation for SQL Server Generic Variation for Uniface Unchanged  Data import step 5000 Migrate to SF schemaWe have added the column is_nullable when loading columns, to make it possible for the MySQL Upcycler to use the generic step.Step New or changed Generic step Changed Variation for DB2 for iSeries Generic Variation for PostgreSQL Generic Variation for Progress OpenEdge Unchanged Variation for SQL Server Generic Variation for Uniface Unchanged  Data import step 6000 Create transfer stepsWhen importing data, it is not possible to insert a value in a column of types timestamp or rowversion.Step New or changed Generic step Changed Variation for DB2 for iSeries Generic Variation for PostgreSQL Generic Variation for Progress OpenEdge Generic Variation for SQL Server Generic Variation for Uniface Unchanged   Data model changesData model changes for the Thinkwise Upcycler meta-model are listed here. New tablesNew tables application_enrichment_analysis_step enrichment_run enrichment_run_action_step enrichment_run_analysis_step generic_enrichment_analysis_step hotfix last_agent_check_in technology_enrichment_analysis_step  Renamed tablesFrom table To table application_step application_upcycle_step generic_step generic_upcycle_step technology_step technology_upcycle_step  Column changesTable From column To column application_import_data_step - reason application_upcycle_step application_step_id application_upcycle_step_id application_upcycle_step generic_step_id generic_upcycle_step_id application_upcycle_step technology_step_id technology_upcycle_step_id application_upcycle_step - reason generic_upcycle_step generic_step_id generic_upcycle_step_id import_data_run - appl_lang_id import_data_run - data_db_name import_data_run - data_db_server import_data_run - data_file_encoding import_data_run - data_file_extension import_data_run - data_file_typ import_data_run - project_folder_spec import_data_run - project_id import_data_run - project_vrs_id import_data_run - sf_db_name import_data_run - sf_db_server import_data_run - import_data_run_error_text import_data_run - import_data_run_status import_data_run started_at import_data_started_at import_data_run ended_at import_data_ended_at technology_import_data_step - reason technology_upcycle_step technology_step_id technology_upcycle_step_id technology_upcycle_step generic_step_id generic_upcycle_step_id technology_upcycle_step - reason upcycle_run - data_db_name upcycle_run - data_db_server upcycle_run - data_file_encoding upcycle_run - data_file_extension upcycle_run - data_file_typ upcycle_run - data_folder upcycle_run target_sf sf_db_name upcycle_run dbserver sf_db_server upcycle_run - upcycle_run_error_text upcycle_run - upcycle_run_status upcycle_run started_at upcycle_started_at upcycle_run ended_at upcycle_ended_at upcycle_run_step upcycle_run_status status   

Related products:Upcycler