Check out the LimeSurvey source code on GitHub!

Database Structure and logic

6 years 1 month ago #54816 by robeppef
(sorry for my bad english)
I want to development a java based tool to analyze the results of various limesurvey-surveys, export them into various formats and calculate different measures etc.
Therefore I want to readout the corresponding database tables and parse them into my java datastructure...
Unfortunately I experience problems - the structure of surveys lokks a little bit tricky (e.g. what do the type-characters of questions mean?). Why is an answer sometimes a row in a question-table and so on... Where can I find a documentation for the database structure and its behaviour?
Thanks a lot.

Please Log in to join the conversation.

6 years 1 month ago #54825 by Mazi
If you just need the survey results a simple "SELECT * FROM lime_survey_12345" (12345 = surveyID) should do the trick.

Also have a look at the createfieldmap() function.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)'"

Please Log in to join the conversation.

5 years 5 months ago #65020 by buddy_boy8403
this was helpful, however, I have one question to add to this. (Sorry for bringing up an old thread, by the way).

When you "SELECT * FROM lime_survey_12345" the results look like they tie back to the 'Code' field in the answers table. I'm not very good with linking tables, so how would I link the survey responses to the appropriate answers so show the answer that was selected rather than the code of the answer selected.

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form