Questions & Conversations

We have to create an event schedular in which we get dates entries from database. How do we create event schedular in software ?

I am trying to simply execute a task, without parameters with a process flow every hour.         Indicium Universal (2020.2.2) is running, but I don't see any activity. The version of IAM is 2020.1 and al hotfixes are done.   Could someone explain, step by step, what to do?   

Together with a fellow developer, I am looking for a way to connect to Indicium (Universal) as efficiently and securely as possible from an external application.I couldn't find anything about this in the documentation and in the community.From the data traffic I have been able to deduce that the Universal GUI uses Basic/Cookie Authentication. We could use this way, but probably there is a better way.According to others, there are better alternatives such as JSON Web Tokens (JWT), instead of cookie authentication. I don't know what more the Indicium API offers in terms of authentication.I'm looking for best practice examples.Is there anyone who has already looked into this and can give advise?

One of our customers, who is using the Windows GUI (2019.2.17), is using up to 9 GB (!) of internal memory on the RDS with TSF_dotNET.exe. Most of the time TSF_dotNET.exe is using around 2 GB, but that is also too much. How is this possible and how can we limit this?

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.In some cases it may be desirable to know the translation of a model object, such as a table, column or domain element, inside your business logic. See for example this idea: Translating domain elements | Thinkwise Community (thinkwisesoftware.com)Starting with the last releases of Indicium and soon available in the Windows and Web GUIs, a session variable is added that provides the language of the current user. This makes it possible to automatically generate a function that returns the translation of model objects in the user’s language. FunctionTo add this dynamic function to your Thinkwise application, first create a function subroutine named tsf_translate  with the following properties:Return value: scalar Return scalar domain: transl - nvarchar(200) Input parameters: type_of_object - int transl_object_id - varchar(100)  Control procedureNext, add a control procedure in the Function

Lately, we’ve received the question from several parties (app suppliers like WerkbonApp) whether it’s possible to realize a connection with them. Because of that, I’ve started some intensive testing with Indicium (2018.1 build 2). While doing this, I’ve encountered several problems and questions that I’d like to submit. 1. Is there another authentication way than Basic Auth.? If so, which one and how can I apply this? 2. Why is it possible to filter by $select, $filter and $orderby separate but not with a combination of these? 3. Why is the $top=10 parameter allowed on a table but not on a view? 4. How can I track down the cause of a problem when the system returns a particular HTTP error code (like the 500 internal server error)? I’m aware of the subfolder Logs from Indicium on the (web)server. Are there any other methods to tackle this problem? 5. Is it possible to request both master and detail records (like organisation and contact) in one response? 6. A few p

I'm having some trouble getting things to work. For a webservice we need to base64 encode our message before transmitting it. This worked fine untill we encountered a diacritical mark (ë, î, ú, etc) in the message we want to encode. Then the webservice we're contacting start throwing errors.I've created a test script to show the exact problem and to provide a starting point to hopefully find a solution to this issue. I contains a sample for a correctly encoded message and an invalid one. declare @source varbinary(max) ,@encoded varchar(max)--SAMPLE MESSAGES ONE WITH AND ONE WITHOUT DIACRITICAL MARKS DECLARE @message varchar(max) = 'Dit zijn diekrieten ë, î en ú.'; DECLARE @message2 varchar(max) = 'Dit zijn geen diekrieten e, i en u.';--KNOW CORRECT BASE64 RESULTS AS CALCULATED WITH THE OPENSSL LIBRARY DECLARE @message_base64 nvarchar(max) = 'RGl0IHppam4gZGlla3JpZXRlbiDDqywgw64gZW4gw7ou'; DECLARE @message2_base64 nvarchar(max) = 'RGl0IHppam4gZ2VlbiBkaWVrcmlldGVuIGUsIGkgZW4gdS4=';--BAS

I try to get a process flow with HTTP connector runningI have tried a lot of things already, but still get this error:Specified value has invalid CRLF characters.Parameter name: valueAny suggestions on what can be the reason for this?  

