Support DESK


S6 - Overview of the UI

Previous Article matchIT SQL Index Next Article 

matchIT SQL ships with a web user interface for making amendments to XML configuration files. During installation you are asked whether to enable the Web UI. If enabled, then you will be able to access it through the start menu – Start > Programs > matchIT SQL > matchIT SQL UI. You will need to make two changes to the Web.config file (found in ‘C:\Program Files\matchIT SQL\bin\UI’), namely the following:

<identity impersonate="false" userName="Domain\User" password="Password" />

The value for impersonate will need to be set to true and the values of userName and password will have to be changed to some valid credentials for the machine that the UI is hosted on – The UI will run under the context of this user. The reason for this is so that when an XML file is saved, the application has the permissions to write to the file (which, in the case of IIS, running under an anonymous user, it would not be able to do so). It is best to set up a user with the minimum privileges necessary to perform this action to preserve security.

In the authentication section of the Web.config file, you will notice the following node:

<user name="admin" password="" />

These are the credentials that you will need to enter when logging into the application. For security reasons there isn’t a default password, so one must be set before the Web UI can be used. This must be at least 8 characters in length and contain at least one or more of each of the following: lower case letter, upper case letter, digit, and non-alphanumeric character.

After browsing to the UI through the start menu you should see the following:

Enter the username and password to log into the UI. After doing so, you will be presented with the following screen, where you can either choose to edit and existing configuration file or create a new one:



Note that the folder tree on the left shows the list of XML files that are in the ‘Config’ directory of the matchIT SQL installation – The UI is set to point to this in the Web.config file in the appSettings section, as well as specifying what file to use as a base file for creating new configuration files and reverting to default settings (Template.xml by default, which is omitted from the edit list on the left – this file is read-only). You will also notice a ‘Log out’ link at the top right of the screen that you can use to get back to the ‘Log In’ screen. Once you select to edit or create a file, the screen will look as follows.


You are now in a position to edit / create the file you have selected. The navigation of the form follows the logical structure of the XML and should be easy to use. On the left hand side you will see three buttons - ‘Save’, ‘Save and Exit’ and ‘Restart’ – which allow you to save changes and return to the config file selection page. At the top of most sections you will see the ‘Revert To Start’ and ‘Default Settings’ buttons which revert the changes you have made to the section you are on back to the settings you started with or to the default settings respectively. Note that the Data Sources section doesn’t have a ‘Default Settings’ button for each data source, as there are no real ‘Default Settings’ for a data source.

If you are unsure of any section you are looking at, you can use the ‘help’ prompts in each section to point you in the right direction. These are the small blue circles containing a white question mark located on the right. Clicking on them will expand information on the section they are related to.


Previous Article matchIT SQL Index Next Article


Was this article helpful?
0 out of 0 found this helpful


Please sign in to leave a comment.