Welcome to the LimeSurvey Community Forum

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

Show results in another webpage in real time

More
2 months 4 weeks ago #241144 by hvitor
Show results in another webpage in real time was created by hvitor
Please help us help you and fill where relevant:
Your LimeSurvey version: [last
Own server or LimeSurvey hosting: own
Survey theme/template: default
==================
I need to integrate survey results into another webpage, intended for our team to see the results in real time. 

Is anyone using some form of implementation of this kind?

Thanks in advance 

Please Log in to join the conversation.

More
2 months 4 weeks ago #241159 by tpartner
Replied by tpartner on topic Show results in another webpage in real time
Enable public statistics and copy the URL given at the end of the survey.

- manual.limesurvey.org/Presentation/en#Public_Statistics
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

More
2 months 4 weeks ago #241178 by Joffm
Replied by Joffm on topic Show results in another webpage in real time
And if you want to do it more sophisticated, create your own dashboard.
 
You may access the survey data either directly or by the API.

 
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The following user(s) said Thank You: DenisChenu

Please Log in to join the conversation.

More
2 months 3 weeks ago #241311 by DenisChenu
Replied by DenisChenu on topic Show results in another webpage in real time

And if you want to do it more sophisticated, create your own dashboard.
 
You may access the survey data either directly or by the API.


 
You have some sample of code for such dashboard ? Done with R ? Python ? PHP ?
Something we can put on manual maybe ?
 
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.

Please Log in to join the conversation.

More
2 months 3 weeks ago #241468 by Matadeleo
Replied by Matadeleo on topic Show results in another webpage in real time
Looks impressive Joffm! Is this set up specific to a single survey, or have you managed to create something more dynamic (auto generated per survey)?
The following user(s) said Thank You: DenisChenu

Please Log in to join the conversation.

More
2 months 3 weeks ago #241472 by Joffm
Replied by Joffm on topic Show results in another webpage in real time
Well, it is the bootstrap "startmin" template and the chart library "highcharts".
The rest a php script with direct access to the LS database.

The only thing I did to ease my life is a "translation table" like this to have better readable columns in the SQL queries.
Code:
$survey=853397;
 
$tbl_daten='lime_survey_'.$survey;
$tbl_sample='lime_tokens_'.$survey;
$tbl_timing='lime_survey_'.$survey.'_timings';
$col_browser=$survey.'X20X1057';
$col_random=$survey.'X37X1047';
$col_F1=$survey.'X20X199';
$col_F2=$survey.'X104X999';
$col_F4=$survey.'X35X201';
...

To be honest: It is more or less "l'art pour l'art" or to impress a customer.

Joffm
 
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The following user(s) said Thank You: DenisChenu

Please Log in to join the conversation.

More
2 months 3 weeks ago #241475 by tpartner
Replied by tpartner on topic Show results in another webpage in real time

To be honest: It is more or less "l'art pour l'art" or to impress a customer.

I think it has impressed more than a customer. :)
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

More
2 months 3 weeks ago #241476 by DenisChenu
Replied by DenisChenu on topic Show results in another webpage in real time

Well, it is the bootstrap "startmin" template and the chart library "highcharts".
The rest a php script with direct access to the LS database.

To be honest: It is more or less "l'art pour l'art" or to impress a customer.

 
No usage of API ?
really impressive …
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.

Please Log in to join the conversation.

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source