I'm trying to let the end user import ‘large’ sets of data (CSV/Excel) into the database via the Web GUI. It's not that large as in this (https://community.thinkwisesoftware.com/development-13/best-practice-for-inserting-large-amounts-of-rows-into-one-table-837) thread, but large enough to let the web interface time-out. The problem then is that the import is partially done: It could have imported for example 3k of 50k records. The end-user doesn't know what to do: What part is partially imported? And how to fix it? I'm trying to speed this up, but I can't really increase it's performance. When I take a look at the debugger in de Windows GUI I see a lot of database-calls per row. For each row the default and layout concept are triggered, and the record is inserted per piece. Imagine you want to insert 50k records, and each cycle takes only 5ms, but when it's multiplied with 50k it's 250 seconds. From a user point of view this is absolutely unacceptable (besides it probably crashes in t

Free tool supporting many styles of code, integrated in SSMS. Users can create and share formatting profiles. Anybody has experience with leveraging this for uniform SQL coding style and thus easy cooperation between different developers?

When the user opens the (desktop) application for the first time, our application might be a bit overwhelming. That's why we want some 'tutorial' or landing page where the software is explained. This could be a web page with some videos embedded in it. This is a bit like downloading a new app on your phone where the important parts are highlighted in a 'scroller view' (each dot is a page) or there is a highlight on certain button or action. The user should keep seeing this window, until he clicks somewhere saying "Don't show again". I did read this post that looks a bit similar: https://community.thinkwisesoftware.com/development-13/how-do-i-set-a-table-as-a-start-object-or-landing-page-when-ever-a-user-logs-in-889 By following the steps described on the link above we could add a menu item with 'first start' and set that as a start object for each user. Problem is that it will start each time, where it's quite difficult for a beginner user to disable this the next time: You have to

I want to set some role rights on a specific table but I keep getting this error: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). What is the cause of this error? Or, where do we exceed a limit?

One of our strategic goals is to completing the DEVOPS spirit of working @Acto in an Agile way of thinking. This means that most of the complete development cycle has to be automated DevOps software lifecycle management @ActoCurrently one of our projects is working on automating and speeding up the biggest part of the generation of the deploy package, one could say that these are the steps between Build and Test, which currently takes about 3 to 6 hours for each cycle (without testing, just generating). Our goal is to have several cycles a day if not many more, which of course can only be achieved when (almost) fully automated   We want everything that can be automated to be automated. We want it to run mainly in the background.   It would be helpful if the whole thing could be automated by Thinkwise  – but until then, there are things we can do ourselves, but for certain parts we are unable to automate them in the process of creating a deploy package.   The process consists out

I am trying to pass a variable to a DevExpress report using the Reportingservice. When I call the report directly, passing the parameter directly as a Report parameter, it works fine. When I am trtying to pass it with help of the rapport_params it fails somehow.  In the rapport_params I inserted the following values:id    149530report_id    115036parmtr_id    order_nrparmtr_value    1035939 Inside the DevExpress report I have defined the variable:  When I use a value in the preview it also works fine, so I guess the problem is in passing the value from the Reportingservice to the report? Does anyone have any experience with this? 

Hello, We have built a replacement for Wunderlist ((sub)tasks registration). This will be used by our Terminal drivers. They will use a tablet and the application will be accessed through the Universal GUI with a 4G connection. These tablets will rotate between the different drivers. They will log in with their AD account. Problem now is that you can see the passwords of the other drivers by clicking on the eye of the password control. This is certainly not desirable. This is an example, but I can imagine there will be more situations that this can happen. How to deal with this? For example, can the show/hide password eye toggle be turned off?   Thanks in advance. Randolph

I am trying to use the OAuth connector to make a synchronization with the tax service platform of the British Government.I have followed the docs and set everything up accordingly. However when the proces action of the OAuth login connector is reached, a white screen comes up and nothing is happening. I assume thinkwise is adding the client_id, scope and redirect_uri to the Authorization URL? I was hoping to find more information in the debug screen to find out what URL’s etc are being called, but that is not the case. Can someone tell me what I am doing wrong here? I below screenshots you can see my settings.   Settings in OAuth servers      White screen. Nothing happening.    My proces flow 

I am trying to make a link from a third party application to my Thnikwise application via Indicium. For this I prefer the use of tasks/stored procedures with output parameters, which works fine. To minimize the amount of requests I like to return detail data in JSON format as output. It works almost as expected, except that Indicium ads escape characters (backslashes). Like this: code:{ "@odata.context":"https://dev-mob.smarttt.nl/sf/stt/$metadata#STT.complex", "row_id": "BBF3801D-2E9C-42FC-9D33-182C326867EB", "item_id": "Jhlkd2awEQLiPSK7B", "child_rows": "[{\"row_id\":\"80E2F8FDD3B3\",\"image_id\":\"1231\"}, {\"row_id\":\"47F6978E83EE\",\"image_id\":\"1232\"}, {\"row_id\":\"2D40689AFEA2\",\"image_id\":\"1234\"}]"} I there any way or trick to get this solved?

