Please help us help you and fill where relevant:
Your LimeSurvey version: LimeSurvey Community Edition Version 5.4.12+221121
Own server or LimeSurvey hosting: self hosted
Survey theme/template:
==================

hey,
we'd like to be able to distinguise participants who tried but not completed the survey, from others that didnt even started. now we can make two exports:
completed and not yet completed.
is there a way to make a single export with this information?

also, is there something in the API that helps in an automated way to do this?

thanx

I am not quite sure what your issue is. You can export ALL responses, completed or not completed into one export file of course. It is actually the default:
 

And then you have the column of "last page" and also "completed" in the response tab of the backend that will allow you to determine who has completed and who hasn't (despite the indicator that those incomplete will lack some answers, of course):
 

This is how it looks like in the export:
 

So there is no "completed" column, but there is the submit date. If the survey hasn't been completed, you won't have any submit date, just like here for response 1 and 2, both did not submit the form completely.

In last page you will see the last page they have seen. Here it is "1" for all, because my example just had 1 page, but in a survey with more than one page you will see different "last pages" for those that got to the last page or not. They still could not have submitted. So the best way to tell if they are complete or not is the fact that they have a submit date. Here it was an anonymous survey so the actual date and time was not recorded, but a standard date instead.

No Idea about the API, not using it.

 

hey thanx for the quick response.

i was talking about the participants export, not the responses. there you can see the different export types:
 

which give this csv
 

we want a single export, either csv or through API with users that completed full or partial only. in tihs export you can only see clearly fuuly completed. all others look the same.

When you export response: if survey is not anonymous : you can add the token column at end.

OK, so I understood it wrong.

In reality what you want is to distinguish 3 profiles:
1. Respondents who completed the survey
2. Respondents who started the survey but did not complete
3. Respondents who did not do anything (haven't even started).

Profile 1 is clearly visible in the export of the token table, your issue are to distinguish between profile 2 and 3.

Seems like there is no way to have this detail directly in the token table export. You might have to join the token table with the responses table through the token to get this information.

thanx for your replies, they were very helpful