Scheme data loader
Refresh SurveySparrow responses per scheme and save them to MySQL.
Analysis tables read directly from MySQL. Refresh the analysis page after loading data.
Last pull is available after a database refresh; empty surveys have no stored timestamp.
Classification is manual and uses the OpenAI API. Both free-text questions are processed; unchanged saved results are skipped. Keep this page open until complete, or stop and resume later.
| ID | Scheme | Team | Type of scheme | Local authority | Survey ID | Database responses | Last pull | Load data | Status | Classify answers | Last classified | Review results |
|---|