Importing Yahoo Group Member List

[spcover]

I've been working on a site for a friend who has a pretty successful Yahoo Group. During the past six months, we've installed vBulletin 2.8 and then the VBPortal system at phpportals.com over it. So far it is looking good.

Now we want to try to move the Yahoo Group activity over to the vBulletin-based system. There are over 1,000 members in the Group.

I can download the Yahoo Group member list and convert it to a series of INSERT statements. But I need help with constructing the INSERT statements.

For one, I don't understand the numerics on many of the fields and more importantly I certainly don't know how to encrypt a password. This is an example of a phpMyAdmin dump of an INSERT statement for my user record in our vBulletin site:

INSERT INTO user VALUES (3, 6, 'sean, '435599a6845186f3ca42dca51174e8a4', 'sean@yahoo.com', 2, '', 0, 'http://www.yahoo.com', '', '', '', 'Scarsdale Technologies, Inc.\r\nhttp://www.yahoo.com', 1, 0, 0, 'Webmaster', 1, 1033611785, 1, -1, 1046835562, 1047005472, 1042211321, 4, '-5', 1, '2', '', '', 1, 1, 1, 33, 15, '0000-00-00', -1, 1, '', 0, 1, 0, 0, '');

Now, the Yahoo Groups member download file provides very little data. Here is my data record there:

'sean,'sean@yahoo.com','','M','','','Special Notices','Normal','7/10/2001'

It is basically the Username, Email Address, Sex, and Date Joined. No password is provided.

So to convert the Yahoo list, I'd need to make up a password for each user. Let's say, for the conversion, I would make both their new VBulletin username and password equal to their Yahoo name.

Can you help me?

I need an example of the statements required to encrypt the new password (in this instance, it'd temporarily be equal to the username) and to INSERT the new record into the User table.

Thanks much.

Sean