Thinkwise Platform

Since the SF/IAM upgrade to the new version 2022.2, users in the end application have been experiencing problems with date control. For example, the calendar in the Windows GUI no longer starts with the local user settings.Time zone information setting for users Even with changing the domain time zone which is behind the relevant column the calendar continues to start with Sunday as the first day of the week. Time zone "Local”In the SF, I am using the CustomDateMask runtime. SF | Runtime configurations✔ Local pc settings are correct (Monday as the first day of the week);✔ IAM user has Time zone "Europe/Amsterdam” ; How can we fix this 😮?

I’m receiving this error message while opening the product through IAM which has rights on this column. However he gets this error. When I log in with an admin account I won't get the error.This is probably a right problem but does anyone know how to solve this?Stored procedure 'lay_artikel' genereerde een fout bij het afleiden van de parameters.  Informatie: Parameter 30 - extra_id (kolom): An SqlParameter with ParameterName '@extra_id' is not contained by this SqlParameterCollection. 

After the upgrade from version 2021.2 to version 2022.2, I found out that the tile icon field no longer exists in the Software Factory.  We are not happy about that. What is the idea behind it? 

 Hello, I'm trying to pass a process flow variable to a report API through HTTP connector process action but it doesn't work. I've even tried with a fixed parameter. I think the problem is with the report url. See the prints below:  

Hi everyone,I've made a DevExpress report and in SF Reports configured the settings as seen in print screen 1.The "Print preview" action for DevExpress works fine in the Windows GUI.But in Web GUI when I select the action "Print preview" (print screen 2) I get an error (print screen 3).If I choose action "Export to PDF" it generated the report successfully and I can see the exported pdf with the correct data.So the problem only occurs with the "Print preview" for DevExpress. Note: In a process flow I've a Report type SSRS(Local) and a Report action Print preview. In Web GUI the Print preview doesn't throw an error and successfully shows the preview. Do you guys have some ideas what could be the problem and how to fix it ? print screen 1print screen 2print screen 3 

When I add the developer mode in IAM (user), I get the 'Developer’ tab in the GUI. Unfortunatelly the debug tab does not show any information. Is this the normal behaviour?

Hi all,I'm setting up a simple e-mail functionality within an application I'm working on. We're doing it via an SMTP-connector within a process flow as advised in the documentation.It currently looks like this: Simple process flowAll works well via the Windows GUI opened against Indicium. While testing it in Universal with Indicium I'm getting the following error:2022-08-19T09:22:00.8630009+00:00 80016378-0003-b600-b63f-84710c7967bb [ERR] TSFMessagesMiddleware: An unhandled exception occurred while processing the request. (fffadd8a)Microsoft.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'TSFReportMailer'.It doesn't seem to be a Role-issue, but I can't seem to find what it could be. Any ideas what it could be? If more information is needed I'll happily provide it.Thanks,Rony 

Anyone adept here in SVG and the Star Rating solution in the ThinkStore. It doesn't seem to work in the Universal. Whatever I do I always get back one black star.  This gets generated:<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" viewBox="0 0 120 24" width="120px" height="24px"> <defs> <linearGradient id="star_1"><stop offset="0%" stop-color="orange"></stop><stop offset="100%" stop-color="orange"></stop> </linearGradient> <linearGradient id="star_2" x1="0" x2="100%" y1="0" y2="0"><stop offset="0%" stop-color="orange"></stop><stop offset="100%" stop-color="orange"></stop> </linearGradient> <linearGradient id="star_3" x1="0" x2="100%" y1="0" y2="0"><stop offset="0%" stop-color="orange"></stop><stop offset="100%" stop-color="orange"></stop> </linearGradient> <linearGradient id=

I have upgraded to TW 2022.2, Indicium universal 2022.2.11, Windows GUI 2022.2.11. I made a simple procesflow to test the new fileconnectors but the debug tells me it is not supported for Windows or Web gui.Am I doing something wrong or are the new fileconnectors indeed Universal gui only? Same happens with the read file connector by the way.  

We want to make use of the password reset functionality so that after a new user has been created (via the API), they can enter their new password themselves.To be able to do this, an e-mail needs to be sent and an e-mail server needs to be able to facilitate this.We make use of an online MS-Exchange. However this uses an Oauth2 authentication method and not basic authentication as described in the Thinkwise documentation. Does indicium support Oauth2 authentication for the e-mail server and if so, how do we configure this?

Hi everyone,We are wondering if it would be possible to have a developers license, so that developers can keep up with new functionalities by trying them out, and expand their knowledge on the platform altogether by playing and discovering.Currently, if developers use a local playground sort of thing, with platforms against a local SQL server, the cost will increase considerably because of the number of tables that are calculated towards the partner license. We've set up a hosting account where we installed a platform at, so that we can try out things and create a solution-library for ourselves. It's not optimal though.The Thinkwise course itself uses virtual machines that get recycled. It would be a step forward if partners could use a VM at their own infrastructure where their developers can learn new things, and keep them up-to-speed with new things. This is just thinking out loud though.Would anything similar be possible? Are there more developers that would like such a thing as we

