- Posts: 27
- Thank you received: 1
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Basic Export to Excel
- g3guy
- Topic Author
- Offline
- Junior Member
Less
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
Is there an easier way to accomplish something like this?
Thanks!
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
Is there an easier way to accomplish something like this?
Thanks!
The topic has been locked.
- fransmarcelissen
- Offline
- Premium Member
Less
More
- Posts: 118
- Thank you received: 49
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
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
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 27
- Thank you received: 1
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!
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
- Offline
- Premium Member
Less
More
- Posts: 118
- Thank you received: 49
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.
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.
- Ben_V
- Offline
- Platinum Member
Less
More
- Posts: 1223
- Thank you received: 351
10 years 3 months ago - 10 years 3 months ago #102274
by Ben_V
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)
Replied by Ben_V on topic Basic Export to Excel
Hello,
I suppose you may be interested in these thread
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
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 27
- Thank you received: 1
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...
In terms of the suggestion by Ben_v - thanks! Will check that out too...
The topic has been locked.