Questions & Conversations

How do you translate Maps extender item? I've input the translation objectsd in the extender, but they are not showing in the Translations form.  

Check constraints is only defined on tables. However it could be helpful to define constraints on columns or even domains. Searching on internet I find references that constraints on domains have the advantage of defining them just once instead of defining them for every use. I have not found any information in the community, so I assume there is a reason why constraints are only defined on a table. So what reasons are there for only defining a constraint on a table instead of also defining them on columns and domains?

I'm trying to insert a record via the Indicium Universal OData API. I'm getting stuck on a read only field. Consider the following data model as example: I have the tables project and project_vrs (having a reference between them). Please note that ‘project_id’ is read-only in the table project_vrs, and there is no identity used. If you generate the model you'll see the following screen: The user can open/add a ‘Project’ and via the details he can access ‘project_vrs’. It also allows him to add a project_vrs. My question is, how can I reproduce the Windows GUI behaviour via the OData API? Doing a POST call via Postman inserts the project:   The project_id ‘TEST’ is created. When I try to add project_vrs I get an http 403 error: The Indicium log shows the following interesting line: dbug: Indicium.Controllers.TableController[0] Cannot change the value of the property 'project_id' of 'project_vrs'.The application model prohibits editing this property. This is probably cause

Do temporal tables count as one or two tables for licensing?

I'm experimenting with the OData API and I was wondering what the possible response messages are in case of exceptions / errors. I found out that there's a response header provided called “TSFMessages”, which is base64 encoded. Decoding this value gives a result like below: { "MessageType": "ApplicationDbMessage", "RawMessage": "<msg id=\"import_error\"></msg>", "MessageID": null, "NamedParameters": null} Is there an overview of all MessageTypes? E.g. what can I expect? And what do the other parameters do?

I managed to create an API task to upload images in the application, save a record in the database and store the file in azure file storage. This opens the door to new features  One more optimization could be made for how the storage location should now be included in the API call. I would like to get the yellow marked piece from the settings in IAM. Or rather not want to participate in the API call at all.   Any idea how this could best be solved?

