1
allein
How to add a bunch of users to xoops
  • 2008/7/11 9:02

  • allein

  • Just popping in

  • Posts: 15

  • Since: 2006/12/13


I don't know if there is a way to add bunch of users to XOOPS now? Say, via a csv file, or a tabbed txt file, or an Excel sheet.

If there is a way to do what I ask here, please LMK. TIA.

2
Nick_James
Re: How to add a bunch of users to xoops

I would like to know that also.

You can probably do it with SQL script file.

Here is a bit of SQL script used by the vl weather module to create the database and to then load in the data. You would just need to load in the data.

Section to creat the table

CREATE TABLE stations (
icao varchar(4) NOT NULL default '',
name varchar(255) NOT NULL default '',
cc char(2) NOT NULL default '',
country varchar(128) NOT NULL default '',
locshort varchar(40) default NULL,
zone varchar(6) default NULL,
PRIMARY KEY (icao),
UNIQUE KEY icao (icao),
KEY cc (cc)
) TYPE=MyISAM;


Followed by the data list.
#
# Dumping data for table `stations`
#

INSERT INTO stations VALUES ('OAFZ', 'Faizabad', 'AF', 'Afghanistan', NULL, NULL),
('OAFR', 'Farah', 'AF', 'Afghanistan', NULL, NULL),
('OAHR', 'Herat', 'AF', 'Afghanistan', NULL, NULL),
('OAJS', 'Jabul-Saraj', 'AF', 'Afghanistan', NULL, NULL),
Nicholas James
President - LaDads
www.ladads.info

3
Nick_James
Re: How to add a bunch of users to xoops

The table would by {your prefix)_USERS

And the fields are:

Field Type Attributes Null Default Extra Action
uid mediumint(8) UNSIGNED No auto_increment Browse Change Drop Primary Index Unique Fulltext
name varchar(60) No Browse Change Drop Primary Index Unique Fulltext
uname varchar(25) No Browse Change Drop Primary Index Unique Fulltext
email varchar(60) No Browse Change Drop Primary Index Unique Fulltext
url varchar(100) No Browse Change Drop Primary Index Unique Fulltext
user_avatar varchar(30) No blank.gif Browse Change Drop Primary Index Unique Fulltext
user_regdate int(10) UNSIGNED No 0 Browse Change Drop Primary Index Unique Fulltext
user_icq varchar(15) No Browse Change Drop Primary Index Unique Fulltext
user_from varchar(100) No Browse Change Drop Primary Index Unique Fulltext
user_sig tinytext No Browse Change Drop Primary Index Unique Fulltext
user_viewemail tinyint(1) UNSIGNED No 0 Browse Change Drop Primary Index Unique Fulltext
actkey varchar(8) No Browse Change Drop Primary Index Unique Fulltext
user_aim varchar(18) No Browse Change Drop Primary Index Unique Fulltext
user_yim varchar(25) No Browse Change Drop Primary Index Unique Fulltext
user_msnm varchar(100) No Browse Change Drop Primary Index Unique Fulltext
pass varchar(32) No Browse Change Drop Primary Index Unique Fulltext
posts mediumint(8) UNSIGNED No 0 Browse Change Drop Primary Index Unique Fulltext
attachsig tinyint(1) UNSIGNED No 0 Browse Change Drop Primary Index Unique Fulltext
rank smallint(5) UNSIGNED No 0 Browse Change Drop Primary Index Unique Fulltext
level tinyint(3) UNSIGNED No 1 Browse Change Drop Primary Index Unique Fulltext
theme varchar(100) No Browse Change Drop Primary Index Unique Fulltext
timezone_offset float(3,1) No 0.0 Browse Change Drop Primary Index Unique Fulltext
last_login int(10) UNSIGNED No 0 Browse Change Drop Primary Index Unique Fulltext
umode varchar(10) No Browse Change Drop Primary Index Unique Fulltext
uorder tinyint(1) UNSIGNED No 0 Browse Change Drop Primary Index Unique Fulltext
notify_method tinyint(1) No 1 Browse Change Drop Primary Index Unique Fulltext
notify_mode tinyint(1) No 0 Browse Change Drop Primary Index Unique Fulltext
user_occ varchar(100) No Browse Change Drop Primary Index Unique Fulltext
bio tinytext No Browse Change Drop Primary Index Unique Fulltext
user_intrest varchar(150) No Browse Change Drop Primary Index Unique Fulltext
user_mailok tinyint(1) UNSIGNED No 1
Nicholas James
President - LaDads
www.ladads.info

Login

Who's Online

227 user(s) are online (128 user(s) are browsing Support Forums)


Members: 0


Guests: 227


more...

Donat-O-Meter

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

Latest GitHub Commits