- Posts: 673
- Karma: 98
- Thank you received: 105
SQL query for report builder
c_schmitz wrote: Hello!
As you already pointed out there is nothing like that in LimeSurvey and there is no way to create such a view yet. I am sorry.
okay thanks for your response
is it also on the roadmap yet ?
if yes I am ok to contribute (for testing for instance )
I do'nt know whether I understand this questions correctly, but until recently I created reports automatically in R and in spss, after reading the database with an simple sql statement. I have created hundreds of reports in this way. This is also possible from spss (and probably also in pspp). The sql statement is simply SELECT * FROM `lime_survey_XXX` where XXX is the survey id. The disadventage of this is that the variable names are SGQ codes (something like 242445X263X2350). Another disadvantage is that in general reading the database is only possible if you are on the server where the database is installed).
Since some time I notices that remotecontrol is much simplier and useful. See manual.limesurvey.org/RemoteControl_2_API#export_responses . Using rc it is possible (for example in R, or php) to read the answers directly in a batch mode, with decent variable names. This data tables can directly be used in R/spss/pspp, or whatever statistical program or report generator you are using.
In my expercience R is much, much more useful than spss.
Mazi wrote: gigipaul wrote:Saving assessment results hasn't been implemented yet. You can vote for this feature here: ideas.limesurvey.org/ideatorrent/idea/7/
I am also interested in getting the results out of the lime surveys with assessment values, so we can generate reports out of it. Please let me know
To achieve this with current versions you have to code your own script to generate reports.
I have the same requirement of generating reports out of assessment values. Is this a feature available with the current versions?