Where can I find participant answers in the database

Plus d'informations
il y a 3 mois 2 jours #157672 par cdubinsky
cdubinsky a créé le sujet : 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!

Connexion pour participer à la conversation.

Plus d'informations
il y a 3 mois 1 jour - il y a 3 mois 1 jour #157687 par fvanderstarre
fvanderstarre a répondu au sujet : 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].
Dernière édition: il y a 3 mois 1 jour par fvanderstarre. Raison: typo's

Connexion pour participer à la conversation.

Plus d'informations
il y a 3 mois 1 jour #157689 par LouisGac
LouisGac a répondu au sujet : Where can I find participant answers in the database
table {prefix}_survey_{surveyid}

Connexion pour participer à la conversation.

Plus d'informations
il y a 3 mois 1 jour #157698 par fvanderstarre
fvanderstarre a répondu au sujet : Where can I find participant answers in the database
Well that's the short answer... ;)

Connexion pour participer à la conversation.

Plus d'informations
il y a 3 mois 1 jour #157701 par LouisGac
LouisGac a répondu au sujet : Where can I find participant answers in the database
sorry I haven't seen you answered in the while ^^

Connexion pour participer à la conversation.

Plus d'informations
il y a 3 mois 1 jour #157708 par cdubinsky
cdubinsky a répondu au sujet : 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!:)

Connexion pour participer à la conversation.

Commencez dès maintenant !

Créez simplement un compte et commencez à utiliser LimeSurvey dès aujourd'hui.

Inscrivez-vous maintenant

Inscrivez-vous à notre Newsletter!