Questions & Conversations

For BI purposes we want to make a call on the Indicium API and retrieve a large table from our application. The table has over 22 million records. We did some testing and the throughput is appr. 1 million records per 12,5 minutes, so we estimate almost 5 hours total transfer time. We want to speed up the process; it is a nightly job. But, we also are looking into transferring the data during office hours, but the gui becomes inresponsive during the process. My questionshow can we increase the performance? is it possible to create a second endpoint that will relieve the pressure on the gui endpoint? if we would upload the data to another API, would that be faster or give less strain on indicium?   

Hi!We have some problems when it comes to load the preview for pdf files stored in Azure.We are getting this error "This page has been blocked by Chrome". The thing is that other files as images are working just fine and the pdf files stored using blob are working as well.There is no specific error in console log and in network it looks like it was loaded ok.Do you have any suggestion? Thanks!

I have been trying to get a test case working to use the Unzip action, but all efforts fail with a -7 status ( The 'File data' input parameter did not represent a valid .zip file.).The flow is set up very simple:- Upload file to Azure Blob storage (Task with a file upload);- Use “Read file” action to get the binary data for the next step;- Use “Unzip file”The last step has the original filename “test.zip”, the binary data and a chosen target folder “unzipped_files”. The filename is confirmed to still be the same name at the upload location. Test process flow Input Unzip filePartial shot of Unzip file action stepI have even tried setting all “Encoding” options at the “Read file” action in case that was necessary, but nothing seems to change the result.The zip file contains is just 3 .jpg images and manually downloading the file from the storage location has given a working file that I can unpack without problem.Any idea what could be wrong or missing?

Hi,Is it possible to use the process flow monitor for system flows in a test, acc, or production environment? I think it only works if you are in developer mode and in all environments except DEV I do not get the option to test a system flow.How can I solve this? I am now missing the option to select a system flow and application when I start the process flow monitor.  

I've noticed that while creating UNIT tests with mock data that data columns which have the domain with Data type decimal do not show up in the mock tests. In this example on the table “voorraad” i have a column named “voorraad_aantal”When changing the datatype of the domain from decimal to numeric the column does show up.  when looking into the table “data_set_col_selection” which is what you see then script shows during creation that it has the following when statement it checks the table dttp if the .calulated is 0 when checking the dttp table with the following queryselect dt.prog_lang_id ,dt.dttp_id ,dt.calculatedfrom dttp dt where dt.dttp_id in ('NUMERIC', 'DECIMAL') and dt. prog_lang_id = 'SQL'the result shows that for decimal the value is null and for numeric is 0 Is there a reason for this? it the use of numeric preferable? In the current model that I'm working in the datatypes are all set to DECIMAL. Changing this to NUMERIC fixes the problem with being unable to create unit

Hello, I created a process flow to send user notification  However, when I run the process, the push notification doesn't send to users. When I login as the user the push notification didn't popup from the website.  Is there anything I missed out?   The input parameters are successfully captured I only put a show message to verify if the parameters are captured. Please help to advice. I'm using universal GUI 2025 Thank you in advance

Hi,After I created a client application in IAM and restarted IIS I get the error below, what is the cause of this? 

Hi all,I want to anonymize data on a database. However, I cannot set my database to ‘Single User Mode’.I get the following error: I saw on that I have to set HADR to off, however I get this message: ‘Msg 40517, Level 16, State 1, Line 2Keyword or statement option 'hadr' is not supported in this version of SQL Server.’ The database is hosted on Azure. Is there a setting in Azure I need to alter? Kind regards,Rick

Hi, I am running into an issue with downloading zipped data, since it returns unreadable data.The flow I have created looks as follows: The table task sets some parameters, like the folder which needs to be zipped, for the ZIP file process action. The ZIP file returns the binary data of the zipped files in the folder. The download file action is feeded the binary data from the ZIP file. This return something like the following in my downloads:  PK V´Z«H[Ï!z A¨ 2_ROOS NV_346514_14-05-2025.pdfÔ»y<›k¿.žÎƒªª©¥h«hKX­©5®VMUMÑš‚´UCDdµ„Ô”NæbaaáEÍm 5Dˆ¥¦ªª¤‚¨YH$qž®wÿöÙ¿wŸ?öÞ篓|îOâÉýÜÏ=|ÇëúR¾sÃ|IC[ô°rAaRªèa­Ó¿œF=ô=lh¨y÷éož§5 }==OkÚ£þ}ÅThe download file returns a 0 as successfull as well as the zip file action. As you can see, the data from the download file process action does have some resemblance of the zip_file_content which makes me assume that the zipped file data is actually downloaded. However, this is not usefull for the application user. The downloaded data should be a zipped

Some time ago (few years now) I replaced all PNG icons by SVG icons because of the future Universal Dark mode that apperently flips the BW colors? At least that is what I was told. During testing of the Universal GUI I notice that when I switch to dark mode some icons are shown white on the dark background, some are partially white and partially black and most of them are just shown black on the almost black dark mode background.I ran the “Decolorize all SVG icons that contain a black fill color” enrichment but that didn't correct the behaviour.The first icon I dug into (The globe with KIN in it) was one altered (originally downloaded from icons8.com) in inkscape resulting in quite a lot of metadata.I used https://jakearchibald.github.io/svgomg/ to clean my svg but the end result is still the same: I couldn’t find a task that showed the icon all white but there is one in the menu: I have attached a selection of icons used in the screenshots.

