datawiser / qual2db

Python code for extracting data from the Qualtrics API and posting to a MySQL database
8 stars 8 forks source link

Prompt for schema overhaul when responses contain new survey schema content #19

Open datawiser opened 7 years ago

datawiser commented 7 years ago

If a new block, question, choice, or answer is added in Qualtrics, but the survey schema in SQL is not updated, qual2db does not necessarily fail or throw an error when response data is updated, even though this results in rows of data in responses that are orphaned, missing related rows from the schema. (Today's example was a new choice in a dropdown multiple choice question.)

Ideal fix would be not just to throw an informative error, but to start an overhaul automatically or stop and prompt the user to overhaul.