Thinkwise Platform

Questions, discussions, news and updates regarding the Thinkwise Platform.

1796 Topics

Jasper
Administrator
JasperAdministrator
published in Questions & Conversations

Multirow task execution

When executing a task for a selection of rows, the user interface first executes the context procedure for every single row to check if the user is allowed to execute the task for that row, and then executes the task for each permitted row. This can be quite time consuming, especially for web clients where the progress is also reported back to the client.To speed up multirow task execution, a new feature has been developed to execute tasks for a selection of rows.To enable multirow execution for a task:Add an XML-typed parameter to the task Make sure Popup for each row is switched off Set the MultiselectParameterID extended property with the name of the parameterWith multirow execution enabled for a task, when the user interface executes the task, the specified XML parameter is filled with the parameter values for all rows. Even if only one row is selected.The parameter is only filled when the task is executed. The XML is therefore not visible in the popup or available in the default a

173734
htimmermans
Vanguard
1 month ago
E
Sidekick
Edwin SaanSidekick
asked in Questions & Conversations

Http connector Exact online

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. 

32
D
Moderator
1 year ago
Blommetje
BlommetjePartner
asked in Questions & Conversations

What causes the message 'We stopped hearing from Inidicum'

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! 

29
Mark Jongeling
Administrator
11 months ago
Harm Horstman
Hero
Harm HorstmanHero
asked in Questions & Conversations

How to schedule a process flow?

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?   

28
Harm Horstman
Hero
6 months ago
Anne Buit
Community Manager
Anne BuitCommunity Manager
published in News & Blogs

Revised creation and automationBlog

The Thinkwise Platform version 2021.3 has revised the way the Creation screen works, opening up more elegant ways to leverage tooling to automate this process.The generation screen consists of a number of steps:Generate definition Validate definition Generate source code Execute source code Run unit testsThis has remained unchanged between versions 2021.2 and 2021.3. However, the way these steps are performed has fundamentally changed.In the previous version, the steps in the generation screen were bound to a specific client. A developer would start Generate definition and the definition generation would be orchestrated start-to-end by the users client. This has served us well for many years, but there are some drawbacks that we’ve addressed in this release. The new Creation approachAll ‘jobs’ are no longer performed by a client, but are instead performed by Indicium. This means that generation, validation and such will continue even if the developer closes the screen or even the Softw

99623
Anne Buit
Community Manager
10 months ago
Blommetje
BlommetjePartner
asked in Questions & Conversations

use comma instead of point

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.  

21
Mark Jongeling
Administrator
2 years ago
Johan van Eijsden
Captain
Johan van EijsdenCaptain
asked in Questions & Conversations

Windows GUI on RDS

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?

21
Mark
Rookie
2 years ago
A
Vanguard
AshwiniVanguard
asked in Questions & Conversations

Calendar Scheduler

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

19
A
Vanguard
3 years ago
C. Lousberg
Vanguard
C. LousbergVanguard
asked in Questions & Conversations

IAM Scheduled system flow doesn't run anymore

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

18
E
Moderator
1 year ago
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations

When I logout the returnurl is missing the /indicium/ directory what is causing it?

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

18
Freddy
4 months ago
Lars Berntrop
Sidekick
Lars BerntropSidekick
asked in Questions & Conversations

ApexSQL Refactor and Software Factory

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?

17
Jasper
Administrator
3 years ago
P
Vanguard
pvleeuwenVanguard
asked in Questions & Conversations

OAuth connector gives blank screen

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 

17
P
Vanguard
10 months ago
R
Apprentice
Ronald VHApprentice
asked in Questions & Conversations

Integration with Matomo

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. 

16
R
Superhero
1 year ago
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations

Universal GUI performance

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. 

16
Freddy
10 months ago
F
Thinkwise blogger
Frank Wijnhout
posted in Questions & Conversations

Make your logging data available in the GUI

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

16
P
Vanguard
5 months ago
Jasper
Administrator
JasperAdministrator
published in Questions & Conversations

Translating model objects in business logic

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

36016
Kasper Reijnders
10 months ago
Erik Brink
Moderator
Erik BrinkModerator
published in News & Blogs

Grid double-click task executionBlog

We are thrilled to introduce a great new feature. We received quite a few requests to apply some more possibilities to start user actions from a grid record, like we see also in apps like Outlook, Gmail, etc.  Our Web GUI already supports grid links, where a column with a textual link can start a task based on the clicked record. We plan to support this feature in our Windows and Universal GUI soon too. In the future, we will also provide options to display the link in a nicer way, using icons and tooltips. More about that in a later blog post. Recently we’ve added a similar cool feature to the grids of our Windows and Web GUI’s: Grids now support a task to be executed when a record is double-clickedTo configure which tasks to use, the SF offers a new (model) extender, released in a recent hot-fix, which can be used to assign multiple table tasks to the double click action.  The GUI will choose the first enabled task to execute. We chose to allow more than one so the developer can dete

69416
Erik Brink
Moderator
3 months ago
R
Rucha NaikPartner
asked in Questions & Conversations

Process flow works in GUI but not in Universal.

