Basic Export to Excel

More
3 years 5 months ago #102262 by g3guy
g3guy created the topic: Basic Export to Excel
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!

Please Log in to join the conversation.

More
3 years 5 months ago - 3 years 5 months ago #102270 by fransmarcelissen
fransmarcelissen replied the 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: 3 years 5 months ago by fransmarcelissen.

Please Log in to join the conversation.

More
3 years 5 months ago #102272 by g3guy
g3guy replied the 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!

Please Log in to join the conversation.

More
3 years 5 months ago #102273 by fransmarcelissen
fransmarcelissen replied the topic: Basic Export to Excel
Hi g3guy,
Please send me (This email address is being protected from spambots. You need JavaScript enabled to view it.) 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

Please Log in to join the conversation.

More
3 years 5 months ago - 3 years 5 months ago #102274 by Ben_V
Ben_V replied the 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: 3 years 5 months ago by Ben_V.
The following user(s) said Thank You: g3guy

Please Log in to join the conversation.

More
3 years 5 months ago #102296 by g3guy
g3guy replied the 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...

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now