Product updates
Ideas
Groups
E-learning
Documentation
Events

Community
Search

Replies posted by Vincent Doppenberg

422 Replies

Oldest first

Newest first

Onno SpoorVanguard

asked in Questions & Conversations

No new version Indicium (Basic) 2021.1?

Version 2021.1.10 of Indicium Basic has now been released as well. But as mentioned by Mark, version 2020.2.10 will also work on the 2021.1 platform.

Erwin EkkelModerator

Execute a system flow from the SF (for development purposes)Completed

There is a third way.As of Indicium Universal version 2020.2.12, you can start a system flow by using an API call. This way, you can start the flow with the push of a button from a tool like Postman or Insomnia, without having to change it in any way.The API call should look like this:POSThttps://<server>/<indicium_application>/sf/<appl>/<process_flow_id>Including the necessary authentication, of course.

Roy van UffelenCaptain

posted in Questions & Conversations

What's the difference between the data types ROWGUID and UNIQUEIDENTIFIER

Hello Roy,The UNIQUEIDENTIFIER data type is a simple data type that allows you to store GUID values in a column. You can choose the GUID value yourself, you can update the value later and the value is stored in the database.ROWGUID isn’t actually a data type, it is simply shorthand for the UNIQUEIDENTIFIER data type with a few extra properties on the column definition. You can see these properties listed in the properties column on your screenshot.Aside from UNIQUE, NOT NULL and DEFAULT NEWSEQUENTIALID(), it will also cause the ROWGUIDCOL property to be added to be column. Columns marked by the ROWGUIDCOL flag can be selected or compared by using the ROWGUIDCOL alias, without needing to know the actual name of the column. This can be helpful in various scenarios and SQL Server itself depends on it in a few cases. Most notably, when using a FILESTREAM data type in a table, that table must contain a column marked with the ROWGUICOL flag.The ROWGUID data type in the SF is marked as Calcul

Roy van UffelenCaptain

posted in Questions & Conversations

What's the difference between the data types ROWGUID and UNIQUEIDENTIFIER

Hello Roy,A column that is of a domain linked to ROWGUID is always Mandatory (not null), never Identity (it is no integer and has its own incremental function) or Editable (just like a calculated column or a column marked as Identity).Correct. If it is part of a primary key, and it is part of a foreign key then it can be edited just like a lookup.No, a ROWGUID column can never be edited. It will be generated once when the record is created and will then always be an inseparable identifier for that record. ROWGUIDCOLs are used in database replication scenarios for instance and this way, even if the entire record has changed, two records can still be matched as being the same record and can be replicated accordingly. A UNIQUEIDENTIFIER has non of the desired featured as a default (other than being able to store a GUID). A UNIQUEIDENTIFIER is necessary if you want to store a GUID received from another system that you need to remember in order to communicate it to this other system.Correct

Roy van UffelenCaptain

posted in Questions & Conversations

What's the difference between the data types ROWGUID and UNIQUEIDENTIFIER

Hello Roy,It is true that ROWGUID values can never be edited, but that doesn’t mean that they can’t be referenced and chosen in a target table as a lookup value. I understand why you might think that these two things are mutually exclusive, but they aren’t. I have highlighted below where your understanding is wrong.Your NO-answer implies that this is not possible if the primary key column in the source table is a ROWGUID, as by drawing a reference to the target table it also will be a ROWGUID in the target table.When drawing a reference to a ROWGUID column in a source table, the corresponding column in the target table doesn’t need to be ROWGUID as well. In fact, it shouldn’t be because then you get exactly the problem that you describe. ROWGUID is not a data type just like IDENTITY is not a data type. When you reference an IDENTITY column, your target column data type will typically be INT and will have none of the IDENTITY properties applied to it, it merely references the value. Whe

Roy van UffelenCaptain

posted in Questions & Conversations

What's the difference between the data types ROWGUID and UNIQUEIDENTIFIER

As an addition to the above, if referencing a ROWGUID column without having the target column yet causes the target column to be added as a ROWGUID column as well, then this is an oversight in the SF. As far as I understand it, that should not be how it behaves. Again, this issue is probably caused by the choice of defining ROWGUID as its own data type in the SF.I realize that I misunderstood your comment a little.Does this mean that in this case I will have to manually change the domain of this foreign key column from ROWGUID to UNIQUEIDENTIFIER?So yes, this is exactly the case. The SF should have done this for you but doesn’t due to a bug. You can manually correct it in that way. Could you report an issue for this in TCP? That way we can track it and update you when it is fixed.

