Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Where can I find participant answers in the database

  • cdubinsky
  • cdubinsky's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 7 months ago #157672 by cdubinsky
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!
The topic has been locked.
More
6 years 7 months ago - 6 years 7 months ago #157687 by fvanderstarre
Replied by fvanderstarre on 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: 6 years 7 months ago by fvanderstarre. Reason: typo's
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
6 years 7 months ago #157689 by LouisGac
table {prefix}_survey_{surveyid}
The topic has been locked.
More
6 years 7 months ago #157698 by fvanderstarre
Replied by fvanderstarre on topic Where can I find participant answers in the database
Well that's the short answer... ;)
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
6 years 7 months ago #157701 by LouisGac
sorry I haven't seen you answered in the while ^^
The topic has been locked.
  • cdubinsky
  • cdubinsky's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 7 months ago #157708 by cdubinsky
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!:)
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose