Documentation
Back to website >

SQL Registry

General

 
The EULANDA® SQL-Registry is used to store system adjustments, hierarchical adjustment information, user settings and system information.

In contrast to the Windows® Registry, the SQL Registry is stored centrally in the EULANDA® database of the SQL Server. Each work center can immediately evaluate the registry settings. Copying the database and thus porting, for example to a laptop, is done by copying the EULANDA® database file.

Direct changes to the SQL registry can jeopardize system stability. For this reason, you should always perform a data backup by exporting the root before making changes to the SQL registry.

The SQL registry is initially cached when changes are made. Changes are only written to the SQL server after leaving EULANDA®. If you want to write changes back to the SQL server immediately, you can use the command "Open Registry" in the file menu "Direct mode - without cache". In the SQL-Designer from the EULANDA start window you will also find a registry editor. In the "Extras" menu.

Invocation

The SQL registry can be accessed from the Quick Launch toolbar under System Administration.

system administration
If changes have to be made to the registry of users who are not logged on, or if the active user key is to be deleted, the SQL registry must be called from the start menu. here no PC may be logged on to the EULANDA®. In this case, proceed as follows. Restart EULANDA®, in the start menu select via the right mouse menu above the client the item Administration and there the SQL-Designer. In the SQL-Designer you will find the SQL-Registry in the Extras-Menu.

Description of SQL Registry settings

Detailed documentation on the SQL Registry and the hierarchical guide can be found in the chapter "The SQL Registry" in the developer's manual.

Operating

Menu File - Export Registration File


Content and structure of the registry or parts of it can be saved as a file and imported later - also in another client. To do this, first select "Marking mode" from the "Edit" menu. In the registry tree, a click box is now displayed on the left of each registry key. Select the desired registry keys and then call the export function. The file name can be chosen freely, but must have the extension".cnreg".
 

Menu File - Import Registration File

A previously exported SQL registry, or parts thereof, can be imported into an existing system. The program function for importing can be found in the File menu.

Menu File - Load Value

Binary field values can be loaded using the "Load value" function from the File menu or using the right mouse button. This function allows images to be read in as field values or small program files, such as the DATEV check program, for example.

Menu File - Save value

A binary field value can be saved to a file. The file name is completely freely selectable. Therefore, you need to know what kind of field value it was in the case of"Save value". If it was an image, the file extension".BMP" must be used.

Modification

With the right mouse button, each registry value can be changed. The standard editor corresponding to the data type is used here. However, multi-line text is easier to change using"Change with...:".

Change with

Depending on the data type, it may make sense not to use the standard editor with the right mouse button. There is a special editor for multiline texts and one for text elements separated by semicolons.

New

Using this function, a new key (folder) or a field with the data types character string, integer or binary value can be created with the right mouse button. Boolean values are entered in the registry as integer values with content 0 for false and 1 for true. The New function is also available in the Edit menu.

Copying

A field value can be copied using the right mouse button. This function is also available in the"Edit" menu.

Insertion

A previously copied field value can be pasted into another key (folder) using the right mouse button and the "Paste" function. This function is also available in the"Edit" menu.

Edit Menu - Selection Mode

Use the"Edit" menu to switch the SQL Registry to the selection mode. You can then select different folders or folder trees and export them.

Menu View - Refresh or F5

The"View" menu can be used to update the SQL Registry after changes have been made. This update only applies to the display. Registry changes are saved when you exit the program. Exceptions are certain binary data types.

Search SQL Registry

The SQL Registry Editor has a powerful search function. You can search both in the actual data and by key or value names. In addition to the standard search, regular expressions can also be used.
All entries found are clearly displayed in a list. The entries can be called up with a mouse click in the SQL Editor.
Search the registry
 

Call and operation

You will find the search window in the menu "Edit" of the registry editor.

After entering the search text and, if necessary, changing the search options, start the search using the"Search" button or the ENTER key. Depending on the search option selected, the search may take some time. During the search the results area is permanently updated to show the search progress. In addition, the button "Search" is labeled "Stop". It can now be used to end the search prematurely.

Search options

Upper/lower case - if this option is selected, only exact upper/lower case matches are found.

Regular expressions - the search pattern is a regular expression. This allows even complex character strings to be found quickly.

Whole string - the search text matches the found text from start to finish. When regular expressions are used, the search pattern is applied to the entire text, not line by line.

Ignore - the following characters are ignored when searching in "Data". This means that they are filtered out before the actual search.

Search in

Key path - allows you to search the registry hierarchy. For example, the registration key "\OBJECTS\DATAOBJECTS\REPORTS\cnsoft.order.confirmation" is found when searching for "\REPORTS\cnsoft".
 
Key name - only the single key name is searched
 
Value names - Search for value names, such as "CommandText", "Title", etc.
 
Data - The complete data is searched. These can be single strings or binary data. Searching the data considerably reduces the search speed.

Marking the results

The results can be selected individually (CTRL+T) or completely (CTRL+UMSCH+T) in the registry editor. The registry keys marked in this way can then be exported, for example.

SQL registry repair

The program item "SQL Registry Repair" can be reached via the quick start bar and there the item "System administration".

Always make a proper data backup directly from EULANDA® via the start menu before the repair.

 
Registry Repair

Restoring the root key

The SQL registry contains essential information required for the proper execution of EULANDA®. It contains various ROOT keys, of which the \ROOT\OBJECTS is the most important. Not only all information systems and report templates are stored here, but also field assignments and definitions of behaviors.
The repair resets the complete \ROOT\OBJECTS tree to the delivery state of your used EULANDA®. Only report templates and information systems from you or third party providers - so-called vendor templates - are inserted back into the old locations after repair.
To start the repair, select the "Restore" button.
If cnsoft.report templates are detected during the repair, the repair sets the settings for "Hidden" to the value you have set if possible. However, if -"cnsoft.report templates" are saved elsewhere or have different names after repair, this setting cannot be set. In this case, you would have to check in the print menus whether report templates are duplicated and if necessary reset the "cnsoft.report template" to "hidden" in the report designer.

Delete user settings

EULANDA® remembers the last positions and sizes of windows, browser compositions and other personal settings for each user in the network. When you log on to the system for the first time, each new user first receives a copy of the system's default values. The administrator can change these default values, so that one cannot speak of a factory setting here.
If personal settings are undesirable, for example due to the purchase of a new PC with a different resolution, all personal settings can be deleted. The next time you log on, the standard settings are used as a template.
Deleting the user settings is not selective, but affects the user settings of all users.

Restore default user settings

The default user settings can be changed by the administrator at any time. If you want to reset these to the factory settings, select the "Restore" button.