The LimeSurvey Fund-Raiser 2012 is complete. Thank you for donating a total of 25,000 USD!     List of donors »

Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Database Structure and logic

Database Structure and logic 2 years 4 months ago #54816

  • robeppef
  • robeppef's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
Hello,
(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.
The administrator has disabled public write access.

Re: Database Structure and logic 2 years 4 months ago #54825

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5116
  • Thank you received: 260
  • Karma: 240
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)limesurvey.org'"
The administrator has disabled public write access.

Re: Database Structure and logic 1 year 8 months ago #65020

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.
The administrator has disabled public write access.
  • Page:
  • 1
Moderators: DenisChenu, ITEd
Time to create page: 0.186 seconds
Donation Image