Questions & Conversations

I’ve maganged to setup the connection to the Exact Online API from postman.Now I try to setup the connection from the SF but we running into an invalid_request error as a result.I’ve used the same input variables and keys, so at the moment I’ve not a clue why this result is happening:      Has anybody in the community succesfully connected to the Exact Online API. 

Since the new version the generation process is done by Indicium. However, often this message is displayed; It usually disappears/appears a few times and the generation does not fail, but still, It does not look good to me. What is the cause of this message?Thanks! 

I am trying to simply execute a task, without parameters with a process flow every hour.         Indicium Universal (2020.2.2) is running, but I don't see any activity. The version of IAM is 2020.1 and al hotfixes are done.   Could someone explain, step by step, what to do?   

One of our customers, who is using the Windows GUI (2019.2.17), is using up to 9 GB (!) of internal memory on the RDS with TSF_dotNET.exe. Most of the time TSF_dotNET.exe is using around 2 GB, but that is also too much. How is this possible and how can we limit this?

Hi,for the entire app we use a lot of fields with values with a comma. However, TW by defaults uses a point. Now this is not too bad for our friends in the us of a. But here in Europe, I would very much like to offer a comma in values. Is this possible? It is needed for money, size, weight, etc.  

Is it now already possible to execute a table task or process flow with parameters, with a hyperlink in a html field? The goal is to open another document within the same browser tab, or as floating document.Can the syntax as described in “Improved HTML control with a deep link” (release notes 2024.2.14) be used? 

Again we run into problems, because Indicium stopped for some reason.I am quiet sure that everything is set up as mentioned in the documentation. But I am still not sure if all settings that are needed to let Indicium running are set. It would be helpful to have a simple checklist for this in the documentation. Now is it too much fragmented.Any ideas what else can be the reason for Indicium to stop running? In this case the customer has a on-premise configuration, so we cannot make use of Azure to monitor te webservice. For this it would be really a good idea to have the idea @Erwin Ekkel available in the GUI.  As a workaround I am now considering to make system flow that updates a sort of 'heartbeat’ date field in a little application status table and use a task + badge as in indicator when the last 'heartbeat’ is longer than 5 minutes ago. 

We have to create an event schedular in which we get dates entries from database. How do we create event schedular in software ?

Since a last IAM Sync today our scheduled system flow won't be executed anymore.  Last run was at 2.21: PM (UTC) today but the next run every 3 minutes will be updates, but the task won't be executed.We have both Indicium and Indicium Basic running against this IAM to support both Universal and Windows UI via Indicium.An IIS restart didn't fix the issue, nor a sync of the IAM did fix it.Running IAM 2021.1

Free tool supporting many styles of code, integrated in SSMS. Users can create and share formatting profiles. Anybody has experience with leveraging this for uniform SQL coding style and thus easy cooperation between different developers?

Hi. I thought I got all working on linux, but I found out that when I logout the return URL is missing /indicium/ in its path. Where do I set this or what is causing this?https://server.lef.tec.br/indicium/account/ui/logout?returnurl=https://server.lef.tec.br

It seems like not possible to show HTML in the previewer component in Universal.Is this not yet possible in the Universal GUI or can it be realized in another way?See below an example of a HTML page shown in de Windows GUI versus Universal Universal: 

We have a task with a barcode as the last parameter that is scanned using an externally connected barcode scanner:According to the documentation, the task should submitted directly, but that doesn't happen.How do I get this working?

I'm trying to test the recently released OAuth login connector support in the Universal GUI. Thanks to the Docs I conclude that I have to update the Extended property oauthredirecturi to switch from http to https.I did this on our TEST environment for the Application in which I am testing this We had the Indicium recycled after the changeIAM Extended propertyAzure AD error@Vincent Doppenberg However, the error still mentions the http uri. Could it be that the Universal GUI does not look at the IAM Extended property override?Another question: previously we always used the /signin-microsoft for this scenario in Insomnia. Why is this changed to oauth-callback and should we register both Reply URLs in the Azure AD App or update to oauth-callback for the OpenID Provider scenario too?

