Questions & Conversations

Out of curiosity, today I did the SQL basics e-learning. Very nice and a good starting point for a beginning SQL developer, my compliments.   A small improvement: Change the database name in the setup_database_sql_training.sql file from sql_training2 to sql_training. When creating the database, a different database name (sql_training2) is used than in the other SQL exercises (sql_training). "Dealing with errors" is explained in topic 2. Because of this, this doesn't seem like a deliberate choice to me? Script | setup_database_sql_training Script | 1. Select statements Script | 2. JoinsSomewhere it does make for good practice right away but for an inexperienced person it may be too unclear. Curious to hear your reaction.

Hi, I am trying to make use of the new system task in a system flow. However, it seems to do nothing at all within my system flow.Release notes 2021.3 :**Execute system task** - allows using tasks inside system flows. Note that the default procedure will not be executed when using this process action. Any task parameters that are not set as input and output will not be used by Indicium to run the task. A validation is created for this. I am not using a def and no variables. I am simply trying to make a change in the database using a control procedure. I am using a dummy task to make the flow available in the menu.Why does the code not run?  

I don’t know why but in my development environment my tasks are disappeared above my cardlist in the mobile GUI. I already tried to add the showgridheader = true property to the cardlist but that does not work. In the live environment the tasks are shown above the cardlist. I’m confused!! We didn’t change anything. Same screen type, same cardlist.The only difference is that we added 1 task! We have now 4 tasks instead of 3?To test I disabled the task from the subject, but also then no tasks are shown above the cardlist. Please HELP! Our users will not be happy with this? 

In universal GUI, is there a way  to hide the translation of Task buttons, to only show the icons?

In my application I want to send emails. I have an email queue with emails which are sent with a process flow which uses the SMTP connector.When I trigger the process of sending the emails with a table task it’s working and I get status code: “0 - Successful” from the SMTP connector.When I trigger the process flow by scheduling it. The SMTP connector return status code: “-2 - Unsuccessful (making a connection with server failed)”.  Has anybody an idea what’s going on?

