Skip to main content

Questions & Conversations

Software Factory & IAM (Installation, Development, Deployment, Integration) | E-learning | Documentation | Community

  • 2,748 Topics
  • 9,478 Replies
2748 Topics
Rucha Naik
Rucha NaikPartner
asked in Questions & Conversations
How to control the scheduled email?

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.

292
Rucha Naik
O
Vanguard
Onno SpoorVanguard
asked in Questions & Conversations
FTP Connector encoding

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.

1243
V
Moderator
M
Rookie
Marvin AlibahadoerRookie
asked in Questions & Conversations
hide task button on form only

Hi, I have a table with companies, the screen type has a grid on the left side and a form on the right side. I also have a task to export these records to a XML file. Since it’s a general export task, it doesn’t make sence to use this task from the form of a selected record. I would like the button to only be available in the task bar in the grid section of the screen. However, if I use a context to hide the task, its hidden in both the form and the grid. Is there a way to only hide the task in the form? (we only use the windows GUI btw) Thanks in advance!Marvin

572
M
Rookie
C. Lousberg
Captain
C. LousbergCaptain
posted in Questions & Conversations
Exception "not_authorized_usr_admin" when syncing AD groups from SQL Server

Hi,since some months our SQL Job which will sync the AD groups to IAM runs into an error after a certain time.SQL Job:DECLARE @usr_grp_id AS varchar(100) ,@active_directory_grp_name AS varchar(100) ,@active_directory_domain_name AS varchar(1000) ,@net_bios_name AS varchar(15) ,@user_name AS varchar(100) ,@password AS nvarchar(100)SET @user_name = '{DOMAIN SERVICE ACCOUNT}'SET @password = '{DOMAIN SERVICE ACCOUNT PASSWORD}'DECLARE sync_ad_groups CURSOR FAST_FORWARDFORSELECT usr_grp_id ,active_directory_grp_name ,active_directory_domain_name ,net_bios_domain_nameFROM usr_grpWHERE 1 = 1 AND usr_grp_type = 1 AND active_directory_grp_name IS NOT NULLOPEN sync_ad_groupsFETCH NEXTFROM sync_ad_groupsINTO @usr_grp_id ,@active_directory_grp_name ,@active_directory_domain_name ,@net_bios_nameWHILE @@fetch_status <> - 1BEGIN IF @@fetch_status <> - 2 BEGIN EXEC task_import_active_directory_grp @tenant_id = 1 ,@usr_grp_id = @usr_grp_id

654
C. Lousberg
Captain
A
Apprentice
a.schoonderbeekApprentice
asked in Questions & Conversations
Create report with dynamic file name

I created a report with report type DevExpress and use it as a table report. When the report is downloaded the file name is always te same. It looks like the Report Translation is used. Is it possible to add something unique to file name, like the current date and data from a column in the table? 

1122
A
Apprentice
B
Rookie
BrechtvGilsRookie
asked in Questions & Conversations
Cube view filter gives strange data

The filter on the cube view does niet give the expected results. How is this possible? See image below, the filtered results are in the range until - 10.000, however, I see different results. It does not matter if the check ‘apply to specific level’ is on. Could anyone help me with this odd situation? 

823
Mark Jongeling
Administrator
Rucha Naik
Rucha NaikPartner
asked in Questions & Conversations
Task for date helper in universal not working , which works in GUI.

In the date helper, there is a task to go tot the current date. This task is working in the GUI. However, the same task in universal is not working. Can someone please guide? GUI image Universal image 

504
Rucha Naik
B
Rookie
BrechtvGilsRookie
asked in Questions & Conversations
Unit test type subroutine

Hi, We are implementing unit tests and want to keep track of our progress. However, we have several unit tests with the unit test type 'Subroutine’. This unit test type is not taken into account in the analysis. How can we keep track of our subroutines (i.e. functions and procedures) in the different cubes? The unit test types: And the code groups show in the cubes:  

691
Mark Jongeling
Administrator
Frank Wijnhout
Thinkwise blogger
Frank Wijnhout
posted in Questions & Conversations
Make your logging data available in the GUI

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.GoalWhen you have system versioned tables in your database, SQL Server logs all changes made to the data in those tables. This solution makes this logging data available for the user. This can look like this: SolutionThe solution in this topic creates views on all system-versioned tables. These views give the user access to the logging data. Also, all of these views get conditional layouts in the Software Factory. These conditional layouts give fields with changed values a color, which makes it easier to analyze the data.Dynamic model meta_view_historyThis code create a view definition for every system versioned table, along with conditional layouts to point out changed data.When you add this code to the dynamic model, you have to change a few values first:@screen_type_id                Your desired screen type: You can keep this null, or change the value.@original_date_column          Na

87316
P
Captain
Bas
Vanguard
BasVanguard
asked in Questions & Conversations
Indicium/Universal login flow

