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?
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.
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.