1

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.

1
  • Give this a shout over on StackOverflow.com also!
    – squillman
    May 19, 2009 at 15:26

2 Answers 2

2

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.

1
  • Links are dead as of January 2018. Jan 16, 2018 at 16:22
1

I wonder if this tool would be useful to you. It is called SharePoint Survey Loader. It allows you to input possible answers separated by semicolons so I'm thinking save as custom CSV file from your spreadsheet.

http://sharepointsurveyimportloader.cyberpine.com/

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .