Friday, November 4, 2011

Question sequence gets disordered when export a survey with Rating Scale questions to Excel sheet.

Question sequence is disordered when we export a survey list to excel
Resolution – Only to get questions in proper sequence in Excel sheet!!
  • Checked Survey settings
  • Found there were total 50 questions and found almost 30 questions were created using "Rating Scale" category
  • Changed question ordering from Survey settings > Change order of questions
  • Previously it was from Q-1 > Q-1-a….Q-5 > Q-5-e
  • Changed it to reverse order and arranged Q-5-e > Q-5…..Q-1-a > Q-1
  • Exported to spreadsheet, and got all the questions in right order.
  • Now another issue occurred, Q-6 (Multiple Line of Text) came first in datasheet, so from view removed it to be displayed or to be exported to spreadsheet.
  • The other issue noticed was when user clicks on "Respond to this survey", user will get the same reverse orders of questions (i.e. Q-5, 4, 3, 2, 1, 6)
  • Though this helps us to get questions in proper sequence only in Spreadsheet but this cannot be implemented as this occurs disordering of questions in survey.
Found 2 alternate workarounds
Workaround 1
  • Changed all "Rating Scale" questions to "Choice" category with "Radio button" & fill in "mandatory" option
  • Order remained same (i.e. Q- 1, 2, 3, 4, 5, 6)
  • Now it worked proper for both scenarios, user got the right order when open "Respond to this survey" and also got the right order when exported to excel.
Workaround 2
  • Created a page and added a Data View Web part using SPD on the page
  • Used SharePoint survey as a Data source and added all questions / columns in to the web part
  • Then from Data view web part exported data to excel
Feel free to reach me in case of any queries on above steps. Thanks

No comments:

Popular Posts


The opinions expressed on this blog are the personal views of Pratik's SharePoint Blog, and do not represent or reflect the viewpoints or policies of any past, present, or future employer, colleague, or customer, or any other entity. The posts on this blog are provided ‘as is’ with no warranties, express or implied, and confer no rights. Use of information contained within this blog, including specific technical steps mentioned herein, is at your own risk. References to specific software products, processes, resources, or companies do not imply any endorsement.