Reputation: 1
I am tasked with creating a very similar output to the excel output that is generated from the SurveyMonkey application. Most of the answer-to-answer mapping is pretty straight forward, but mapping matrix type questions seems overly complicated. Has anyone come up with a reliable way to map this data in order to export it to a list-based response? The best thing I have come up with is building an in-memory tree mapping the collectors to respondents to questions to answers to (selected) answers.
To me, this seems like a lot of unnecessary mapping, and I'm just wondering if anyone has come up with a better way.
Upvotes: 0
Views: 435
Reputation: 459
See the related question: What are the expected values for the various "ENUM" types returned by the SurveyMonkey API?
I give a lot of skeleton VBA code at Accessing SurveyMonkey API from VBA
Good luck Patrick
Upvotes: 1