Questions & Conversations

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,

Goal Sometime you need to extract only the file name (or maybe extention) from a file path. Solution declare @file_path varchar(500) = '\\server_name\folder_name\folder_name_2\file_1.txt';select right(@file_path, charindex(char(92), reverse(@file_path)) - 1)  

First off: I'm hoping it's OK that questions are asked about Universal, especially since it is an essential part of our current development. We've set all our project versions to Inactive (except the current branch), but nonetheless all our project versions show up in the left bar of Universal. Our current project has a larger number of Inactive project versions, so the list gets very long.

Hi,   What options are there for triggering alert for the end users, perhaps based on groups?  I have an app with several user groups, and I want them to have two things;  an in-app overview page of all items due. (for example, invoice that need to be paid, or orders that need to be closed).  I want them to receive an email every morning at 0700 with all these items. I can’t find anything in SF of the documentation.  I thought of making an Table Variant and filter on the date field. (if invoice_due_date = tomorrow..) but I wonder if this is the best.    Any thoughts on this?    Kind regards, Alex     

I personally like the group label option for a grid, however when you start a group label and there are hidden columns the last visible column never is included in the group. The only way to solve this is to unhide all columns, and hide them in the Grid-layout and make sure they are not within a grid-group.  Would be great if this problem could be solved. 

Is it fair to say that the @cursor_to_col_id parameter in a default control procedure is not working in Universal?

Can processes be executed in Universal? It seems not to work at this time.

We're currently testing our project in Universal. We've seen that tasks from the menu work in the current interface, but are not starting from Universal. When we click them we get the following error:  

I have nothing against drags, but drag rows are not my thing. Is it already possible to disable this on a per-user basis in the runtime configuration, or UP? If so, I must have overlooked it in the documentation. Otherwise I would applaud exposing this feature in an upcoming SF release!   -edit- For me it would suffice to be able to disable the behaviour of default drag/drop; just tick it in the context menu in the same way as I have to do for ‘editable grid' to enable it.