K.BakkenesCaptain

Validate field input value without using a default/layout/triggerCompleted

Note that the comments below the idea that Robert Jan has linked also apply to this idea and what was said there has already been implemented in Indicium Universal. I think that both of these ideas describe a nice addition to the SF, but I would also like to give some context on how a large part of the mentioned issues have already been solved and will no longer exist once we fully migrate to only having user interfaces that operate on top of Indicium Universal (which is a goal that we are working towards).Given the situation where you don’t have any non-Thinkwise software accessing the database, you will typically only need either a layout procedure or a default procedure to both ensure the integrity of your data and give a message to the user.If the field is mandatory, you can simply clear it in the default procedure, set the cursor to that field and return the error message. Even if it’s a column that’s not mandatory on the database and was made mandatory by a layout procedure,

Romario DindajalRookie

posted in Questions & Conversations

Universal gui 2021.1.0 POST METHOD 500

Hello Romario,Whenever you encounter a 500 status code, an error has occurred in Indicium or on the database and you will be able to find more information in the log file inside of Indicium’s Logs folder. Could you please check these logs to see if you can find the cause of the error?

Harm HorstmanSuperhero

asked in Questions & Conversations

How to upload a file using Indicium 2021.1

Hello Harm,There have been no changes to how file uploading works in Indicium Universal for over a year.When it comes to adding/editing records and executing tasks/reports, Indicium Universal offers two APIs. What you see when using the Universal GUI is what we call resource staging. Clicking add/edit record or a task/report will perform a request that creates a resource in Indicium. Every field the user enters will be a request that changes the state of this resource. And finally, saving the record or executing the task/report is another request, which will cause the action to be performed. This way, the state of a record/task/report is managed by Indicium and Indicium will also take care of all application logic. Since through this method, every change to a field is its own request, we can upload files much more efficiently. Rather than sending the entire contents of the file in the JSON body of the request, we can now stream it to the server, using the standard way to do this in HTT

Roy van UffelenCaptain

posted in Questions & Conversations

What's the difference between the data types ROWGUID and UNIQUEIDENTIFIER

Hello Roy,You are doing it correctly, the validation is mistaken. This is an extension of the issue that causes the target column to be created as a ROWGUID as well, when drawing a reference. The Software Factory doesn’t handle ROWGUID very well right now. It treats ROWGUID as a data type even though it isn’t, causing errors like the ones you’re experiencing. Could you report an issue for this as well please?As for using ROWGUID as the primary key, this is technically possible on the database. I’m actually not sure why the Software Factory doesn’t allow this. ROWGUIDs make for better clustered indexes than regular UNIQUEIDENTIFIERs since they are sequential. Maybe someone else can elaborate on the reason that they can’t be primary key. You could post an idea to allow ROWGUIDs to be primary keys in the Ideas section.Hope that helps.

asked in Questions & Conversations

Azure SQL Database for Software Factory

Hello mperrot,Our Universal GUI, Web GUI and Indicium can also be hosted on Azure, not just on VMs, but also as App Services. The Thinkwise Platform can be fully cloud native and scales particularly well when using the Universal GUI and Indicium Universal.

asked in Questions & Conversations

Auto refresh table variant in Universal

Hello Ramon,This idea that was just posted has a lot of overlap with what you would like to see. Voting on it will make it reach our backlog sooner.

asked in Questions & Conversations

Azure SQL Database for Software Factory

As an additional note to my previous answer. The Software Factory itself only works on the Windows GUI at the moment, so you will need an Azure VM or an on-premise machine for development purposes. We are currently working on supporting the Software Factory on the Universal GUI and Indicium Universal. Once that is finished, you won’t need a VM or on-premise machine for development anymore either and you can fully work in the cloud.

K.BakkenesCaptain

asked in Questions & Conversations

Process flow application connector not working via an API call

