Questions & Conversations

Hi,I tried to use the use the data sensitivity function in the SF. However, it returned several errors. The initial error in the SF indicated that the database is not in single-user mode. Consequently, I tried to upgrade the database, yet encountered another error similar to the one below. It is an Azure SQL database. What steps can I take to enable single-user mode? 

 We are trying to import an excel file using the import functionality but we keep getting an error. We created a custom report which results into an export to excel. After editing the excel report, we want to import the excel file again and update the existing rows. However, we get the following error.We also tried to use the export functionality of the Universal GUI, but if we make an edit in the excel file, we get the same error using the import. Do you have any suggestions? We also do not see any errors in indicium error log. We use the current version: Version: 2024.1Build: 11.1 (beta)

Hello everyone,I have made an update to my dynamic model which edits the data model and the subjects. It sets certain columns to hidden in the subjects, while leaving the newly created display columns visible to the user. I had to make an edit to this dynamic model to prevent the following from happening: (link to a previous post)I made sure the dynamic model made these columns hidden in the data model. But the following error occurs when I run this dynamic model object more than once:It is an unclear error. I must add that we use the staged strategy, so that it does it's job every regeneration of the model. And this never posed a problem. But only after making this edit, so that the database columns are hidden on data model level, this error shows after a first successful run.This is the error it gives when I run it using the generate model in the creation tab:What must I do to resolve this error? I think the error is a little to unclear to actually know what is going on here. I know

 Hello, I'm exploring ways to enhance document search capabilities within Thinkwise, specifically focusing on textual metadata such as the content of the document, document name, document type (name), document number, and author.Could you point me towards the documentation to documentation or resources for integrating AI-powered search, including leveraging external services like OpenAI, configuring custom search criteria, ensuring relevance and ranking of results, and implementing features such as natural language processing and document summarization?

Hello,We are building a report which works when it is started as a ‘Start Table Report’, but not when used with a ‘Generate Report’ task. We want to store the document we generate in our database, along with the record that it should be attached to. For that reason we need to be able to access the file_data, file_name, and file_path in the process/system flow. We are generating the report, and then using the ‘Write_file’ action to store the generated report in our file system. From here I want to use the ‘Add row’ action to add the document to our database.Generating the report works, but when I go to open the PDF I get the following error:  It is saying that the colorspace is not valid in the PDF. We are using the windows gui to generate the report. We have used DevExpress to build the report.Any idea how to fix this?

Hello everyone,We recently implemented a solution for manual tests. This is that we can generate a description using generative AI. This works well for single objects, but when I want to generate descriptions for all of the remaining 200 tests, it becomes incredibly slow, and eventually even freezes. I thought this was my code at first, but when I tested it with the already present description generator for template code, it did the exact same.So now I have to generate my descriptions one by one, which will take an incredibly long time, otherwise I can wait about an hour for it to reach 25% only for it to freeze. We make use of GPT-4.0-turbo. Is this known to be slow or is there something wrong?

Hi all,I'm working on building a screen type with a lot of information on the screen in the form of tables (5) and a form (1). During the design phase, it was determined that the page is vertically oriented and that users should be able to scroll through it at the page level (not at the table level). We assumed that the vertical scrollbar would automatically be added when you put 'too many elements' on the page, but this is not the case, and that's where my problem lies. I would like to have the scrollbar, but I'm not sure how, and I've already tried several things. Can someone point me in the right direction? I’ve added a sketch for clarity.ps. Im on the most recent version of thinkwise and using the universal GUI.Thanks in advance!  

Hello! I have noticed that, sometimes, when a screen has pages, the “Go to row” process action does not work if the record is saved with a custom task on a different page than the one that is opened.For example, now i have the first page opened. If the record is saved on the second one, the focus from “Go to row” is not going to be put on the record.Is there a different way to select a row even if it is on another page? 

I've updated my SSMS to the newest version and uninstalled the previous version.Whenever I edit a template in the external editor by pressing on the little pencil in the SF (Functionality screen) it now tried to start an even older version of SSMS which I didn't even know was still installed :pI uninstalled that ancient SSMS as wel hopin that the SF would pick up mu new SSMS but now it wants to use mySQL workbench 😁Can I help SF to find the correct editor?

We currently use the Thinkwise 2023.3 product. It seems that in this version all indexes are being rebuilt when doing a smart upgrade.In the current version of our application only one new table is introduced, but it takes much longer than in the previous version of the SF (2023.1) we used. Hundreds if of indexes are created, so the upgrade takes longer than expected.Anybody else have experienced this? Is this new in this version and if so, why? Can't it be “smarter”?

We have a (detail) dataset with 65 rows with x-y coordinates, which we like to show on the map.For some reason only 50 items are visible on the map.Is there a maximum number of markers that can be shown on a (detail) map? 

Is there a way to securely delete a file from Thinkwise which for example is stored in Azure (Files), on a local filesystem (share) or other type of storage device?The requirement comes from a GDPR related specification which states that it should be possible to securely delete a file by:Overwriting it’s contents with random data to make it non-reproducable Overwriting it’s contents by encrypting the file (and throw away the key)

Due to a problem we have with the OpenID Connect authentication provider in combination with PWA we would like to disable the “Install as PWA” from the menu so end-users cannot use this functionality and just use the browser based variant. Does anyone know if and how PWA installation can be disabled?

Pagination in Universal is a nice new feature in 2024.1.13. However, it appears that the number of pages for a table is maximized to the modeled number of "max no. of records" for a table.For performance reasons with the Windows Gui, we have provided some tables with a maximum number of records, but in Universal this is not necessary with pagination.It is even inconvenient because some of the records are no longer accessible.Or am I missing something?

