How to Reconcile Duplicate Defect Records
Two similar photos do not necessarily describe the same defect. Before removing a suspected duplicate, compare the exact location, observation and action required, then preserve enough context for recipients of earlier reports to follow the correction.
By Blu Mint Digital. 3 minute read. Last reviewed .
Compare the actual observations
Start with the building, room and component. Check whether the records describe the same position from different angles or different items in a repeated layout. A scratched door and a door that binds may be separate observations even when they concern the same opening.
Read the descriptions and captions rather than relying on titles alone. “Kitchen door” can mean a cabinet, entry door or appliance panel. Resolve that ambiguity with the original observer where possible before changing the record.
Use a reconciliation checklist
- Do the location and component references match?
- Do the photos show the same condition and visit context?
- Is the required action the same or independently repairable?
- Have different contractors already received different references?
- Does one record contain evidence or a response missing from the other?
Keep the records separate while a material uncertainty remains. Mark the question in a note and nominate who will resolve it. Premature deletion can remove the only photo or contractor response that explains the issue.
Preserve continuity when correcting a duplicate
Once confirmed, decide which reference will remain current. Save the earlier issued report and retain any unique evidence before removing or reorganising working information. Explain the correction to recipients who may still be using the retired reference.
For example: “Item J042-018 duplicates J042-011 at the same cupboard. Future updates use J042-011; no repair completion is implied by this correction.” This is an illustrative manual convention. Site Audit does not provide an automatic duplicate-merge or reference-redirection feature.
Reconcile counts after the correction
If the list total drops because a duplicate is removed, report it as a data correction. Do not include it in a count of repaired defects. That distinction matters when a weekly summary is used to understand the amount of work remaining.
Pro CSV export can make it easier to sort a register by title or location for review, but the spreadsheet cannot decide whether two images represent one observation. Return to the working records for that check. Improve future capture with the location naming system, and use the version-control workflow to keep issued references understandable after changes.