Questions & Conversations

Using the File upload control it is possible to upload a file. Using File upload requires a Storage location in the database.Is there an option to browse for a file (or folder) and only import the selected path (with filename), but without actually having to upload a file?I want to use this in combination with BULK INSERT, so don't need an uploaded folder in the application.

Is since the last update to 2021.2 something changed in the scheduler component. After updating the SF I’m running into an error. when starting the scheduling component. We have 2 functions with the schdueling component. The other function works normal. 

I can’t create a sequence without cache (version 2021.2) ,‘The cache size for sequence object 'deb_contract' must be greater than 0.’in the sequence  cache is not enabled 

Hi,I would like to scroll horizontally in the multiline userinterface controll, without using the magnifier glass.How can I do this? Currently there is only a vertical scroll bar. 

Is there already any functionality that cover the Idea below? Should this be added as a bug? I don’t know if this functionality is already available in Windows GUI or Web GUI, but not available in Universal GUI.

Recently we've upgraded from G9 to 2021.2, and we've noticed a difference when we want to import.In the old situation, the field Project id was automatically filled because the ‘Hang & Sluitwerk'-table is a detail table from Projects. In the import file we don't provide the ‘Project’-field at this moment.When you manually add a new row in the form the Project id field is also filled with the project, 404 in this case.With 2021.2 and the newest GUI this is changed and the column is empty.Did I miss a setting or is this something that has been changed over the last years?Thnx.Patrick

We are trying to configure the “Forgot password?” option on the Universal login page.Tried to search the community and docs but didn't find a way to achieve this.We are using both IAM and Windows-users for login, and I guess the “Forgot password” option is not available for Windows users ?I guess we need to configure a SMTP-server somewhere (appsettings.json?) and ofcourse the user should have an emailadress configured.Is there maybe some documentation how to configure all of this ?Running on Indicium 2021.1, Universal 2021.1.15.0Thanks.

For some subjects we've disabled the default CRUD elements and replaced it by tasks.For the ‘Edit’ I can assign Ctrl + E to “override” the default edit shortcut. However, for the add and delete I cannot select the + and - sign. The Ascii code table is unfortunately read only. Is this somehow possible to do?It would make more sense to our users the shortcuts are generic and not mixed (Ctrl+- and Alt+X for example). I'm aware that this idea would probably fix our problem, but I don't really expect that to be implemented soon.

I have upgraded to 2021.2.14 and I am experiencing problems with the browsericon and two-factor authentication. I have tested some and the following happens: I stop the application pool →  service unavailable I start the application pool and go to the url and clear Cache (shift-F5) → browsericon is reset to TW default, logo is TW default I log in and go to the 2-factor page, which looks like this: I log in and log out, after that I clear browsercache again → on the login page our logo is back, but the browsericon is still TW default.When I downgrade to 2021.2.12 , start the application pool and clear my browsercache it works fine:  The browsericon and logo are both back again after logging out and shift F5.

Is there a way to set password to pdf generated by report buttons or in the pdf itself generated by dev express

I updated the SF and the IAM_SF tot 2021.2. Now I’m testing to upgrade the live IAM tot 2021.2.I have a small rol issue so I want to correct this role in the production application and then synchronize with IAM. Alltough after upgrading the IAM I try to sync and then I’m running into this message. The iAM 2021.3 is required. As far as I know I updated tot the latest version of 2021.2 last week. Why is it asking for 2021.3  

I have applied some changes in a data structure, where the original table is no longer exposed to end users, but instead is exposed via views. The already created unit tests are still on the object that is no longer exposed. How can I change the unit test “Object” (dbo.unit_test.object) value to the new view? Because it's read only as far I can see. Is it safe to update that field value, or must I rewrite all unit tests? 

I want to create a table variant of the resource scheduler for read only. In this variant I want to disable most tasks to add, resize and drop items in the schedule. I tried to create a reference between the resource view and the tasks view, but that seems not to work. The tasks are still available.How could I achieve this?  

