Thinkwise Platform

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.GoalMany application have functionality for importing or exporting data in XML format. Sometimes you will get an error about an illegal XML character:XML parsing: line 1, character 2967663, illegal xml characterAnd then you will have to try to find that character, which is very hard. This solution can help you out.SolutionThis solution creates a stored procedure search_illegal_xml_characters which searches your entire database for illegal XML characters. It is also possible to search in one specific table.The procedures uses a function, remove_illegal_characters_for_xml, which is also created in this solution. Important: this function does NOT remove illegal characters from your database. It only removes those characters from a string.Dynamic model add_search_illegal_xml_charactersThis dynamic model code creates stored procedure search_illegal_xml_characters and function remove_illegal_ch

Is there a way to format messages? For instance use different font sizes, using bold or place an indentation or icon?Is there also a way to make process variables editable within a message?

I'm having a problem after synchronising a new version of our product to the customer where it looks that new added columns are not known for some users. Some other users don't have that problem.The problem is visible, because the layout procedure gives an error:Stored procedure “lat_product” genereerde een fout bij het afleiden van de parameters InformationNew columnsHowever, this is only happening with some users. When i am logged in, in my computer on the customers side, and when I open that version, I don't have that problem.Are there any directions I can look into?

I configure my startup documents as in the screenshot below.On restart of the SF the result is not as I would expect; the list is deduplicated, and the SF is booted accordingly.  Is there some trick to get the Software Factory to dance to my tune? This occurence is on platform 2020.2, GUI 2020.2.20. 

Shouldn't tooltips be visible for items in the Listbar menu?The tooltip is now shown when the mouse moves over the tab of an open table, while I think it is less desirable there.

I am not able to make the drag-drop interaction work on the resource scheduler.I can only drag an item to the green square area and not to the yellow square area. (screenshot 1)When I drag it to the green area, it also doesn't fill the resource_id field and the drop_date field. (screenshot 2) I believe I have filled the settings in the extender also correctly, I believe. (screenshot 3)  screenshot 1screenshot 2 screenshot 3 

I'm trying to connect an IAM (2020.2) test database to Indicium 2020.2.12 at an Azure App Service, but I get stuck at a certain point. When I try to access the root directory of Indicium I get the following.An error occurred while starting the application..NET Framework 4.8.4210.0 X64 v4.0.0.0 | Microsoft.AspNetCore.Hosting version 2.2.0-rtm-35687 | Microsoft Windows 10.0.14393 &The logs says the following:2020-11-18T15:13:39.0399438+00:00 [INF] Initiating startup license check (a070e428)2020-11-18T15:13:39.1962080+00:00 [INF] Reading license from IAM. (d4563d62)2020-11-18T15:13:39.4790579+00:00 [INF] License successfully read from IAM. (66b06fb5)um.Startup.getOpenIdSigningCertificate() in C:\azp\agent\_work\1\s\src\Indicium\Startup.cs:line 658 at Indicium.Startup.configureIdentityServer(IServiceCollection services) in C:\azp\agent\_work\1\s\src\Indicium\Startup.cs:line 605 at Indicium.Startup.ConfigureServices(IServiceCollection services) in C:\azp\agent\_work\

Anyone?We use the mobile interface extensively and 1 of the most used options is to use files and images to communicate. We are a bit struggling with this because not all of the JPG’s (image upload fileds) can be opened on mobile. We can see the thumbnail in the GUI but normally if you tick the thumbail the image can be viewed ‘large screen’.  With some jpg’s we see the thumbnail but when opening a white screen is shown. Can it be the file size of this particular image which is ca. 4,5 MB. It’s a picture create on a Canon Ixux. (As I can see in the image properties) If I upload a new image, from the camera of my mobile (Samsung A40) a jpg file is created as well and this file can be viewed when ticking the thumbnail. I see only a difference in file size…. What could be the cause that the view window is empty. (totally whie) 

When using the resources scheduler in a detail screen, the row height is not automatically adjusted based on the content.I have to press the little arrows mulitple times to get the appointment bar.I have set the property ‘Auto row height’ as 1.How can I solve this?Settings in SF screenshot of the rows with incorrect height 

How can I make a print selection of reports, process flow yes/no?

