Any suggestions on an approach to register members in mass from data stored in an external file. I have a 200+ membership-based organization that I have created a DNN portal for to handle member communications, interactions, file sharing, etc. All my membership info (names, addresses, emails) is currently in an an Excel spreadsheet. These people are literally all over the country and I know if I try to commnicate with them and tell them how to register, not only is it going to take too long because some people just don't response to email, but I'm going to get bombarded with questions from the techno-illiterates who can't seem to do it.
Personally, I don't care if there are individuals who never actually visit and use the portal, but I want all my membership info centralized in one repository rather than having some in Excel, some in my portal database etc.
So, I want to take my Excel data, upload it into my portal database as new registrations and then send a mass email to everyone telling them they've been registered, how to login, and by the way, you're now responsible for keeping up your own contact data. So if you move or change emails and don't update it, you won't receive the organizations mailings in the future.
I've looked at and deciphered the aspnet_membership table in enough detail to be able to query it and use an XML/XSL module to display a member directory in my portal. But if anyone can give me suggestions or sample code on how to do a mass upload/registration, I would appreciate it.