xoops forums

knarf

Just popping in
Posted on: 2005/3/2 19:15
knarf
knarf (Show more)
Just popping in
Posts: 12
Since: 2005/3/2 1
#1

Creating users in mass

Hi there,

Is there any script (i supose it has to be done within MySQL) to create a lot of users in once? I've got al users in a excel sheet and want to create them in once instead of manually doing it.

I would be very thankfull if anyone has such a script for me!

Frank

simonfoley

Just popping in
Posted on: 2005/4/28 8:50
simonfoley
simonfoley (Show more)
Just popping in
Posts: 18
Since: 2005/3/14
#2

Re: Creating users in mass

I am looking for the same thing. Any ideas?

christian

Just can't stay away
Posted on: 2005/4/28 11:24
christian
christian (Show more)
Just can't stay away
Posts: 401
Since: 2002/2/24
#3

Re: Creating users in mass

Hi

I made a package whith a flat file, where the users file contains only : user, name, email.

If not email in file, this is created automatically with your domains.

You can download here

Best regards

simonfoley

Just popping in
Posted on: 2005/5/2 12:18
simonfoley
simonfoley (Show more)
Just popping in
Posts: 18
Since: 2005/3/14
#4

Re: Creating users in mass

Christian

This looks great. I downlaoded the file, but there are no instructions on how to use it.

Sorry, can you explain very briefly?

I hope so.

Best wishes

Simon

rowdie

Just can't stay away
Posted on: 2005/5/2 12:48
rowdie
rowdie (Show more)
Just can't stay away
Posts: 846
Since: 2004/7/21
#5

Re: Creating users in mass

Maybe this previous thread about Christian's script might help?

simonfoley

Just popping in
Posted on: 2005/5/4 17:43
simonfoley
simonfoley (Show more)
Just popping in
Posts: 18
Since: 2005/3/14
#6

Re: Creating users in mass

I had a look at this but there seem to be no instructions on how to do this. I can not believe that this has not been done often with xoops.

I am just as blank now.

Simon

christian

Just can't stay away
Posted on: 2005/5/4 18:56
christian
christian (Show more)
Just can't stay away
Posts: 401
Since: 2002/2/24
#7

Re: Creating users in mass

Hi Simon,

this script run so :

file : user2.csv
it contains user, name and email (optional)
the fields are separate with a semicolon

file : phpfile_users.php
you must personnalize the informations for connect your database (line 5 to 8)

line 40 : change email@domain.tld
if in the users'file email not exist, the script create automatically a email address

line 46 : password equal to user

file : bd_test.sql
use for test this script

Give me a description of your file , and I can analyze for import in your site.

simonfoley

Just popping in
Posted on: 2005/5/5 8:39
simonfoley
simonfoley (Show more)
Just popping in
Posts: 18
Since: 2005/3/14
#8

Re: Creating users in mass

Wow, great. You are a star for taking the time for this. I will be preparing the info over the next few days and then will give it a go. Thanks in advance.

Simon

tedsmith

Home away from home
Posted on: 2005/8/15 9:39
tedsmith
tedsmith (Show more)
Home away from home
Posts: 1151
Since: 2004/6/2 1
#9

Re: Creating users in mass

Hi guys.

I also have a requirement to import users in bulk from a comma deliminated text file that contains user registrations from an old web site (see this earlier post). In my case, the fields I have are as follows :

[b]UsernamePasswordReal NameE-Mail address[/b]


The trouble I have is that I have to keep the usernames and the passwords that have already been allocated from the old site the same (to avoid re-emailing them all to tell them what their new details are), whereas the script appears to assign the value of $user as the value for $password.

Can anyone tell me how to change the script file so that all it does is import the 4 values into the XOOPS registration system straight from the file without changing them? A cut and paste would be lovelly because I am not a PHP writer, or MySQL (in fact, I'm quite useless!)

Thanks

Ted

tedsmith

Home away from home
Posted on: 2005/8/15 12:46
tedsmith
tedsmith (Show more)
Home away from home
Posts: 1151
Since: 2004/6/2 1
#10

Re: Creating users in mass

Quote:

Can anyone tell me how to change the script file so that all it does is import the 4 values into the XOOPS registration system straight from the file without changing them?


??