Import only users

[openmind]

We have inherited the old userbase from another vbulletin forum. For various reasons we only have the users table so no forums, thread, posts etc.

Can Impex just import these users into a group we decide upon?

[Steve Machol]

No sorry. You would need a complete database.

[openmind]

Nuts. So my only option would be to write a compare/insert script. Not to worry, was worth a try

[Steve Machol]

Yes, you could write a custom script for this.

[openmind]

OK that's a plan. When inserting the new user into the existing users table, is there anywhere else we need to update or just the users table itself?

We'll be setting up a new group so I guess we just need the new user group ID for the insert correct?

[Steve Machol]

You will have to update three tables with the data for each member:

user
userfield
usertextfield

[openmind]

OK excellent, thanks Steve

I'll post a copy of the script here when I'm done. It will be in ColdFusion but it will give people the idea.

[openmind]

Well that worked a treat.

I've posted the ColdFusion script below if anyone wants it. Note that this assumes you only have the users table to work with and if you use and it breaks your stuff, don't blame me, I have bodyguards