PostNuke Members porting...

Posted: Thu Sep 04, 2003 7:33 am

Is there any way to port a Post Nuke membership database to PHPNuke? This is the last step in our migration, but we're having some trouble getting the members moved over. We have over 800, so I really can't trash them all and start over. Any help would be appreciated.

Posted: Thu Sep 04, 2003 8:39 am

Make a backup of PostNuke's nuke_users table with phpMyAdmin, make sure you select "complete inserts", the backup will have the table's structure and insert lines for all users, these will look something like:

Code:

INSERT INTO `nuke_users` VALUES (1, '', 'Anonymous', '', '', '', 'blank.gif', '1055706103', '', '', '', '', '', 0, 0, '', '', '', '', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, '12.0');

Copy those insert lines into a separate file and insert between `nuke_users` and VALUES the following:

Code:

(user_id, name, username, user_email, femail, user_website, user_avatar, user_regdate, user_icq, user_occ, user_from, user_interests, user_sig, user_viewemail, user_theme, user_aim, user_yim, user_msnm, user_password, storynum, umode, uorder, thold, noscore, bio, ublockon, ublock, theme, commentmax, counter, user_timezone)

so that they will now look something like:

Code:

INSERT INTO `nuke_users` (user_id, name, username, user_email, femail, user_website, user_avatar, user_regdate, user_icq, user_occ, user_from, user_interests, user_sig, user_viewemail, user_theme, user_aim, user_yim, user_msnm, user_password, storynum, umode, uorder, thold, noscore, bio, ublockon, ublock, theme, commentmax, counter, user_timezone) VALUES (1, '', 'Anonymous', '', '', '', 'blank.gif', '1055706103', '', '', '', '', '', 0, 0, '', '', '', '', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, '12.0');

After you have created Nuke's database tables you can use the modified insert lines to load your users, by default Nuke creates an anonymous user so remove the anonymous user from your insert lines, no need for duplicates. Good luck.

Posted: Thu Sep 04, 2003 10:58 am

Thanks man! Got it smooth as silk! All their passwords & such will remain?

Posted: Sat Sep 06, 2003 12:46 pm

The userlist should transfer intact password and all.

Nuke Cadet Joined: Aug 30, 2004 Posts: 1

Is there a way to transfer Postnuke news and links to Nuke?

Thanks,

Mark