Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Automating Export of Limesurvey Responses

More
9 years 3 months ago - 9 years 3 months ago #114961 by Luke
If anyone is still interested in this please find all the files below.


File Attachment:

File Name: limesurvey_export.zip
File Size:23 KB
Last edit: 9 years 3 months ago by c_schmitz.
The following user(s) said Thank You: ConradNg
The topic has been locked.
  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
9 years 3 months ago #114962 by c_schmitz
Replied by c_schmitz on topic Automating Export of Limesurvey Responses
Hi,

thank you for sharing but why don't you use the RemoteControl API function export_responses ?
Otherwise if something within LimeSurvey changes your export code will not properly be working anymore.

A JSONRPC client is even included within LimeSurvey. Look at function test() of the remotecontrol controller.

Best regards

Carsten Schmitz
LimeSurvey project leader
The topic has been locked.
More
9 years 3 months ago #115007 by Luke
Because I wrote it over 3 years ago when there was no API?

;)
The topic has been locked.
  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
9 years 3 months ago #115008 by c_schmitz
Replied by c_schmitz on topic Automating Export of Limesurvey Responses
Weird, last message is said to be from 3 days ago.

Best regards

Carsten Schmitz
LimeSurvey project leader
The topic has been locked.
More
9 years 3 months ago #115029 by Luke
"it" is my script, not my message. I wrote the script over 3 years ago :)
The topic has been locked.
  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
9 years 3 months ago #115032 by c_schmitz
Replied by c_schmitz on topic Automating Export of Limesurvey Responses
Ah ok ;)

Best regards

Carsten Schmitz
LimeSurvey project leader
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
9 years 3 months ago #115060 by Mazi
Luke, can you let us know with which Limesurvey versions your script works?

Do you always have to call the script manually or can it also be set up as a daily cron job?

Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The topic has been locked.
More
9 years 3 months ago - 9 years 3 months ago #115305 by Luke
I customized LS code for the purpose of one of my projects. LS version I used was:

$versionnumber = "1.90+";
$dbversionnumber = 143;
$buildnumber = '9343';

This was around 3 years ago, my data download script has been running as a cron job since then. Have not had a single problem with it.

Luke
Last edit: 9 years 3 months ago by Luke.
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
9 years 3 months ago #115315 by Mazi
Thanks for these details, Luke.

Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The topic has been locked.
More
8 years 11 months ago #119009 by mercuralchapman
Replied by mercuralchapman on topic Automating Export of Limesurvey Responses
I'm interested in automating survey response exports and sending via email using the API but I really have no idea how to get started. Has anyone done this or would you be willing to create something I could run through a cron job?
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
8 years 1 week ago #132854 by Mazi
We have recently coded a custom export script which can be called using a certain link. At that link you can adjust the survey ID so it can be used for several surveys and within the script you can define the export format that should be used.
The script creates a simple "download responses" link the user can click and then the download starts.
That link can also be embedded e.g. at the confirmation or admin email.

Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The following user(s) said Thank You: clj
The topic has been locked.
More
7 years 10 months ago #135048 by first
Replied by first on topic Automating Export of Limesurvey Responses
Dont we have any method in remote control api to read whole survey data of a specific respondent?

Survey Designer and Programmer
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose