Questions & Conversations

I would expect imports work within the same versions of 2025.1. Is there a reason why a different sub-version blocks this task? And is there an easy tool to upgrade a model without upgrading the whole environment where the model is exported from? ************************************* Thinkwise Software Error Message *************************************Datum: 19-6-2025 10:54:22GUI: 2025.1.13.0.NET Runtime: 4.0.30319.42000Database: IAM_SFLanguage: NLSoftware Factory version of the imported model does not match the Software Factory version. The import cannot be continued.Imported model SF Version: 2025.1Current SF version: 2025.1.14SQL:task_import_model

The new version of the SF 2019.2 has a new prefilter "My projects” who's default active. The Software Factory doesn't recognize our NIVERPLAST project as "My project” anymore. I don't know the exactly prefilter conditions but probably this prefilter is watching to the database-user in combination with the user who created the project in the SF or something like that?  For me it feels like a bug but maby there is a good explanation for it?    Project: … (Hidden behind prefilter "My projects” )  Prefilter "My projects” default ON    

In the releasenotes of SF 2019.1 is mentioned that Table Valued CLR functions are now supported. So I tried to convert a script of a CLR function to the 'Subroutine' option in TSF. The original code sets the 'internal' subroutine id as 'call_web' and the external name as 'CallWeb' If the subroutine is created via the TSF the subroutine_id is used as the internal and external name. When I generate the source code and open the source code file of 'clr_functions' I see the following query: Is is possible to use a different between internal and external names? It feels wrong to use the external C# function name as internal name. The syntax deviates from all other procedure/subroutine names in our project.

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.GoalMany application have functionality for importing or exporting data in XML format. Sometimes you will get an error about an illegal XML character:XML parsing: line 1, character 2967663, illegal xml characterAnd then you will have to try to find that character, which is very hard. This solution can help you out.SolutionThis solution creates a stored procedure search_illegal_xml_characters which searches your entire database for illegal XML characters. It is also possible to search in one specific table.The procedures uses a function, remove_illegal_characters_for_xml, which is also created in this solution. Important: this function does NOT remove illegal characters from your database. It only removes those characters from a string.Dynamic model add_search_illegal_xml_charactersThis dynamic model code creates stored procedure search_illegal_xml_characters and function remove_illegal_ch

We have multiple clients using our software, and some of them may have a different version in production than other. In some cases, there is the need for data conversion because of new functionalities or restrictions. We encounter some risks when upgrading from different versions i.e. we have one client that is currently on version 6.300 and one on a slightly higher version 6.301.We developer our conversion script for version 6.400, and place it in a certain folder. However, this come with some risks and we would like to manage our conversion scripts in the SF.We already use the UPGRADE code group for scripts that have to be executed every upgrade, but in this case we need a script that will be executed in every upgrade that encapsulates version 6.400.So in our examples, an upgrade from version 6.300 to 6.400 should have the script, but also from 6.301, or even if we skip version 6.400 and go straight to a 6.401.The UPGRADE code group can be used to manage data conversion scripts for s

I am experiencing an alignment issue in a grid. In case of a mandatory field, the header alignment seems to be to the left side by default, even if the data is aligned to the right: For comparison, without mandatory % field: After saving the alignment of the header is still to the left:  After visiting another tab and then going back to the original tab, the alignment is as should be, to the right:I experience this within the variants of a table.Is this a known issue? 

Is it possible for a user (or admin) to share a cube view created and saved by a user, with all (or a selection of) the rest of the users?For instance:A user creates a cube view that will not only be useful for himself, but also for all members of his department. I will be great if the user can share it with his colleagues.

I have set up a scheduler and the timescale must be default in weeks, so I set up a schedeluar view with weeks and assigned it as default view in schedular but it seems like it do not work.  In the application it always presented in days.  

For certain contexts where we show a difference between values it makes sense to display positive numbers with a plus sign. For example a difference of 5 displayed as “+5” in a list or a cube. I looked for a domain control to see if the gui offers such an option but I couldn’t find it. Is there a straightforward method or do I have to convert numbers to varchar to accomplish this?

