- Posts: 26
- Thank you received: 1
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Survey participant export: howto distinguise partially completed from others
- priza
- Topic Author
- Offline
- Junior Member
Less
More
1 year 2 months ago #241110
by priza
Survey participant export: howto distinguise partially completed from others was created by priza
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
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
Please Log in to join the conversation.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11681
- Thank you received: 2748
1 year 2 months ago #241111
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Survey participant export: howto distinguise partially completed from others
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.
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.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Please Log in to join the conversation.
- priza
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 26
- Thank you received: 1
1 year 2 months ago #241117
by priza
Replied by priza on topic Survey participant export: howto distinguise partially completed from others
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.
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.
Please Log in to join the conversation.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13676
- Thank you received: 2496
1 year 2 months ago #241118
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Survey participant export: howto distinguise partially completed from others
When you export response: if survey is not anonymous : you can add the token column at end.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Please Log in to join the conversation.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11681
- Thank you received: 2748
1 year 2 months ago #241127
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Survey participant export: howto distinguise partially completed from others
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.
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.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Please Log in to join the conversation.
- priza
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 26
- Thank you received: 1
1 year 1 month ago #241219
by priza
Replied by priza on topic Survey participant export: howto distinguise partially completed from others
thanx for your replies, they were very helpful
Please Log in to join the conversation.