Thinkwise Platform

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 have set-up a white list of file types that are supported in the file storage:However, this only works afterwards. Users can set other extensions during the import and will receive an error message afterwards. Edit by moderator - Please keep the Community posts in English ik heb bij de file storage een white list opstellen van bestandtypes die ondersteund worden:https://docs.thinkwisesoftware.com/docs/sf/overview#file-storage---allowed-extensions Echter werkt dit wel maar alleen achter af. Gebruikers kunnen wel andere extensies instellen tijdens de import en krijgen dat achter af een foutmelding. 

We have updated our desktop and webgui to 2022.1.19. The old webgui was 2022.1.16.We have a problem with the webgui.When using ctrl + to add a new record without saving the previous record, several fields ar not visible anymore, where they were in the old webgui. We checked the lay parameters using the debugscreen, and the fields should be visible according to the value of the parameter (@jrn_debiteur_type = 0 and @jrn_debiteur_mand = 1).  In the Windows gui the fields are correctly shown. Also, when we first save the previous record, and then add a new record, there is no problem. In the old webgui we also didn't have this problem. Looks like a little bug to me?

How to set focus on a specific row even after inserting a new row in a table?

Hello, I created a task that insert a row with values from table A in table B. It is possible to auto refresh the table B, so the changes to be visible after inserting, without doing a refresh on the screen?

Is it possible in IAM to change for all users in go; Set password expiration policy Set pass 'Allow Change’ checkbox Set Theme (I have a testing environment and want to make sure the end user sees this very clearly with a very different color scheme) 

how can i view the Http request content in a proces flow monitor?   

I have an issue with the DeleteAppointmentTaskScheduler. It works fine with the SF-model, but I can't get it working when I use the application in IAM. Checked:Same GUI (2022.1.18). Extended property set in SF (not overruled in IAM, and not in ini-file). Model rights for the task, parameters and tab task. The task can be used directly from the table.  Database rights (execute task).  Special charactersWhat else? 

Hi,Is it possible to create a varchar domain that has a specific regex pattern? Like a dutch postal code, having space between the numbers and letters. Or is this only possible by changing the entered value with a Default.

hi, When creating json messages for a 3rd party API, we use SQL to create the json structure. This json message has > 100 fields, and most of these fields are in our datamodel. But, of course, our column names do differ from the API fields, so we have to alias these fields in the procedure.Is there a way to have our column names following the TW naming convention, and register the API field labels? I see columns have alias property in the data domain, can we use this? 

How i can make a task by deafult to be disable and only after selecting a specific row to be enable?

Hi. I created a chart for the past 2 months..  and a few things:I have a date column, which is shown as a timestamp (date_time).. why? Looks like a bug.  When you create a chart, the SF creates date groups.. these don't work with the Universal it appears.. it just gives errors when you want to use them.   

I am trying to send an email to the employee through SMTP connector in a process flow. It works fine with constant value as input (To Recipient) field and receiving the email too. When i tried input with process variable as expression, it is showing error, status code -1. How can i make it work? In my use case, each time the email id will be different, that expression should pick the correct email id but it fails to do so. 

Hi,In the use log in IAM I can see the use_log_sessions by many users.Only 1 user does have use-log_actions?How can I turn on the logging for other users?And can I query the number of times a task is used by a user?I can see some data but this is more than 1 month ago.  select * from use_log_usr_action where project_id = 'serp'and usr_action_type_id like '%task%'and project_vrs_id in ('1.54','1.55','1.56','1.57','1.58')order by date_time desc

Hello everyone,I'm trying to realize the following; upon log on of the user, the user gets presented a more or less personalized dashboard. The dashboard contains, among other things, a list of notes (made by other users) that are assigned to the user.In order to get this done, we need to execute a process flow or system flow that fires a tsf_notify at some point. Is there a way to fire a flow when a screen loads or is loaded? Is there some "done loading" event that can be observed or hooked into? Can a screen, for instance, be configured for auto refresh, as a refresh event can fire a flow. We could make the flow stop the refresh, so the refresh only happens once. Just a thought.What would be the proper way to go about this?Thanks in advance,- Alex.

Hi,An 3rd party API gets us a JSON with a base64 encoded file which I can save in a varbinary field. Now this file contains specific text we need to extract, and this is possible by saving the file first to a temporary location, and then use process action Readfile to get the content in a process variable and then process it in a stored procedure.Can this be done without the temp saving of the file? It feels like i’m using 90’s technique 😉 but I cannot find any suggestion in documentation or community for decoding the file on-the-fly. 

