Skip to main content

Questions & Conversations

Ask a question or have a conversation about the Thinkwise Platform

  • 2,958 Topics
  • 10,177 Replies
2958 Topics
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.

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

1833
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

4944
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_orde

1801
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",

11181
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
Mark Jongeling
Administrator
Mark JongelingAdministrator
asked in Questions & Conversations
Best practice for inserting large amounts of rows into one table

/-This is more of a SQL question-/ For the project I work on I'm in charge of realizing functionality to import large amounts of Product data (ASCII format / .txt file data). The database I work with is placed in a environment where multiple companies work on the same database. In the application, they only see their own data. For example, if 30 companies use the database and all have a pool of 1 million Products, then the 'Product’ table will have 30 million records in total but will only see their own 1 million products. The data that I will import consists possibly over a million records and will be inserted into the single ‘Product’ table. What I'm worried about is that inserting 1 million products in one go will take a very long time, so I want to look at possible ways to accelerate this process and making sure that importing big files does not take hours. I have read about removing indexes, parallel processes and such to speed up the process but I'm not fully convinced it would b

393210
Anne Buit
Community Manager
R
Hero
RolandHero
asked in Questions & Conversations
Input screen similar to spreadsheet

We are trying to design a new screen for data input with a grid similar to a spreadsheet. Let me try to picture our situation. Our products are garments in all kinds of sizes which could be XXS to XXL, 44 to 64, etc. Several size systems are at play here and every kind of garment has its own system as well as size range. Our design team needs an easy input screen with spreadsheet like layout. Per type of garment and per size there are several measurements to be made. Think of something like this for trousers: 44 46 48 50 52 54 56 58 60 62 64Waist . . . . . . . . . . .Inseam . . . . . . . . . . .Length . . . . . . . . . . .Pocket . . . . . . . . . . . The left column contains the measurement types. The top row contains the sizes. Every dot is a measurement that needs to be recorded. A t-shirt however might look something like this: 2XS XS S M L XL 2XL 3XL 4XLWaist . . . . . . . . .Neck . . . . . . . . .Length . . . . . . . . .Sleeve . . . . . . . . . This screen will be the first of man

19612
Anne Buit
Community Manager
R
Superhero
René WSuperhero
asked in Questions & Conversations
How to use e-mail address login on Azure

I'm trying to deploy an application to Azure using App Services and a Azure SQL database. We want users to log in with their e-mail address, such as user@company.com and john@doe.com both on the same application / database. The user id in IAM is an e-mail address and the users in the SQL database are also. Only when trying to log in, the login with the e-mail address user@company.com fails: Cannot open server “company.com” requested by the login. The login failed. When I add the database server address to the e-mail address (user@company.com@my-database.database.windows.net), then the login succeeds. How can I fix this that the user doesn't have to add the database server address? Please note, when connecting with this user via SQL Server Studio Management Tools it also requires the postfix of the database server address in the user name, despite the fact that the user / login in the database is only [user@company.com].

1304
R
Superhero
Raj Rozendaal
Sidekick
Raj RozendaalSidekick
asked in Questions & Conversations
Difference in preview component Web vs. Windows

We created a report in which we want to retrieve some images we uploaded in the application. The images are saved in the application folder where the service account has full rights. We can approach the image in the windows and web GUI by pressing the download button. However, when we create the report the previewer in the Web-GUI seems not to retrieve the image properly. Does the dev-express reporting previewer expect access in a different way in the web-gui? I expect this to be the same for web and windows. web windows

2324
Raj Rozendaal
Sidekick
eurban
Captain
eurbanCaptain
asked in Questions & Conversations
Filter Form

where can i change the field width from the filter

1606
Mark Jongeling
Administrator
D
Vanguard
Dennis BeerenVanguard
asked in Questions & Conversations
Exclude column of data type xml from update trigger

I created a column in a table with the xml data type. However during execution of the source code of the update trigger of that table, I get the following error caused by this field. Therefore I would like to exclude this field from the update trigger, but I cannot find a way to do this. I already set the “Trigger for update” attribute of the column to false in the subject, but that doesn’t do the trick. The following highlighted code fragment in the update trigger is the problem I guess. Is there a way to exclude this field from the automatically generated update trigger?

2406
Jasper
Superhero
R
Apprentice
RonaldApprentice
asked in Questions & Conversations
Subroutines and API alias

We want to use the API alias but when we fill the alias (field API alias) however the name does not change in the OData layer (Indicium)

1262
Jeroen van den Belt
Administrator
Mark Jongeling
Administrator
Mark JongelingAdministrator
asked in Questions & Conversations
Field with Password control show it's value in List

Is this correct behavior by the (latest) GUI? It seems to me this is not the way it should work. A password shouldn't be revealed like this. Visible password values

692
Mark Jongeling
Administrator
R
Hero
RolandHero
asked in Questions & Conversations
Show positive numbers with plus sign

For certain contexts where we show a difference between values it makes sense to display positive numbers with a plus sign. For example a difference of 5 displayed as “+5” in a list or a cube. I looked for a domain control to see if the gui offers such an option but I couldn’t find it. Is there a straightforward method or do I have to convert numbers to varchar to accomplish this?

631
Mark Jongeling
Administrator
J
Rookie
jnausRookie
asked in Questions & Conversations
Create custom color for progress bar on splash screen SF

We have a request from Customer Aartsen if we can provide (besides custom background and logo) opportunity to have custom colored (Aartsen red) progress bar on Windows GUI splash screen starting the application.

931
Jasper
Superhero
D
Vanguard
Dennis BeerenVanguard
asked in Questions & Conversations
What is the advantage of attached database design?

When I was studying the present situation in our system, I came across attached database design. I would never have designed it this way myself, but since I'm relatively new to database design and eager to learn, I wonder what the advantages and disadvantages are of laying out the references and private keys in this way. A 'calculatie' consists of one of more 'calculatie_onderdeel' which consists of one or more 'calculatie_onderdeel_blok' which consists of one or more 'calculatie_onderdeel_blok_vak'. When I would have been the one to design this, I would have used one private key per table. E.g. calculatie_id for the first, calculatie_onderdeel_id for the second and so on. Then I would have created PK / FK references on these id fields. Please see attached picture of the design I'm referring to. Any thoughts on this, or some background information are welcome.

1423
D
Vanguard

Badges

Show all badges
Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings