none
how to find the incomplete survey responses in sharepoint 2010 list

    Question

  • Hi,

    I'm a site collection administrator. But i'm not able to find the survey response which is incomplete status. so how to i find the incomplete survey response user names and inform them to complete. Please help

    Thursday, October 17, 2013 12:50 AM

Answers

  • Hello maxi prakash,

    I think there is bit confusion so just bit more clarification about survey:

    1. If you have implemented branching logic then you have "Save and Close" button to save incomplete survey in "show all responses view". Later you can open same survey response and you will be able to complete it by click on finish button. But if you click cancel then saved response will be deleted from view and there will be no response. (see both the pics, where second pic of saved response and "completed" is no).

    Hope it could help


    Hemendra:Yesterday is just a memory,Tomorrow we may never see
    Please remember to mark the replies as answers if they help and unmark them if they provide no help


    Thursday, October 24, 2013 5:28 AM
    Moderator

All replies

  • Hello,

    SP does save incomplete survey until they finish so you can only view complete survey via UI. However you can query them in DB but not recommended so be careful when you query content DB.

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


    Hemendra:Yesterday is just a memory,Tomorrow we may never see
    Please remember to mark the replies as answers if they help and unmark them if they provide no help

    Thursday, October 17, 2013 5:15 AM
    Moderator
  • I'm able to achieve with CAML query. Your CAML query should follow below. 

    1. Each question is created as Title. Example if my question title is 'Question1'  you can see column named Question1

    2.CAML query - where (question1 is null or empty) or (question2 null or empty) is your result.

    3. You can find out all the column names from list settings.

    4. Add viewfields as below.

    <FieldRef Name="Question1" />
    <FieldRef Name="Question2" />
    <FieldRef Name="Author" />

     

    Bala

    Thursday, October 17, 2013 3:25 PM
  • Hi Hemendra,

     Thanks for your reply. I just want to know is any other way we can find the incomplete survey response details. because, i don't have access for the DB. is this one of the disadvantage of sharepoint 2010?  
    Friday, October 18, 2013 12:03 AM
  • I am not aware about any default way, which can give the incomplete survey result. Infect this was also problem with earlier version (MOSS 2007).


    Hemendra:Yesterday is just a memory,Tomorrow we may never see
    Please remember to mark the replies as answers if they help and unmark them if they provide no help

    Friday, October 18, 2013 4:40 AM
    Moderator
  • Just figured out the simplest way of doing this job.

    1. Export excel on survey list

    2. Apply Filters on excel to see the incomplete responses.


    Bala

    Friday, October 18, 2013 5:40 AM
  • Bala,

    I'd double check this.  There's a difference between an incomplete survey that a user hasn't reached the end of and a full one that's had optional questions ignored. 

    Hemendra is right when he says that SP Surveys are only stored locally until they're fully completed.

    Friday, October 18, 2013 11:24 AM
    Answerer
  • Hi Bala,

      Thanks for your reply with screen shot. I was done the export excel on survey list. but i can only export complete responses. 

    Sunday, October 20, 2013 11:22 PM
  • Prakash-

    This exports all the responses in the list. You can apply filters in excel to compute incomplete responses.


    Bala

    Wednesday, October 23, 2013 12:24 PM
  • Hello maxi prakash,

    I think there is bit confusion so just bit more clarification about survey:

    1. If you have implemented branching logic then you have "Save and Close" button to save incomplete survey in "show all responses view". Later you can open same survey response and you will be able to complete it by click on finish button. But if you click cancel then saved response will be deleted from view and there will be no response. (see both the pics, where second pic of saved response and "completed" is no).

    Hope it could help


    Hemendra:Yesterday is just a memory,Tomorrow we may never see
    Please remember to mark the replies as answers if they help and unmark them if they provide no help


    Thursday, October 24, 2013 5:28 AM
    Moderator
  • So just to tack on an additional question for further clarification as I am in a same situation.

    Where I have a survey,  the survey reports result number of 11.

    Now when I go to the Sharepoint CA server and use powershell and grab the list object.

    $list.Itemcount  results in 11.

    But $list.items | Select Id, Name    results in 4 items.

    Where are the other 7 items?

    What is exactly counted in the Item count of a survey list?

    In other lists, the item count is comprised of folders and items.  

    So going down that path.  I did a

    $list.folders.count   result is 0.

    $list.rootfolder.subfolders result in 5 folder.   

    Ok we are getting somewhere.  

    But 5(subfolders.count) + 4 (items.count) only = 9  where are the other two counts coming from?

    Are items that have been deleted from a survey still counted if they are in the recycle bin?


    pfcjt@hotmail.com

    Friday, March 9, 2018 3:41 PM