I'm trying to use the Indicium OData API via a .NET Core 3.0 console application. I receive an exception on inserting records, while the record is inserted in the database. I have no clue why. I'm not sure if this is an issue in the Indicium OData API or the .NET nuget package. For example I want to add a ‘server’ to the IAM database. By using a generated piece of code (see https://docs.microsoft.com/nl-nl/odata/client/basic-crud-operations) this is quite easy to set up; Add the indicium OData API via “Unchase OData Connected Service” Configure the metadata ($metadata.xml is the result of http://server/indicium/iam/iam/$metadata)With the following code you retrieve the ‘server’ table and insert a new record in to it: using SQLSERVER_IAM;using System;using System.Net;namespace IndiciumTest{ class Program { static void Main(string[] args) { var uri = new Uri("http://server/indicium/iam/iam"); var container = new Container(uri); container.Credentials = new NetworkCredential("userName", "p

Where can I activate the option to log IAM Administrator actions ?

I noticed when exporting a cube to excel that the filters, column and data labels are printed to the first two rows of the file. This has the effect that the first 4 as well as the 6th column of the actual data (from row 4 onward) consist of so-called merged cells. Is it possible to export without those first 2 lines and end up with an export that consists of only regular single cells, similar to the output of a regular grid? Quite a few of our users struggle to integrate the current output in their analyses.

I just had an issue with the scheduled system flow that was perfectly handled with a TCP call by ​@Angelica van der Beek . I thought it would be worthwhile to share it in the community, in case someone else encounters the same issue.  At our customer we had a systemflow scheduled every 5 seconds, in order to treat incoming calls. The system flow did not work, wh in the production environment while in Acceptance it did. We did verify all settings according to documentation: - Configuring pool usershttps://docs.thinkwisesoftware.com/docs/deployment/indicium#configuring-pool-users - Create the web applicationhttps://docs.thinkwisesoftware.com/docs/deployment/indicium#create-the-web-application - Restarting the applicationhttps://docs.thinkwisesoftware.com/docs/deployment/iis#restarting-the-application - application Initializationhttps://docs.thinkwisesoftware.com/docs/deployment/iis#application-initialization

We're trying to create an application in Thinkwise which uses an Oracle as underlying database.The following configuration is used:- Model:  RDBMS type: Oracle- Runtime configuration:  Database:    Server name: <server-name>\<pdb-name>:1521    Database: THINKWISE    Pool credentials:      User: THINKWISE      Password: <password of user THINKWISE>      On creating the Execute Sourcecode gives errors.Connection to the database is successful and the software factory identifies that the schema exists and will skip the db step. So far so good.But when executing all code files the 'indexes' and 'procedures' steps fail:Index step:An unknown error occurred while executing '/* drop all indexes */declare   v_index_name      varchar2(255);  cursor drop_objects is  select i.index_name    from all_indexes i    where i.owner = (select sys_context('userenv', 'current_schema') from dual)     and not exists (select 1 -- bij het aanmaken van een pk kolom wordt automatisch een index aa

In most (web based) applications it's common to use pre and post fixes, like this on in the omage.  That way you can easily indicate how the data in the field should be interpreted. Usecases are currencies, percentage, wheight, degrees, etc.  What are the plans for the universal in that respect? 

When I am exporting to Excel from a grid view, the currency fields are displayed in Excel with a $ sign. How can I control this? Extended properties of the application are set to "UseWindowsCulture”. However no matter what kind of language settings in Windows I change, I do not succeed to display the € in Excel. The cell property in Excel is set to $ #.##0,000 during export. While the currency setting in Excel is set to display € sign. 

Hi, is it possible to display hidden columns in the export as well?

Hello,Currently, when i create a badge control procedure, the checkbox ‘Badge’ under Performance on the subject is automatically checked, but the checkbox ‘Show badge’ on the main subject is not automatically checked. Is there a reason why this is the default action? Wouldn’t it make much more sence to just automatically check the ‘Show badge’ box as well?

When we try to execute a task on a Android device with Indicium 2020.1.006, the app draws the Execute and Cancel button somewhere in the middle of the input parameters. This does not happen in the Mobile GUI.    

Is it possible to translate a table variant independent from its parent table?

I am confused on the workings of code history tab on control procedures - templates. The workings seems to differ from one version to another. The way I would expect it to work is like this: The template is created in the trunk, amended in the trunk a day later. The next day a branch is created and the template is amended in the branch. And the next day it is merged back to the trunk. trunk - create the template on 2019-1-1 in version 1.00 trunk - amended the template on 2019-1-2 in version 1.00 branch - amended the template on 2019-1-3 in version 1.00 (branch) trunk - merged the branch back to the trunk on 2019-1-4 in version 1.10 now in the trunk I would expect the following in the code history: insert - trunk - 1.00 - 2019-1-1 update - trunk - 1.00 - 2019-1-2 update - branch - 1.10 - 2019-1-4 and in the branch the following: insert - trunk - 1.00 - 2019-1-1 update - trunk - 1.00 - 2019-1-2 update - branch - 1.00 - 2019-1-3 what i actually get after merging is this in t

People make mistakes, sometimes small, sometimes big. I would like to be able to change the title of my Community topics in case I make a mistake. Even if I'm only able to change it within 10 minutes after posting. Could it be made possible?

Why are earlier sessions still open? And could this have an impact on the application? We start the application via a Windows GUI with Indicium.

Like the title says, can this be a '>' no matter when I'm looking or editing my topic? The '>' confused me in thinking my description wasn't correct. I think inSided can only change it since it's their product

Is it possible when creating a user defined pre filter to add multiple selections for an item of the type ‘contains’, for example ‘status’ contains ‘open’ and ‘planned’?