mattroumaya / surveymonkey

Access your SurveyMonkey data directly from R!
https://mattroumaya.github.io/surveymonkey/
Other
42 stars 10 forks source link

Multiple choice columns misordered if rearranged after creation #24

Closed sfirke closed 5 years ago

sfirke commented 5 years ago

I see an "N/A - I did not attend" .. type answer choice appearing last in SurveyMonkey xlsx export, the order in which it was offered, but not in the current R API version. I'm guessing that's because the package is ordering based on choice #, which is in the order the options were created, and doesn't allow for them being re-arranged.

Solution will involve looking at choice position order when ordering columns. Not a critical bug, and fixable.

sfirke commented 5 years ago

Not just multiple choices, but whole questions, see the last question of survey 172776097 - it should be column ~103 but instead it's column ~29 based on order of creation. Need to reorder the qid_text_crosswalk by the order that questions and choices appear on the survey.