Strip "x" out of choice_id prior to insert into SQL for "carry-through" questions

datawiser / qual2db

Python code for extracting data from the Qualtrics API and posting to a MySQL database

8 stars 8 forks source link

Strip "x" out of choice_id prior to insert into SQL for "carry-through" questions #20

Open datawiser opened 7 years ago

datawiser commented 7 years ago

Qualtrics export tag for "carry through" matrix questions (where choice text is based on a prior option) looks like "Q1_x1" instead of the standard "Q1_1". Current qual2db 2.x inserts "x1" successfully into MySQL "choice_recode" field (type varchar(50)), but fails on insert to choice_qid (type int(11)).