- Posts: 2
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Lookup / autocomplete from database
- klaster
- Topic Author
- Offline
- New Member
Less
More
1 month 4 weeks ago #257724
by klaster
Lookup / autocomplete from database was created by klaster
Looking for an option to auto-fill open-ended quation value with previously recorded values (specifically - street addresses).
Addresses are now stored in CSV file and approx 2.6 million rows so having it javascript (pre-loaded in page) is out of question.
Does Limesurvey provide any options for looking the values up from local database (mysql, sqlite etc). There is one workaround for a (very) old version () is this still relevant or is there some new version around?
Addresses are now stored in CSV file and approx 2.6 million rows so having it javascript (pre-loaded in page) is out of question.
Does Limesurvey provide any options for looking the values up from local database (mysql, sqlite etc). There is one workaround for a (very) old version () is this still relevant or is there some new version around?
Please Log in to join the conversation.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10109
- Thank you received: 3595
1 month 4 weeks ago #257725
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 Lookup / autocomplete from database
Not built-in. In my opinion, you will need to make an AJAX call to a remote file which queries your DB.
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: DenisChenu
Please Log in to join the conversation.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12943
- Thank you received: 3979
1 month 4 weeks ago #257727
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Lookup / autocomplete from database
Hi,
but which version are you using?
In my opinion there is no reason why the solutions in the workaround section.
I still use the first two, but I will give the MySQL solution a try.
Joffm
but which version are you using?
In my opinion there is no reason why the solutions in the workaround section.
I still use the first two, but I will give the MySQL solution a try.
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The following user(s) said Thank You: DenisChenu
Please Log in to join the conversation.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
1 month 4 weeks ago #257748
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Lookup / autocomplete from database
What do you mean by "autofill" ?
Something like that : demo.sondages.pro/699888
gitlab.com/SondagesPro/QuestionSettingsT...tQuestionByResponses
Something like that : demo.sondages.pro/699888
gitlab.com/SondagesPro/QuestionSettingsT...tQuestionByResponses
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Please Log in to join the conversation.
- klaster
- Topic Author
- Offline
- New Member
Less
More
- Posts: 2
- Thank you received: 0
1 month 3 weeks ago #258071
by klaster
Replied by klaster on topic Lookup / autocomplete from database
the solution does seem suitable, although i am a bit worried about the size of my lookup array (1.2M unique addresses). I see the plugin is for LS v5, any plans/options to run it under LS v6?
Please Log in to join the conversation.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
1 month 3 weeks ago #258082
by DenisChenu
And if add a limit : need an order (by population ?)
When i have time or a client need it.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Lookup / autocomplete from database
Maybe need to add a limit to 10 (or a parameters) on the request, but can be tested without.the solution does seem suitable, although i am a bit worried about the size of my lookup array (1.2M unique addresses).
And if add a limit : need an order (by population ?)
Surely,I see the plugin is for LS v5, any plans/options to run it under LS v6?
When i have time or a client need it.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Please Log in to join the conversation.