Record merging is the process whereby Autoline reads files identified as containing duplicate data and either deleting the records concerned or marking them for subsequent deletion.
A progress bar (at the bottom of the form) indicates how much of the process has been completed as a proportion of the total. Also, as each file is completed, a tick is displayed in the All merged? column of its grid line.
If Autoline encounters a problem during the merge, the affected file's line in the grid is displayed in red and the following is displayed in the form's message area (at upper left):
There were errors, merge incomplete. Press OK to close
In that case, clicking the OK button enables you to store the selection and retry the process later.
The Database Cleansing: Step 4 of 4 - Record Merge form is displayed when you click either the Set to X status or the Delete button on the Confirm merge start form. It enables you to observe progress of the merge including any faults encountered.
Only show files that need updating: A tick indicates that only those files that need merging are displayed as lines in the main grid
COLOUR GRID:
Indicates the meaning of colored text in the main grid lines.
Blue: File successfully merged
Black: The file was identified as needing merging, but was deselected from the merge list
Grey: File does not need merging
Red: A fault occurred when merging the file
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 Left: Number of records in the file remaining to be merged
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 due to be merged have been successfully merged. (Ticks are displayed as the merge progresses, file by file.)
Notes: Blank if the file needs merging, otherwise the reason why it does not need merging
PUSH BUTTONS:
Cancel: Greyed-out at this stage
View log: Displays a log of the de-duplication run, including details of the record retained on the system and how many records were merged and from which files
OK: In the event of faults occurring during the merge (indicated by red text in the affected file's grid line), clicking OK displays a confirmation box containing the message Do you want to save selection for later? and a Save button, enabling you to store the merge selection for subsequent retrieval and processing.
De-duplication outline process
