Welcome to the LimeSurvey Community Forum

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

Basic Export to Excel

  • g3guy
  • g3guy's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
10 years 3 months ago #102262 by g3guy
Basic Export to Excel was created by g3guy
Hi

Taking a stab, but will try anyway :)

I'm trying to create a passworded page on my site that accessible only by my client. On the page currently I've replicated the "Response Summary" page (so it saves me reporting to them on a daily basis). That was easy enough as all I had to do was query the DB.

Now I would like to add in the functionality so they can export their results in Excel. Unfortunately not so straight forward with the need to lookup all the labels to the questions. I started looking at the export.php code, but that's way over my head :unsure:

Is there an easier way to accomplish something like this?

Thanks!
The topic has been locked.
  • fransmarcelissen
  • fransmarcelissen's Avatar
  • Offline
  • Premium Member
  • Premium Member
More
10 years 3 months ago - 10 years 3 months ago #102270 by fransmarcelissen
Replied by fransmarcelissen on topic Basic Export to Excel
There is another way to do this: create a html page (not in limesurvey) with a list of links to the relevant limesurvey pages. For instance: the link to export page is www.MYSERVER.nl/index.php/admin/export/s...ults/surveyid/355632 The html page you can tailor exactly to the wishes of the customer. In fact I wrote the customer page in R, and read directy the mysql tables of limesurvey. For instance: on the customer page you can show a list of users, and again link to the relevant limesurvey page).
If you are interested, i can show an example (in dutch).
Frans
Last edit: 10 years 3 months ago by fransmarcelissen.
The topic has been locked.
  • g3guy
  • g3guy's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
10 years 3 months ago #102272 by g3guy
Replied by g3guy on topic Basic Export to Excel
Hi Frans

I'm actually quite interested in the alternative - although how to you bypass the required authentication? The intention is they they never sniff anything on Limesurvey...

Happy to go with the Dutch example!
The topic has been locked.
  • fransmarcelissen
  • fransmarcelissen's Avatar
  • Offline
  • Premium Member
  • Premium Member
More
10 years 3 months ago #102273 by fransmarcelissen
Replied by fransmarcelissen on topic Basic Export to Excel
Hi g3guy,
Please send me (info@digipsy.nl) your email adres and name, then i will create a login for you.
The authentification is handled by limesurvey. When you jump to a location in limesurvey it asks your name. I have arranged my system so that you can see a list of participants and generate reports without having to login, but when you want to do change something, you have to login.
The following user(s) said Thank You: g3guy
The topic has been locked.
More
10 years 3 months ago - 10 years 3 months ago #102274 by Ben_V
Replied by Ben_V on topic Basic Export to Excel
Hello,
I suppose you may be interested in these thread ;)

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Last edit: 10 years 3 months ago by Ben_V.
The following user(s) said Thank You: g3guy
The topic has been locked.
  • g3guy
  • g3guy's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
10 years 3 months ago #102296 by g3guy
Replied by g3guy on topic Basic Export to Excel
Thanks Frans! Will be in touch and revert back here with my finding for others to see.

In terms of the suggestion by Ben_v - thanks! Will check that out too...
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose