Can I export data result via command line?

More
3 years 7 months ago #105243 by yangxg
yangxg created the topic: Can I export data result via command line?
Hi:

I want to integrate limesurvey and R in a more automatical way, that is to use limesurvey as the data collecting tool and analyze the result with R. Therefore, I need to import the data result via command script. Although tools like RMySQL can read data directly from the database, I more love the data structure by the export function inside the Limesurvey.

My questions is, how to exporting the data in R format by the command line (preferably in Linux platform), in stead of mannually click the exporting button after loggin?

I dont know if it is possible, and if not, is there any alternative solution?

Thanks a lot for any help!

Yang
The following user(s) said Thank You: r0bis

Please Log in to join the conversation.

More
7 months 1 week ago #148682 by r0bis
r0bis replied the topic: Can I export data result via command line?
This is precisely my situation as well. Such a facility would be great. I would envision as a commandline utility that can generate data export in one of the defined formats (csv, xls, R) for a given survey as defined by surveyID.

Please Log in to join the conversation.

More
7 months 1 week ago #148693 by r0bis
r0bis replied the topic: Can I export data result via command line?
Just an update - I found perfect solution for my needs. Data can be pulled off remotely (or if you connect to the machine via crossover cable, in case of non-internet connected machine) at whatever intervals you like using JSON-RPC interface. Data goes straight into R. Basically you need to install **limer** library into R from github.com/cloudyr/limer and you are set to go. You can easily write scripts in R that can be run from crontab.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now