Is it possible that the docs was not updated https://docs.thinkwisesoftware.com/docs/sf/process_flows_connectors#generate-report ? it says theres a status code as low as -4 but i am getting a contraint error on the output parameter because it is trying to output -5. Now i am not 100% sure there isn’t something weird going on in my process and the -5 is coming from somewhere else. But to rule it out would be nice to get some confirmation. Thanks.

What is the purpose of being able to enable/disable process actions in a role? The reason asking is that when one action is not enabled, the whole process flow is not granted and therefor not working.Here an example situation:Example of a simple process flowThere is a table task on several screens which all execute the same type of action and flow to opening a report. For management it is easy to have all entries in the same flow.In a role only one or limited screens need to be available to the user, so only those parts of the flow need to be accessible I would think. Lets say the first line in the example and not the Pink and Green marked ones.Another consequence is when you are developing and adding a new screen with the same task and you add it to the flow. Let say the Green marked one. Now in all role that have this flow, the functionality is broken, because there is a new action available even though that would not touch anything in the old roles. You need to enable this action in

With an HTTP connector within a custom protocol process flow we make a call to an external API and in certain scenarios it returns an expected 404 code as response.  How can we ensure that such a 404 response is not written as an error in the Indicium log? We like to keep the log file as clean as possible.  

Although there is a solution mentioned about 8 months ago to solve this problem (disabling auto-edit), this is not possible for our solution. We make use of the form list functionality which depends on auto-edit being always “on”. The seconds possible cause is that we make use of state changing forms. This means that a user enters data in the form and when done, clicks on a task-button to post the form to be processed by a backoffice system. The task-button starts a process which performs additional validation and when successful posts the form. The posting of the form changes the state of the form by which it is no longer visible to the end-user and the form is automatically closed using a process task. The form is closed, but this does not prevent presenting the “Object was not found...” error message. We know that the form is no longer available (due to no longer complying to the filter condition of the variant), but cannot find a way to suppress the error message.

I have a multi row task that starts a process flow. This process flow executes HTTP requests for the selected rows. Now I want to show progress (tsf_send_progress), but this progress is not shown in the Windows GUI. When I look in the debug tab I can see the messages are sent.How can I show progress?

Hello!We found an issue on all of our projects after the update. The taskbar does not seem to go away in Universal GUI. As seen below, we only have the tiles task as screen components. In the Universal screen, both the tiles and the taskbar are displayed. We are not sure if this is a bug, or f there is any way to fix it.Screen typeUniversal screen 

Hi, I am running into a problem when trying to import and use the data of an excel document within a flow. I have made a task that has a file column which is coupled with azure file storage. Uploading the task to azure file storage works fine. However, I want to use the content of the excel in the flow that has been started by this task.   The process action that, at least to me, makes the most sense to use would be the read file process action. This is where I ran into my first problem. The input of the source file parameter could be random when a user inserts files with the same name. Additionally, the read file process action does not translate the data from base64 to a string, is this intended behaviour? Or would this not be possible with the read file process action/ any other process action?In short: Is it possible to import an excel file from a task and use the data from the excel file within the same flow?  I am looking forward to any ideas that will get this working!

We are trying to create a screen where the user can get their current location and want to show this directly for verification using the maps component.From here we want to start location-related tasks, such as field inspections, observations, etc.For the test, this view is used ​SELECT tsf_user = dbo.tsf_user()     , device_gps_location = NULL     , maps_coords = '{"CoordSets": [[{"Lon":"4.7635140", "Lat":"52.4253230"}]]}'     , map_marker = 'BLUE'​It looks like below:  A marker on the map should move to current location after leaving the GPS Location field.I know how to control the maps component, but I can't get it to work.If possible the current location of the user is shown immediately when the screen is opened and the users allows the application to use the location. Any ideas?

There is a domain with 5 elements and they all have a translation. In a task I am using a parameter with the same domain, but to limit the options in the selection, I have used a view to reduce them to logic choices and the column uses the same domain.When I now use the task, it does indeed limit my choices, but now it does not show the translated values. Clicking open the lookup, you see the options there are translated. How can I make it work that the parameter also uses these? Task showing db value, while the lookup view shows the translation.(Universal GUI 2024.1.12.2 Platform: 2023.3 with hotfixes applied)

Hi, I’m encountering issues while editing a specific table form.  When I click on any of the checkboxes, it immediately clears the forms. I assume this is related to the default procedure because when I disable the default procedure in subjects, the issue no longer occurs. However, even after re-enabling the default procedure and commenting out all of the code, and then executing the empty default procedure script, the problem persists.Also, this problem only occurs in Universal Gui (2024.1.11.1.0).What could be causing this and how do I fix it?

Is it possible to set the user Configuration on a user group level instead of per-user?https://docs.thinkwisesoftware.com/docs/iam/users#configure-user-preferences  Select a Configuration or create a new configuration using the pop-up. Available configurations are: None - No user preferences are stored and the user preferences ribbon is hidden. Resize - Users can collapse and expand their menu and ribbon. Furthermore, they can change the sort sequence and column width in a grid view. Move - Resize plus the option to configure their own start objects and set the sort sequence of all subjects. OnOff - All options except for changing screen types. Complete - All user preferences options are available to the user. As far as I understand setting this to complete also enables the user to change screen types and save user-defined-prefilters. I couldn’t find an option to set this on a user group.