users
Permalink
I'm building a new site for a local club. This club has over 1000 members. Is there a way of importing all the members into the user database. I've got the userlist in a xls spreadsheet..
Any Ideas??
Thanks
Bob
Any Ideas??
Thanks
Bob
You would have to create a file of some kind to do this for you, which you could run as a job or a command line script. I have attached some code which would be close to what you are looking for, but would need to be tweaked for your needs.
Hi Hutman;
That's perfect.. Exactly what I needed
Thanks Again
Bob
That's perfect.. Exactly what I needed
Thanks Again
Bob
I see hutman has got you sorted but just out of interest my first thought was to use Excel formulae to build a string of MySQL commands that you execute on the Users table to add the data.
I just tried a quick test adding one user with SQL and it seemed to work but I have a feeling that this isn't good practice - can anybody think of a reason this would be a bad idea?
I just tried a quick test adding one user with SQL and it seemed to work but I have a feeling that this isn't good practice - can anybody think of a reason this would be a bad idea?