Hi,I created a process flow to create IAM user when an employee is added. The complete flow is working as intended through GUI, however getting error in Universal.The user is created via GUI but not via Universal. How to resolve it?Universal version : 2022.2.17.0.0 GUI process flow monitorUniversal Below is the entry in the error log , however it seems fine to me. at Indicium.Shared.ProcessFlows.SystemActions.SmtpConnector.StartInternal(ReadOnlyDictionary`2 inputParameters) in C:\azp\agent\_work\1\s\src\Indicium.Shared\ProcessFlows\SystemActions\SmtpConnector.cs:line 272   --- End of inner exception stack trace ---   at Indicium.Shared.ProcessFlows.SystemActions.SmtpConnector.StartInternal(ReadOnlyDictionary`2 inputParameters) in C:\azp\agent\_work\1\s\src\Indicium.Shared\ProcessFlows\SystemActions\SmtpConnector.cs:line 279   at Indicium.Shared.ProcessFlows.ActiveProcessAction.Start(ReadOnlyDictionary`2 variableState) in C:\azp\agent\_work\1\s\src\Indicium.Shared\ProcessFlows\ActivePro

15
R
1 month ago
R
Sidekick
rustieSidekick
asked in Questions & Conversations

indicium issue with azure key

I tried to configure a different pool user identity. i made sure to follow the steps here: https://docs.thinkwisesoftware.com/docs/deployment/indicium_encryptionAnd then I logged in to Universal and Maintenance > IAM configurations to create the pool user. and i still get this error:This environment has not been configured to allow data encryption. when you restart the web app after committing the changes in the appsettings file or adding them to the config page, you get this message:This page isn’t working right nowserverurl.azurewebsites.net can't currently handle this request.HTTP ERROR 500It's like adding the settign for encryption key breaks Indicium

15
R
Sidekick
1 month ago
Alex Kerschkamp
Warrior
Alex KerschkampWarrior
asked in Questions & Conversations

Microsoft Graph issue

Hello everyone,Because the new Exchange connector that is scheduled for the month November of this year will not give adequate possibilities for our client, we're trying our luck with Microsoft Graph. We created a call and made it fit our needs using Postman.We configured and use all the right credentials (client ID, tenant ID and client secret) for token generation. Actually, we created a call for getting data, and one for patching data. The call types are, of course, get and patch respectively. All calls are successful, and perform as expected, using Postman.Next, we went to our Software Factory, to make Thinkwise perform the same calls. Using a process flow, we make the proper call, the same as we did using Postman.We get a correct token in Thinkwise. When we copy this token from the debugger, and check it with jwt.ms, we get a valid token. In fact, when we use this token in Postman to make calls, it works perfectly. So, token generation works properly.However, the calls that work i

15
Alex Kerschkamp
Warrior
6 months ago
S
Sidekick
sujitSidekick
asked in Questions & Conversations

Unable to move SMTP Connector Process Action

HiWe’ve created a Task under ‘email Table’ that will send email & document as an attachment to the Receiver email id when over email_status=’open’ in the Email table. Task(send_status_email) which sends email with attachment Process Flow Design Page When we Start that task to send email - In The process Flow Monitor 1st time the process action are Excutes in this way start_tab_task  → decision → decision_attachment_to_disk → write_file, After the write_file Process Action ,an infinite loop will run which always then Go to process action (decision_attachment_to_disk → write_file)  from where the process flow Nevers Go to the Process Action SMTP_Connector.process Monitor windowSMTP_Connector Input ParametersProcee Action - Write_disk file input Parameters Need Some Suggestions from some expert who can help to complete this Task.If this information is not sufficient ,Please free to reach me .Regards, Sujit

15
E
Moderator
3 months ago
Harm Horstman
Hero
Harm HorstmanHero
asked in Questions & Conversations

Show HTML in Previewer in Universal GUI

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: 

15
Erik Brink
Moderator
17 days ago
A
Vanguard
AshwiniVanguard
asked in Questions & Conversations

Screen Type

We have to create detailed grid so how can we bind multiple values in that ?

14
Mark Jongeling
Administrator
3 years ago
D
Moderator
Dick van den BrinkModerator
published in News & Blogs

Using OAuth to get data from external applicationsBlog

The Thinkwise Platform has powerful functionality to connect to external applications using OAuth. Customers often use external applications, for example a payment system. In that case they often want to import the data to the Thinkwise database, as the external system is their single source of truth. We can use the Thinkwise Platform to synchronize this data. With the support of system flows we can even automate this to automatically collect the latest data.In this blog I will use Exact Online as the external application to synchronize the projects from Exact to a database.Creating the data modelI made a very simple model for demo purposes. As a developer you can extract a lot more data from the API.The data model contains two tables, the oauth_token_info table to save the OAuth access and refresh tokens. The project table contains the information we will extract from the Exact Online API.Data modelApp RegistrationTo call the API first we need to register an application in Exact Onlin

74213
D
Moderator
7 months ago
Mark Jongeling
Administrator
Mark JongelingCommunity manager
posted in Questions & Conversations

Autonomously generate report and send it by e-mail

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.GoalBased on a customer story.Every day at 06:45 a procedure runs for the customer and during that procedure, errors can occur. These errors are recorded inside the application and viewed by one particular user. This user only opens the application to look at these errors. If there are no errors at all, the user still has to look inside the application to find out. It would be more handy if the user gets an e-mail with a Report of all the errors. SolutionBy using the System Flow functionality, we can autonomously let Indicium take care of generating a Report and sending it to the user by e-mail.In this example I will show you what is needed to achieve this.Prerequisites:Indicium (Universal) - hereafter called Indicium Application in IAM SMTP server for sending the e-mail - this example uses a free SMTP server by sendinblueChaptersCreate a View in the Software Factory Create a DevExpress R

13
Mark Jongeling
Administrator
6 months ago

Badges

Show all badges
Terms & ConditionsCookie settings