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.

Can you provide a sample survey (.lss file) containg only the relevant question and a sample CSV file?

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 ?

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 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 csv will have about 1000 lines.

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.

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).

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.

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.

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.

Good to know. I will relay this to my tech person.