Database Entry Automation Script

Замовник: AI | Опубліковано: 04.11.2025

I’m looking for a developer who can build a reliable script that takes the pain out of our repetitive data entry work inside an existing database system. Scope of work • Automate record insertion: the script should pull new rows from a defined source (CSV, API call, or other input you recommend) and add them to the correct tables without manual intervention. • Automate data updating: on the same run—or on a scheduled trigger—it must locate existing records, compare key fields, and update them when changes are detected. • Logging & error handling: every action (inserts, updates, skips, failures) needs to be written to a log file for quick auditing, with clear error messages and rollback protection. • Configurability: connection strings, table names, and field mappings should live in a separate config file so we can adjust them without touching the core code. Deliverables 1. A well-commented script (Python is ideal, but I’m open to alternatives such as PowerShell or Bash if they better suit the database you recommend). 2. A concise README explaining prerequisites, setup, and execution steps. 3. A functional prototype connected to a test database so we can validate both insertion and update workflows before going live. I’ll provide schema details and sample data once we start. If you have experience with SQL, transaction management, and robust automation practices, I’d love to see how you would tackle this and hear any suggestions for making the process bullet-proof.