Welcome to the LimeSurvey Community Forum

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

Using external data source for piping

  • external_eval
  • external_eval's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 10 months ago #228527 by external_eval
Using external data source for piping was created by external_eval
Please help us help you and fill where relevant:
Your LimeSurvey version: 3.28.3+220315
Own server or LimeSurvey hosting: My own
Survey theme/template: Fruity (or extensions of this theme)
==================
Hi all,
Can I use a data source from outside the survey, for example, stored in a CSV, for piping the data from this source into questions based on the respondent's answers?
For instance, if the data is  
ID,name,address
10, Tom, Maple Street
and the respondent fills in "10" as an answer, it'll return "Tom" or "Maple Street" through lookup in other questions or tips according to the need of the name or address.

Normally, I would use the attributes of the respondent for this purpose but in this case, the survey needs to be open.
Thank you!
Jakub

Please Log in to join the conversation.

  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 10 months ago #228537 by tpartner
Replied by tpartner on topic Using external data source for piping
This will require some JavaScript development using jQuery to retrieve the CSV contents and something like jquery.csv to perform the lookups.

Here are a couple of related posts:

- forums.limesurvey.org/forum/can-i-do-thi...ry-from-table#225449

- forums.limesurvey.org/forum/can-i-do-thi...zoom-onto-map#197130

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The following user(s) said Thank You: external_eval

Please Log in to join the conversation.

  • external_eval
  • external_eval's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 10 months ago #228582 by external_eval
Replied by external_eval on topic Using external data source for piping
Thank you Tony, I hope I'll make it work.

Please Log in to join the conversation.

  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 10 months ago #228585 by tpartner
Replied by tpartner on topic Using external data source for piping
Let me know how it works out. I'm on vacation so can't help with code but may in a week or so.

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.

Lime-years ahead

Online-surveys for every purse and purpose