Validate incoming file rows and load valid records into a database table.
Check incoming record batches and flag entries that need correction.
Get valid records into your document collection, plus an import count and a CSV showing which entries need correction.
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.
Check incoming activity files and report rejected rows.
Get fresh website activity in your analysis table, with an import tally and a report of rows that 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.