Hello all,In our program we discovered that a column should have been mandatory but was not selected to be in the SF. This has been fixed in a later version by simply making the column mandatory, and we wanted to try to use the Data conversion functionality to fill in the missing data. The following expression has to be used for filling the column, and this has been selected in the SF as well;isnull(t1.calculatie_soort,(select ws.standaard_calculatie_soort_id from waarde_standaard ws))However, when generating the code for this upgrade, we found out that the SF generates a faulty statement when inserting the data from the renamed table; t1."product_type" as "product_type", t1."calculatie_soort"(isnull(t1.calculatie_soort,(select ws.standaard_calculatie_soort_id from waarde_standaard ws))) as "calculatie_soort", t1."per_1_of_100" as "per_1_of_100",As you see, unchanged columns are fine, but our change column "calculatie_soort” now causes an error, as bot the "normal” co

Hi all,when executing the “tsf_send_message” function I get 2 diffirent design of the message box.For context, in img 1A. I use a custom made message named “warning_msg” in a DEFAULT control procedure which return the design shown in img 1B.img 1Aimg 1B Now I use the same concept of the “tsf_send_message” (img 2A) in a TASKS control procedure but as we can see in img 2B, it uses a diffirent design. I think it uses the browser default message.img 2Aimg 2B I would like to use the same design accross all procedures. Please help!Thanks.

Uploaded images are displaying unevenly based on its resolution. Do we have any option to make it fit to size? 

Hi all,In a project using the Universal GUI we want to import Excel files that unfortunately don't meet the prerequisites of the Indicium Import API. However, we do have a solution for this. In a frontend JavaScript application, we are able to read the Excel file and map the contents to a JSON structure. Then this JSON can be imported through an API endpoint.But I still have two questions: Is it possible to load the external application within the Universal GUI, for example in an iframe? Is there a way that the user does not have to log in again on the external application? Do we have to pass an API key or is the user already logged in on the API once he's logged in on Universal? Thanks for your help!

I am experimenting with multitenancy options. Currently I have a user table, and here a Tenant is set. When that user opens a table, a mandatory prefilter filters on Accounts with a matching tenant_id. This way, the user will only his accounts. Works ok. When this users Adds a new account, I need to save the users tenant, in the account record. I added a field with Default Value type: Expression - and then the expression is; select dbo.get_tenant() So far, still good. but, now I need to add this expression in all tables/columns where I need this. So I thought of making a Domain, with an expression set there. Feels more efficient. However, it doesn't show a thing! Here I have create 4 columns. Default value in column Constant value in domain (dbo.get_tenant ) Expression value in domain (dbo.get_tenant) (which copies to column values) Expression/query in domain (‘text’) Calculated field; expression in table Domain with expressions - which shows blank in the form.  So, why can I not set a

Hi,I was wondering how to (auto)scale/resize an image shown in the preview component in Universal. As you can see below, the image is shown at its original size with scroll bars in Universal. The Windows GUI does automatically scale/resize images.Universal GUIWindows GUII tried using an expression with the HTML domain:concat('<img src="', t1.product_image, '"style="width:100px;" alt="image"/>')Which results in:<img src="https://vastgoedpartner.nl/wp-content/uploads/2018/12/IMG_3845-4.png"style="width:100px;" alt="image"/>Unfortunately, the preview component does not seem to pick up this HTML calculated field and it keeps showing the image url (website domain). I've also tried the following variation that includes the html & head tags, but this did not change anything.concat('<html><head></head><body>', '<img src="', t1.product_image, '"style="width:100px;" alt="image"/>', '</body></html>

Hello everyone,Has any of you experience with clients that manage and edit the templates used in their solution themselves? We use the DevExpress Report Designer to create templates for the client. However, the client wants to do the editing and maintenance of these templates themselves. As far as I know there is no wysiwig editor for this, so the client would need to use the DevExpress tool as well. This involves a creation of the application after an upload of the template in order to synchronize the report. What would be the proper way to instruct the client in this case? Or are these actions something that you never unlock for the client?Best regards,- Alex.

Hello, I want to create some defaults in functionality for some fields and to be able to change them after. Is it possible or do I need to use something else? 

We have been working a bit with the scheduler and I have some questions on how to solve it or when it could be seen in the GUI. How can we have the date range in Portuguese localization? It appears that with the scheduler component there is nog update button, how can I refresh it?  Is there a way to dynamically color the bars?  In this case there are 2 distinct flows..  I want to give them a different color. And if I have 3 different flows I want 3 different colors for the tasks matching the flow.  Is there a way to show the day of the week that is shown?  Can you give weekends / holidays a background color? Can we zoom in smaller then days (I know that question has been asked before).  can the list on the left be a tree for example?  That you can show the main levels and expend to lower levels?