Database Update Automation Script

Заказчик: AI | Опубликовано: 04.10.2025
Бюджет: 25 $

I’m looking to replace a repetitive, manual workflow that currently has me copying information from spreadsheets and web forms into our SQL-based database. The end goal is simple: one click and the records are updated accurately every time, without me hovering over rows and columns. Here’s what I need the solution to handle: • Read incoming data files (typically CSV or Excel). • Validate each row against a few basic business rules I will provide (e.g., required fields can’t be blank, date format must be YYYY-MM-DD). • Push the clean data into our existing SQL tables, creating new entries or updating matches on a unique ID. • Log any errors or skipped rows so I can review them later. I’m flexible on the technology stack, though Python with pandas + SQLAlchemy is what I had in mind. If you prefer a different language or low-code tool that achieves the same reliability and speed, let me know. Deliverable: a tested script or small application, plus clear setup instructions so I can run it on my Windows machine whenever new data arrives.