I'm pretty sure I have asked this before (either in TCP or perhaps when calling Thinkwise): is there a way to set the size of a popup (lookup) in the GUI? I've checked TCP but can't find the answer I'm looking for. Neither in the ini documentation (looked for “window”, “size”, “popup” etc etc etc) Either by setting a extended property or in an INI file. And if so, is it configurable per subject (don't think so) and if not, isn't that something to add as a new idea here?

Hi All, perhaps it’s an old bug and is it solved already. (We’re still on the 2018 version, hopefully we will update this summer)  Is anyone know with the behaviour that a list bar menu group is opened when starting the application. In this group is only one item. If we close the group, the group will not open again. It stays closed until we restart the application, and then it’s opened by default. I don’t see any settings in the SF or the IAM related to this ‘feature’

Is there anyone who has a working example of the maps component? I find it quite difficult to Implement the functionality by trial and error, based on the documentation. It would be nice to have a fully filled extender definition, plus the definition of a source table, including sample data.    

Hello! A question. I want to fill a column in a table with a default value. I can do this in many ways, but normally in SQL I can do something like this: ALTER TABLE MijnTabel ADD CONSTRAINT DF_xxx DEFAULT GETDATE() FOR MijnKolom Something like this. I wanted to do the same thing within the SF, but it seems that is not possible. What I did was go to the table and then fill in 'GetDate()’ as the default for that column. However, then I get a message during deployment that there was a problem converting the varchar to a date. In short, it sees 'GetDate()’ not as a function, but as a string (the single quotes were added too).  Long story short: is it possible to use GetDate() as a default from within the SF, or should I use another method (f.i. create a default that automatically fills this field with the current date) BTW: there is a slight difference between these two: if I were to use GetDate() as the default, it would get the date when the record was added. If I create my own d

Is it possible to add a 'DEFAULT' constraint to columns via the TSF? Currently we fill trace columns via insert and update triggers but this results in unwanted trigger actions. The insert trigger will update the same table and thereby triggers the update trigger. Which in return executes the whole update trigger. (See code below) We have multiple places where this trigger nesting causes errors or wrong results. If we could add a DEFAULT constraint to the insert columns the code of the insert trigger won't be necessary anymore.

Hi,  We have a web app and have several parties with several users using this software. Now, every time we have a new release and push this to production, all users have the latest version - with new features and bugs fixed etc.  What possibilities are there for having a popup appear with a change log where we can show what has been implemented, has been fixed/changed and such?  Users acknowledges this update and can use the app.  This saves us an email or call to our users every time we update  In an ideal world we would even be able to send a push message, in case of unforeseen reboots or backups or whatever.  Any thoughts on this?    Alex    

I try to send an email via the TsfReport mailer using a smtp connection. This connection does not require a username and a password so I left those entries empty. All other parameters I have created and filled with a value. However the task keeps giving the error: Value cannot be null. Parameter name: address.  I checked the documentation and I even added the parameter e_mail and the parameter email. (At the smtp section it is ‘email’ in the top section it is e_mail?? I also added the smtp_host variable. I have given all the variables a default value, so there is no code involved.  Could security be an issue? If the smtp port is not open for that address, is this the error I’m getting back?     The stacktrace gives….    at System.Net.Mail.MailAddress..ctor(String address, String displayName, Encoding displayNameEncoding)    at Thinkwise.Shared.Mail.SMTPMailer.createMail()    at Thinkwise.Shared.Mail.SMTPMailer.Send()    at Thinkwise.Extensions.ReportMailer.TSFReportMailerBase.T

Goal Something that can often occur in your projects is working with order numbers. This is also done in the Software Factory itself. In our case, when the column "order_no" (for example, 10 and 20) exists, the column "abs_order_no" (in that case 1 and 2) pretty much always also exists. Now you may want to increase the "order_no" for each record by 10. When you add several new records between 2 records, the increment of 10 between these records is interrupted. To correct this, we have renumber tasks in the Software Factory. By using these tasks, the increment between the order numbers will be restored using the "abs_order_no". These renumber tasks are created dynamically in the dynamic model of the SF. I would like to share this concept with you. This is the model part. But I'll also include the control procedure code and template code for the code of the renumber tasks itself. Let's get you inspired! Solution Create the tasks by executing the dynamic model code in the zip-file.

When the ‘forgot password’ function is used in the webGUI, a token as shown below is sent to the user by mail. This token is probably very safe, but also difficult to copy in handwriting (correctly), and the safety it provides is does not reflect the functions Zeeman provides to most users.  Is it possible to configure a shorter/simpler token? I was thinking of a 4 digit numeric code, but a 6 digit code (provided by the forgot password function in the mobile GUI) would also be ok.    

I'm unable to use the tile menu in Universal, although it is the only menu made available in IAM for Universal. What am I doing wrong?

For certain tables such as invoices there’s a lookup to an address table based on a unique address id. The address table has a (hidden) column with a multiline expression containing street name and number, postal code and city. Thus 3 lines effectively. This field is set as the default display column for address lookups. The issue is that in every form of a table that is targeted by this lookup the address appears as a single line. Line breaks completely disappear. I can get around this by adding a new expression column in say the invoices table and make that multiline as well which then displays address data correcty as 3 lines. But since expression fields are always read-only this makes it impossible to change the address through this column. I can of course ‘hack’ this limitation by adding code to a layout procedure that hides the expression field in edit mode and displays the actual address id column instead but that I think pretty much defeats the purpose of having a simple look

When working on a mobile device like a phone (limited display size) expression fields cannot be made visible in the SF in component “Card List”. I wonder why…    Anybody a clue why this is not allowed in the SF (2019.2)?

Hello all, I have a question about unit tests. We're currently working on getting to grips with this subject. But I'm kinda stuck on one specific unit test. I have a default that I want to test. It is a simple one that removes spaces from a string, as follows: if @cursor_from_col_id = '[field]'and @[field] is not nullbegin set @[field] = REPLACE(@[field], ' ', '');end; But now I'm lost when adding the input parameters for the unit test. I'm choosing 'postal_code’ as a parameter with input '1234 AB’. But when I run the test it just returns '1234 AB’ (so it failed). I also tried adding 'cursor_from_col_id’ with input 'postal_code’ as an input parameter, but that also didn't work. Looking forward to your answer!

Hi,   We use the resource schedular and it works fine. But when i checked the setting [Zoom factor] under web settings i got an error "object reference not set when we log in."   Does anybody have experience with this? thanks in advance, regards Ronald      

Hi There, We have used the report mailer (TSFReportMailer) for mailing the report to users with smtp. In windows it is working well but unfortunately when we deploy it on our IIS webserver the follewing error shows   Does anyone have experience with this? The next step is to deploy to a azure enviroment!  Reguards   Ronald

When I open the SF (2020.1 with GUI 2020.2.10) there's a button called “Version control” in the Developer tab page. I do notice some warnings. What does the tab page do and should I be worried things not working properly? I'd assume all should be green or blue. Some assemblies are referring other (patch)versions and some assemblies cannot be loaded it seems. TSF_dotNET, Version=2020.2.10.0, Culture=neutral, PublicKeyToken=nullThinkwise.Runtime, Version=2020.2.10.0, Culture=neutral, PublicKeyToken=nullInfragistics4.Documents.Core.v18.1, Version=18.1.20181.237, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cbInfragistics4.Documents.Excel.v18.1, Version=18.1.20181.237, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cbInfragistics4.Shared.v18.1, Version=18.1.20181.237, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cbInfragistics4.Win.Misc.v18.1, Version=18.1.20181.237, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cbInfragistics4.Win.v18.1, Version=18.1.20181.237, Culture=neutral, PublicKe

Hi    We use the resource schedular and it works fine. But the customer wants that when he scrollss horizontally the vertical scrolls stays the same position. Now the vertical scrollbar is automically set to the top. The user must then click the scrollbar to select the bottom row. This is not handy when you want to scroll from horizontale and see the bottom rows.    By the way a bigger screen solved the problem but is not the solution.   Does anybody have experience with this?   thanks in advance, regards   Ronald  

hi,   I have an overview of ‘orders’. I can print one order to PDF, based on variable order_id just fine.  If I select multiple orders, i will print fine, but instead of one long pdf, i download 1 zipfile with 4 (e.g) orders in it. However, I need it to be 1 file with 4 pages, 1 order per page.  I know this is possible, but I can’t figure it out. My report is build in Report Builder. Do I need to modify my report, change the settings in SF OR both..?     Anyone can point me in the right direction?  Much appreciated! 

Hello, Is it possible to start outlook within a process or task? Kind regards,