Validate incoming file rows and load valid records into a database table.
Add valid master records from Excel and flag row errors.
Get valid Excel rows into PostgreSQL and a chat report showing how many went in and what needs fixing.
Keep approved records in the target table and flag invalid source rows.
Get approved records into your target table and a dated report showing which rows transferred or need fixing.