Thinkwise Platform

Hi,   When exporting a grid to Excel the data will be shown in Excel with the standard Calibri font. I would like to see my data appear with the Tahoma font. When I change the default font in Excel to Tahoma, my data still appears in Calibri. Is this because the grid is exported with a standard lay-out using Calibri? If so, can I change this to Tahoma? Or do I have to use conditional formatting to change the ‘export’-font? I would like to do this for all grids by default.    

The Thinkwise suite adapts colors of SVG icons to the menu items and tabs they’re used in. That’s a really nice feature. But how do I color SVG icons in other places such as image combo’s and prefilters? Of course I could color SVG’s manually but I much rather control this in other ways such as themes and conditional layouts. I’ve tried conditional layout but it only affects text unfortunately. I would also like to be able to add padding to icons. The only way I have seen so far to make icons in a grid smaller is by making the column narrower but that’s not always an option. We’re on version 2019.2.

Is there any easy way to set focus on fields within mobile apps. The layouts don't seem to work.

For big dataset it could help a lot for the performance to avoid using 'LIKE’ in where clauses. I expected a different behavior, depending on 'Filter Condition’  Example: Combined filter value: 2019 2020  Result:    SELECT .. FROM .. t1 WHERE (t1.[ACC_YEAR] LIKE '%2019%’) or (t1.[ACC_YEAR] Like '%2020%’) Should be: SELECT .. FROM .. t1 WHERE (t1.[ACC_YEAR] = 2019) or (t1.[ACC_YEAR] = 2020)  

Is it possible to test offline functionality in the 'debug viewer’.

Hi all, Can someone explane what the purpose of the “Task parameter tags” and how it works. This can be found by the tasks.   There is no documentation avaibele on this subject yet.   Regards   Ronald Gombert  

Is there a way for a user to see which screens and records he has opened lately, with the possibility to navigate to them right away?

A user of the web GUI wants to create a new password for his user account. The authentication methode is “IAM” and login verification is set to “Password” in IAM. Because we host the application on our IIS for multiple customers, we are the administrator of IAM for these customers. I know I can set a new password in IAM myself, but I do not want to know the users password. So I want to let him change the password himself. The settings “Allow change” in IAM is set to “True”  and Expires is set to “Change after login”. The user is able to set a new password in the following form:   After changing the password, the following message appears: So far so good. But when trying to login with the new password, I get an error: But the user can login with his original password, so the change/update did not work! Same problem when trying to reset the password via the option “Change password” in the blue tab.     The Application Pool user has owner rights on the database, so that should not be the

how to create sql sequence in SF 

I have multiple users and I have to assign opening objects or landing page as per the users.. eg: buyer, supplier, management etc. When ever a specific role user logs in, he/ she is suposed to land on respective screens.

Is it possible in some way to expand and collapse all items in the Resource tree view with the Resource scheduler? Currently the resource tree is fully expanded by default but I would like to be able to collapse them all in one go if possible.

The Windows GUI can recolor black SVGs to match the label color, but the Universal GUI needs SVG's with no color. Should I uncolor all my SVGs or should I wait for a Universal release which fixes this?

Hi,   I am trying to get an application for mobile up and running. I have made a small test application and deployed it on a test server using our test_iam. When trying to log in using the desktop viewer I receive the above error. The network tab in debug shows no error. Using insomnia I am able to login to retrieve the metadata using the same credentials. The IIS and indicium are working fine, we are also using it for communication with our webshop. I checked all iam user settings, but they seem fine since I can start the application with the desktop GUI as well. screen login:   What am I doing wrong here?  

Although I didn’t learn about this in my standard SF training I recently found out that there is a way in the SF to make a column unique by creating a unique index. See picture below:   I wonder if this is common practice when one needs a value in a column to be unique? Are there any drawbacks that I have to take into account? I also wonder why this option isn’t available when creating the column?

Are you actively testing heatmap analytics 'frameworks’ (support) on the webgui/universal UI? Especially an implementation for user behaviour tracking. - Hotjar for example. For those that are unkown with heatmaps: Heatmaps are visual representations of attention, engagement, and interactions generated by your visitors as they navigate through your application. It uncovers areas of improvement in our business processes that we've always guessed but never really gotten confirmed to focus upon. May just also be the best solution to get to focus on the right/proper testing area's -  business process wise and technically -  but also where to place AI/ML in between It also helps detecting where we can/should add functionality and where to ditch or reposition certain functionality that never ever gets touched. (Which happens more often than one would think)

