Questions & Conversations

When the user opens the (desktop) application for the first time, our application might be a bit overwhelming. That's why we want some 'tutorial' or landing page where the software is explained. This could be a web page with some videos embedded in it. This is a bit like downloading a new app on your phone where the important parts are highlighted in a 'scroller view' (each dot is a page) or there is a highlight on certain button or action. The user should keep seeing this window, until he clicks somewhere saying "Don't show again". I did read this post that looks a bit similar: https://community.thinkwisesoftware.com/development-13/how-do-i-set-a-table-as-a-start-object-or-landing-page-when-ever-a-user-logs-in-889 By following the steps described on the link above we could add

Hello! A question. I want to fill a column in a table with a default value. I can do this in many ways, but normally in SQL I can do something like this: ALTER TABLE MijnTabel ADD CONSTRAINT DF_xxx DEFAULT GETDATE() FOR MijnKolom Something like this. I wanted to do the same thing within the SF, but it seems that is not possible. What I did was go to the table and then fill in 'GetDate()’ as the default for that column. However, then I get a message during deployment that there was a problem converting the varchar to a date. In short, it sees 'GetDate()’ not as a function, but as a string (the single quotes were added too).  Long story short: is it possible to use GetDate() as a default from within the SF, or should I use another method (f.i. create a default that automatically fills this field with the current date) BTW: there is a slight difference between these two: if I were to use GetDate() as the default, it

Hello there, I have created a subroutine/stored procedure to have the AD groups automatically synchronized using an SQL Agent job. Initially this job starts up fine (every evening at 20:00), but after some time the job fails with the message below: Executed as user: {service account}. <msg id="not_authorized_usr_admin"></msg> [SQLSTATE 42000] (Error 50000).  The step failed. If I then manually kick off the stored procedure, the job will function correctly again for some time. Below the stored procedure which is used: declare sync_ad_groups cursor fast_forward for select usr_grp_id, active_directory_grp_name from iam.dbo.usr_grp where 1 = 1 and usr_grp_type = 1 open sync_ad_groups fetch next from sync_ad_groups into @usr_grp_id, @active_directory_grp_name while @@fetch_status <> -1

Hello all, I have a question about unit tests. We're currently working on getting to grips with this subject. But I'm kinda stuck on one specific unit test. I have a default that I want to test. It is a simple one that removes spaces from a string, as follows: if @cursor_from_col_id = '[field]'and @[field] is not nullbegin set @[field] = REPLACE(@[field], ' ', '');end; But now I'm lost when adding the input parameters for the unit test. I'm choosing 'postal_code’ as a parameter with input '1234 AB’. But when I run the test it just returns '1234 AB’ (so it failed). I also tried adding 'cursor_from_col_id’ with input 'postal_code’ as an input parameter, but that also didn't work. Looking forward to your answer!

I am trying to simply execute a task, without parameters with a process flow every hour.         Indicium Universal (2020.2.2) is running, but I don't see any activity. The version of IAM is 2020.1 and al hotfixes are done.   Could someone explain, step by step, what to do?   

Goal Sometime you need to extract only the file name (or maybe extention) from a file path. Solution declare @file_path varchar(500) = '\\server_name\folder_name\folder_name_2\file_1.txt';select right(@file_path, charindex(char(92), reverse(@file_path)) - 1)  

Hello, Is it possible to start outlook within a process or task? Kind regards,

I have created a ftp connection with a very bacic ftp side. There is no ssl, no tls, no nothing, only address, username and password. Directly from the server we can connect with filezilla. From the TW ftp connector we cannot connect. I checked the ftp site and the credentials thoroughly end those are 100%  correct. When we connect from the server we run into a message “This server does not support ftp over tls” “Your password and files will be sint in clear over the internet” So we have to click away this message. Could this message be the bottleneck for the TW ftp connecter giving the STATUS -2.  Our system engineers ask if we can use the option “command-line override” for this ftp connection. Is this possible. What else can I do? Thanks anyone for answering.     

Hi,   We use the resource schedular and it works fine. But when i checked the setting [Zoom factor] under web settings i got an error "object reference not set when we log in."   Does anybody have experience with this? thanks in advance, regards Ronald      

Hi    We use the resource schedular and it works fine. But the customer wants that when he scrollss horizontally the vertical scrolls stays the same position. Now the vertical scrollbar is automically set to the top. The user must then click the scrollbar to select the bottom row. This is not handy when you want to scroll from horizontale and see the bottom rows.    By the way a bigger screen solved the problem but is not the solution.   Does anybody have experience with this?   thanks in advance, regards   Ronald  