In the app we are currently building we have a screen with 7 items. When we only had 6 items, the screen was shown in 1 column. After we have added an extra item (number 7) the screen is divided into 2 columns, while the screen could be made larger to show all items in 1 column. Can we set this up somewhere? We use the Universal GUI. It does not seem to respond to the "No of columns in form" setting NB. In the Windows GUI the (7) items are shown in 1 column

Hey everyone,I would like to migrate from the Basic Indicium to the Universal Indicium. I am currently using the Basic Indicium for interfacing with another system through the web. Does the Universal Indicium support the full API interfacing features which the Basic Indicium supports? And are there any differences between those 2 types of Indicium that I should take into consideration when switching from the Basic to the Universal Indicium?

The normal view of records is in a grid where each record has its own row. Currently something has changed (unknown what) with the result that each there is some way of grouping/tree.How do I switch between the original and this grouped view? And is there a way to group it not on “Datum”, but on another column in the grid?

At certain points in our process we want to inform users of certain events. For instance when a response time is about to expire and immediate action is required.What options are there in Thinkwise of informing users?Currently we are thinking about sending an e-mail (badges aren't visible outside of the application), but am getting lost in the various options that should be there, but that I can't seem to find. For instance my SQL Server on Azure does not support msdb..sysmail_profile.A simple and detailed explanation would be welcome.

I've created a constraint to a table (check if date from is before date until). The moment I trigger this the following message is shown:Unfortunately I see no way of changing this message to a custom message that explains clearer what is wrong.I also want to show this my highlighting the involved fields or placing the message beside one of the fields.Any ideas to make this happen are welcome.

The theme for our application was developed a long time ago (2014 with TSF G8).Because we are now using the screentype component “Prefilterbar” more often, we need to improve how this looks. When we designed this, apparently the background color was set to gradient (white to gray) but now it is not always clear when a prefilter is active or inactive. This is especially a problem in the web GUI. In the Windows GUI it does look how we would like to have it.This is how it looks in the web GUI (no clear contrast between active and inactive):  This is how it looks in the Windows GUI (clear contrast between active and inactive): The same theme is used for both platforms. What do I have to change to improve the look and feel for the inactive prefilters the web GUI?

Is it possible to remove the Options section at the login screen?For our end users it's not relevant and only raises questions. I'm aware that it can be set to read only, but that isn't enough.

Is it possible to disable the dark mode theme in the Universal GUI?

I would like to validate if the input is valid, using regex.In my case it's a text field where the user can enter an IBAN number. Is there an option in the SF to do that? Thanks, Regards, Peter

is it possible to print from the web gui to a local printer crystal reports or reporting service

I’m trying to get the IAM login logo to show up in the Web GUI. I use SF 2020.2 with all hotfixes applied and using Web GUI 2020.2.22. In the IAM i did configure the Login Logo in the Global Settings → Login → Logo and uploaded a file. I also invalidated the caches.The Web GUI still displays the Thinkwise Logo.I know that this setting is available with the settings.ini file, but i try to keep all my application data together in the database. I have not specified an ApplicationLoginLogo property in the settings.ini file.Am i doing something wrong here, or is this functionality not available yet in the Web GUI?

How can we use the cursor_to_col_id parameter in a default procedure when using Universal GUI?In this question it's mentioned this parameter only works when leaving the field by using the [Enter]-key. But using Universal GUI it's not possible to use [Enter] to leave a field.Especially if a user works on a mobile device .

Hi!Is there a way to hide all the action buttons (so including the Refresh button)? We are using a Detail Tab in the Screen Type and we would like to see all the action buttons, including the white-space, to be hidden. ps. Turning off the ‘Navigation’ checkbox does not help.

Is it possible to show SVG as image in a cardlist column? We have a column with a SVG-element. But when i use this column in a cardlist, the SVG-element is not translated to an image. It shows the SVG-element code instead of the image.We are using the latest version of the Universal GUI (v1.5.2).

When modeling roles, you can easily verify this using Role simulation. I noticed this only works for the Windows GUI, the Web GUI isn't affected by this setting. Is this intended?We try to only use the Web GUI (while developing) as our end users also use this GUI, not the Windows GUI. In the past we’ve encountered several issues due to differences in Windows GUI / Web GUI, so we try to keep as close as possible to the product the end users sees.