Questions & Conversations

I am trying to upload a pdf file to an external server. The http-connector should sent a multipart/form-data message, consisting of an application/json part and an application/pdf part.I have constructed the message and I am able to upload a file to the server. However, the pdf file seems to be corrupted or somehow transferred incorrectly.I am reading the pdf file as a varbinary and since I am unable to insert a binary in the content-variable of the http-connector, I am forced to convert the varbinary to a varchar. I use the following code to do so:convert(varchar(max), @file_data, 1)To evaluate I have sent the message from the Thinkwise http-connector as well as from Postman to RequestBin.com. The messages arrive differently: Postman, raw, looks like this (only part of the data copied)0000000 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0000010 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 32 34 33 39 0000020 37 33 36 39 30 35 31 32 39 35 31 33 37 37 36 38 0000030 31 37 34 32 0d 0a 43 6f 6e

How to get application alias or id within custom component to construct correct API endpoint?

Hello,I have a question about displaying datetime strings in the Universal GUI.I’m using a domain with datetime control with option “Show as stored”, which is exactly what I want in my case. Furthermore, I know that the actual string format which is displayed to the users is dependent on the browser settings. For example, for Dutch I see the following: “DD-MM-YYYY HH:MM:SS”.Now I created a NVARCHAR column in a table with HTML control. In this HTML I want to show a datetime in the same format as the other columns (dependent on the browser settings). Is this something that can be achieved?Another usecase has a similar requirement: to show a datetime range in the following format <DATETIME_START> - <DATETIME_END>. For both timestamps I want to use the browser settings for displaying the datetime string.Any recommendation on achieving this? Thanks in advance!

Hello,I'm trying to use the web connection to send a json body, but i'm not able to get it going. BEfore losing more time with it, i went back to using the http connector, where it works as expected. I saw this topic: Web Connection Parameter | Thinkwise Community Is this still an issue, or is there something else going on? 

Hi!We have started in a few places in app to separate the grid and details of the lines because the screen was to crowded.We do that by using a task triggered by double-click on record which starts a process flow:Depending on the place task was triggered, the process flow takes the primary key and navigates to a variant passing as filter the primary key On the variant, we have only the details of the record clickedThe main problem is that if the user refreshes the page, the primary key is lost and the form will display the information for the first record in the initial grid.Is there a solution for this? If not, maybe we can find a solution, me and my colleagues where thinking that besides the subject and variant used will help also to include in URL the record in focus.this is the current URLour proposalIn this way, not only will help keeping individual pages for records relevant but also in grid to not lose the focus on a row and maybe other usages that I don't have currently in mind

Please make it possible to filter on blank values in columns, like it is possible in windows GUI   

Hello,I was wondering if it is possible to automatically adjust the grid row height to the content of a column which has HTML control. For example, our grid cell looks liks this now:Cell of a grid with data type = NVARCHAR and control=HTMLWe achieved this by manually setting the row height to X pixel, but are wondering if there is some other way? If there is an alternative to HTML control in order to achieve this, we are also interested. 

Hello,For a specific usecase, I want users to be able to import a custom CSV file. The import of this file triggers inserts in more than one table. Therefore, the standard import function Thinkwise offers is not sufficient at the moment.In order to tackle the problem. I have a start task which has 2 relevant task parameters:file_name (data_type=NVARCHAR(512) and control=File upload). Here, the users selects a file from file explorer file_data (data_type=VARBINARY_MAX). Here, the varbinary file data is storedThe file which is being uploaded is UTF-8 Encoded. After using CAST(@csv_varbinary as varchar(max))I can see the VARCHAR information. However, special characters like “ö” do not seem to work with this method: “ö” becomes: “ö”. Any advice on how to proceed from here? After doing some research on the internet I tried the following statements already:select @test_varb, CAST(@test_varb as varchar(max)), CAST(@test_varb as varchar(max)) COLLATE Latin1_General_100_BIN2_UTF8, CAST(@test_v

When I filter in Universal GUI, it works. When I save this as a pre-filter and filter again on it, it results in bad requests Because it is not possible to create a simple ticket in TCP, I put it here!!   I cannot share the whole URL in this ticket!FYI: the 2 fields are expression fields  

In the windows GUI, after changing your password, you get errors during default procedures. The debug only says: “Default”.This is solved by restarting or reinstalling the Windows GUI. Reproduction steps:Open the windows GUI Change your password to something else Trigger actions with default procedures and lookupsCurrent behavior: An error with the text: “Default”Debug console: default***QUERY**addition: The software factory has the same behavior

Thinkwise end application is created and deployed, but can’t be accessible even for the IAM admins. We need immediate support! 

In the release notes of Universal GUI 2024.3.12 you mentioned Task Grouping in your introduction, but after upgrade we do not see any changes.   

We have a workflow to set default filters when someone opens a screen;Step 1) Open document … triggers …Step 2) Decision; Filter valuesStep 3) Set the filters.This did not work for a while, but works again.I now tried to create the same at the moment that the user opens a subject which is a detail, but the workflow doesn’t start.Does anyone know how I can start the workflow at this point and set the filters?Thank you,Daan​​​​​​​

