1
felicruel
Add users with script...
  • 2006/11/23 12:31

  • felicruel

  • Just popping in

  • Posts: 2

  • Since: 2006/11/23


Hi!!!

I need add 4300 users in my xoops!!! how I can make one script?

2
jdseymour
Re: Add users with script...

Probably the easiest way would be to export all the user and groups tables and track the setting for a sample registered user, then create an insert statement for each of the relevant tables.

3
felicruel
Re: Add users with script...
  • 2006/11/23 12:54

  • felicruel

  • Just popping in

  • Posts: 2

  • Since: 2006/11/23


I am inexperienced!!!! Export all the user and groups tables... How?...It can detail more?

4
christian
Re: Add users with script...
  • 2006/11/23 13:07

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


Click on my signature

5
jdseymour
Re: Add users with script...

You can view and export these tables in phpmyadmin.


You would weant to look at:

(your-prefix)_users
" _groups_users_link

And that may be the important ones in XOOPS 2.0x (2.2x would be different). May be best to do some reading on mysql, or get an experienced MySQL user to create the script for you.

6
red_Slider
Re: Add users with script...

yes, first export it from oryginal database, then change prefix, an at last import it into new db.

If U will have some problems or need help I can help U - 4 free o course!

Up the XOOPS!

7
preachur
Re: Add users with script...
  • 2006/11/29 0:40

  • preachur

  • Just can't stay away

  • Posts: 525

  • Since: 2006/2/4 4


There is a script.... Just edit the database info and upload it. Then you need a csv file called "users.csv" Then you just open the script in a browser. I just haven't figured out exactly how to set up the .csv values correctly yet. Every time I run it I get 9000 people with the username "admin"

If you want to try it download it here:
http://dev.xoops.org/modules/xfmod/pr ... 61&release_id=786&dl=2160

and if anyone else has any other hints, I too would appreciate them.
Magick can never be restrained, but when freely given is thrice regained!

Login

Who's Online

63 user(s) are online (36 user(s) are browsing Support Forums)


Members: 0


Guests: 63


more...

Donat-O-Meter

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

Latest GitHub Commits