Hi,Is it possible to gather data then generate, export and download an .xml file by executing a task in Web GUI?Thanks!

Hi,Initially I thought you can’t create/use folders on azure file storage. So, now I place all files in de root. How can I make it like this, that I create a shipment, it creates a folder on the file storage. And that files are placed in that folder, when uploaded. I thought that SF didn’t support folder structure, but I heard it does.. so.. anyone can clarify this? 

 I need to filter the data based on the user role .An employee has more items ,but each employee has his own set of items .For example if the user is logged as an employee ,I would like to see the specific items for this employee . How I should approach this problem?

Hi, I’ve created a new Azure Storage. In IAM I’ve set the Storage name + KEY as credentials. They appear bold - I assume due to that they differ from the runtime config version from SF -. When I upload a file in my form (web gui); It shows no error and the path in the db is correct (https://NAME.file.core.windows.net:443/ff-uploads/)But, there is no filename and it is not uploaded to the file storage. It’s in limbo sort of. What is causing this? And how to fix this. 

Hello, So I have 2 tasks on two different tables. I have an id on the first table and I want pass it as a parameter on the second task, I do not have a column for the id in the second table. I tried to put it as an output in a process flow but it's taking the id as null.As you can see in the images below in the first task I have the current_id but in the second one is null. This is the first taskThis is the second task 

Hi all,I am trying to import data using a excel sheet in Universal GUI, but am running into a problem where the existing records won’t update. Context: importing data in a detail screen.Steps taken:export data using option “Export immediately” changing some fields in excel > save excel sheet import using the “Import (update existing rows)” option. Also noticed that it doesn’t update but rather add the rows again.Please help! Thanks

Hi, We are trying to implement dragging and dropping of records in a view to change the order of the records.This particular view has 2 primary keys:slaughterherd_id supplyherd_idAs per:In tasks I've created a task and added 4 task parameters: I added the task to the appropriate view and filled the first 2 task parameters: In Subjects I set the following: In functionality I added an empty template to the task as I'm not yet looking at executing the task itself. I just want to see the dialog.When I perform a drag in the view it looks like dragging but the dialog is never shown.I thought to be clever and added an empty DEFAULT to the task to see in the DEBUG if that got fired. But it doesn't….We are a bit lost what could be wrong. In our first attempt earlier this morning we dit get the dialog to show up. We started experimenting on how we can detect the id of the record we drop onto and during that process the dialog just stopped working :( 

I create a DevExpress report using a stored procedure. I have 2 parameters with the actual value NULL: Somehow the report tries to execute the stored procedure with a value of -1 instead of NULL:  I checked the NULL value allowed checkbox in DevExpress, so that should not be a problem I think. What am I doing wrong here? SF 2022.1 ; DevExpress 1.40

When I am exporting to Excel from a grid view, the currency fields are displayed in Excel with a $ sign. How can I control this? Extended properties of the application are set to "UseWindowsCulture”. However no matter what kind of language settings in Windows I change, I do not succeed to display the € in Excel. The cell property in Excel is set to $ #.##0,000 during export. While the currency setting in Excel is set to display € sign. 

At this moment we are trying to implement unit testing in our process. However, we encounter several problems.The biggest problem we encounter is preparing the mock data, because it’s very time consuming. Is there anyone who could explain me what would be best practice for inserting mock data in the Software Factory. What we experience is that it is difficult and not user friendly to insert data values into a data row. It costs us a lot of time to insert this data, and it is not very clear what foreign keys are of the table and the domains  of the values. So, all tips and best practices would be very helpful.  

I have written below query in a function to send the message when the check box is checked:if @work_permit_check_box = 1 /*and @work_permit= 0 checked*/ beginexec tsf_send_message 'Please change the work permit expiration date.', null, 1;end  The output I am getting. How can I translate this message?

Hi,I have a functionality which automatically triggers an email (a reminder sent on a daily basis) when the work permit of the employee is expired in 30 days.Now we added a checkbox , when it is checked the email should not be sent any more. I tried to implement this with below steps:Created a control procedure : layout  Below code in the template(the work_permit_expiration date is mandatory): if @work_permit_check_box = 1 /*when checked*/ begin set @work_permit_expiration = NULL /*null the date*/ end However, this seems not do perform any changes.Where am I doing wrong? Or is there any other simple way to execute it.

Can you tell me how to encode the File data for the FTP connector when using the FTP method 'Upload file (STOR)’?It seems that the connector uses the UFT-16 Little Endian although the source for the data comes from a VARCHAR.