1
dheltzel
Bulk loading site members
  • 2004/7/18 22:14

  • dheltzel

  • Not too shy to talk

  • Posts: 164

  • Since: 2003/1/8 1


I am planning to load a large number of members into an XOOPS instance from a database. I think that I only need to insert records into the users and groups_users_link tables for each user. Am I missing any other steps?

Also, I assume the password is just a MySQL MD5 hash. Is that correct also?

Is there an existing PHP function to add a user that is better than using SQL inserts?

Thanks!

Dennis

2
spitfire
Re: Bulk loading site members
  • 2004/7/30 21:28

  • spitfire

  • Just popping in

  • Posts: 8

  • Since: 2003/9/24


If there is a better way, I haven't found it. I exported the users table to CSV. Then using one user line as a guide, I used Excel to populate rows with the information (userid, pw etc.) Saved this to CSV and imported back to the table. Did the same with groups table. Seemed to work fine.

Rob

3
jmass
Re: Bulk loading site members
  • 2004/7/30 21:45

  • jmass

  • Friend of XOOPS

  • Posts: 524

  • Since: 2003/12/18


I am going to have to do the sme thing in about 2 weeks. I was planning on manual SQL inserts too.

If there is a better way I am not aware of it.

JMass

4
christian
Re: Bulk loading site members
  • 2004/7/30 22:09

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


Yous can use this free script from csv file : csv importer.

Christian

Login

Who's Online

222 user(s) are online (142 user(s) are browsing Support Forums)


Members: 0


Guests: 222


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits