datawiser / qual2db

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

qual2db can't handle scoring #4

Open datawiser opened 8 years ago

datawiser commented 8 years ago

Qualtrics getLegacyResponseData API call XML displays scores as child nodes. For example, take this data from CSR1068:

merit qualtrics api xml

... and so on. MERIT has 9 subscales, 4 scales, and one overall score, so there are 14 of these.

See csr_working branch qualInterface.py line 255 and following for some workaround code we're using to make qual2db work for MERIT.

SOLUTION: It would be helpful if qual2db's XML parser were smart enough to drop down into the child nodes and treat each one as a new data field, such as MERITOverallScore_WeightedMean.