- Posts: 1
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
1 survey and fetch data like course title, teacher from another DB/source
- medarob
- Topic Author
- Offline
- New Member
Less
More
2 years 11 months ago #215504
by medarob
1 survey and fetch data like course title, teacher from another DB/source was created by medarob
Hi,
I have the following scenario:
We want to create a feedback form for courses. Data to each course like title, name of the teacher, starttime and endtime etc. is stored in a seperate DB.
The questions are the same for each course, only the title, teacher, starttime, endtime differs from each other.
Now, we don't want to manually create a survey for each course. That would be hundreds of surveys...The idea is to create 1 survey and pass information like the course title, organisator into the survey.
Now I read, that it should be possible to add a parameter to the url and that parameter could be used in the survey.
Would it work to add all necessary informations as seperate parameter to the limesurvey url and display them in the survey? With this approach it's possible to manipulate the parameter I guess...
Another idea: Can Limesurvey connect to another DB with, for example, the courseID to fetch the necessary informations?
Those informations should furthermore be stored in the limesurvey DB so that it's possible to see which feedback was given for each course.
I have the following scenario:
We want to create a feedback form for courses. Data to each course like title, name of the teacher, starttime and endtime etc. is stored in a seperate DB.
The questions are the same for each course, only the title, teacher, starttime, endtime differs from each other.
Now, we don't want to manually create a survey for each course. That would be hundreds of surveys...The idea is to create 1 survey and pass information like the course title, organisator into the survey.
Now I read, that it should be possible to add a parameter to the url and that parameter could be used in the survey.
Would it work to add all necessary informations as seperate parameter to the limesurvey url and display them in the survey? With this approach it's possible to manipulate the parameter I guess...
Another idea: Can Limesurvey connect to another DB with, for example, the courseID to fetch the necessary informations?
Those informations should furthermore be stored in the limesurvey DB so that it's possible to see which feedback was given for each course.
The topic has been locked.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10109
- Thank you received: 3593
2 years 11 months ago #215510
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Replied by tpartner on topic 1 survey and fetch data like course title, teacher from another DB/source
1) Here is the manual section on prefilling via URL -
manual.limesurvey.org/URL_fields
2) LimeSurvey cannot connect to another database. A solution may be to make an AJAX call to a remote file that queries that database.
2) LimeSurvey cannot connect to another database. A solution may be to make an AJAX call to a remote file that queries that database.
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11658
- Thank you received: 2742
2 years 11 months ago #215544
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic 1 survey and fetch data like course title, teacher from another DB/source
You could think of using tokens with a high number of "uses left".
Then in the token table you could store the course instead of a person, with custom attributes, etc. Of course you couldn't use tokens for the participants then, but if you would use tokens anyway, then you could include the course for each student in the token table anyway. So I assume you are using an open survey that anyone that has the link can answer.
You still would have to transfer the courses from your database to the token table and then create/copy the URL including the token for each course.
Then in the token table you could store the course instead of a person, with custom attributes, etc. Of course you couldn't use tokens for the participants then, but if you would use tokens anyway, then you could include the course for each student in the token table anyway. So I assume you are using an open survey that anyone that has the link can answer.
You still would have to transfer the courses from your database to the token table and then create/copy the URL including the token for each course.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.