none
view incomplete surveys

    Question

  • HI,

    This is ש Known Issue in sharepoint 2007 and 2010.

    When a user save the survey but not completing it the list item checked out on the user and there is no way 

    to see the incompleted survey results but querying the content db directly.

    I'm having the same issue in sharepoint 2013, is there no change in this behaivor in sharepoint 2013 ?

    thanks.

    Sunday, July 06, 2014 3:18 PM

All replies

  • According to your post, my understanding is that you wanted to view incomplete surveys.

    If you have implemented branching logic then you have "Save and Close" button to save incomplete survey in "show all responses view".

    To add this logic, edit the question which you have created and select the questions under Jump to option against each answer in the first question.

    Then when you click the "Save and Close" button, the imcompleted survey will be saved to the All Responses survey view.

    Here is a similar thread for your reference:

    http://social.technet.microsoft.com/Forums/sharepoint/en-US/43d95471-d3b1-424a-a4d9-51d56f7f48a6/how-to-find-the-incomplete-survey-responses-in-sharepoint-2010-list?forum=sharepointadminprevious

    More information:

    http://www.sharepoint-journey.com/sharepoint-survey.html

    Best Regards,

    Linda Li


    Linda Li
    TechNet Community Support

    Monday, July 07, 2014 6:24 AM
  • Hi Linda,

    The reason that you are seeing the incomplete surveys is that your logedon as the user that created and saved the surveys. if you'll login with a different user, even system admin, you want see the incomplete surveys.

    Thats what i'm trying to do and didnt find anyway to do that even with code running with eleveated priveleges.

    thanks

    Monday, July 07, 2014 6:50 AM
  • I've tested that behaviour and can re-create it. If the user you're logged in as isn't the same as the one who created the survey then they can't see the incomplete one, even as a Site Collection Admin.

    You can get the survey information via the Server Object model. For example this code will print out the count of items in the survey, incomplete or complete.

    $web = Get-SPWeb "URL"
    $survey = $web.Lists["SurveyName"]
    Write-Host "Items in the survey : " $survey.ItemCount

    I haven't found the field that determines what state an item is in but a compare/contrast should show it up.
    Monday, July 07, 2014 7:21 AM
  • Hi,

    With OOTB of SharePoint 2013, users can only see the incomplete responses of their own and all the completed responses.

    There is a sample about getting the total number of incomplete surveys by querying them from the content database, though it is not recommended.

    http://yagyashree.wordpress.com/2012/09/26/how-to-find-total-number-for-incomplete-surveys/

    In addition, I recommend to disable the incomplete function.You can remove the 'Save and Close' button by adding the JavaScript to NewForm.aspx and EditForm.aspx for the survey.

    More information:

    http://danssharepointblog.blogspot.com/2014/01/how-to-hide-save-close-for-surveys.html

    Best Regards,

    Linda Li


    Linda Li
    TechNet Community Support


    Monday, July 07, 2014 7:25 AM
  • Update: There are several fields that differ,

    #False for incomplete, True for complete
    
    #$item.HasPublishedVersion
    
    #'Checkout' or 'Published'
    
    #$item.Level
    
    $incompleteItems = $survey.items | ? { -not $_.HasPublishedVersion }
    $completeItems = $survey.items | ? { $_.HasPublishedVersion }

    You can grab the created by field and spit emails out directy from C# or PowerShell or dump that into a CSV for mailmerging somewhere else. I'd contribute more but my battery is on it's last gasp.
    Monday, July 07, 2014 7:29 AM
  • Hi Alex and Linda, thanks for your info.

    An incomplete survey is checked out on the user, thats whay the HasPublished version and checkout fields are diffrent.

    As for hidding the save button it's not what we need because we want users to ba able to complete the survey in another time.

    I know I can get the surveys for all_userdata table but i prefere not to work directly on the content db.

    Any other ideas ?

    thanks

    Monday, July 07, 2014 11:17 AM
  • Indeed, however that code I put up is PowerShell code which means you're not directly hitting SQL (which is a terrible idea in most cases).

    Monday, July 07, 2014 11:31 AM
  • Hi,

    But your code can only give me the count, i need a detail report of the incomplete surveys.

    Our customer want to invite the user to complete the survey meaning he needs more info about the survey

    thanks

    Monday, July 07, 2014 11:44 AM
  • Did you ever figure out how to get information about incomplete surveys? My need is similar, because I want to see the incomplete responses and include them in analyses for the questions that were answered.

    Thanks!

    Friday, December 19, 2014 4:24 PM
  • The $incompleteItems object in my code above has the survey responses. If you loop through them you can extract any properties you want to know about, such as CreatedBy
    Friday, December 19, 2014 4:45 PM
  • Your code only will show items if you are logged into the server with the user account that submitted the incomplete survey. I did some testing with two different farm admin accounts, one that submitted an incomplete survey and one that did not. The $survey.Items does not return the incomplete items of other users. I used the following PowerShell to validate this:

    $survey.Items | select ID, HasPublishedVersion

    With admin account that submitted an incomplete item:

    164                       True                 Published
    165                      False                  Checkout
    166                       True                 Published

    With farm admin account (didn't submit a survey item):

     164                       True                 Published
     166                       True                 Published

    It seems calling $survey.Items still trims the results just as if you were looking through the web interface. Has anyone else found a different method to call the incomplete survey items?

    Tuesday, July 07, 2015 5:02 PM