Skip to main content

Questions & Conversations

Ask a question or have a conversation about the Thinkwise Platform

  • 3,019 Topics
  • 10,404 Replies
3019 Topics
Hugo Nienhuis
Superhero
Hugo NienhuisSuperhero
asked in Questions & Conversations
export font settings to excel

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.    

1682
Hugo Nienhuis
Superhero
R
Hero
RolandHero
asked in Questions & Conversations
Style SVG's used in image combo and other places

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.

991
Jasper
Superhero
O
Vanguard
Onno SpoorVanguard
asked in Questions & Conversations
Set focus within mobile apps

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

1063
Leroy Witteveen
Moderator
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations
Combined Filter Conditions

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)  

1414
Harm Horstman
Superhero
P
Captain
Peter KruisCaptain
asked in Questions & Conversations
Offline functionality testing

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

1114
P
Captain
R
Apprentice
RonaldApprentice
asked in Questions & Conversations
task paramter

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  

1123
Mark Jongeling
Administrator
P
Captain
Peter KruisCaptain
asked in Questions & Conversations
Last opened screens

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?

652
P
Captain
Johan van Eijsden
Captain
Johan van EijsdenCaptain
asked in Questions & Conversations
Reset password

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

1977
Johan van Eijsden
Captain
eurban
Captain
eurbanCaptain
asked in Questions & Conversations
Sql SEQUENCE

how to create sql sequence in SF 

1164
eurban
Captain
A
Vanguard
AshwiniVanguard
asked in Questions & Conversations
How do I set a table as a start object or landing page when ever a user logs-in

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.

1211
Mark Jongeling
Administrator
Mark Jongeling
Administrator
Mark JongelingAdministrator
asked in Questions & Conversations
Expand/Collapse all items in Resource tree view - Resource scheduler

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.

1242
Mark Jongeling
Administrator
Jop ter Horst
Vanguard
Jop ter HorstVanguard
asked in Questions & Conversations
Colorless SVGs

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?

1312
Jop ter Horst
Vanguard
Hugo Nienhuis
Superhero
Hugo NienhuisSuperhero
asked in Questions & Conversations
Mobile - username and password combination is incorrect

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?  

1244
Hugo Nienhuis
Superhero
D
Vanguard
Dennis BeerenVanguard
asked in Questions & Conversations
Drawback of using unique index on column

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?

1372
D
Vanguard
Ricky
Superhero
RickySuperhero
asked in Questions & Conversations
Heatmaps

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)

1273
Ricky
Superhero
Dennis van Leeuwen
Hero
Dennis van LeeuwenHero
posted in Questions & Conversations
SF - Prefilter "My projects"

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    

791
Mark Jongeling
Administrator
M
Rookie
Miriam RoccellaRookie
asked in Questions & Conversations
Hide a column when exporting a table

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?

1111
Jasper
Superhero
E
Sidekick
Edwin van de PeppelSidekick
asked in Questions & Conversations
Mobile APP Grid size

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)? 

903
E
Sidekick
E
Sidekick
Edwin SaanSidekick
asked in Questions & Conversations
Has anyone implemented integration with whatsapp messages somehow?

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.

2462
E
Sidekick
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations
Add row in grid, with process flow

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?          

1843
Erik Brink
Moderator
R
Superhero
René WSuperhero
asked in Questions & Conversations
Bulk import CSV / Excel data

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

4974
Erik Brink
Moderator
R
Superhero
René WSuperhero
asked in Questions & Conversations
Unit testing and triggers

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

1821
Serhat Sahin
Apprentice
Dennis van Leeuwen
Hero
Dennis van LeeuwenHero
posted in Questions & Conversations
Windows Defender - Recognized Thinkwise as trusted application

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.

843
Roel
Vanguard
R
Superhero
René WSuperhero
asked in Questions & Conversations
Consume OData API via .NET Core

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

11191
V
Moderator
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations
Change the layout of email notifications in the community portal

Can the email notification messages send by the Community Portal be made more focused to the topic? This to make them more valuable to read. The same picture with a man watching his tablet PC, doesn't make sense and is just pollution of my inbox. The title of the topic should be part of the email subject, something like: 'New Idea: Apex Refactor and Software Factory' or 'New comment on topic: Home button in Mobile GUI' The description, part of the description or comment in the body, would be great.

1624
Harm Horstman
Superhero

Badges

Show all badges
Terms & ConditionsCookie settings