At a client, we’re going to deploy the universal interface in a short while. While testing the client found an interesting flow concerning login and password recovery that is undesirable.Happy flowIn the universal interface, the user clicks the password recovery link.  The browser is redirected to the indicium interface. The user enters their username/email and a token gets sent out. The user enters the token and new password en hits enter. The user enters a username and password to log in. The user enters their email TOTP token. The user gets redirected to the universal interface.What happened during testing?Somehow the client manually went back to the indicium interface. And started the password recovery there. The process worked the same except he didn't get redirected to the universal interface as no redirect URL was available. They also tried to log in at the indicium interface, the login was successful but the client got stuck as they didn't have an application interface availabl

1183
D
Moderator
Dennis van Leeuwen
Hero
Dennis van LeeuwenHero
asked in Questions & Conversations
401 (Unauthorized) - GET $eager=profile_picture

When opening the Universal GUI login page, DevTools gives a 401 (Unauthorised) error. After logging in with a user with a picture uploaded in IAM the error is shown again.  GET https://office.niverplast.com/indicium/iam/iam/i_ui_usr?$eager=profile_picture401 (Unauthorized)401 - unauthorized. The user is not logged in to Indicium (anymore). Note that the login page will execute i_ui_user before login to validate whether the user has logged in or not. This may cause a 401 error on purpose if not.Once logged in, the profile picture is displayed correctly.Isn't this GET request an attempt to read the IAM profile picture? Isn't it unnecessary that the request is fired at the login screen? 

631
Mark Jongeling
Administrator
Hugo Nienhuis
Superhero
Hugo NienhuisSuperhero
asked in Questions & Conversations
error in sql_indexes during generation after upgrading to SF2022.2

