Microsoft SharePoint is a service that helps organizations share content to quickly find information and seamlessly collaborate.
Track confirmed imports and rows awaiting correction.
Your reporting table gets valid new spreadsheet rows every 15 minutes, with import counts and row-specific fixes waiting in the sheet.
Keep incoming text exports usable and make rejected rows visible.
Your analysts get CSVs from new text exports in a shared folder. A companion report points to source lines that need fixing.
Keep monthly data deliveries checked and easy to find.
Get a dated CSV and row count in your shared folder every month, or an error note explaining why the export stopped.
Record the row count or error for each incoming file.
Keep your PostgreSQL table current as CSV files arrive, with a row count or a clear reason when an import needs attention.
Reconcile each import and surface rejected activity rows.
Get fresh website activity in your analysis table, with an import tally and a report of rows that need fixing.