Welcome to the LimeSurvey Community Forum

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

autocomplete and autofill in 4.xx

More
4 years 1 month ago #218038 by palsboard
We need to ask our students to fill out their ID in the first column and the other two columns containing their email and name will be autofilled from a dataset (CSV) that we maintain. How can we do this? If you could provide an lsq that would be much appreciated. We are running 4.1. Thank you.
The topic has been locked.
More
4 years 1 month ago #218047 by tpartner
Can you provide a sample survey (.lss file) containg only the relevant question and a sample CSV file?

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: palsboard
The topic has been locked.
More
4 years 1 month ago #218052 by DenisChenu
How many lines for the CSV ?

Else : No issue with private information ? Giving to all students the name and the email of all other student is not an issue ?

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
The following user(s) said Thank You: palsboard
The topic has been locked.
More
4 years 1 month ago #218059 by francisakabo
I want help with Question validation equation against .csv file.

I have a csv of staff IDs and corresponding names and I want some selected persons to enter their staff IDS in Question1 which should have a match in the CSV.

If there is a match, the answer to Question2 which is hidden should be populated with the corresponding name of the entered ID in the csv list.

If there is no match, user should be prompted to enter correct ID.

LimeSurvey Version 3.27.6+210629
The following user(s) said Thank You: palsboard
The topic has been locked.
More
4 years 1 month ago #218106 by palsboard
The student can only see their info and not everyone else's. If they mistype their id, they will have to doublecheck. Perhaps another way to get this is to have two matches or for them to enter their email address instead of their ID. Thanks for highlighting this risk.
The topic has been locked.
More
4 years 1 month ago #218107 by palsboard
The csv will have about 1000 lines.
The topic has been locked.
More
4 years 1 month ago #218108 by palsboard
We have set up a new instance on 5.0 and then now are setting up 4.xx instance because the 5.0 didn't work for the csv solution. I will send this to you shortly.
The topic has been locked.
More
4 years 1 month ago #218109 by holch

We have set up a new instance on 5.0 and then now are setting up 4.xx instance because the 5.0 didn't work for the csv solution. I will send this to you shortly.


If the CSV solution doesn't work in 5.x it most probably won't work in LS 4.x either, because actually LS 5.x is just a newer version of LS 4.x. There haven't been all that many changes, especially none that should influence if the CSV solutio works or not (not saying that it is impossible, but highly unlikely that the fault is with LS 5.x).

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The following user(s) said Thank You: palsboard
The topic has been locked.
More
4 years 1 month ago #218110 by holch

The student can only see their info and not everyone else's


How do you guarantee this? If I type any student ID, I might be able to access their data. Trial and error. So while one might not have access to ALL personal information of all students, depending on the structure of the student ID, one could get access to quite a few, I guess.

I am just imagining scenarios right now. This might not be a problem in your case, but guessing valid student IDs might not be so difficult.

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The topic has been locked.
More
4 years 1 month ago #218114 by tpartner
If the CSV is loaded via JavaScript, one could run code in the console to loop through all rows and print values to the console.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
More
4 years 1 month ago #218116 by palsboard
We are weighing the pros and cons. Perhaps they need to type in their last name and id. No data. This is just a registration form for a summer camp. No other data will be shown.
The topic has been locked.
More
4 years 1 month ago #218117 by palsboard
Good to know. I will relay this to my tech person.
The topic has been locked.
More
4 years 1 month ago #218123 by DenisChenu

The student can only see their info and not everyone else's. If they mistype their id, they will have to doublecheck. Perhaps another way to get this is to have two matches or for them to enter their email address instead of their ID. Thanks for highlighting this risk.
 
But :
  1. student can put any number and find the related data (holch point)
  2. You allow to load a CSV file via JS : this CSV file can be loaded by anyone looking at the url call. Too easy to get it directly (more quick than console from tparner)
A general system on privacy is "Asking less than you can : get only the minimal".

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
More
4 years 1 month ago #218127 by palsboard
Thanks everyone for your privacy concerns.

We need to ask for the ID (autocomplete) and email (autofill) to show so to ascertain that the student has filled the ID correctly and confirm their email. But if this is an issue with seeing other kids' info, we will not allow it.

The question remains. We have several other surveys that need the same mechanism of autocomplete and autofill but for a different set of data. Namely, the student will fill out an evaluation form for each workshop that they attend. We would like to make sure that when they enter the workshop ID, the name of the workshop can be autofilled so that they ascertain that they have typed in the correct workshop and can move on more quickly through the surveys.

Your help is much appreciated.

Attached is the LSS and the sample csv. The registration question group is what we would like help with on this thread. We will ask the second part in another thread.
The topic has been locked.
Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose