Open Menu

Synergex Blog


A Winning Formula.

By Richard Morris, Posted on February 15, 2018 at 3:28 am

For a recent project I’ve worked with a customer who wished to provide their users with an engaging desktop application that would allow management of product formulations.  They had a Synergy UI Toolkit version and also elements of the required application in a third-party system, but neither met the needs of the users.  After a review and discussions about their requirements we agreed on a Synergy .NET Windows Presentation Foundation based application using Infragistics tooling for the User Experience.

The basic requirements of the application where to allow the creation and maintenance of formulations.  A formulation contains the components required to make a finished product.  For this customer the final product is an aerosol. 

The basic interface is built using the Infragistics control to handle navigation (Ribbon menu control), listing and selection of data (powerful DataGrid), hierarchical representation of the formulation components (TreeView) and management of finished product details (Property Grid);

Of course, using the Infragistics DockManager allows the user to drag and reposition all the available windows to their liking.

There are powerful searching facilities, or QBE (Query By Example) controls.  These allow the user to provide snippets of information and the application will query the Synergy DBMS database using Symphony Harmony and the Synergex.SynergyDE.Select class;

The top line of the QBE controls allow the user to enter the data in the columns they wish to search for and so only select the data they require and not have to filter through a list of thousands of formulations.

Because the application is written in Synergy, the existing printing capabilities from the original UI Toolkit application have been retained without change;

The whole application is written in Synergy .NET and utilises the Symphony Framework for controlling the data access and presentation.  If you would like more details, or would like to know how you can build modern applications with Synergy .NET please drop me an email.


What a Cracking Idea.

By Richard Morris, Posted on February 9, 2018 at 5:52 am

The Synergex Resource Center Community site has a number of great features including the Answers and Ideas portals.  Ideas is the place to post your ideas for improving Synergy and related products.  You can vote for ideas and provide comment and feedback to help the whole community be more successful. There was a recent idea posted on the Synergex community site

You can read the full idea at the Synergex Resource Center.

The Synergy DBMS Manager allows you to query and manage data in your Synergy data files using Symphony Data Objects.

Code generating Symphony Data Objects for your files is a simple process.  Ensure you have your Synergy Repository configured. You need to define the structure and associated file definition for each file you wish to be able to manage using the utility.  There are full instructions at the Symphony Framework page which walk you through the few simple steps to building your data object assembly in Synergy .Net.  Not sure how to build Synergy .Net assemblies – then send me your repository and I’ll do it for you!

To query data you simply issue the required select command and define the response data object;

Simple, and you can scroll through the results.  The idea posted was to be able to then export the selected data to Microsoft Excel so that further review and analysis can be performed.

A new toolbar button has been added and the GemBox Spread assembly used to easily create the Excel document.  Now you can export all the selected rows to an Excel document:

If you’d like more details, please visit the Symphony Framework page or contact me directly.

 

 

 


Protecting Data

By Richard Morris, Posted on February 7, 2018 at 5:06 am

Whenever I work with customers code there is almost always a need to “run” their applications.  That means I need data.  To ensure that Synergex protects our customers data and that we conform to the various data security requirements of todays world there is usually a need to cleanse the data before I get access to it.  This cleansing process is like redacting words or phrases in a document – to prevent the consumer (in this case me) from seeing the real data.

With Synergy today there are basically two ways to do this;  write a program to clear or set the data fields within the records in the file to a specific value or configure Synergy xfODBC and use a database management tool.  If you don’t want to write code, or license and configure xfODBC you can use the Synergy DBMS Manager.

The Synergy DBMS Manager is a simple utility that can be used to redact data in your Synergy DBMS files.  Your can download and install the Synergy DBMS Manager utility by visiting the downloads page.  The utility uses Symphony Data Objects to describe the data in your files – these are easy to code generate.

Code generating Symphony Data Objects for your files is a simple process.  Ensure you have your Synergy Repository configured. You need to define the structure and associated file definition for each file you wish to be able to manage using the utility.  There are full instructions which walk you through the few simple steps to building your data object assembly in Synergy .Net.  Not sure how to build Synergy .Net assemblies – then send me your repository and I’ll do it for you!

Once you have the data object library built, you simple run the utility:

You’ll need to locate the “Data object assembly” that you have just built, and following that select the “Table mapping method”.  Enter the password and you’ll be in the utility and ready to manage your Synergy DBMS data.

You can perform simple queries to locate and review the data in a file;

Now you can easily redact the data in the file – remember you are affecting the ACTUAL data in the file, so make sure this is a copy of the data file and NOT your LIVE data, there is no rollback functionality!

Simply issue an update command;

Notice the result count () at the bottom of the screen.  Because we didn’t specify a where clause then all records in the file were affected by the requested update.  Now you can perform a simple query and see the results;

This data is now cleaned.  If you need to send data to Synergex Support to assist then to resolve an issue you have, this is a great way to redact and protect that data before sending it.

If you’d like more details, please visit the Symphony Framework page or contact me directly.


Don't miss a post!

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Recent Posts Tag Cloud Archives