www.usoft.com To www.usoft.com

Share your best practices

Share use cases, tips & ideas with other customers

  • 12 Topics
  • 2 Replies

12 Topics

R
robert.hellinx
published in Share your best practices

How to specify a port number in an OLEDB connection string

Sometimes customers do not use the default listener port for a SQL Server database server. In that case you may have to specify the port number in the connection string.This is the full syntax and some example you could use in the USoft binder:[Windows servername],[port number]\[named instance server name[:[database name]NTSERVER01,12345 (Windows server + comma + port number)NTSERVER01,12345:myDatabase (Windows server + comma + port number + colon + database name) Laptop123,12345\SQLEXPRESS:myDatabase(Windows servername + comma + port number + backslash + Instance name + colon + database name)  Named instance is the name of the database server in case of an “Always On” SQL server installation or when you install SQL Server express edition.   

2480
R
2 years ago
dara.sami
dara.sami
published in Share your best practices

Syslog logging for audit trails - Part I

With new data breaches being discovered nowadays almost weekly, it becomes ever more important to protect your application data and keep track of which user has accessed what data and any changes he may have made.  Such a chronological record of access to and modification of data is called an audit-trail.  Audit trails are often used as an investigative tool to detect and analyze application and user behavior for data breaches before they have made such a significant impact such as the complete exposure of the entire database of the application. In a properly configured audit trail system events leading to such an exposure are monitored, and as such data breaches can be kept to a minimum impact, if proper action is taken quickly. Audit trails are commonly kept in logs called audit logs, which keep track of:  Every access and changes to sensitive data in detail. This way, any unintended access can be traced directly to the person who viewed this data, or even changed it.  Any successf

2130
dara.sami
2 years ago
R
robert.hellinx
published in Share your best practices

Five things to do in Windows Designer at the start of a new developmentWindows Designer

The Windows Designer has a few defaults that cannot be changed because they would break existing applications. Some of these applications have been around for more than 25 years! Therefore, at the start of a new project I start with a few simple changes to make life easier and improve the look-and-feel of the application under development. 1. Add an accelerator to the save button in the Main MenuThe save option has no accelerator, a keyboard combination to execute a function, to save changes of application data. Normally we advise not to change items in the default menu, yet in this case it will do no harm. The best way to do so is to change the menu page "STD_FILE". This page is embedded in the default menu page "US_MAIN", but if you built an application specific menu you can easily reuse this menu page. StepsOpen the Designer. Open the Menu page "STD_FILE". Select the menu item "Save". Open the Property Inspector. The topmost property is Accelerator. Add the value: Ctrl+S Save your c

2120
R
3 years ago
Patrick Camphuijsen
Patrick Camphuijsen
published in Share your best practices

Syslog logging for audit trails - Part II

Output to external applications The earlier instructions in part I of this article enable log output of the SFW, Page engine and even the SQL operations at the application level. At this stage log data is sent out by these sources ,targeting localhost as the data destination via UDP. However, there exists no process yet locally to receive and manage the log data. To include this part we need to introduce a log collector. This also means that the localhost is serving as the log server; you could have targeted another machine as well as shown in the configuration properties of the SFW and Page Engine. After establishing the log server, aggregated logs on that server can be further used by a log visualizer.  The instructions from here on lie outside USoft scope, so we will work on setting up external applications to work towards the final use case of having a visual audit trail. NXLog We are free to choose which tool should collect the log data and so we choose nxlog community edition for

1520
Patrick Camphuijsen
2 years ago
Rob.van.Haarst
Rob.van.Haarst
published in Share your best practices

Decision tables in the USoft platform – Part 1

What do you do as a USoft practitioner when a client shows you a decision table?USoft Studio is for specifying rules. USoft Definer is for implementing rules. But... you cannot draw a decision table in USoft Studio, and the Rules Engine you build in USoft Definer listens to business rules, not to decision tables.Here is an an analysis and some suggestions. You must have come across decision tables yourself! Please add any comments, criticism and ideas that you have.This is a 2-part article. This Part 1 explores what decision tables really ARE. Part 2 talks about how to apply decision tables in the USoft platform.Introducing Decision ModellingSay, your client is a local council.  They must be able to decide if people are eligible for housing benefit. They have old software that helps them make this type of decision. They want to replace this software by a rules-based USoft application. Your task is to build the new application with them. To be successful, you need to know how they make

920
Rob.van.Haarst
2 years ago
A
Anonymous
published in Share your best practices

Adding stylesheets and scripts to your project with webdesigner

Even though the USoft Web Designer has default stylesheets and scripts, every now and then you want to add new files. In this blog I will explain how to add new scripts and/or stylesheets to your project.File locationWhen adding the files it is important to know that these are to be placed in the ALT folder of the Web Designer publication. To get the location of the ALT folder simply open the Web Designer, open the ‘Publish’ tab in the menu and click on ‘Publication Configurations’After clicking the ‘Publication Configurations’ in the menu, the following image should appear on your screen and in here you should find the path to your ALT folder (which you defined yourself by creating the publication).  Copy the link of the Alt Template Folder from the Publication Configuration and paste it in the windows file explorer. Your are now in your ALT folder.Create filesNow that you’re in the ALT folder, create a new folder called ‘Website’. When this folder is created, open it and inside creat

660
A
2 years ago
Rob.van.Haarst
Rob.van.Haarst
published in Share your best practices

Decision tables in the USoft platform – Part 2

What do you do as a USoft practitioner when a client shows you a decision table?USoft Studio is for specifying rules. USoft Definer is for implementing rules. But you cannot draw a decision table in USoft Studio, and the Rules Engine you build in USoft Definer listens to business rules, not to decision tables.Here is an an analysis and some suggestions. You must have come across decision tables yourself! Please add any comments, criticism and ideas that you have.This is a 2-part article. Part 1 explored what decision tables really ARE. This Part 2 talks about how you can apply decision tables in the USoft platform.Decision tables in USoftYour client is a local council. They confront you with this decision table for determining the Budget Flexibility of a person applying for housing benefit.What is best practice for you as a USoft developer? What should you do with this decision table in USoft?USoft is a low-code platform. In an ideal world, USoft Studio would let you draw this table in

550
Rob.van.Haarst
2 years ago
Frans.Willem.Duijnhouwer
Frans.Willem.Duijnhouwer
published in Share your best practices

Five tips to work efficiently with USoft Studio

Last few months I have been working with USoft Studio a lot to get to understand and at the same time capture the business rules for one of our customers. Within USoft Studio, we use the Semantics for Business Vocabulary and Rules (SBVR) and standard techniques to create diagrams for object-fact modelling (SBVR diagrams), process flows (BPMN 2.0) and/or database modelling (ER diagrams). There are a lot of manuals available on these topics, but when working with USoft Studio I got some real hands-on experience, which might help you all as well. This short article aims to give you tips to work with USoft Studio as efficiently as possible, based on my personal experience.Tip 1. Do not try to define the entire galaxyWhen defining a set of rules, a pitfall is that you try to define everything. Definitions will result in a nice green term noun concept to indicate you have defined what you mean with it. This “reward” makes you want to get more and more green terms, which is a good thing, but

540
Frans.Willem.Duijnhouwer
2 years ago
J
j.buren
asked in Share your best practices

Anti Virus Best Practises

At the moment we are running Usoft 8 (and planning an upgrade) but are looking for best practises for configuring anti virus. Is there a document with exclusions that must be set at the client?

1
dara.sami
1 year ago
R
Rens Kersbergen
published in Share your best practices

USoft Binder: Windows desktop shortcut for a project binder

This topic is a guide for developers to create the best desktop shortcut for your USoft project binder. A great desktop shortcut will bring you to your project in one click while also allowing you admin rights.Please meet these requirements before continuing:Your machine has USoft installed Your machine has a USoft project binder connected to a development database (example below)Please contact your project lead if you are not sure whether you meet these requirements.You were already able to work on your project by navigating to your project binder, but it is nice to have an efficient desktop shortcut. That is what this guide is all about.After installing USoft on your machine, navigate to <Your USoft installation folder>\bin64 – right click on usbinder.exe – Create shortcut.Drag the new shortcut to your desktop. Then right click – Properties.Open a new file explorer and locate your project binder (.usb file), right click – Copy as path.In the usbinder.exe properties window, edit

200
R
2 months ago
USoft Support
USoft Support
published in Share your best practices

Creating a multi-lingual USoft (web-) applicationTutorial

This article is about making a USoft application multilingual, especially a USoft web application.For a detailed "How to”, download: "Multilingualism in USoft Web Designer applications"

200
USoft Support
1 year ago
B
bert.wilms
asked in Share your best practices

Adding a default record when a another record is inserted

Anyone here who can show me the right direction to achieve the following ? I try to explain it clearly.  Table Aircraft_types has the columns pattern_id, aircraft_id, version_nr, aircraft_class )When someone insert a new record in this table Aircraft_types, a default record need to be inserted into the same Aircraft_types table. it's important that this new record has the same value for Aircraft_id and pattern_id. the aircraft_class need to be retrieved from the column Classid from the aircraft_pattern based on the new pattern_idand it's also important that the default record doesn't need to be created when there is already a record where pattern_id and aircraft_id are identical.So for examplesomene enters the recordpattern_id = BE9M and aircraft_id = P47.The default record that has to be created ispattern_id  = BE9M aircraft_id = BE9Maircraft_class = must contain the value of this select : select aircraft_class from aircraft_patterns where pattern_id = 'BE9M' I've tried a constraint a

1
R
1 day ago

Badge winners

Show all badges
Terms & ConditionsCookie settings