1
Cuidiu
Adding Registered Users
  • 2006/5/15 20:58

  • Cuidiu

  • Quite a regular

  • Posts: 358

  • Since: 2006/4/23


I just received a final count - approximately 245 users that I will need to add to XOOPS. I have an csv file but need help with the best way to import the most information. I'm using extended profiles module. Is there a way to import directly to the database via phpMyAdmin? It looks like there are two areas where user information is stored (_users and user_profile?) and I am not a database person but willing to give it a try if it will simplify adding this many users to XOOPS. Does anyone have any suggestions short of entering these manually? I've looked at some of the importer scripts, read some of the threads but I haven't found anything that addresses 2.2.4 with extended profiles. Would appreciate any hints.

Thanks.
[size=x-small]Working sites:
XOOPS 2.0.16 PHP 5.2.2, MySQL 5.0.24a-standard-log, Apache/2.0.54 (Unix)
XOOPS 2.2.4, PHP 4.3.10, MySQL 3.23.58, Apache/1.3.33 (Unix)[/size]

2
christian
Re: Adding Registered Users
  • 2006/5/15 21:24

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


This script import users from a csv file , but for XOOPS 2.0.x only

it would have to be modified to adapt it to the extended profiles, but in this moment I am very occupied. (sorry )

3
Cuidiu
Re: Adding Registered Users
  • 2006/5/15 21:43

  • Cuidiu

  • Quite a regular

  • Posts: 358

  • Since: 2006/4/23


Thanks christian. I did see that before I posted (and read several posts) and knew it would be different for 2.2.4. I was just hoping someone could steer me in the right direction. Thanks anyway.

Quote:

christian wrote:
This script import users from a csv file , but for XOOPS 2.0.x only

it would have to be modified to adapt it to the extended profiles, but in this moment I am very occupied. (sorry )
[size=x-small]Working sites:
XOOPS 2.0.16 PHP 5.2.2, MySQL 5.0.24a-standard-log, Apache/2.0.54 (Unix)
XOOPS 2.2.4, PHP 4.3.10, MySQL 3.23.58, Apache/1.3.33 (Unix)[/size]

4
christian
Re: Adding Registered Users
  • 2006/5/15 22:12

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


For each user read in the script you can to make 2 insert order

- one for the xoops_users table
- one for the extended profile table

After the script make a insert in the xoops_groups_users_link (group users registered)

5
Cuidiu
Re: Adding Registered Users
  • 2006/5/15 22:23

  • Cuidiu

  • Quite a regular

  • Posts: 358

  • Since: 2006/4/23


Thanks again christian. I had downloaded that script earlier today to have a look. Unfortunately, I'll probably need more hand-holding than your time allows you right now so perhaps when you have more time, I can ask your help then...?
Quote:

christian wrote:
For each user read in the script you can to make 2 insert order

- one for the xoops_users table
- one for the extended profile table

After the script make a insert in the xoops_groups_users_link (group users registered)
[size=x-small]Working sites:
XOOPS 2.0.16 PHP 5.2.2, MySQL 5.0.24a-standard-log, Apache/2.0.54 (Unix)
XOOPS 2.2.4, PHP 4.3.10, MySQL 3.23.58, Apache/1.3.33 (Unix)[/size]

6
hkfind
Re: Adding Registered Users
  • 2006/6/9 7:46

  • hkfind

  • Just popping in

  • Posts: 12

  • Since: 2006/2/8 1


I have the same problem, how can I modify the import_users.php for XOOPS 2.2.x ?

Login

Who's Online

187 user(s) are online (122 user(s) are browsing Support Forums)


Members: 0


Guests: 187


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