Membership registration with existing membership database
I have an existing membership database (600 member dog club) used by the club secretary. This database (Excel spreadsheet) contains basic membership information including email addresses for about 87% of the members and a unique ID number. I have added Password, UserName & UserLevel columns and imported it into my online MySQL database .
I want to create a user login app. Using WA SecurityAssist I have created the applicable pages. I have marked UserName to be unique.
After manually adding a Password & UserName into the database I tested the WA SecurityAssist LogIn & Profile pages and they are working fine (Hooray).
This Login/Registration process is for existing members only, there is a separate manual process for folks to apply for membership.
How can I modify/use the Registration page to utilize the existing database and only allow registration for those already in the database?
One tedious option I thought about because of my lack of programming skills was to create random Passwords & UserNames in the database records and mail merging them into an email to send to the users. A lot of work for 600 people and users would not be able to choose there UserName.