FuzzyDupes was designed to work with arbitrary data sources. Unfortunately each has it’s own options. For the MS-SQL Server you could also try the last option when selecting a data source: “Other (OLEdb / ODBC)”. This dialog allows you to connect with many different data sources. Please try the “Microsoft SQL Server” with the “.NET […]
License Agreement § 1 Object The object of these Licensing Conditions is the computer program FuzzyDupes, it’s online user documentation and other written materials associated with it, which are together referred to below as the software. § 2 Guarantees (1) This software is provided to the licensee “as is”. (2) Kroll Software-Development makes no guarantees […]
Cluster Creation A fuzzy comparison of all records in a database with all others is impossible because the number of the individual comparisons would quickly reach an astronomical figure. Any software for duplicate searches must perform a pre-selection, in which data sets are grouped in blocks which are appropriate for performing fuzzy comparison. FuzzyDupes uses […]
Select in main menu "Extras->Edit Normalization Rules". This launches the Normalization Rules Editor. Edit Normalization Rules For each named format you can add a description, 3 different parent formats and an unlimited number of search/replacements. The Description is only for documentation purposes and has no effect. Inherits from: The current format will inherit all […]
Besides searching for duplicates, FuzzyDupes can also perform a comparison with an external list (Robinson list). In this way you can remove addresses in the external list from your database. Select the menu item "Duplicates->Match with External List". Establish a connection to your database Select a table or view/query Assign the fields of the […]
Besides searching for duplicates, FuzzyDupes enables the fuzzy import of data. This makes it possible to merge two databases without creating duplicates. Select main menu "Duplicates->Fuzzy Merge Database" Establish a connection to your database Select a table or view/query Assign the fields of the source to those of the target table (At least all […]
To export the search result, select the Menu "View->Export". After specifying a filename, the export options dialog box appears: FuzzyDupes saves the table in a delimited text file (CSV). These files can be read by most database programs and MS-Excel. Select the “*.csv” file extension, if you want to create a CSV file, for example, […]
After a successful duplicate search, the program switches to duplicate view and shows the duplicates in groups. Later you can return to this view at the menu item "View->Dubletten". Here you will be able to Manually review the duplicates to check the results during the review cancel the allocation of individual records, if they […]
Show / Hide Columns Select main menu "View->Show Columns…" or click on the corresponding icon, in order to show or hide desired columns in the database table. Export Select main menu "View->Export…" to save the current view to a Text/CSV-File.
Options Show Results Duplicates (default): The duplicate search only returns duplicate rows. All records with duplicates tag: The duplicate search returns all rows. A new column FuzzyDupesID contains GUID’s that are distinct for different rows and identical for similar rows. Thresholds Here you can again set the thresholds. The settings come from the project settings. […]