The total number of matched records/groups is listed in the lower left in RED
1. Duplicate Set Control
- Expand/Collapse All: Expands/Collapses the duplicate groups
- Check/Uncheck All: Checks or Unchecks all records
- Clear All: Unchecks and clears master record selections for all records
2. Current Master Rule
Click the drop-down arrow on the right and select:
- All: Applies the selected Master Rule to all records
- Checked: Applies the selected Master Rule to any checked sets
- Unchecked: Applies the selected Master Rule to unchecked sets
With "unchecked" option, users can apply a rule to all, then apply a different rule to any sets that did not have a master selected, or make manual selections for key groups then apply a rule to what's left (the unchecked)
3. Grid Setup
Show More Fields: Displays a pop-up to select additional fields to show in the grid
- New fields will be added to the right of all current data but can be dragged and dropped to a desired position
- Re-saving the scenario will update the scenario to include any fields added to the grid (updates the Fields to show on found duplicates grid in Screen 1)
Export Grid Data: 3 options for exporting grid results to a spreadsheet
- Formatted XLS: Exports to an xls file with all formatting intact (will look like the grid), data will be sorted by duplicate group
- Data File: Exports to a raw data file (no formatting or grouping)
- Users may want to sort by the CRMfusion_dupeKey so all duplicates are together
- File type options include xls, xlsx, csv, accdb, dbf, xml, tab and sql
- CRMfusion_MasterIcon column translates the pin colors/number codes to literal strings (i.e. Master, Non-Master, Not Set)
- Master / Non-Master File: Exports just 2 columns, Master ID and Non-Master ID
- ONLY exports groups with a master selected
- Does not export records where no master is selected (groups that will not be merged)
4. Grid Display
Drop Down: Show All; Show Checked; Show Unchecked
- Show All: Shows all returned potential duplicates
- Show Checked: Shows only those records that have a check in their check box
- Show Unchecked: Shows only those records that do not have a check in their check box
- Show Grid Horizontal Scroll: Allows the user to enlarge the fields on the grid and scroll left to right allowing for more screen area