When using the windows GUI (TSF_dotNET.exe version 2022.2.16.1) to connect to a SQL Server 2022 database backend it shows when using USE [master];GOSELECT *FROM sys.dm_exec_connections;GOthat no connection to our application is using an encrypted connection.The encryption of the connection can be forced from the server (by using a (if needed self signed) certificate), but of course the clients (windows GUI, Indicium and whatsoever) should support this.Regarding this situation the following questions come into mind:Is using an encrypted connection between de windows GUI 2022.2.16.1 and the backend database server supported ? If so, please point to the appropriate documentation Am I correct in assuming that username and password are at this moment (in a situation of no encrypted connection) exchanged in plain sight ? How is the exchanging of username and password between GUI in general and application, by whatever means, ensured that it is encrypted should we be using the latest releases

Hello everyone,In our software sollution, on some screens, the columns tend to be out of proportion. Here is such an example:The status column is out of proportion, because it is way too big for the small word in there. It gets even more creative with the responsiveness when we hit the task with the padlock icon:now suddenly the projects get out of proportion, we don't know what causes this. It might be one of our settings, but we simply cannot find it.Does anyone else have this and had a solution?

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?

I am looking for a way to simulate the Export functionality that is an option in the GUI, but turn it into a process flow so I can run it as a background task. Also prevent a user having to make certain choices on what to columns to export and to what file format it will be.Certain customers desire large data exports and the .xlsx option will cause OutOfMemoryExceptionOut, but .csv seems to succeed. This process takes quite a while to complete, even though the view itself has the data selected in less than 10 seconds. All this is reason we want to take away the options for customers and put the wait as a background process.What are my options in this case?

Hi, Is it save to assume that icons that cannot be updated with this feature are not used in the model? And can be removed without issue.If so, would it be an option to create a prefilter/(or task) ‘Unused icons’ - similar to whats available on the Domains-tab. Blommetje

I have some big files to upload to Drive/Sharepoint via Graph. How do I model this scenario in Thinkwise?Steps to Upload a Large File Using Resumable Upload Session Create an Upload Session Use the /drive/items/{parent-id}:/{filename}:/createUploadSession endpoint to initiate the upload process. Request: POST https://graph.microsoft.com/v1.0/me/drive/items/{parent-id}:/{filename}:/createUploadSession Authorization: Bearer <access_token> Content-Type: application/json Body (Optional): { "item": { "@microsoft.graph.conflictBehavior": "rename", "name": "your-backup-file.bak" } } Response: The response contains an uploadUrl that you use to upload the file in chunks. Example Response: { "uploadUrl": "https://upload.url.for.your.session", "expirationDateTime": "2024-11-16T23:59:00Z" } Upload the File in Chunks Divide your file into chunks and upload each chunk using a PUT request to the uploadUrl. Chunk Size: Recommended size: 10 MB (10,485,760 bytes). Maximum size: 60 MB (62,914,

Is it possible to automatically refresh visible detail tabs when a field is changed and auto-commit is enabled? 

We have a process flow which will be started by a task. It wil open a document in popup, and after selecting a record in that document, we need to continue the process flow with this selected record. We want to prevent building two process flows, as it will be difficult to save the selected row in one process flow and pass it to the next one. Now i know there is a process step called Manual. First question is: What does this process step do? The documentation is not very elaborate on this. Second question, can we use this manual process step after opening a document, to wait for user input, and continue after a new task was clicked in this same window?

 How can I add extra separate attachments in the process flow from the project folder ?

Hi!We have for now some places in app where we do want some precision for our fields, usually we use type numeric with different specifications depending on the needs.The problem that we have is that we don't always want to show all the decimals, we need them for some calculations still.It is already something to do that and we just didn't find out what? Is weird to display that many decimals if the user doesn't need them but for background calculations are needed. (This example maybe is a bit to much, but for 6,8,10 decimals can be some situations and still are a lot to display)If not, we don't want to fake with with a field of another type with some format and so, maybe we can have another setting on the domain for this situations where we can specify display decimals. (other cases can be for description fields for example if you want just a preview of description and maybe more uses).

 Hi!We have quite a few dropdowns which are pointing to variants and seems like for all of them once a few weeks we get them stuck on this "Loading...”.The strange part is that if you let it open and wait to dissappear, click again on the dropdown, the results are there.Do you have any idea what is going wrong? Is not for a specific table and some variants don't have anything fancy, just some prefilters. If we try directly with the table/view, the problem does not persist. 

Hi, im trying to retrieve the parent_row_id from a newly added row. However @ and T1 both dont work. Anyone knows how I should fix this?select top 1 step_nr + 1from calculation_step--where calculation_method_id = t1.calculation_method_id «order by step_nr desc