We have upgraded the SF to 2022.2. During the generation of the project the following error occurs on sql_indexes:The MERGE statement conflicted with the FOREIGN KEY constraint "ref_prog_object_item_prog_object_item_parmtr". The conflict occurred in database "sf_raijmakers", table "dbo.prog_object_item".We were unable to find missing or false keys.We analyzed the generated code which looks like this :/* Create index 'besteld' on table 'inkoop_order_regel'. */if exists (select 1 from sys.fulltext_indexes fx                    join sysobjects ot on ot.id = fx.object_id                    join sysindexes ix on ix.id = ot.id and ix.indid = fx.unique_index_id                    where ot.xtype = 'U'                      and ot.name  = 'inkoop_order_regel'                      and ix.name  = 'besteld')   drop fulltext index on "inkoop_order_regel"goif exists (select 1 from sysindexes ix                    join sysobjects ot on ot.id = ix.id                    where ot.xtype = 'U'             

613
Mark Jongeling
Administrator
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations
Shortkey to execute task

Is there a ShortKey (e.g. Ctrl+Enter) to go directly to the 'Execute' button in a task from any field?Users wish to complete a task faster, by skipping optional fields, without having to use the mouse. Example:  

341
Mark Jongeling
Administrator
S
Apprentice
SergioApprentice
asked in Questions & Conversations
Change image of forgot password page

Is it possible to change the image on the "forgot password” page and the following pages such as the  "Enter token and new password” page

461
D
Moderator
N
Rookie
Nadia MittererRookie
asked in Questions & Conversations
Multi-Tenant application with IAM Tenant on one data base guideline/documentation

Hi, I'm trying to create a SAAS project with thinkwise. My request is to store the data of all customers in a single datadase.I did read the Tenants documentation and I think, that I need to create a "Multi-tenant IAM & Multi-tenant product" solution. Is there any documentation of best practices on how to create a Multi-tenant product? Thank you in advance

1002
Mark Jongeling
Administrator
D
Vanguard
Dennis BeerenVanguard
asked in Questions & Conversations
How to display percentage in the UI (when value in DB is in decimals)?

I am looking for a way to display a percentage in the UI, while the column contains decimal values in the database. E.g. 0.51 in database displays 51 in UI.I expected that the domain control field 'Percentage’ would do the trick, but it doesn't. The documentation is not very specific about what the Percentage control does when it is selected in a domain:I cannot be the first to deal with this issue, hence I hope that somebody here can point me in the right direction.Thanks in advance!

3325
Freddy
A
Anne VriesPartner
asked in Questions & Conversations
Process flow open document filter performance

HelloI have an issue with the performance of one of my screens which is opened with a process flow.The main problem is that I want a filter to apply to the open document action before it retrieves all rows.This images might clarify my problem I was wondering if somebody had a solution/workaround which allows me to apply filters to open document actions like this?I think a possible solution in my case is to make a reference to the document I'm trying to open and just present it to the user as a detail screen then the reference columns become my filter in the WHERE condition. But I would rather just open it as a new document.

1273
A
eurban
Captain
eurbanCaptain
asked in Questions & Conversations
focus tasks butoon

Is it possible to set focus on  task button 

575
Mark Jongeling
Administrator
ElenaTodirenchi
Vanguard
ElenaTodirenchiVanguard
asked in Questions & Conversations
Task parameters

Hello, I created a task a week ago and today I added a new task parameter, but when I edited the functionality the new parameter didn't show up. How can I make it appear?

432
ElenaTodirenchi
Vanguard
mperrott
Hero
mperrottHero
asked in Questions & Conversations
Azure AD single sign on in Universal GUI

Dear all,As per subject I’m trying to setup the SSO on the Universal GUI for part of my users and facing an issue. The documentation mentions the setup of the SSO from Thinkwise perspective which is sufficient, but there is no documentation at least for the setup for Azure/AWS/Google perspective what is actually needed.My Setup:I have a Resource group (RG) called TEST I have a VNET for the RG I have SQL server and App service in the VNET I have a Front Door having the default *.azurefd.net and my custom domain The Front Door points to my App service and redirects traffic correctly. The Indicium and Universal are installed on the App service. The whitelist of client redirect URLs in IAM is my custom domain only.For the SSO:I have done the App registration I have added the new configuration in App Service for the OpenID Microsoft authentication I have added my custom domain on App serviceProblem I face and would like some input is that,The App registration requires that the Redirect URIs

2894
Sjors Niesten
Apprentice
Alex Kerschkamp
Captain
Alex KerschkampCaptain
asked in Questions & Conversations
Microsoft Graph issue

Hello everyone,Because the new Exchange connector that is scheduled for the month November of this year will not give adequate possibilities for our client, we're trying our luck with Microsoft Graph. We created a call and made it fit our needs using Postman.We configured and use all the right credentials (client ID, tenant ID and client secret) for token generation. Actually, we created a call for getting data, and one for patching data. The call types are, of course, get and patch respectively. All calls are successful, and perform as expected, using Postman.Next, we went to our Software Factory, to make Thinkwise perform the same calls. Using a process flow, we make the proper call, the same as we did using Postman.We get a correct token in Thinkwise. When we copy this token from the debugger, and check it with jwt.ms, we get a valid token. In fact, when we use this token in Postman to make calls, it works perfectly. So, token generation works properly.However, the calls that work i

95115
Alex Kerschkamp
Captain
E
Sidekick
ericbosmanSidekick
asked in Questions & Conversations
Create a password in iam

I want to create a user in IAM which is only for service purposes. Nobody has ever to login on this user.Because we have many environments, I want to automate this.Creating the user is not a problem, but i do not know how to set the password with encryption.I see i need the password, a salt and the password-hash and then i understand that i can use the sql script:insert into usr_authentication (      [tenant_id]      ,[usr_id]      ,[password_hash]      ,[password_salt]      ,[password_algorithm]) Values ( … )but in what way can i determine the values of the hash?

17411
E
Sidekick
pauloportu
Apprentice
pauloportuApprentice
asked in Questions & Conversations
cube view universal generates dateTime from date fields?

When producing cube view graphs in Windos GUI we see an expected row where we have a Date type field: However, the Universal GUI shows this Date field as follows:  Question: how can we have a cube view where the row Date only shows a date without 'T00:00:00’? Please advise, thank you, Paul 

935
Mark Jongeling
Administrator
Bas
Vanguard
BasVanguard
asked in Questions & Conversations
Base64 encoding

I'm having some trouble getting things to work. For a webservice we need to base64 encode our message before transmitting it. This worked fine untill we encountered a diacritical mark (ë, î, ú, etc) in the message we want to encode. Then the webservice we're contacting start throwing errors.I've created a test script to show the exact problem and to provide a starting point to hopefully find a solution to this issue. I contains a sample for a correctly encoded message and an invalid one. declare @source varbinary(max) ,@encoded varchar(max)--SAMPLE MESSAGES ONE WITH AND ONE WITHOUT DIACRITICAL MARKS DECLARE @message varchar(max) = 'Dit zijn diekrieten ë, î en ú.'; DECLARE @message2 varchar(max) = 'Dit zijn geen diekrieten e, i en u.';--KNOW CORRECT BASE64 RESULTS AS CALCULATED WITH THE OPENSSL LIBRARY DECLARE @message_base64 nvarchar(max) = 'RGl0IHppam4gZGlla3JpZXRlbiDDqywgw64gZW4gw7ou'; DECLARE @message2_base64 nvarchar(max) = 'RGl0IHppam4gZ2VlbiBkaWVrcmlldGVuIGUsIGkgZW4gdS4=';--BAS

4506
Bas
Vanguard
M
Vanguard
Mark LeunissenVanguard
asked in Questions & Conversations
How to limit API access

Hi all, Is it possible to limit the access to OData API apart from the rights (insert/copy/delete/update) on a table given in the SF? Since we do not want every user /  user group to have access to the OData API, we would like to limit certain users / user groups.  Thanks in advance.

2066
M
Vanguard

Badges

Show all badges
Terms & ConditionsCookie settings