Where can I find participant answers in the database

More
3 months 6 days ago #157672 by cdubinsky
cdubinsky created the topic: Where can I find participant answers in the database
We have a specific way the data from the surveys needs to be exported. We have a program which was written for an older version of LimeSurvey, but does not work with the newer versions.

I am trying to query the database for the answers to a survey by a specific participant. I understand from the manual that the answers are tagged by the token for the participant. I have been able to find and query the participants token, but I cannot find anywhere in the database where the participants answers are stored.

Any information on which table the answers to the surveys is store would be much appreciated.

We are using Version 2.58.0+170104.

Thank you!

Please Log in to join the conversation.

More
3 months 6 days ago - 3 months 6 days ago #157687 by fvanderstarre
fvanderstarre replied the topic: Where can I find participant answers in the database
Hi, find out your survey's database id (survey id) and database table prefix (may be empty). Participant answers are stored in database table [prefix_]survey_[survey_id].
Last Edit: 3 months 6 days ago by fvanderstarre. Reason: typo's

Please Log in to join the conversation.

More
3 months 6 days ago #157689 by LouisGac
LouisGac replied the topic: Where can I find participant answers in the database
table {prefix}_survey_{surveyid}

Please Log in to join the conversation.

More
3 months 6 days ago #157698 by fvanderstarre
fvanderstarre replied the topic: Where can I find participant answers in the database
Well that's the short answer... ;)

Please Log in to join the conversation.

More
3 months 6 days ago #157701 by LouisGac
LouisGac replied the topic: Where can I find participant answers in the database
sorry I haven't seen you answered in the while ^^

Please Log in to join the conversation.

More
3 months 6 days ago #157708 by cdubinsky
cdubinsky replied the topic: Where can I find participant answers in the database
Thank you both for your responses, I now see the answers in that table. I think my test survey didn't have enough questions to catch my eye, but I see the answers now.

Thanks!:)

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!