Questions & Conversations

I'm trying to add data to IAM 2020.2 via an external program*. I try to do this via Indicium. What I can do with the Windows / Web GUI, I can't do with Indicium. I've managed to find out that the following error happens:dbug: Indicium.Controllers.TableController[0]     Cannot commit the resource for entity 'gui_appl'. The layout procedure has made the property 'mobile_proxy_address' mandatory, but no value was supplied.This happens when I do a post call (with PostMan i.e.) to https://localhost:5001/iam/iam/gui_applwith the following content:{   "project_id": "my_project",   "project_vrs_id": "1.00",   "active": "true",   "db_name": "my_database",   "order_no": 10,   "server_id": 2,   "max_concurrent_sessions_per_account": 1,   "claim_timeout": 1,   "gui_appl_alias": "my_database"}It only happens when the application platform "Mobile" is enabled. According to the log message the field mobile_proxy_address is missing. So I've tried to add it, with "", null and '127.0.0.1' as va

Will our form filters be available in the Universal GUI?  

Since 2014 we started with our standard Thinkwise application JP-Bouwmanagement for the construction industry as a Windows application. Every customer is using the same version of the application.Last year we created a web server (Microsoft Windows Server 2016 Standard, x64, quad-core, 32 GB) to host our application for customers who wanted to switch from Windows to Web. SQL Server 2017 runs on a separate server (Microsoft Windows Server 2016 Standard, x64, quad-core, 16 GB).We are now using one installation of the Thinkwise Web GUI. Each customer website in IIS points to the same Web GUI folder. Of course each website has its own Application Pool User for permissions.Performance is okay, but it could be better. Currently about 25 customers are using the Web GUI to user our application. Each customer is using their own database.Is this setup on IIS best practice? Or is it better to create a Web GUI folder per customer?Can anyone advise us on how we can improve performance?

In our application we have a table bijlage that is linked to different subjects. This table contains a column bijlage in which the filename (including full path) is being stored.Because inserting a new file is a lot of clicks, I would like to use drag & drop. I already saw the blog about inserting records with drag and drop, but I was not sure if this was applicable for files.Do you have an example of how to implement this with files?We are still using TSF 2018.3. Is this even possible with this version?

I want to add a column to the include columns of a generated index from a reference. I could create a new index, but then I would have index on column A and index on column A with include column B. Since having too many indexes is not optimal for SQL server I want the existing reference index to have the include column. How do you correctly modify an existing index created by a reference? Is there a way to do this in the sf without resorting on the dynamic model?

Is it possible for a customer to create it's own formula based on the data of a grid? Kind of like an Excel Formula?

Does anyone have experience with displaying external websites within a Thinkwise application (WebGUI), using the document previewer?I am trying to display a sharepoint page in this way within the application, but so far without no success. It looks like a cross domain problem.I wonder whether the solution should be found in Thinkwise or is it a setting in Sharepoint?

Hi all,I have an overview of Shipments. Shipments move items (e.g containers).  An item is connected to a shipment.  In my Shipment table (the start of my app) I want to use the filter for searching on Delayed/Active/etc.  Shipments. This works fine. But I also want to search on Items and Packages. So, i want my filter to go through the table 'item’ and show the info. Is there any way this is possible? This is set up as followes;  

In the detail form we want to change the order if 2 fields depending on a certain value of a field in a row. Is this possible?Example:Field 1 has value "A”In detail form you seeField 1Field 2Field 3 Field 1 has value "B”In detail form you seeField 1Field 3Field 2 I was thinking about a solution using extra fields that are turned on or off via a layout procedure, but maybe there is a way via a functionality to just order the fields on runtime.Thank you

I trying to create a unit test for a task where the user can input a xml file from an external source. I'm facing the issue that those files are always larger than the input field length, even if i try to minimize the xml as much as possible (unit_test_input_parmtr_overview.input_value = 1000).Is there a work around for this? 

I have updated an Universal GUI environment from 1.3.1 to 1.4.0. I have been logged in before (in 1.3.1), so a pop-up like above shows up*.Thing is here, that Universal doesn't say so much for our end users: What is it? And what is updated? They will ask. To place this in perspective: We’re an ISV: We ship the software to multiple customers having no knowledge about the Thinkwise platform and terms like Universal GUI. For them it's just a website, or a GUI. What does a ISV customer expect when clicking Update now? Updating the complete application? What's changed?I think this is not clear for our end users and only raises questions, which I want preferably to avoid. Is it possible to ignore this message? Or is the message editable, so it makes more sense? To be honest we don't want to bother our end user with GUI updates (which should be done automatically). The only updates we do want to bother them with, are the end product updates. Because that's probably something they're actually