Hello,I’ve run into some weird behavior I cannot explain:When starting a process flow from a task, the process variable values don’t appear to be available in the control procedure attached to that first task. It will always be NULL instead of the default assigned to it. The process variable has a default value assigned to it but that value appears to only be set in any procedure/process after the first task. Furthermore, if I set the value of this process variable in the first task and use the multi row task execution, the other instances of the task do not see each other’s value (always null).Some verification I’ve done:The process variable has a default set using the form under process variables (Same behavior for both expression and constant value) The first task has a task parameter with both input and output set to true and no default is assigned there. In the process action, the process variable is assigned to the input and output of the task parameter. Confirmed that the proces

When I use a cardlist to display information in Universal, I get an error as follows: 2021-06-17T09:59:28.9376037+02:00 80000036-0001-f400-b63f-84710c7967bb [ERR] TSFMessagesMiddleware: An unhandled exception occurred while processing the request. (fffadd8a)Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'OFFSET'.Invalid usage of the option NEXT in the FETCH statement.   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__188_0(Task`1 result)   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)--- End of stack trace from previous location ---   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)--- End of stack trace from previous location ---   at Indicium.Data.Shared.Connection.DbCommandExtensions.<>c__DisplayClass3_

I want to import multiple csv-files into the same table.I want to know which imported rows were part of the same import-batch.In the Debug-view I only see the INSERT (preceded by DEFAULT if modeled), but see no extra information about the batch or imported file.How can I do this?

We want to start up a process flow via a single job on the databasein the evening hours.  So that in the morning the reports are ready for use.Is this possible to realise in Thinkwise, and if so, in what way?

Hi, with the update of IAM 2021.2 tenants are introduced. We’ve already had some kind of custom tenant structure (outside IAM) and I would like to apply the tenant structure as well into IAM. It might be interesting for us, so the external tooling could disappear.However, I want to upgrade to 2021.2 including a proper tenant structure, unfortunately there is no task to move a user and user groups to it's own (new) tenant, it's all to “Default”. Is this somehow possible?

Multi-selecting rows is quite new in Universal. We think the functionality itself is really interesting, and that is why we tested around a bit with it. A task is able to execute multiple times, depending on the amount of rows you selected. Recently, we have added a Context procedure which disables a task in certain situations. Whenever a row is selected which does not meet the requirements specified in the Context, then the task is disabled. If you multi-select a row for which the task is enabled via the Context, then the task is enabled again eventhough a row is selected for which you should not be allowed to execute the task. Luckily, the Universal GUI shows the following message when trying to execute the task:We noticed this behaviour does not happen in the Windows GUI. There the task is executed even if one of the selected rows disabled the task. Therefore, the questions we have regarding the multi-select functionality are:Is this behaviour final in the Universal GUI? If not, is

Good morning,Yesterday we have tried out the extended property that should enable an integration between Thinkwise and Matomo: We would like to use Matomo for heatmaps and session recordings.Despite that we have set the extended property (and even installed the JS; https://developer.matomo.org/guides/tracking-javascript-guide), Matomo's dashboard is not receiving any input from our application built in Thinkwise. Could you explain what we need to do in order to integrate Matomo properly?Thanks in advance. 

In Excel you have the option to use freeze panes to keep certain rows and/or columns always visible.Is there a way in Thinkwise to keep the first couple of columns always visible in a grid?I would assume to find this within Subject>Components>Grid, but can't find it there.

Can we have the translation of the report variant displayed in the design screen so that I can see the correct order?Have created 3 variants of the reports. 

Hi!I have a scheduled system flow that I would like to start when a task is executed as well.This is normally not possible because you can’t add ‘Execute task’  to system flows.To circumvent this problem, I could add a second process flow which is started by the task and uses the http connector to make a post request to indicium to start the systemflow. (As described in https://docs.thinkwisesoftware.com/docs/indicium/process_flows.html)This should work fine but has a ‘hacky’ feel to it. Is there a better alternative I’m unaware of?

Has someone in the community established a succesfull integration with gmail, especially for the incoming emails. Requirement is to store incoming emails (from the google gmail client) into a TW application and connect them to clients, contacts, orders including attachments.Hope someone has done that… Or somebody who knows somebody who has done that 

As seen here in the Cur. column USD is highlighted while the form version is highlighting the whole field.