Hello K.Bakkenes,I don't see anything wrong with your Application Connector at first glance, but there are various things that could go wrong. Please note that the prc_send_e_mail_v2_appl_connector entry in the DB event log is a process procedure. The DB event log logs database events, such as process procedures, it does not log process actions.Here are a few tips for debugging process flows:If you're wondering whether or not a certain action in your process flow is reached, you can add a process procedure to that action and either log a record, raise an error or check the DB event log to determine if that process procedure is called. If you feel like an error occurs in your process flow then you can check Indicium's logs. All errors produced by process actions will be logged to a log file. Every process action has the output parameter Status code. The value of this parameter determines the success of the action. A status code of >= 0 means successful (green arrow) and < 0 means

K.BakkenesCaptain

asked in Questions & Conversations

Process flow API settings SF 2021.1

Hello K.Bakkenes,The API and API alias fields are currently ignored by Indicium. Given the names of these fields, I understand your assumption that you would need to use these if you want to start your process flow with an API call, but this is not the case.Every process flow can be started with an API call.But if you want to keep it simple, please make sure that your process flow follows these requirements:Have only one starting action (only one arrow leaving the Start process action). Use only system flow actions (this excludes tasks and reports as well).If you stick to those requirements, starting your flow is as simple as the following API call:POST/iam/appl/process_flow_idIf the first process action in your flow is a task, an add record, an edit record or a delete record action, then you can start your process flow by performing the corresponding API call. It will trigger the flow automatically. In this case it doesn't matter if you have multiple starting actions, but please make

Harm HorstmanSuperhero

asked in Questions & Conversations

How to upload a file using Indicium 2021.1

Hello Harm,We have recently released documentation regarding resource staging: https://docs.thinkwisesoftware.com/docs/indicium/resource_staging.htmlSadly it doesn't include how to upload files, but it does provide a lot of necessary context to understand how it works.Let say that you have the following staged resource:GET/iam/appl/staged_project_document(b03b9235-dcde-43cb-82b6-a66752d132fb)You can then upload a file for that resource by performing the following two requests:PATCH/iam/appl/staged_project_document(b03b9235-dcde-43cb-82b6-a66752d132fb)Content-Type: application/json{ "document": "some_document.docx"}This first request determines the file name at the destination and in the record on the database. Note that it could have a suffix added to it to make it unique. POST/iam/appl/staged_project_document(b03b9235-dcde-43cb-82b6-a66752d132fb)/upload_documentContent-Type: xContent-Length: x-- binary dataThis second request streams the file data to Indicium. Note that there is no

René WSuperhero

asked in Questions & Conversations

IAM 2021.1 on Universal

Hello René,This issue is typically caused by redirect rules or URL rewrite rules in IIS. Do you have a reverse proxy in front of Indicium that routes requests to the Indicium web application? Or do you manipulate the URLs in any way by means of rewrite rules before they reach Indicium? If so, could you check if this issue also occurs when you request the following URL directly on that Indicium web application?/iam/2098/usr(usr_id='user%40company.com')

René WSuperhero

asked in Questions & Conversations

IAM 2021.1 on Universal

Hello René,There were indeed two different issues at play here. The first issue was related to the URL rewrites, the second issue should be fixed in version 2021.1.13 of Indicium, which was released in TCP yesterday. Sorry for the inconvenience, please try updating Indicium to see if that fixes your remaining problems.I hope this helps.

René WSuperhero

asked in Questions & Conversations

IAM 2021.1 on Universal

Hello René,You're right. At first glance, this issue resembled one that was recently fixed in Indicium, but I have managed to reproduce your issue. This looks like an issue in the Universal GUI, I have asked them to look at it.

K.BakkenesCaptain

asked in Questions & Conversations

Process flow application connector not working via an API call

Hello K.Bakkenes,The application connector doesn't work on the Windows GUI that's why you're getting the -100 status code there. In this specific case my fourth tip wasn't very useful.You said that you're not seeing any error messages in Indicium's logs, this would indicate that the application connector ran successfully and returned status code 0, can you confirm that this is the case? If it ran successfully but your ‘json_result’ variable stays null, then the most obvious explanation would be that you did not map the json_result variable to the Result output parameter of the application connector.The application connector can be the starting point of a process flow, if you start it by means of an API call or a schedule (system flow). It is not necessary to use the application connector when calling the process flow as an API, the database connector would also work. Both process actions are system flow actions, which means that they can be executed autonomously without a user interfac

