Showing posts with label Survey all responses not showing in export to spreadsheet. Show all posts
Showing posts with label Survey all responses not showing in export to spreadsheet. Show all posts

08 March, 2011

Export To Spreadsheet not showing response columns from Survey:MOSS 2007

Survey list has so many limitations and this list is very unique from all lists which are present in sharepoint.

I have handled so many issues regarding survey from last few weeks. From all of them, i have noticed one which is very unqiue and need some tweaks to get your issue resolved.

When we used "export to spreadsheet" option for survey then we dont get all the columns data  and shows only time stamp and items field.

End user opened a ticket for this and it took some time to resolve this issue as it was new for me also.

Please refer the following steps regarding the same:
1. Open the survey list

2. Edit Page

3. Modify shared webpart

4. Edit the current view

5. Select the appropriate view in which you wants to make the changes

6. Copy the View GUID ID from the URL and paste in a note pad https://sharepoint2007/sites/AHRC/Comp%20Survey%20Report/_layouts/viewedit.aspx?List=%7B415A8DFB%2D0FFF%2D4412%2D925D%2DC4191DDF4127%7D&View=%7B02550769%2DEBF3%2D45F8%2D987C%2DE19F51CC06DB%7D&Source=https%3A%2F%2Ftestl%2Ewsstools%2Econsumer%2Esharepointgroup%2Enet%2Fsites%2FAHRC%2FComp%2520Survey%2520Report%2Fdefault%2Easpx%3FPageView%3DShared

7. Edit the GUID to eliminate few characters , notice the change carefully: %7B02550769%2DEBF3%2D45F8%2D987C%2DE19F51CC06DB%7D&  becomes “02550769- EBF3- 45F8-987C-E19F51CC06DB”

8. Select the number of columns as per your requirements and click OK

9. Click on Actions-Export to spreadsheet. Now as you mentioned in the screenshot below there is a view ID in connection properties-Replace the View GUID with the one copied above and click OK.

10. It will give you the correct spreadsheet.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you