Automating Export of Limesurvey Responses

Mehr
6 Jahre 2 Monate her #54569 von rvenkat
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.

Bitte Anmelden um der Konversation beizutretten.

Mehr
6 Jahre 2 Monate her #54615 von DenisChenu
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.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
Folgende Benutzer bedankten sich: rvenkat

Bitte Anmelden um der Konversation beizutretten.

Mehr
6 Jahre 2 Monate her #54635 von rvenkat
Thank you. I will look into it.

Bitte Anmelden um der Konversation beizutretten.

Mehr
6 Jahre 2 Monate her #54636 von rvenkat
Did you mean admin/exportresults.php?
Thanks.

Bitte Anmelden um der Konversation beizutretten.

Mehr
6 Jahre 2 Monate her #54638 von DenisChenu

rvenkat schrieb: 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


Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Bitte Anmelden um der Konversation beizutretten.

Mehr
6 Jahre 2 Monate her #54643 von Luke

Shnoulle schrieb: 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.
Folgende Benutzer bedankten sich: r0bis

Bitte Anmelden um der Konversation beizutretten.

Mehr
6 Jahre 2 Monate her #54644 von holch
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.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Bitte Anmelden um der Konversation beizutretten.

Mehr
6 Jahre 2 Monate her #54645 von Luke

holch schrieb: 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

;)

Bitte Anmelden um der Konversation beizutretten.

Mehr
6 Jahre 2 Monate her #54647 von holch
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.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Bitte Anmelden um der Konversation beizutretten.

Mehr
6 Jahre 2 Monate her #54655 von DenisChenu

holch schrieb: 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 :).

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Bitte Anmelden um der Konversation beizutretten.

Mehr
6 Jahre 1 Monat her #55947 von Luke
Hello, finally I wrote "cmdline_exportsurvey.php" and it works.

Where is the best place to upload the files and describe how to use it?

Bitte Anmelden um der Konversation beizutretten.

Mehr
6 Jahre 1 Monat her #55956 von DenisChenu
Hello,

I think there are 2 possibility, and the 2 can be done.

1st: workaround part in docs.limesurvey.org
2nd: UserPatch bugs.limesurvey.org

:)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Bitte Anmelden um der Konversation beizutretten.

Mehr
6 Jahre 1 Monat her #56029 von Mazi

Luke schrieb: Hello, finally I wrote "cmdline_exportsurvey.php" and it works.

Where is the best place to upload the files and describe how to use it?

Please open a new ticket at our Bugtracker (user patches) and describe the patch as detailled as possible. You can assign it to user "c_schmitz" and ask for review.


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

Bitte Anmelden um der Konversation beizutretten.

Mehr
4 Jahre 2 Monate her #91333 von lstrange
Hello - I came across this thread and noticed that Luke wrote a script to automate export of data from a survey. Was this feature ever incorporated into the tool and if so, how do you access it? I have a user interested in this type of functionality.

Thanks - Lainie

Bitte Anmelden um der Konversation beizutretten.

Mehr
4 Jahre 2 Monate her #91490 von Luke
Hi, I am the guy who wrote the script but I have no knowledge of whether what you ask about was ever done.

Bitte Anmelden um der Konversation beizutretten.