René WSuperhero

asked in Questions & Conversations

IAM 2021.1 on Universal

Hello René,The $expand parameter is part of OData, the protocol that is used between Indicium and its clients to describe queries. The purpose of $expand is to join a record with a record from another table, in order to select corresponding columns from that record as well. The Universal GUI uses $expand to fetch the display value of lookups.For every lookup that has a display value that differs from its data value, Indicium will create a transl_{lookup_column_id} property which can be expanded. This property, called a navigation property, is a reference between two tables, the table with the lookup column and the table with the lookup display value.$expand=transl_project_id($select=project_name)A parameter like the one above means:Expand the lookup column ‘project_id’ by joining with the table that contains the display value for this lookup and from that table, select that display value (project_name)There is nothing inherently wrong with this feature, it is very important for lookups

K.BakkenesCaptain

asked in Questions & Conversations

Process flow application connector not working via an API call

Hello K.Bakkenes,I'm glad that you have managed to find and resolve your issue. Is there a way to prevent this first file_path error?Yes, by ensuring that the File connector is only called when there is a file to read. It is a common practice to let a process action loop back onto itself and changing the process variables in the process procedure in order to move the next record, file, etc. The problem is often that the first call fails because the process procedure is necessary to initialize the process variables. This could be solved by initializing the first values of the process variables in the process procedure of the preceeding actions, but in your case, you would have the same logic in three different process procedures then.For this purpose, we have introduced the Decision process action in version 2021.1 of our platform. I recommend the following setup:Move the logic from the Read file process procedure to the Decision process procedure Have the the Read file process action n

GUI - extension to developer modeClosed

I want to list a few points that we should consider if we decide to implement this feature, not to argue against it, but to make sure that we implement it correctly and what that would involve.Development mode in the Windows GUI is currently determined by the INI file and anyone can turn it on or off. We should consider looking at the users marked with ‘Developer mode’ in IAM instead, allowing administrators to determine which users have access to this feature. In the future, the Windows GUI will run on top of Indicium Universal and the GUI will no longer have a say in whether or not default and layout procedures are executed or not. This feature will quickly become an Indicium Universal feature. Again, this would require us to use the Developer mode list in IAM instead, otherwise any client can claim to be a developer. Since it is not possible to circumvent default and layout procedures in Indicium Universal, their importance and reliability has grown as well. They can be used to ensu

René WSuperhero

asked in Questions & Conversations

How to use OpenID from IAM for authentication on Azure App Service?

Hello René,If you are using Indicium Universal and you have configured at least one OpenID client in IAM, then Indicium's /.well-known/openid-configuration endpoint will be available. Please note that it is necessary to restart Indicium for any changes to OpenID clients in IAM to take effect. You can remove all of the other properties in that configuration section:authorizationEndpointtokenEndpointissuerwellKnownOpenIdConfigurationThe values of the client ID and the client secret can be chosen freely, but they must match on both sides. Please note that the clientSecretSettingName property refers to the name of setting under which the secret is stored, not the value of the secret itself. You will need to configure the client secret that you've entered in IAM in the Azure App Service Application Settings as well and then take the name of that setting.The URL of the Azure App Service (where you want to go after being signed in successfully) should also be registered as a Redirect URL for

René WSuperhero

asked in Questions & Conversations

How to use OpenID from IAM for authentication on Azure App Service?

Hello René,I'm happy to hear that it's working. Thank you for the additional information on how to configure an Azure App Service as an OpenID client specifically.Indicium can serve as an OpenID Identity Provider to any client that implements the protocol correctly, but it can be challenging to configure both the server and the client and make them work together. Both sides expect specific values from each other when it comes to URLs, scopes and claim types and since these differ from server to server and client to client, it's hard to document it at a general level.Perhaps we should write a blog post or dedicate a paragraph in our documentation on how to get this working for Azure App Services specifically, using your insights. This will probably become a fairly common use case for OpenID.

1
2
3
4
5
6
7
...
17

Page 4 / 17

Badges

Martijn_Reedehas earned the badge Geek
Dennis Kallanseehas earned the badge Geek
Alban_Thas earned the badge Generator
martijngaasbeekhas earned the badge Preparator
SanderAdamhas earned the badge Preparator

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login

Login to the Thinkwise Software Community

Login

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK