phpBB Importer Ready!

UPDATE: Please make sure to read the last posts. The beginning of the thread is kinda old, so please don't think this is how it works. Read the last posts.

----------------------------------

Hello. This is my first time posting here, so I hope I make a good first impression

Anyways...I just finished my phpBB 1.4.0 Convertor Utility, allthough I don't have an actual phpBB 1.4.0 DB to test it on. All I did was use a DB with 2 forums, one topic, and one post . Anyways, if you have phpBB 1.4.0, or any other kind of phpBB (Convert it to 1.4.0, of course ), please please help me test this.

If you find an error or some way of crashing or messing up the process, please tell me what happened. Also, if you could send me a copy of the database you are using, that would be greatly appreciated. Please don't think I'll steal your PWs, because they are MD5 encoded.

Known Bugs:

• Does not make private forums private while converting

When it is converting, all the user passwords are changed to a different md5-encoded string. I plan to change this later.

I know it isn't very user friendly. Also, please don't take any part of this code without my permission. I worked really hard on it. Thanks a bunch.

Please post anything you have to say about this below.

[Juan]

Just tried it. All members where imported correctly, but no posts.

This is the url: http://www.christopherleeweb.com/forums

[Hawkeye]

I'm having the same problem. Everything is imported correctly but no posts appear in any of the threads. Any ideas?

[Juan]

Yes, on mine you get the correct forum names but no threads in the forums.

[greenland]

I need to convert my Ikonboard to vB real soon, is there someone who can give an advice ??

Thanks in advance !

[Nebula]

No posts?? I'll go check it out. Also, please clearly state any problems. Don't just say oh, by the way, blah de dah .

Thanks. I'll go work on it.

[greenland]

My current state:
I was able to convert my users already.

Now I have to convert 40.000 posts from my Ikonboard 2.1.8 to vB, I don't know how to do it, because I don't know if there are several tables or only on I have to deal with on the vB side.

[Hawkeye]

Nebula, when I run the convertor all the information is transferred from phpbb to vb apart from the posts themselves. Information is not being copied from the post_text field of phpbb to the pagetext field of vb. I've done a clean install of both boards and it doesn't clear the problem.

[JamesUS]

greenland: An official ikonboard -> vB converter is in the works, however at this time there is no ETA.
If you want to do the posts yourself you need to look at the post and thread tables.

[Nebula]

Hey. Here's a quick status update. The new version is almost complete. It fixes numerous bugs (Including the no-show threads). The visual output of the script has also improved.

You can expect the new version to be released late tonight, or sometime tomorrow. It is looking really good, I must say.

Post any problems or comments you may have here!!

[Nebula]

Forget about what I said about being almost complete. Something big just came up. Anyways...here's the current version. Styles don't work, and I am investigating why. If anyone knows why...PLEASE, please tell me. Also, test this and let me know how it all works out...

[Nebula]

Well, I think this script is finally done!! I have completed everything I wanted to. Please download this file and run it. It also has a feature that I have disabled in this version. Let me explain.

phpBB uses the MD5 encryption algorithm to encrypt passwords. If you know this function, you know that it cannot be decrypted. The script randomly generates the user a new password, and then will email them their new password. That is disabled, just so you don't have to, just because you are testing it, and are not seriously doing this.

If you want to remove that, just surf to Line 192, and remove the comment at the beginning of the line. And remove Line 193 completely. That will let you access the mailer function. I have not tested this, and ANY HELP WITH IT WILL BE GREATLY APPRECIATED!!

Anyways, please test this. If all goes well, I will send this to the vBulletin Developers. I think it is complete. If you think it is missing something, please PLEASE tell me!! I really want this thing to be done!! Thanks all.

Well, what are you doing?? GET DOWNLOADING!!!!!

Hi,
Your work on the import of the phpBB is very nice ;-)
and i love it !

I try your last version, but i have some problems... (20 forums, 200 users, 1100 posts)
- In the table forum, all the fields replycount lastpost lastposter threadcount allowposting have the value ZERO ! and of course, i see the value 0 in my browser for all this relatives fields.
- When i want to open a topic for read posts, i can see posts, but i have a warning for every posts in a topic (Warning: unexpected error in date() in C:\InetPub\wwwroot\vbulletin-fr\upload\admin\functions.php on line 1209).
(I make all my tests of importation on a new fresh and correct install of VB 2.0.1)

I think the importation of style is not very important, because it is very difficult to have a good importation from phpBB to VB. I have skip this code and my importation is ok (style does not change). I prefere a good import of posts, PM, topics, category...

Have a nice day and sorry for my english
JY

[Nebula]

I just looked at my code, and I cannot find the problemwith the allowposting equalling 0. However, all the others should be null. Did you:

• Download the newest version? (The one right before your post is the newest one)
• Complete the final step (Including updating all the counters)?

As for the dates...that has been fixed. There was a problem with them, and it was fixed in the version above your post. It is very important to update all the counters in the order specified. You must update Users, then Threads, and then Forums, and then Rebuild the Search Index.

The reason you need to update all the counters is that none of the lastpost/lastpostuserid/etc... is inserted is because vBulletin's BBimport system feels you shouldn't. They only import the necessary data. The other code would take additional queries, and I wanted this to run as clean as possible. Also, when you finish an import, you should ALWAYS update your counters and rebuild your search index anyways, so having the script import the lastpost stuff is almost completely pointless (That's my Humble Opinion...).

Anyways...try my newest version if you haven't. If you were using the newest version that I released last night...well...hmm. I guess you should send me your phpBB database, and I'll run the script on it, and I'll see what's wrong.

Thank you for helping to test my script!!

Nice !!! all is fine (style also !!)
My mistake was that i don't rebuilt index for counter...i think that it was automatic...i am stupid
This is a great utility for all proprietary of phpBB forum.

My phpBB forum is here

Now, with your help and your scrip, i hope to switch in VB in the next week.

Thank you very much for your help and your support !

[Nebula]

Hey...No problem. Helping people is what I like to do.

I'm gonna wait for a few more people to test this, and then I'm gonna take out all the development stuff, maybe comment it, and then sent it to the vBulletin Dev Team. Hopefully, they will like it

Thanks for your support. If you have phpBB, and haven't started testing the final version, please do.