Wednesday, 17 April 2013

Survey questions are not exported in the right order when you select “export to spreadsheet” to Excel on Sharepoint 2010.

Surveys in Sharepoint 2010 are quite limited, but I have to admit this limitation brings simplicity to the users. Some users become quite confuse when it comes to InfoPath, so why not giving them the option of developing surveys?.

If one of them it is causing trouble and needs extra functionality, we can always add it, at the end of the day a Survey is a custom list.

There is bug in Sharepoint 2010 where the survey questions are not exported in the right order when you select “export to spreadsheet”. Why is this happening?, because a file called Overview.aspx as well as AllItems.aspx and summary.aspx have been build gradually in LILO (Last In Last Out) order. To fix this issue we only need to edit these files, and I will advise to modify only Overview.aspx. This file has the option to “export to spreadsheet”.

Step 1
Click on your survey, and you will end in a screen like this:
image

 

Step 2
Copy the URL without “/overview.aspx” and open Sharepoint Designer, go to “Open Site” and click to open.
image

 

Step 3
Go to “Lists and Libraries” and select “mysurvey” (this is my survey, select yours). Select “Overview” on the right side and double click.
image

The page will be opened, select “Code” (bottom), to see the code of the page.
image

 

Step 4
Go to the section it says <ViewFields> and choose the order you want. The order of these fields will be the order of the output of your spreadsheet. You can add extra fields if you want.

<XmlDefinition>
	<View Name="{E82854CC-2572-4FD2-A2B1-4BD74EE111D6}" DefaultView="TRUE" Type="HTML" TabularView="FALSE" ReadOnly="TRUE" FreeForm="TRUE" DisplayName="Overview" Url="/extranetpresentation/Lists/mysurvey/overview.aspx" Level="1" BaseViewID="3" ContentTypeID="0x" ImageUrl="/_layouts/images/survey.png" CssStyleSheet="survey.css">
		<ViewFields>
			<FieldRef Name="Author"/>
			<FieldRef Name="my_x0020_0_x0020_question"/>
			<FieldRef Name="_x0031__x0020_My_x0020_first_x00"/>
			<FieldRef Name="my_x0020_second_x0020_qestion"/>
			<FieldRef Name="my_x0020_third_x0020_question"/>
			<FieldRef Name="Type_x0020_your_x0020_question_x"/>
		</ViewFields>
		<Toolbar Type="Standard"/>
	</View>
</XmlDefinition>


 


Conclusion: All Responses, Graphical Summary and Overview are the files which control the out of the box survey. We just need to access to these files to customise our “out of the box” surveys.

6 comments:

ninest123 said...

replica watches, louis vuitton, air jordan pas cher, longchamp pas cher, ray ban sunglasses, nike air max, oakley sunglasses, ugg boots, oakley sunglasses, nike free, nike roshe run, louboutin shoes, michael kors, louboutin, longchamp outlet, louis vuitton outlet, polo ralph lauren outlet, longchamp outlet, tiffany jewelry, tiffany and co, jordan shoes, tory burch outlet, ugg boots, air max, louis vuitton, replica watches, nike free, louis vuitton, uggs on sale, sac longchamp, burberry, chanel handbags, oakley sunglasses, polo ralph lauren outlet, louboutin outlet, longchamp, louis vuitton outlet, prada outlet, cheap oakley sunglasses, oakley sunglasses, christian louboutin outlet, louboutin pas cher, ralph lauren pas cher, ray ban sunglasses, kate spade outlet, ray ban sunglasses, nike air max, prada handbags, gucci outlet, nike outlet

ninest123 said...

burberry outlet online, nike air max, coach purses, nike air max, michael kors, timberland, new balance pas cher, true religion jeans, kate spade handbags, nike free run uk, north face, true religion jeans, ralph lauren uk, air force, hollister pas cher, ray ban uk, converse pas cher, lacoste pas cher, michael kors outlet, michael kors outlet, ugg boots, michael kors outlet, michael kors outlet, coach outlet, vans pas cher, hollister, burberry, coach outlet, nike blazer, oakley pas cher, vanessa bruno, mulberry, ugg boots, lululemon, hermes, tn pas cher, ray ban pas cher, sac guess, hogan, true religion jeans, abercrombie and fitch, true religion outlet, michael kors, nike air max, michael kors outlet, replica handbags, michael kors, nike roshe, north face, michael kors

ninest123 said...

BVlongchamp, iphone 5s cases, hollister, ferragamo shoes, herve leger, jimmy choo shoes, giuseppe zanotti, north face outlet, vans shoes, mont blanc, nike huarache, celine handbags, iphone cases, iphone 6s cases, nike trainers, lululemon, louboutin, ralph lauren, iphone 6 cases, babyliss, s5 cases, hollister, north face outlet, nfl jerseys, bottega veneta, soccer shoes, oakley, baseball bats, abercrombie and fitch, ghd, chi flat iron, valentino shoes, beats by dre, asics running shoes, wedding dresses, reebok shoes, timberland boots, ipad cases, mac cosmetics, mcm handbags, nike roshe, nike air max, insanity workout, iphone 6s plus cases, birkin bag, p90x workout, hollister, instyler, iphone 6 plus cases, soccer jerseys, new balance

ninest123 said...

barbour jackets, toms shoes, lancel, supra shoes, juicy couture outlet, moncler, moncler, louis vuitton, thomas sabo, hollister, canada goose uk, canada goose, louis vuitton, doudoune canada goose, converse outlet, canada goose outlet, replica watches, bottes ugg, canada goose outlet, nike air max, gucci, moncler, pandora jewelry, canada goose, karen millen, marc jacobs, converse, moncler, ray ban, wedding dresses, montre pas cher, ugg,ugg australia,ugg italia, moncler, pandora charms, canada goose, moncler, canada goose, ugg,uggs,uggs canada, moncler, vans, swarovski crystal, sac louis vuitton pas cher, pandora jewelry, juicy couture outlet, louis vuitton, louis vuitton, moncler outlet, coach outlet, swarovski, ugg boots uk, links of london, ugg pas cher, pandora charms

Anonymous said...

Thank you very much for this post. Very helpful in SharePoint 2013 as well!

chenmeinv0 said...

the north face
tory burch sale
cheap ugg boots
moncler outlet
michael kors outlet online
steelers jerseys
cheap oakley sunglasses
coach factory outlet
canada goose online
gucci bags
2016.12.17xukaimin