Validate incoming file rows and load valid records into a database table.
Find approved rows with missing fields in each transfer report.
Get approved records into your target table and a dated report showing which rows transferred or need fixing.
Keep duplicate identifiers out of the tracking table.
Keep your tracking table focused on valid form responses, with an email explaining what was added or what needs fixing.