11-01-2016, 11:10 AM
Well, here is what I'm thinking.
If that spreadsheet you have has people's email addresses, then that is the MOST secure way to do it. You could import that table into the db in phpmyadmin (as a csv file...super simple) and if you give me a sample of that file ... it doesn't even have to have the real info... I just need to know what the column names look like, I can write you a script that creates an account for every user and creates a mystery password that would be unknowable. From there, your users would try to login and they would be asked to verify their email and change their password.
If you don't have the email, I don't know how you would get the people their username...BUT if you have any other identifying info on the people, I could hash that together to generate a password kind of like you were talking about. The key is know what info you have on each person, so I could run a little test for you.
If that spreadsheet you have has people's email addresses, then that is the MOST secure way to do it. You could import that table into the db in phpmyadmin (as a csv file...super simple) and if you give me a sample of that file ... it doesn't even have to have the real info... I just need to know what the column names look like, I can write you a script that creates an account for every user and creates a mystery password that would be unknowable. From there, your users would try to login and they would be asked to verify their email and change their password.
If you don't have the email, I don't know how you would get the people their username...BUT if you have any other identifying info on the people, I could hash that together to generate a password kind of like you were talking about. The key is know what info you have on each person, so I could run a little test for you.