Is there a way to import information into a survey from an external datasource? I have a user who has a spreadsheet full of measures (Over 300 of them) who would like to create a few surveys in SharePoint so that he could ask our users to rate some software based on these measures.
Manual data entry of all 300+ measures directly into a survey would take a LOT of time. Is there an easy way to get these measures into a survey?
Thanks to Adam for his answer below. As an admin, some pointers as to how to use these objects from Power Shell or Iron Python would help as well.
Best Answer
Never done it myself, but perhaps you could combine this code which programmatically creates the basics of a survey with this code which adds the questions. It shouldn't be too hard to do some sort of mail merge to convert your user's spreadsheet into code which will create the questions.