Export to a table in MySql database on Server

More
7 years 8 months ago #106350 by mark01
I use software [QLR Manager] to report directly from MySql tables.
I would like to use this for LimeSurvey reporting but hate the variable names used in the native LS tables.
The export to SPSS,CSV,etc convert the variable names to question names - much better for me.
I would like to export to a mysql table in the same database as the LS being used.
Is this possible? I can achieve this by exporting as CSV and uploading to MySql - a bit of schlep - is there a direct way?
Regards
Mark
The topic has been locked.
More
7 years 8 months ago #106373 by byan
LS uses MySQL. If the LS you are using is hosted on a server you have direct access, you should be able to use QLR Manager to connect to the LS database tables directly.
The topic has been locked.
More
7 years 8 months ago #106376 by mark01
Yes I do connect directly - works perfectly - what I want is to make a version with the question names as variables - like AGE - rather than variable names like - 1234x12x34.
When you save via SPSS or R or CSV this happens but I want it saved on the servers as a MySql table not on my computer as .sav,.csv, etc.

Regards
The topic has been locked.
More
7 years 8 months ago #106414 by mdekker
It should be possible using the new plugin system to code something to do that. You would have to use the afterSurveyComplete event to intercept the final response and then write it to the database. You could check out the /plugins/Demo/ShowResponse to get you started.

If you want to add switch to the survey settings to enable / disable this feature that should be possible too. github.com/SamMousa/limesurvey-encrypt is something similar, but for encryption of the data.

---
Menno Dekker
The topic has been locked.

Start now!

Just create your account and start using Limesurvey today.

Register now