When I open the SF (2020.1 with GUI 2020.2.10) there's a button called “Version control” in the Developer tab page. I do notice some warnings. What does the tab page do and should I be worried things not working properly? I'd assume all should be green or blue. Some assemblies are referring other (patch)versions and some assemblies cannot be loaded it seems. TSF_dotNET, Version=2020.2.10.0, Culture=neutral, PublicKeyToken=nullThinkwise.Runtime, Version=2020.2.10.0, Culture=neutral, PublicKeyToken=nullInfragistics4.Documents.Core.v18.1, Version=18.1.20181.237, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cbInfragistics4.Documents.Excel.v18.1, Version=18.1.20181.237, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cbInfragistics4.Shared.v18.1, Version=18.1.20181.237, Culture=neutral, PublicKeyToken=7dd5c3163f

Hi,   What options are there for triggering alert for the end users, perhaps based on groups?  I have an app with several user groups, and I want them to have two things;  an in-app overview page of all items due. (for example, invoice that need to be paid, or orders that need to be closed).  I want them to receive an email every morning at 0700 with all these items. I can’t find anything in SF of the documentation.  I thought of making an Table Variant and filter on the date field. (if invoice_due_date = tomorrow..) but I wonder if this is the best.    Any thoughts on this?    Kind regards, Alex     

hi,   I have an overview of ‘orders’. I can print one order to PDF, based on variable order_id just fine.  If I select multiple orders, i will print fine, but instead of one long pdf, i download 1 zipfile with 4 (e.g) orders in it. However, I need it to be 1 file with 4 pages, 1 order per page.  I know this is possible, but I can’t figure it out. My report is build in Report Builder. Do I need to modify my report, change the settings in SF OR both..?     Anyone can point me in the right direction?  Much appreciated! 

I personally like the group label option for a grid, however when you start a group label and there are hidden columns the last visible column never is included in the group. The only way to solve this is to unhide all columns, and hide them in the Grid-layout and make sure they are not within a grid-group.  Would be great if this problem could be solved. 

One of our customers, who is using the Windows GUI (2019.2.17), is using up to 9 GB (!) of internal memory on the RDS with TSF_dotNET.exe. Most of the time TSF_dotNET.exe is using around 2 GB, but that is also too much. How is this possible and how can we limit this?

I'm unable to use the tile menu in Universal, although it is the only menu made available in IAM for Universal. What am I doing wrong?

Is it fair to say that the @cursor_to_col_id parameter in a default control procedure is not working in Universal?

Can processes be executed in Universal? It seems not to work at this time.

When working on a mobile device like a phone (limited display size) expression fields cannot be made visible in the SF in component “Card List”. I wonder why…    Anybody a clue why this is not allowed in the SF (2019.2)?

Goal The goal of this solution is to automatically add trace fields for setting a record to inactive for all tables that has a active field so the user can see who set the record to inactive. Since the records can have have additional changes to the records after setting them to inactive there are separate trace fields for this action. This looks like this in the GUI: Solution The solution consists of code for Dynamic Model (for adding the fields, for adding a prefilter to show only active records and add a task to deactivate active records and a task to activate inactive records.    Dynamic model add_active_inactive_fields  This code adds inactive trace columns to every table. The trace fields are: inactive_by

Currently we're testing our application on the universal. The issue we're having is that the themes we apply in the SF aren’t shown there.   We’re using the RC2.1.0 GUI version with platform version 2020.1   Note: the themes are applied if we use the web gui.

We're currently testing our project in Universal. We've seen that tasks from the menu work in the current interface, but are not starting from Universal. When we click them we get the following error:  

First off: I'm hoping it's OK that questions are asked about Universal, especially since it is an essential part of our current development. We've set all our project versions to Inactive (except the current branch), but nonetheless all our project versions show up in the left bar of Universal. Our current project has a larger number of Inactive project versions, so the list gets very long.

How come I get a 500 error? I want to install Indicium Universal, because I want to use the process flow scheduler functionality. How is the configuration different from the installation of the 'old' Indicium? How do I know that the correct version of .NET Core Windows Hosting Runtime is running?

When the ‘forgot password’ function is used in the webGUI, a token as shown below is sent to the user by mail. This token is probably very safe, but also difficult to copy in handwriting (correctly), and the safety it provides is does not reflect the functions Zeeman provides to most users.  Is it possible to configure a shorter/simpler token? I was thinking of a 4 digit numeric code, but a 6 digit code (provided by the forgot password function in the mobile GUI) would also be ok.