Questions & Conversations

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?  

How do you write the result of an HTTP connector via a Write file to an Azure file storage?I followed the steps described in: https://docs.thinkwisesoftware.com/docs/sf/process_flows_connectors#write-files-to-an-external-locationIn the log I get the message:[ERR] Process action 'write_file' in processflow 'write_product_to_excel' returned the following message: Process action 'write_file' in processflow 'write_product_to_excel' was not provided a (valid) value for its 'File location' parameter. (ca3b443c)How should the File location be configured?I have now setup the followingThe project contains the storage location bc_customer_data:The process flow variable is created as follows:I configured the write file connector in the following way:In a process procedure the file name is set: 

Hello everyone,We asked Thinkwise Support about the way to set up the Exchange Connector in cases where the legacy EWS Connector is missing from Azure. The reply was to add full Application permissions for the newer Office 365 Exchange Online connector in Azure. However, that Office 365 Exchange Online option is not present in Azure either.Microsoft advices to use the MS Graph connector for as much as possible. We might be able to go that route. But we're curious about the contingency plan for the Thinkwise Exchange Connector. Is there such a plan? What is the future for this connector?Best regards,- Alex

Hello, I want to copy some columns from a linked table to another table. I want to know if it's possible to select with check boxes in a pop up screen which columns have to be copied?

Hi all,I noticed that there is a duplicate taskbar in Universal gui. Ofcourse in the screentype this is added as a component but when I remove the taskbar from the screentype it seems to work as intended. Why is that? img 1: screentype where taskbar component is added  img 2: screentype where taskbar component is not added 

Hi,I was playing with the Upcycler. In general things went ok, but I have 2 questions. 5 files failed with importing the data. Is it possible to only run these 5 files again, by removing the successful files from the folder, of might that conflict with things? Or do all the files need be run in 1 batch (and thus removing the data from the db for a new run)? And what would be the advice in fixing these issues? e.g.; A table name is ‘INDEX’ , so sql doesn’t accept it. What stage of the upcycling would be best to change this? Also, the encoding of the data files .json was selected by the Upcycler, but when importing it was not the correct Encoding. I selected the utf-8-bom for importing and then it worked. Is this something that I could have seen in advance? Thanks! 

I want to activate a special theme with extra large fonts for a visually impaired end user. In the user preferences in IAM I have set this specific theme for the user in question, but it doesn't work.What is the correct way to get this done?

Is it possible to change the database value from 0, 1, 2 etc to strings as shown below: I have tried it and i get an error at "Execute source code” 

Hi all,when multiselecting records in Universal GUI the selected records get a gray background as seen in img 1. img 1 But when you set a background color as a conditional layout, the multiselect becomes unnoticeable(img 2)img 2In img 2 I have selected the last 3 “Service” records but it is not noticeable.How can this be fixed?Thanks.

hi,For printing documents (pdf files, txt files for label printer) we need some settings per user so we can specify which printer is to be used (without manual user input). So I need a look-up for printers.In advanced menu we can add printers, but can we use this table in our data model? Or are these printers only for reporting?

I like to achieve the following in our application (Web GUI):When the user executes a certain task a download* is started and shown in the running tasks window. When the download is finished the user can retrieve the file via the running tasks window.* The download is the response of a select request to indicium with the option to export as XLSX added (&$export=xlsx).It should behave the same as how you can download a GUI via the TCP website.What steps are needed to achieve this?

How can I have an empty grid (to start with) and a dropdown from a related table?  Now it stays empty, because I guess there is not information shown yet in the list. 

Is it possible to display multiple lines in the treeview component?I've been trying to add char(13) + char(10) and \r\n but both won't show the second line.  

We have a table with readings per vehicle. This table is reachable via indicium universal for external parties. They can query by vehicle, sort on date etc etc… That's all fine. But if one forgets to use Ttop=10 of $top=100 for example in the URL, a list of thousans of records can and will be returned.When setting for example max_no_of_records on a table, the (windows) GUI respects such a setting. Indicium universal however ignores this setting completely. Will this be introduced in a future release of indicium universal? And will there be a way to query a variant in the future?