I've just recently upgraded to the 2025.1 version and I'm preparing the switch from the Windows GUI to the Universal GUI.I've noticed that the mandatory fields in the Universal GUi are a lot less visible than they used to be in the Windows GUI.Is there a simple way to make them a different colour like in this screenshot where I used a conditional layout (condition similar to 5 != 6) to force that this field is shown in Gold?Technically I could think of a query that automagically adds the desired conditional layout for every task field where “mandatory” is set to true to easily force this but that fielss like a very dirty hack 🙄Mainly because that is not what the conditional layout is for and it might even conflict with existing ones….

We are wondering if this should already work.I found out not, for that reason we have now added a form to the detail screen, while we want a detail that exists out of just a editable grid that also allows inserts.   

My users don't like the “the saved data cannot be shown” message.And in the context of this application I understand that.The search for a Person on a screen with a cardlist and a form.If they don't find the Person they must add it.After adding the Person they get this message.But they want to see the Person they just added.I tried making a task with a process flow that replaces the normal Add button.Very simple, a task without template, then process actions for Clear Filter, Add Row (capture Person ID), Change Filter (to Person ID).Work fine, but I cannot disable the standard Add button without als disabling the Add Row process action.So this is not the solution.Then I tried without a task, starting the process flow with Add Row. But then I cannot do a Clear Filter first.So it is Add Row, Clear Filter, Change Filter.But that gives met the dreaded message “the saved data cannot be shown” again. While it IS SHOWN ON THE SCREEN.How do I accomplish this?(On Universal 2024.3)

Hi,When viewing a PDF in Universal it is possible to create annotations like marking, drawing and adding text. As far as I can see the only way to obtain the annotated version of the document is to download it (manually) and then to upload it again to store it in a Thinkwise defined storage location.Is it somehow possible to the download the annotated document and then upload it again from within Thinkwise?

Hallo,, Can we easily applied / use Expression on the column table that will filter the result?Example:       Status has Yes/No value, but you want to display only Yeson status column table can we use expression calculated field  t1.status = Yes?or create a virtual column to add expression? The result will only display all status that has Yes value.I'm using table not view table. any other way to filter the result without using view table.  Thank you in advance

Is it possible to configure a unit test for a control procedure instead_of_trigger?I have a CP which inputs values when a user changes them in a view. The CP does some calculation and then updates values of multiple rows in the database. I'm trying to build a unit test for this without succes.Which unit test type should i use for this case? i've tried with update statement and update handler, but without succes.

I just read the following note in the documentation for the print file connector:PDF files can only be printed on a Windows platformIs this still the case? Because it would be a huge deal braker for platform independence and greatly hamper our efforts to switch to a full Linux platform for running Indicium and Universal services.Of course we could create a tiny application just for print jobs but that would still require a Windows machine.

Experimenting with our options to use AI tooling in the Software Factory, I struggled to even get a basic example working.We already have for other applications (none SF) some models in use on Azure. So for our experiment it would be handy to to use an existing resource and went with o3-mini.It always gave a “Unsuccessful (invalid request)” when looking in the Process Flow monitor. So perhaps the Resource Name need to include the whole url including the api-version, but that does not fit the field.Eventually we just tried another model, namely: gpt-4o-mini.Eureka! It seems this works straight away.So the question. Are the Models to choose for use with the Software Factory limited by certain types?

Could you please make a new account for a new colleague from our IT department? Her name is Robin Liu. Her e-mail address is [replaced by moderator]Thank you for your effort!

Hi,We have customers that (still) scan documents to a TIFF-format. As far as I can see the default Universal viewer doesn't preview files of this type. Is there an option to view these types of documents?

hi,We have a Universal application that has a grid which needs specific column widths, for entering both descriptive fields (wide) and hours (small). In the model we set some widths in the subjects, but when the users change this in the application, I cannot find these settings in IAM, Authorization, Users, User preferences.Only when I change the sort order of a column it shows in IAM.I can manually add a user preference in IAM, and after clearing the cache this change is visible in the grid. But it seems that changes in the grid are not saved in IAM.Is there something we have to set for this to work?Thanks!

We are looking for a way to make a pdf report, based on real time data, available on the customer's website. The intention is not to show the report in an iframe, but as a download.Something like how the file API works would be great, but then a real time generated file as response.Is there a way to realize this with a GET request?example: https://.../indicium/iam/api/public_vessel_schedule_pdf?route_name=north_europe&duration_weeks=4Or will this always have to be done via a POST request?We have started setting up a system flow, but we are stuck.What is the recommended approach?

Hi all,In our application, we have a form that is set to ‘Auto-edit’. Whenever the search bar is used and the filtered results are shown in the grid, the cursor is automatically moved to the form.Depending on the type speed, this can result in unintended changes of the values in the form. I have attached a gif of the problem. After I typed ‘Royal’ in the search bar, the result is shown. The cursor moved from the search bar to the form, where I started typing something. Can I adjust a setting somewhere to prevent this from happening? Kind regards,Rick PS: The GIF shows anonymized data.