Has anyone dealt with printing labels on a Zebra Printer. With 2 of my clients I have the same issue that I cannot use the full width of the label.The label is automatically scaled to about 70% of it’s label size.And whatever setting I do, I just does not use the full width of the label.I have created reports in as well Dev Express as SSRS and both have the same problem. With DevExpress If I print my label on a HP Laserjet on A4, the label size is correct. If I print it to the Zebra printer the label is scaled to about 70%.I have contacted Zebra and they told me that the paper size of the label is not correct, but I setup the paper size of the label correctly in Dev Express and in the printer driver itself (I’m getting a bit nuts of this)The label size is 105 x 83. I already tried to change every single parameter step by step, but the label is still scaled to about 70%. The last attempt was a bit bigger but still 3-4 centimers of the label is not used. Preview in DevExpressPage setup i

Within Deployment>Creation there are three tabs (Generate definition; Generate source code and Execute source code) in which you can change the values from fields, but at the same time have various buttons with associated tasks.I'm looking to create a screen in which a user can enter data and have buttons to navigate to other screens and/or cancel/save the data (through an associated procedure).What do I need to do to be able model this functionality?

I have a http connector in a process flow which communicates with a .net core 3.0 web api. The API can both produce XML and JSON: [HttpPost][Produces("application/xml", new string[] { "application/json" })]public IActionResult Post() If I do a call with no accept headers specified, this API returns the content as application/json. According to the documentation you can add headers to the HTTP connector: [ { "Key": "Accept", "Value": "application/json" } ] or: [ { "Key": "Accept", "Value": "application/xml" } ] To specify the expected result content type, so if XML is required, the last header should be applied. When I add this and execute the http connector it shows me the following message: The 'Accept' header must be modified using the appropriate property or method. Parameter name: name With a stack trace: The 'Accept' header must be modified using the appropriate property or method. Parameter name: name    at System.Net.WebHeaderCollection.ThrowOnRestrictedHeader(String headerNa

One of the major trends in IT is the tighter integration of Communication, Collaboration and Core System tools. Microsoft Teams and Slack are communication channels that not only replace email for many conversations and notifications, but also provide great added value for collaboration. Microsoft Teams far outperforms any of their competitors on collaboration, thanks to being embedded in Office/Dynamics 365 and allowing for custom in-Teams apps, integrations, etc. Slack has been acquired by SalesForce recently with the same purpose of tightly integrating a collaboration tool with a Core (CRM) System:Together, Salesforce and Slack will deliver the Slack-first Customer 360 that gives companies a single source of truth for their business, and a single platform for connecting employees, customers, and partners with each other and the apps they use every day, all within their existing workflows.In light of these trends and the high adoption rates of tools like Teams and Slack, I am surpris

I have a challenge when it comes to automatically starting the indicium application.  We're working with the Software Factory Version 2021.3 where the Indicium layer is used in the generation process. Correct me if I'm wrong but the message We stopped hearing from Indicium is given when Indicium does not pick up new system flows for at least 60 seconds. This usually means that Indicium is not running anymore and should be reactivated. Scheduled every 30 secondsThis is explainable behavior after rebooting the web server, when the IIS manage server is stopped or when the application pool is stopped or recycled. For all these examples IIS is not automatically starting the indicium application. We should always start Indicium manually by accessing the URL. Indicium will always be accessed by https based on a IIS redirect rule.  When Indicium is running the SF will continue his Generate definition job IIS || Application Pool | Advanced Settings | Start Mode "AlwaysRunnings” | Regular Time I

I am trying to upload a pdf file to an external server. The http-connector should sent a multipart/form-data message, consisting of an application/json part and an application/pdf part.I have constructed the message and I am able to upload a file to the server. However, the pdf file seems to be corrupted or somehow transferred incorrectly.I am reading the pdf file as a varbinary and since I am unable to insert a binary in the content-variable of the http-connector, I am forced to convert the varbinary to a varchar. I use the following code to do so:convert(varchar(max), @file_data, 1)To evaluate I have sent the message from the Thinkwise http-connector as well as from Postman to RequestBin.com. The messages arrive differently: Postman, raw, looks like this (only part of the data copied)0000000 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0000010 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 32 34 33 39 0000020 37 33 36 39 30 35 31 32 39 35 31 33 37 37 36 38 0000030 31 37 34 32 0d 0a 43 6f 6e