1
knarf
Creating users in mass
  • 2005/3/2 19:15

  • knarf

  • Just popping in

  • Posts: 12

  • Since: 2005/3/2 1


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

2
simonfoley
Re: Creating users in mass
  • 2005/4/28 8:50

  • simonfoley

  • Just popping in

  • Posts: 18

  • Since: 2005/3/14


I am looking for the same thing. Any ideas?

3
christian
Re: Creating users in mass
  • 2005/4/28 11:24

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


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

4
simonfoley
Re: Creating users in mass
  • 2005/5/2 12:18

  • simonfoley

  • Just popping in

  • Posts: 18

  • Since: 2005/3/14


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

5
rowdie
Re: Creating users in mass
  • 2005/5/2 12:48

  • rowdie

  • Just can't stay away

  • Posts: 846

  • Since: 2004/7/21



6
simonfoley
Re: Creating users in mass
  • 2005/5/4 17:43

  • simonfoley

  • Just popping in

  • Posts: 18

  • Since: 2005/3/14


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

7
christian
Re: Creating users in mass
  • 2005/5/4 18:56

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


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.

8
simonfoley
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

9
tedsmith
Re: Creating users in mass
  • 2005/8/15 9:39

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


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

10
tedsmith
Re: Creating users in mass
  • 2005/8/15 12:46

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


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?


??

Login

Who's Online

446 user(s) are online (316 user(s) are browsing Support Forums)


Members: 0


Guests: 446


more...

Donat-O-Meter

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

Latest GitHub Commits