We're experiencing performance issues in Universal with a certain view. I already tried using ForceRecompile in extended properties to make it load faster but that doesn’t seem to have an effect. I rewrote the sp_prepexec statement to a regular select query and it's just as slow. This is the query that’s being run on SQL Server: declare @p0 tinyint, @p1 nvarchar(6), @p2 int, @p3 int, @p4 intselect @p0=200, @p1=N'%A%', @p2=1, @p3=201, @p4=200000SELECT t1.[tsf_row_number], t1.[bedrijf_nummer], t1.[klant_groep_nummer], t1.[klant_nummer]FROM (SELECT ROW_NUMBER() OVER (ORDER BY t1.[klant_nummer] ASC, t1.[bedrijf_nummer] ASC, t1.[klant_groep_nummer] ASC) AS [tsf_row_number], t1.[bedrijf_nummer], t1.[klant_groep_nummer], t1.[klant_nummer]FROM (SELECT t1.*FROM [vw_example] t1) t1WHERE t1.[klant_groep_soort] = @p0 AND (isnull(t1.klant_geblokkeerd_voor,0) in (0,1)) AND (exists (select kg.klant_groep_nummer_hoofd from klant_groep kg where kg.bedrijf_nummer = t1.bedrijf_nummer and kg.klant_groep_

I am trying to use the OAuth connector to make a synchronization with the tax service platform of the British Government.I have followed the docs and set everything up accordingly. However when the proces action of the OAuth login connector is reached, a white screen comes up and nothing is happening. I assume thinkwise is adding the client_id, scope and redirect_uri to the Authorization URL? I was hoping to find more information in the debug screen to find out what URL’s etc are being called, but that is not the case. Can someone tell me what I am doing wrong here? I below screenshots you can see my settings.   Settings in OAuth servers      White screen. Nothing happening.    My proces flow 

What could be the reason a query is taking way more time through the GUI than direct on SMSS? If I copy this query into SMSS and execute it, it's done instantly. While via the GUI it takes quite some milliseconds. 

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.In some cases it may be desirable to know the translation of a model object, such as a table, column or domain element, inside your business logic. See for example this idea: Translating domain elements | Thinkwise Community (thinkwisesoftware.com)Starting with the last releases of Indicium and soon available in the Windows and Web GUIs, a session variable is added that provides the language of the current user. This makes it possible to automatically generate a function that returns the translation of model objects in the user’s language. FunctionTo add this dynamic function to your Thinkwise application, first create a function subroutine named tsf_translate  with the following properties:Return value: scalar Return scalar domain: transl - nvarchar(200) Input parameters: type_of_object - int transl_object_id - varchar(100)  Control procedureNext, add a control procedure in the Function

I tried to set up the “forgot password” function in IAM. So I filled in Global settings the email service and the IAM user has the function “change password” on. But I get some strange errors in the logs of Indicium after I use the forgot password function.  

Recently we’ve upgraded our Test- and Staging environments in Azure to Indicium 2023.1.15 and Universal GUI 2023.1.15.1 and enabled the Extended Property RefreshOnDocumentSwitch = Yes as described in the release notes of Universal GUI 2023.1.15Release Notes Universal GUI 2023.1.15 | Refresh on revisiting a page or tabHowever, we don't see any refreshed data when a user revisits the opened document in the menu.Are we missing something? Any help would be appreciated. PS: We have disabled ‘Show Open Documents’ in the software factory, so we don't show the open documents in the menu.

Good morning,Yesterday we have tried out the extended property that should enable an integration between Thinkwise and Matomo: We would like to use Matomo for heatmaps and session recordings.Despite that we have set the extended property (and even installed the JS; https://developer.matomo.org/guides/tracking-javascript-guide), Matomo's dashboard is not receiving any input from our application built in Thinkwise. Could you explain what we need to do in order to integrate Matomo properly?Thanks in advance. 

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.GoalWhen you have system versioned tables in your database, SQL Server logs all changes made to the data in those tables. This solution makes this logging data available for the user. This can look like this: SolutionThe solution in this topic creates views on all system-versioned tables. These views give the user access to the logging data. Also, all of these views get conditional layouts in the Software Factory. These conditional layouts give fields with changed values a color, which makes it easier to analyze the data.Dynamic model meta_view_historyThis code create a view definition for every system versioned table, along with conditional layouts to point out changed data.When you add this code to the dynamic model, you have to change a few values first:@screen_type_id                Your desired screen type: You can keep this null, or change the value.@original_date_column          Na