Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi
  • Page :
  • 1
  • 2

SUJET : Automating Export of Limesurvey Responses

Automating Export of Limesurvey Responses il y a 3 ans 9 mois #54569

  • rvenkat
  • Portrait de rvenkat
  • Hors ligne
  • Senior Lime
  • Messages : 42
  • Remerciements reçus 1
  • Karma: 2
I would like to know if there is way to export survey responses automatically into a separate program (which does data analysis)?

I want to automatically get responses at periodic intervals. I would like to configure survey ID, start and end dates for the period.

Currently, I am able to manually get data in CSV. Can we automate this process?

Has anyone tried doing this? Your suggestions/experience would be greatly appreciated.
L'administrateur a désactivé l'accès en écriture pour le public.

Re: Automating Export of Limesurvey Responses il y a 3 ans 9 mois #54615

  • DenisChenu
  • Portrait de DenisChenu
  • En ligne
  • Moderator Lime
  • Messages : 6451
  • Remerciements reçus 844
  • Karma: 249
LimeSurvey use database, you can use a php script (or another langage) to extract the answer from the database, and export like you want with a cron job.

You can have a look at admin/export.php to have some function to use for your script.

But you need to develop you own solution.
L'administrateur a désactivé l'accès en écriture pour le public.
Cet utilisateur a été remercié pour son message par: rvenkat

Re: Automating Export of Limesurvey Responses il y a 3 ans 9 mois #54635

  • rvenkat
  • Portrait de rvenkat
  • Hors ligne
  • Senior Lime
  • Messages : 42
  • Remerciements reçus 1
  • Karma: 2
Thank you. I will look into it.
L'administrateur a désactivé l'accès en écriture pour le public.

Re: Automating Export of Limesurvey Responses il y a 3 ans 9 mois #54636

  • rvenkat
  • Portrait de rvenkat
  • Hors ligne
  • Senior Lime
  • Messages : 42
  • Remerciements reçus 1
  • Karma: 2
Did you mean admin/exportresults.php?
Thanks.
L'administrateur a désactivé l'accès en écriture pour le public.

Re: Automating Export of Limesurvey Responses il y a 3 ans 9 mois #54638

  • DenisChenu
  • Portrait de DenisChenu
  • En ligne
  • Moderator Lime
  • Messages : 6451
  • Remerciements reçus 844
  • Karma: 249
rvenkat écrit:
Did you mean admin/exportresults.php?
Thanks.
I don't look, but i think it's a good start.

And i think you can have a look to a search site (like google) with
PHP Script Export MySQL CSV
L'administrateur a désactivé l'accès en écriture pour le public.

Re: Automating Export of Limesurvey Responses il y a 3 ans 9 mois #54643

  • Luke
  • Portrait de Luke
  • Hors ligne
  • Fresh Lemon
  • Messages : 13
  • Remerciements reçus 1
  • Karma: 1
Shnoulle écrit:
LimeSurvey use database, you can use a php script (or another langage) to extract the answer from the database, and export like you want with a cron job.

No, it will not be that easy. LS does not store actual values in the tables, but the codes. The codes link to other tables with actual values.

My survey has over 400 questions. Most of them are dropdowns. Doing what you suggested manually is just not practical.
L'administrateur a désactivé l'accès en écriture pour le public.

Re: Automating Export of Limesurvey Responses il y a 3 ans 9 mois #54644

  • holch
  • Portrait de holch
  • Hors ligne
  • LimeSurvey Team
  • Messages : 2851
  • Remerciements reçus 359
  • Karma: 124
well, I think what Shnoulle wants to say is, that there is a export of results to csv which uses the exportresults.php. If you want something different than that, then the best way would be to have a look at the exportresults.php to see how it is done and then customize something for your specific needs.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
L'administrateur a désactivé l'accès en écriture pour le public.

Re: Automating Export of Limesurvey Responses il y a 3 ans 9 mois #54645

  • Luke
  • Portrait de Luke
  • Hors ligne
  • Fresh Lemon
  • Messages : 13
  • Remerciements reçus 1
  • Karma: 1
holch écrit:
well, I think what Shnoulle wants to say is, that there is a export of results to csv which uses the exportresults.php. If you want something different than that, then the best way would be to have a look at the exportresults.php to see how it is done and then customize something for your specific needs.

And for someone already familiar with the code, how hard would it be to write

cmdline_export_survey_data_csv.php

;)
L'administrateur a désactivé l'accès en écriture pour le public.

Re: Automating Export of Limesurvey Responses il y a 3 ans 9 mois #54647

  • holch
  • Portrait de holch
  • Hors ligne
  • LimeSurvey Team
  • Messages : 2851
  • Remerciements reçus 359
  • Karma: 124
Well, I assume if Shnoulle would know it, he would have said so, don't you think. Not everyone who is somehow involved with LS knows every function and every bit of it. As far as I know, everyone has some kind of speciality.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
L'administrateur a désactivé l'accès en écriture pour le public.

Re: Automating Export of Limesurvey Responses il y a 3 ans 9 mois #54655

  • DenisChenu
  • Portrait de DenisChenu
  • En ligne
  • Moderator Lime
  • Messages : 6451
  • Remerciements reçus 844
  • Karma: 249
holch écrit:
Well, I assume if Shnoulle would know it, he would have said so, don't you think. Not everyone who is somehow involved with LS knows every function and every bit of it. As far as I know, everyone has some kind of speciality.
Yep,

I never work on a function like this , i think it was 'some' hour of working :).

And Luke, your right, you need to link the table 'lime_survey_xxxx' with question and answer to do the job. I think, if i work on it, to look at the existent function, and include common.php, exportresult.php etc ... can be interesting.

Some of us offer professionnal support if you want :).
L'administrateur a désactivé l'accès en écriture pour le public.
  • Page :
  • 1
  • 2
Modérateurs: ITEd
Temps de génération de la page : 0.149 secondes
Donation Image