Info
- 184 posts
- 45 voices
- Started 7 months ago by Anointed
- Latest reply from tate83
- This topic is not resolved
Introducing bbConverter - Convert your current forums for use with bbPress 2x
-
Can you send it to me aellis@trinnovations.com I will run test on it.
-
I received it and ran some tests the issue is: "I have firstly migrated the punbb to bbpress 1.1 so all the tables reflect that migration". Well the data in the table is wrong compared to a fresh bbpress and posts in it. The "post_position" column is always 1 on your site this is not accurate and causing part of your issues. I see "topic_poster" and "topic_last_poster" all 0 as well.
If you can send me your punbb database I can make a conversion file for it and will solve everything.
Anyone who is doing a two step process this to that to this please refrain from using my script and ask for the direct conversion file. Everything I have tested is fresh copies of each forum platform without ever being converted into and I haven't been able to get any issues.
Right now I have requests for phpbb3 and punbb. I need databases for these if you want to help speed up the process. I just need to test the phpbb3 and I can go live with it so if anyone has test data would be appreciated.
-
Is there a schematic for the bbpress forum/post/userlog/etc databases? I have a custom forum with a lot of posts that I'd like to import into bbpress but I'm going to be doing it myself. Is the code in your importer script clear enough so that I could do something?
It would be cool if there was a simple universal xml file one could create with all the data for bbpress and import it that way.
Thanks.
-
I would check out the "Example.php" file for info on how to create a converter. It is pretty self explanatory to any developer. We made it extremely easy to create conversion files. All you have to do is create the mapping and the system does everything else for you.
-
Version 1.3 Released:
phpBB3 now supportedpunBB is started and should be early next week.
Brilliant!
Not sure why nor do I care at this stage, just converted 30,000 posts, 6,000 topics & 2,000 users from phpbb to bbPress.
I haven't looked at users (or any db tables) just some posts and links are getting converted funkily:
Edit: Removed examples as formatting makes the issue extremely unclear
-
bbConverter FAQ/Known Issues 1.3 phpbb - bbpress
- Post URL's (**From post above this post)
The URL's from phpbb I thought were not getting migrated correctly when in fact they are, it is just that phpbb in its table lists the URL's rather oddly. When looking at URL's in the raw tables of phpbb they are in the following format:
<!-- m --><a class="postlink" href="http://example.com">http://example.com<!-- m --></a>
Need to strip the <!-- m --> & ' class="postlink"' before conversion either with bbconverter or firstly converting the links in phpbb before conversion- Poster IP Address is not migrated.
see this post.- Images and Attachments (and smilies) are not migrated.
see this post.- Existing Users
If a username already exists in wp_users the imported user will be named imported_username eg. If 'john' already exists will import as 'imported_john'- User Post Counts are not imported
When viewing /wp-admin/users.php each user post count is '0'
Ideally adding support to bbPress Core /wp-admin/tools.php?page=bbp-recount would fix that.
(I couldn't find where WP/BBP is keeping the total post count for a user though it is stored in phpbb_users user_posts)- Ophaned/Deleted User Posts:
If the user has been deleted from phpbb when bbConverter runs these posts will be imported into bbPress as userid '1' (i.e. 'Admin')- Time Zone
Ensure you have your WP install is set to the same Time Zone as phpbb to get correct post times- User Profile data AIM & YahooIM fields are migrated by Jabber is not
add the following code for 'jabber' to '/** User Section **********' of phpbb.php script below aim/yim
<br /> // User jabber.<br /> $this->field_map[] = array(<br /> 'from_tablename' => 'users', 'from_fieldname' => 'user_jabber',<br /> 'to_type' => 'user', 'to_fieldname' => 'jabber'<br /> );<br />- 'Quotes'
I haven't fully looked into how quote behavior works just yet, needless to say a workaround of sorts needs to be found for this.- Additional User Profile fields
Ideally would like to import phpbb_users user_from (phpbb User Localtion) field to wp_usermeta description (Thus eg. Melbourne, Australia is added to the WP user BIO). Unless of course there is a funky way to import 'User Location'(user_from), 'Signatures'(user_sig), 'occupation'(user_occ) & 'interests'(user_interests) all together into WP Bio?- User Stuff not migrated (No big deal IMHO)
User Subscribed Post, Favorite, Bookmarks, Private Messages, Rank
(I dont see much of that as a very big issue in my case, users can just start this stuff from scratch)And that's about all I have for now... Any ideas or other workarounds would all be well received and again thanks guys for this plugin and hope that now phpbb is there I can help contribute something back.
Cheers,
Stephen
-
Just understand very hard to be able to parse everything with all the different formats for every forum. I use a standard off the shelf parser class which doesn't catch everything. The parser will need to be expanded or edited to cover all cases I need help on this. Need the community to help maintain that. Add it once and it is added for everyone. Right now priority is PunBB then I can take a look at parser updates.
-
Looking for some conversion advice. Here is my current setup.
Server1: http://www.example.com - WordPress 3.3 only... no forums, no bbPress, no BuddyPress, etc..
Server2: forums.example.com - phpBB 2.0.23. No integration with WordPress.
Server3: db.example.com - The database server for both WordPress and phpBB.I'm looking to migrate from phpBB2 to bbPress. However I do *not* want my WordPress user table and my forums user table to commingle. After reading up on the conversion scripts available, the fact that bbPress 2 is a plugin and not standalone, etc I'm thinking that the following would be my best course of action.
1) Do a straight conversion from phpBB2 to phpBB3.
2) Install a new copy of WordPress on server2, get it up and running basic.
3) Install the bbPress plugin for WordPress on server2.
4) Run bbConverter to convert the (now) phpbb3 database to bbPress.
Does this sound like the best course of action? Anything anyone would suggest different?
-
Thanks for the info on the example conversion script.
Not sure if I'll be able to do what I need because PHP isn't my forte but I'll take an honest look!
It would be seriously cool if you'd put together a conversion from XML script. That way all anyone would need to do is export their forum data to xml in whatever way the conversion script needed.
Being able to use my data (learnjazzpiano.com has had it's forums going for 16 years) is the only thing holding me back from BBPress.
-
- Posted 5 months ago #
Are there plans to support standalone bbPress installs that have WordPress integration with the bbPress Integration plugin. I can convert everything but my users due to them residing in the WordPress database. Any insight on how I can accomplish this? Thanks!
-
- Posted 5 months ago #
@jermaine - Yours is the easiest conversion of all. Just opt to skip the user migration all together.
-
And its lost all the posting timestamps.... arrgg!!
This is importing from BBpress standalone.
http://wordbooker.tty.org.uk/supportforums/forum/wordbooker-general-chat-and-news/news-2/
shows the mess.
Oh and it would be great if you could chose which sort of users to bring over - like only bring over Active users rather than all of them.
-
Well, this was a mess. I went to bed during a conversion and the computer went to sleep too.
Apparently, clicking restart checkbox actually restarts converting the same forums again and so there were duplicates created. I deleted everything via the admin panel and started without clicking the restart started the conversion at the same place I left off of the second attempt but the forum slugs used -2 after all of the forums. I tried again checking "clean out" but this did not fix this -2 problem because the script picks up where things left off....
Should I go into the db and clear things out and start again?
Update: I just looked in the database and wp_bb_ tables are all empty. So, where are these forums being kept?
This is a multisite. WP 3.3. Conversion was (is??) vBulletin to bbPress. vBulletin was kept in its own database, separate from WP.
-
@shoo, 169k is nothing... I've got on with 3.5M posts and estimated it'll take almost a week to import... lol Got another one running right now that's got 300k and it's been running 22 hours and is maybe 2/3 the way done.
The problem is with the meta updates and the way WP stores that kind of stuff there's a boat load of inserting going on for every post. I'm hoping to take a look at the script in a few days to see if I can help it along.
@citizenkeith, if you are using the lastest version of the converter it should be pulling the correct dates. At least it is for VB now, where it wasn't on the last version.
-
I am trying to convert phpbb3 database and it goes quite smoothly BUT suddenly stops at some point when converting posts :(
Screen: http://forumpokerowe.com/obrazki/bbconverter_error_screen.gif
I've tried various 'Rows Limit' (50, 100, 200)
What am I doing wrong?I use:
WordPress 3.2.1
PhpBB 3.08
BBPress plugin 2.0.2
BBConverter 1.3 -
watch the last topic on phpmyadmin, you can try to delete this topic?
For me it's a disaster. 160 000 to upload messages, I left my pc tune 24 hours and my PC reboot, can not return, I must repeat: '(
but the links in the posts are broken, the smiley worse, it generates a link rambling ... even if this plugin is very generous and left a good feeling, that's 3 months I waited, finally, I'm at the point of give up and keep my phpbb, but if I have a holy horror!
-
@shooo
With a site that large and complex, I would probably suggest contacting AWJunkies on his bbconverter site and simply pay to have him convert it personally for you. He has converted sites much lareger than yours without problems. Frankly he's a wizard with databases, so might as well have an expert take care of it for you. We're not talking a lot of money here anyhow, and it will save any frustration you are having. -
Thank you,
I was completely unmotivated last night, things are better this morning, the motivation is back.
I will re test the plugin next week, or make a manual injection.
and if it does not work, I will contact the experts:).Thank you very much to you for your support and the information / idea.
good day
Shooo -
I've finally managed to import all the posts :) BUT...
it took so so so long to convert all the data from phpbb3 to wordpress and I had to be very cautious during the process. I had to be careful with my browser window, wordpress session, etc. It reminded me of the times when I had Atari Computer with cassettes. Moreover the restart option didn't work as described in documents.I have problem with the "Freshness" of the posts. I cannot correctly synchroniz them. Sometimes it even shows "no topics". bbPress Recount gives funny effects.
