Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

THEMA: Can LimeSurvey allow MySQL queries to analyze data for longitudinal surveys?

Can LimeSurvey allow MySQL queries to analyze data for longitudinal surveys? 1 Jahr 5 Monate her #88630

  • cdc
  • cdcs Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 1
  • Karma: 0
Is it possible to directly query the survey response data in LimeSurvey with MySQL query commands from our own PHP code? Are the database field names assignable/setup so that the query will be readable?

We would like to use LimeSurvey to setup surveys for what will be tens of thousands of users. Each user will take multiple surveys (ag 10) over one year. We need to be able to do automated, SQL-query-based analysis of the large volume of data that will be generated. We are trying to find the right solution for doing this. Is LimeSurvey it? Is there another tool that would be a better fit for what we are doing? We have been using SurveyMonkey, but they don't allow API access or SQL access to the survey results data.

Thanks from a new potential user
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Can LimeSurvey allow MySQL queries to analyze data for longitudinal surveys? 1 Jahr 5 Monate her #88631

  • mdekker
  • mdekkers Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 340
  • Dank erhalten: 68
  • Karma: 38
sql access is possible, but you have to make some effort to 'translate' fieldnames to questioncodes. Maybe the remotecontrol api is something that can help you:
docs.limesurvey.org/RemoteControl+2+API&...tions+for+LimeSurvey
---
Menno Dekker
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: Can LimeSurvey allow MySQL queries to analyze data for longitudinal surveys? 1 Jahr 5 Monate her #88662

  • DenisChenu
  • DenisChenus Avatar
  • OFFLINE
  • Moderator Lime
  • Beiträge: 5854
  • Dank erhalten: 716
  • Karma: 222
And you have access at whole survey code (rules 1 of the GPL licence), then you can take some part to do your own PHP script.

Like remote control : need some work.

Denis
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Moderatoren: ITEd
Ladezeit der Seite: 0.158 Sekunden
Donation Image