What's Included and New - Version 1.0.1.0

Scrubs - Data Cleansing

Sieve - Merge Purge

Pre Post Office

 

More 'Mac' type names have been added.

More than 800 new last names of the 'Mac' type have been added to the surname table. This table is utilized by the Full Name Parser and Casing, upper lowering, tasks.

More Surnames 

Upper lower casing now does French accenting.

The Casing task provides a new option that will allow you to apply or remove French accents while upper lower casing your data.

Select your table in the Task List

SQL Server Table

The Properties pane will display the available settings.

Accenting Option

You can also accent data based on a language field. Bring up the Task Item Selector Dialog and add a Language item. Then map your table's language field to this item in the Assigned Items list.

French Language Item

When the casing task is run accenting will only be applied to records that have an 'F' or 'French' in the language field.

Address Parsing task incorrectly identified parsed output fields.

Parsed output from the Address Parsing task was not being moved to the correct address line when multiple output address fields were defined.

This has now been fixed.

Error in merge purge formatting stage with SQL Server tables.

During the Formatting stage of merge purges the SQL SELECT statement was malformed and produced an error when opening a table.

Corrected with the proper SQL statement.

Use Surname property ignored in householding merge match.

Editing the Use Surname setting was not being saved before a task was run, thus being ignored during processing.

Code modifications made and corrected.

Use Initials setting in Individual merge purges not updated during project changes.

Editing the Use Initials setting was not being saved before a task was run, thus being ignored during processing.

Code modifications made and corrected.

F5 and F10 added as shortcut keys for Run and Verify.

Pressing the F5 key is now equivalent to clicking on the Running Man icon to start processing.

Pressing the F10 key will verify your project settings which is the same as clicking on the Verify button in the toolbar.