How accurate is the comparison routine?
The comparison routine of Synkronizer is very accurate. Since 15 years we have
been working very closely with our customers and collecting each Excel file, which
prepares serious comparison problems. We have tested all of these problem files
with Synkronizer 11 and improved and optimized the comparison routine.
Of course, there may still be Excel files which cause comparison problems. In this
case, we kindly ask you to send us the files so we can immediately repair and
optimize the comparison routine.
How do I get the best comparing results?
Synkronizer achieves the best comparing results when your Excel sheets contain a
database structure. In other words, your sheets must have unique column headings
and primary keys. The advantage of a database structure is that you can delete
or add any row/columns within your Excel sheets. You can also sort the data.
Synkronizer detects all differences immediately.
What is a primary key?
The database has one column with primary keys (unique identification number,
article number etc.). A primary key identifies the data records and facilitates
the sorting and synchronizing of your data. The primary key does not necessary
need to be a single column, it can also be formed from two or three columns
(e.g. family name, first name and city). Disadvantage of multiple column
primary keys: duplicated primary keys may occur.
What are duplicated primary keys?
Duplicated primary keys are data records that contain the same identification
number. Assuming the primary key is formed from the family and first name,
if you have several customers called "John Miller" in your database,
Synkronizer does not know which data records are to be compared. Make sure
that you always operate with unique primary keys.
Automatically compare files?
The Developer Edition of Synkronizer 11 can now be used by command line and/or
Visual Basic. In this way you can automate comparison processes (e.g. comparison
of multiple files in one pass ). Several examples are available in the user manual.
Note: The Developer Edition of 11 Synkronizer is not available before Sprint 2014.