This is an Archived topic.GoalReplace all existing file links in an end product without manually writing an update script for every table. This can be used for migrating file systems or DTAP-deployment.SolutionI wrote a script that replaces all file links of domains with control ‘File link’ and ‘File upload’. The script gathers the tables that it can update from IAM and builds an update script.Use CTRL+SHIFT+M to fill the following parameters: 

Hi all,I have a screentype with a big search on top. However, after searching, I go into editing found record, I do not it anymore. Is it possible to set a different screentype for the Edit-mode ? Or turn it off (hide it) in some other way. Searching:  Editing:  

I would like to start testing the new universal GUI on Azure. Is there any documentation available how to setup all the bits needed to do this?

There is an option to add custom code to the Upgrade code group to do for example an insert into a table. However, how do I use this when using a branch? for example if I have a table with 2 rows and during development I want to add row number 3.  trunk version 1        2 rows exist   branch version 1  2 rows exist   branch version 2  3 rows should exist    trunk version 2        3 rows should exist Branch version 2 is merged back to the trunk to create trunk v2 and trunk version 2 will be used to do the upgrade from trunk version 1 to 2. The actual insert is developed in branch version 2. Now I have two options: option 1: If I use after upgrade always then the code is in the upgrade script every release untill i delete it  manually. option 2 :If I use after upgrade from branch 1 to branch 2 then insert part gets lost in the trunk version 2.  How do I do this correctly? If I have to do it manually in trunk version 2 then it beats the purpose of the upgrade script part.  

How can I import the Insights demo into my Software Factory? I have a Thinkwise_insights zip containing iam.bak, Insights.bak and Insights_IAM_PROD.bak. Of course I can import them in SQL SMS.Thank you in advance!

Using TSFReportMailer is already a very nice feature in Thinkwise, however, we would like to know the status of a message:has it been sent not sent (perhaps reason / error report) message still in queue on mail serverIs it possible to obtain this information, and, if so, how and/or where (preferrably with example) thank you,Paul

But when is it going to be supported?

Currently when testing development (SF) the Web GUI, my colleagues can log in using their domain account (COMPANY\User). Even if they are not defined in the SF as User (Settings > Users), they're able to log in.Now we also want the same users have access to a Universal GUI environment, but unfortunately they cannot login. Is there something we have to allow/add in the SF/IAM?I notice that they can log in on the Indicium service, but cannot do particular calls which for example the Universal GUI uses when logging in.I.e. http://localhost/indicium/iam/sf/i_ui_usr gives a 404.When logging in using a developer account I see this:When logging in with a non-developer account this is the Chrome log:It looks like the login succeeds (204), but there is something with permissions I guess due to the 404 on i_ui_usr.

Hi All, I print a report, and that is all ok. However, I want to print a report with some language settings. So, I want my report to do the following: I give the parameter account_id to the Report Based on account_id I want SF to check in a table Account for the Language_id  Set this language_id in the Field 'Language’ in the print prompt. I've been trying for quite while, but somehow.. the lookup fails. Is there someone out there to shine some light in this dark world? Thanks,Alex

I was trying to use the Microsoft SQL Server system data type Hierarchyid. This data type is extremely useful for data that contains some kind of hierarchy. For example multi level BOM structures. However, when I set up a domain as a DTTP my context couldn't handle it and later on the mobile GUI wouldn't even start since it couldn't handle this data type(said the error log). My question is if someone can confirm that this data type is not supported by the GUI's (Web, Windows and Mobile)? If so I will submit an idea with further explanation why I think this is a useful feature.  See this link for more information about the data type: Hierachyid

When I was downloading a new version of the Windows GUI I noticed that it allowed me to download 2 options, a full and minimal option. What is the difference between those 2 options?

We are looking for system requirements regarding the Universal GUI. Do they exist already? If so, where can i find these? 

When using the Universal GUI, a tsf_send_message execution from a task shows the following message: "Stage task commit failed. Error: unknown_error_occurred”. When i use the same task in the Web GUI, it shows the message i'm expecting: “Invalid quantity, there are more quantities delivered then ordered".The response headers contains the following data (decoded string of TSFMessages):{"MessageType":"ApplicationDbMessage","RawMessage":"<msg id=\"purchase_order_line_not_deliverable_invalid_quantity\"></msg>","MessageID":null,"NamedParameters":null}The "msg” element is sent with the right data. The returned status code is "500 Internal Server Error”. Any idea what causes this problem?

When exporting data to Excel the character “&” is being shown as “&”. This is done by the button “Exporteren” in the toolbar of the Windows GUI.     Can this be fixed please?