Welcome to the LimeSurvey Community Forum

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

Using Third Party Software to Analyse the Data

  • LSSSurvey1
  • LSSSurvey1's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
6 years 2 months ago #163020 by LSSSurvey1
Hi,
is there a database mapping for the answers of the survey?
I have my own automated reports that gets generated by Crystal Reports Server, and it will be very helpful to me to create a Crystal Report that pulls the results directly from the database on a monthly bases and put it in charts and email it to me..

if yes, would you please send the answers database mapping so i test it using my CR ?

Thanks.
The topic has been locked.
More
6 years 2 months ago #163022 by jelo
You might try the RemoteControl API. User CrystalReport decades ago. Some kind of coding language support might be available.
manual.limesurvey.org/RemoteControl_2_API


The last database map I'm aware of is for LS 2.5
manual.limesurvey.org/LimeSurvey_2.5_dat...layout_documentation

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The following user(s) said Thank You: LSSSurvey1
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
6 years 2 months ago #163032 by LouisGac
Replied by LouisGac on topic Using Third Party Software to Analyse the Data

LSSSurvey1 wrote: if yes, would you please send the answers database mapping so i test it using my CR ?


For now the answer table is not normalized, indeed, it's a different table for each survey....
The table is: {prefix}_survey_{survey id}

You can have a look to the limeR software code: it's providing a bridge between LimeSurvey and R.
github.com/cloudyr/limer
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose