I'm writing an R package to facilitate data dictionary generation and cleaning for exported Qualtrics response data. I would require a way to regenerate QID column names from the metadata json. I'm wondering if I could find a spec on how Qualtrics platform does this?
Regenerating QID column names of exported response data from metadata
+1
Userlevel 5
+13
@lyh970817 Are you looking at the survey export file (.qsf)? This is the data dictionary for your surveys. Simply rename the file to .json (since it is a JSON file).
+1
https://www.qualtrics.com/community/discussion/comment/27544#Comment_27544Sorry I was not being clear in the question - I'm referring to exported response data with column names like these:
"QID124934938" "QID124931340"
"QID124931341_0" "QID124931341_1"
"QID124931341_2" "QID124931341_3"
I believe the QIDs extracted from elsewhere do not have these "_[0-9]+" appended. So I'm wondering how to match the metadata to these response data columns.
Userlevel 5
+13
@lyh970817 Check the .qsf file. All of the default IDs and any recoded IDs should be in the .qsf file. Again this file is the best source for defining the survey.
+1
https://www.qualtrics.com/community/discussion/comment/27550#Comment_27550Thanks! I think in the qsf file there are QIDs like "QID124931341" and its recode levels, subquestions etc. but it's not very straightforward to combine them into exactly what exports as the QIDs appearing in the response data file. It depends on the question type and selector etc.
Leave a Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.