Ignore duplicate records on lab import
Bradley Cobb
When importing data from a lab, and the Automatic Lab Import mappings or use of Client Aliases or Global Aliases results in a logical duplicate, and the duplicate is an exact duplicate (aka same Site, Location, Sample ID, Source, Value, Unit of Measure) - then the system should just skip the duplicate records instead of rejecting the lab import. This would also apply if it's an exact duplicate.
Example records of this could be:
Date,Site,Sample Point,Sample Ref,Variable,Source,Value,Comment
14/02/2025 10:00:00,MySite,Point 01,XY1JK67E-1,Benzene,PE-181690,<0.1,mg/kg,
14/02/2025 10:00:00,MySite,Point 01,XY1JK67E-1,Benzene,PE-181690,<0.1,mg/kg,
14/02/2025 10:00:00,MySite,Point 01,XY1JK67E-1,Benzene (F0),PE-181690,<0.1,mg/kg,
All of these should result in one record imported instead of generating the error "Unit of Measure - uom type must be unique per parameter".