Hi all, Does anyone has a clue how to solve this message.The index ligt buiten de matrix grenzen. It happens when I try to open a detail list contact person on the relations subject. Don’t remember we changed something there.It occurs direct when pressing the detail tab contact person. It’s a detail what worked for ever? It occurs in my testdatabase right after restoring a backup from live and running the upgrade.     bij Thinkwise.TSFComponents.TSFGrid.buildVisibleColumnIndex(Obj obj)   bij Thinkwise.TSFComponents.TSFGrid.SetObj(ObjViewContextUserPreferences objViewUP)   bij Thinkwise.TSFComponents.TSFGrid.afterControllerSet(TSFController controller)   bij Thinkwise.Shared.NullableObservable`1.OnAfterSet(T newValue)   bij Thinkwise.Shared.NullableObservable`1.OnValueChanged(T newValue)   bij Thinkwise.Shared.Observable`1.set_Value(T value)   bij Thinkwise.TSFComponents.AbstractViewBuilder.bindControl(IAbstractScreen rootControl, ScreenElement element, IImplementsScreenElement control,

My process flow “TEST”  starts when Open_Job_Flow Task is runned on “table1”The task “Open_Job_Flow” is also linked on “table2”, but when i run the task from “table2” the process flow does not start. If i change the process action type from “Start table task” to “Start task” the process flow “TEST”  does not run also on “table1”.How can i “link” the process flow to both tables without create a copy of the process flow “TEST”  ?   

Is there a way to schedule a Task?My goal is to query a rest webservice ( with HTTP connector) every minute.

I have noticed that the filter in the IAM task ‘Apply user rights to the database’ works different from the filter in the IAM task ‘Apply user rights to IAM’.Starting with the latter: when I apply rights to IAM with the filter cleared like thisthe users will receive the following error: When I select all rows in the user tabel, and apply the rights like this: the users are able to log in.When applying user rights tot he database it seems to be the other way around: if I select all rows and then apply it only applies the rights to one user; if I clear the filter it applies rights to all users.Is this the intended behaviour? Windows gui 2021.3.18; platform 2021.3 -  Indicium universal 2021.3.18.

Is it possible to automatically created users in IAM using T-SQL? The users have been defined in an excel sheet (i.e. login name, password), we can create the users within the application automatically. We would like to do the same within IAM. If possible, is there an existing script we could alter and use? Thanks in advance!

User can't retrieve a tab in the IAM, how can we restore the basic settings in the IAM. Have tried this but get a comment. how can i solve this? 

After a record has been changed (by a user or directly on the database), the changed data must be forwarded to an API. In the update trigger of the relevant table, a task is called that collects the data and converts it to JSON. In a process flow with the above task of process action type "Start task" as starting point, which then passes the data to an "HTTP connector" that calls the API. When a record is changed, the task is activated by the trigger, but the process flow is never started. How do I get the process flow started, what am I overlooking?

Every time I run ‘Creation’ de upgrade-file gives me back 4 tables which not have been changed for months. Luckily, these are not the biggest tables but it is very confusing to see not only he tables that really needs to be converted. What could be the reason they keep coming back ?

So, we have a task to create an invoice. This is a process flow, first we check all values such as Debtor code, vat code etc. If not ok, these must be set and then the invoice can be made. If all is ok from the start, the invoice is made. BUT, not all people clicking the Create Invoice, cannot add certain values on the account - like discount, vat code, debtor code. So, what I kinda what I a ‘You have insufficient rights for this… EXIT.” Is there a way to detect and show such a message?  kind regardsalex 

I made a process flow to close the current document and open the next one in the process. When opening a document using a process flow in universal I get the following error:The document opens normally in the windows gui.The design of the process flow is as follows:Extra information:The universal is opened using the SF.Versions:SF: 2020.2Universal: 2021.3.15Indicium: 2021.3.17

Hi, Why is there a difference between the items to review that appear in the functionality screen vs the items that appear in the code review screen.  Thanks in advance Ricky

Hello I am implementing a resource scheduler and was wondering if it was possible to use the tasks defined in the resource_scheduler_extender as starting points for process flows. I have it sort of working when i use the process action start table task but it seems that my layouts and defaults then do not trigger for the starting task.  Is this normal behaviour for process flows or is it because of it being use in the scheduler?There is of course a workaround by makeing the starting task empty and linking to new tasks from there but i wonder if there is special behaviour concerning the scheduler and process flows.Greets Anne

What could be the reason that table icons are not shown on detail tabs in de Windows GUI?I am currently using WinGUI 2021.3.10 on a SF 2021.2 model 

Hi, i have a relationship between a technician and a incident. the technician is a separate table with a relation to the incident table. currently i am unable to select fields from related tables. how can i select these fields?

The badge values are recalculated with a time interval of 5 minutes (default). When the user interface is not used, it seems that the recalculation of badge values stops after 5 times. After that, the badge values are not shown anymore. Is that a known behaviour?  

Hi,as we aren't able to configure the correct date format via the Extended Property's, we've added an Expression field to the view with some code like "FORMAT(ExpirationDate,'d-M  HH:mm','nl-NL')”For some reason this function is working when running the application via the SF by a developer, but when deploying (IAM sync done, and also did a generate which shouldn't be needed as it is an expression calcuation) it to a test-environment the FORMAT-expression is showing another format (hh:mm instead of HH:mm)Some ideas what might be missing here ?

In a screen (variant) where auto refresh is set, the selected line always jumps between the actively selected and the previously selected record.If you do not touch the mouse/keyboard you will see the selected record number change between those 2 numbers.The view that is displayed with the respective screen has a unique PK.The WIndows GUI works properly.We work with Universal GUI 2021.3.14 b1.1, Platform version 2021.3,Any idea what could be causing this problem?NB. @Robbert van Tongeren reported this problem internally to Thinkwise some time ago.

I want to test our application within the SF with the Web gui directly. However, I get following error:  I am using SF 2021.3 and webgui 2021.3.17. What am I doing wrong, or is this not possible at all?

 I use  the TSFReportmailer for  creating PDF’s ,  web gui gives error.  Gui version 2021.3.17.0. some ideas ?    

I would like to insert the signature from a customer in a shipping document, made in Chrystal Report.Our company truckdriver is using a application in Universal GUI on his tablet to follow his route for the day and receiving a signature after delivering the goods. The signature is saved as a .png, Inserting it as a picture on the shipping document results in a black square. When I convert the signature to a .JPEG it shows the signature fine. Is there a direct way to save the signature as a .JPEG ?