Synchronization of dictionary

Synchronization of dictionary

Synchronization of dictionary - D2000 CfgSynchronizeDictionary

Function SynchronizeDictionary is a component of program D2000 CfgSynchro. It is used to copy (synchronize) the contents of dictionary among two databases (or D2000 System applications).

By means of user interface the changed dictionaries can be identified and subsequently, if needed, copied from one configuration database to the other (database synchronization). This tool is suitable for synchronization of databases that were created as a copy of the original configuration database and changes in them have been performed separately.

Comparing dictionaries


In order to synchronize configuration databases every dictionary entry must be paired with its image (counterpart) in the other database. The image must have an identical composite key that identifies it.
A composite key consists of TEXTKEY (a unique key of an entry) and LNG_IDX (language identifier). This pair of information characterizes an entry in a dictionary unequivocally and it is unique.

The above mentioned implies that if there are items with the same key and language identifier in two different configuration databases, they will be considered identical and the synchronization may take place thanks to having identical composite keys. If either of the two parts of a key differ from the keys defined for the other entry the items cannot be considered identical and synchronization cannot be accomplished. A situation may occur that the same language is included in both databases, however, with different identifier. So as to be able to synchronize such databases correctly, the languages have to be paired. If a language cannot be found in the other database it can be easily added to that database.

Coupled entries
Coupled entries

In the picture there are coupled entries from two databases according to the composite key. The individual items consist of:


ID

Makes the orientation and lucidity to be easier.

Key

Key that is common for both databases (left, right).

Language

Displays language of the entry.

Left database

Item from left database.

Right database

Item from right database.


States of objects


Status of objects
Status of objects

1

The entries match in both databases (no synchronization possible).

2

The items are different and can be synchronized.

3

The items are different and they will be updated / inserted according to the orientation of the arrow.

4

One database does not contain the item, which will be therefore removed from the other database as well.


A text displayed in blue is a more current item.
An item in red designates an item with undefined text.
If there is a text (NULL) of black colour, it means that this key was associated with a value as (NULL).
An empty item indicates that no entry for the particular key can be found in the database.

Icons indicating the direction of transfer


Transfer from the left database to the right.

Transfer from the right database to the left.

No change.


Main window


Synchronisation of dictionaries
Synchronisation of dictionaries

1

Panel allowing to open databases.

2

Filtering by state.

3

Filtering by language.

4

Filtering by mask.

5

Tools for database synchronization.

6

Pairing of languages.

7

Commit database changes.

8

Displays data.

9

Closes the window.