The new version of the SF 2019.2 has a new prefilter "My projects” who's default active. The Software Factory doesn't recognize our NIVERPLAST project as "My project” anymore. I don't know the exactly prefilter conditions but probably this prefilter is watching to the database-user in combination with the user who created the project in the SF or something like that?  For me it feels like a bug but maby there is a good explanation for it?    Project: … (Hidden behind prefilter "My projects” )  Prefilter "My projects” default ON    

In our application we usually allow the standard export of a table through the button on the lint. In many cases though there are columns which are used for calculation of presentation but are not meant to be exported. It would be handy to hide these columns from the list of column to export when the user chooses the advanced export. Unfortunately hiding such a column in the ‘Subject’ tab or through a layout does not have the desired effect of hiding it from the export. So the question is: is there actually a way to hide a column in a table so that the user can never select it for export?

Apparently the mobile app starts resizing the columns to a “collapsed format” when the screen size is lower than 800px. It looks like if all information for the entity is displayed in a single column, this give the following result:         Both images are the same grid. Is there an option or setting so we can force the display of the grid to not collapse this information, and start showing the configured columns (second image)? 

We would to be able to send whatsapp messages from the application to users, in this case employees. Has anyone done this with the SF? Pleas let me know.

I like to create a very simple grid to add and maintain records in a table. To make it even more easy for inexperienced users, I like to create an ‘Add’ button in form, with a task without logic. Result:   To let it work I like to make use of a simple process flow. For some reason, it does not work. The process flow monitor remains blank. What am I doing wrong?          

I'm trying to let the end user import ‘large’ sets of data (CSV/Excel) into the database via the Web GUI. It's not that large as in this (https://community.thinkwisesoftware.com/development-13/best-practice-for-inserting-large-amounts-of-rows-into-one-table-837) thread, but large enough to let the web interface time-out. The problem then is that the import is partially done: It could have imported for example 3k of 50k records. The end-user doesn't know what to do: What part is partially imported? And how to fix it? I'm trying to speed this up, but I can't really increase it's performance. When I take a look at the debugger in de Windows GUI I see a lot of database-calls per row. For each row the default and layout concept are triggered, and the record is inserted per piece. Imagine you want to insert 50k records, and each cycle takes only 5ms, but when it's multiplied with 50k it's 250 seconds. From a user point of view this is absolutely unacceptable (besides it probably crashes in t

I'm having difficulties unit testing certain concepts like a context. Let's say I'm having the following use case; The purchase_order (PO) contains purchase_order_line's (POL). When the PO has the status ‘done’, the user or api cannot insert or update PO lines for that PO. I've disabled this using a trigger, i.e. if exists ( select 1 from inserted i -- purchase_order_line join purchase_order po on po.purchase_order_id = i.purchase_order_id where po.status = 'done') begin -- abort etc, cancel insert/update for purchase_order_line.end I have attached a layout and a context concepts for both the PO and POL's. I want to unit test the behaviour for in example the context or layout of a purchase_order_line, that certain tasks / buttons are disabled. This can be done via unit test or via process tests. If I do this via unit tests I have to create a Data set. When I do this and I execute the unit test, the data set creation fails: Due to the trigger i'm not able to both insert a purchase_or

Windows Defender doesn’t see Thinkwise Software B.V. (TSF_dotNET.exe) as a trusted app. I don’t know which conditions you need to comply but it would be great if this application is recognized as trusted and the message doesn’t have to shown. It can be confusing for the users.  Windows Defender Smartscreen message Click on the link “More information” to get the following two buttons Choosing “Do not execute” the following error appears  Once accepted by choosing “Execute” the message will not come again.

I'm trying to use the Indicium OData API via a .NET Core 3.0 console application. I receive an exception on inserting records, while the record is inserted in the database. I have no clue why. I'm not sure if this is an issue in the Indicium OData API or the .NET nuget package. For example I want to add a ‘server’ to the IAM database. By using a generated piece of code (see https://docs.microsoft.com/nl-nl/odata/client/basic-crud-operations) this is quite easy to set up; Add the indicium OData API via “Unchase OData Connected Service” Configure the metadata ($metadata.xml is the result of http://server/indicium/iam/iam/$metadata)With the following code you retrieve the ‘server’ table and insert a new record in to it: using SQLSERVER_IAM;using System;using System.Net;namespace IndiciumTest{ class Program { static void Main(string[] args) { var uri = new Uri("http://server/indicium/iam/iam"); var container = new Container(uri); container.Credentials = new NetworkCredential("userName", "p