Questions & Conversations

Using a task we send email messages together with attachment report which is auto generated, using TSFReportMailer. This works fine, our message can be created, along with subject and recipient(s), and even sends an attachment, however, so far only in .pdf-format. According to the documentation, here https://docs.thinkwisesoftware.com/docs/kb/report_mailer.html#parameters it should be possible to send the attachment in for example .xls format? in our task we added the following task parameter:  We have tried various different setting, so far no luck. please advise, thank you Paul

When I do adbo.tsf_send_message ‘message’, null, 1 -- abort in a task, I get a dialog like this in the Universal GUI:In the WebGUI you'll get something like this:Difference? Cancel versus OK.Why is the Universal giving a Cancel button, and the WebGUI a OK button?With Cancel you'd expect the task to be cancelled, but you don't, you're returned to the task (Press cancel to continue?). It's kind of a acknowledgement, but not a cancel I think.Why is this a Cancel button, and not a OK or “Dismiss” for example?

I've table with 60+ fields and some related tables (parent-child relation). Based on a status in the header table, the record in that table and the related records in the child tables should be made readonly in a layout procedure.Is there option to make this in a ‘simple’ part of code without specifying all the fields separately?Otherwise there is a risk when adding new fields, that these will be missed to make them also readonly.Is this possible with dynamic model? Thanks in advance!

Situation:I have a list of products with a product name. For each customer I have the option to indicate which products are allowed and give this customer-product an alias. With an alias the customer only knows the alias and not the original product name. So the same product for different customers can have different names.A screen for the service desk should show all products (also those that are not connected to a/the customer). When no customer is selected all products are shown with their product names. But when selecting a customer, the products should have a mark if it is available for the selected customer, and when an alias is known for this customer, the product name must be extended by this alias (for instance by + ‘ - ‘ + alias).Question:What options within the SF do I have to get this dynamic display value without having to resort to a view with a cross product between all customers and products (as this can become very large)? 

Why can I only have one condition on a conditional layout? I already came across multiple cases where I wanted to use a conditional layout based on more than 1 condition. For example, to check if an order is too late. You only want to check for orders that are not delivered yet. By doing this, only the not delivered orders get a conditional layout when their expected delivery date is exceeded. Is it possible that we will can query for conditional layouts? or add multiple conditions?

Hi, I run into something weird. I have a table, with the column shipment_id visible. In the table_variant, it is not showing. Although the Components say 'read-only’ or 'Editable’. It just does not show. Other column in the same table variant do hide/re-appear when making changes, so this one column is somehow different. Yet… how? What am I missing here?  Column set to Editable;  Column should be first one visible in this screen.  

Hi, got something I don't understand. When i open <url>/FF-OSL-Universal-lab-API/api/I get;  When I go to;<url>/FF-OSL-Universal-lab-API/api/iam/iamI get (a login screen, and when logged in);When I check in IAM I have an active App;  However, When i call; <url>/FF-OSL-Universal-lab-API/api/iam/344i get→ redirect to http:// (not https) and a 500 error→ If I force https:// i get a timeout error. Also, trying the alias is not working; FF-OSL-Universal-lab-API/api/iam/ff → same issue. When opening; <url>FF-OSL-Universal-lab-API/api/iam/iam/gui_applgives me:  So, the id is found  (the active app is is further down the line..) BUT : Notice the the URI is suddenly changed.I open:<url>.com/FF-OSL-Universal-lab-API/api/iam/iam/gui_appland get;<url>.com/iam/iam/$metadata#gui_appl  Where did my Indicium Universal part of the uri go?! Anyway, any thoughts on this are more than welcome! Been puzzling for quite some hours now. Kind regards, Alex 

Hi, From what I have read, it is possible to use Two Factor Authentication (2FA) in the Windows GUI by initializing it with the Indicium environment. However, I could not find anything about using 2FA in the Web GUI. Is it at all possible to use 2FA in this context? If so, how, and if not, are there any plans to enable this sort of thing?Kind regards, Dries Fransen

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?