The record locking stage includes a facility to view:
Files that need merging because matching data has been found (including the number of affected records in each file)
Optionally, all files searched for matching data (including, for those files that do not need merging, the reason why).
It provides facilities for manually deselecting a file from the merge list, storing the merge selection for subsequent retrieval and processing, and viewing a log of the last de-duplication run.
Tip: To postpone running the merge process, you can click the Cancel button at any time prior to clicking the Merge button. A confirmation box is displayed, enabling you to store the merge selection for subsequent retrieval and processing.
The Database Cleansing: Step 3 of 4 - Record Locking form is displayed when you click the Next button on the Database Cleansing: Step 2 of 4 - Customer record confirmation form. Its grid lists files containing matching data and the company, module, and number of records affected by the lock. When the form is first displayed, when you click the previous form's Next button, the All locked? column is ticked line-by-line as each file is processed in turn.
Only show files that need updating: A tick indicates that only those files that need merging are displayed as lines in the main grid.
Tip: Untick the Only show files that need updating box to refresh the grid with all files interrogated during the process, including those that do not need merging together with the reason why (in the Notes column).
COLOUR GRID:
Indicates the meaning of colored text in the main grid lines.
Blue: File needs merging
Black: The file was identified as needing merging, but you deselected it from the merge list
Grey: File does not need merging
Red: A fault occurred with the file's locking
Tip: To manually deselect a file listed for merging (blue line) from being merged, double-click its line in the grid. Its text turns black.
Ref.: Sequential number for display clarity only
Company: Autoline company code
Module: Autoline software module to which the file belongs
File: Filename/identifier
Open?: A tick indicates that the file is open
Updates Req'd: Number of records affected by the file lock
All Locked?: A tick indicates that the file's records due to be merged are locked to prevent them being updated by another process or user
All Merged?: A tick indicates that the file's records have been successfully merged (unticked at this stage)
Notes: Blank if the file needs merging, otherwise it states the reason why it does not need merging
PUSH BUTTONS:
Cancel: Displays a confirmation box containing the message Do you want to save selection for later? and a Yes button, returning you to the enabling you to the Database Cleansing... form 1 with your selection listed in its grid
View log: Displays a log of the last de-duplication run, including details of the record retained on the system and how many records were merged and from which files
Merge: Displays the Confirm merge start form, ready for the final stage of the de-duplication process
De-duplication outline process
