http://bbpress.org/forums/ bbPress support forums Tag: conversion en Sun, 07 Sep 2008 18:38:14 +0000 http://bbpress.org/forums/topic/phpbb3-converstion#post-18922 Thu, 04 Sep 2008 19:23:38 +0000 chrishajer 18922@http://bbpress.org/forums/ <p><a href="http://bbpress.org/forums/topic/bbpress-initiates-importexport-standard-for-web-forums" rel="nofollow">http://bbpress.org/forums/topic/bbpress-initiates-importexport-standard-for-web-forums</a> </p> http://bbpress.org/forums/topic/phpbb3-converstion#post-18918 Thu, 04 Sep 2008 18:31:10 +0000 bryan868 18918@http://bbpress.org/forums/ <p>So what was the outcome from the Summer of Code? Did we get a phpBB 3.0 converter? </p> http://bbpress.org/forums/topic/phpbb3-converstion#post-17834 Thu, 31 Jul 2008 13:34:09 +0000 hhberthelsen 17834@http://bbpress.org/forums/ <p>I'm also looking for an update, and so far found these links:<br /> <a href="http://codex.wordpress.org/GSoC2008" rel="nofollow">http://codex.wordpress.org/GSoC2008</a><br /> <a href="http://www.stealyourcarbon.net/2008/07/midterm-progress/" rel="nofollow">http://www.stealyourcarbon.net/2008/07/midterm-progress/</a><br /> <a href="http://www.stealyourcarbon.net/2008/07/bbpress-importer/" rel="nofollow">http://www.stealyourcarbon.net/2008/07/bbpress-importer/</a></p> <p>and SoC '08 discussions going on here:<br /> <a href="http://groups.google.com/group/wordpress-soc-2008" rel="nofollow">http://groups.google.com/group/wordpress-soc-2008</a></p> <p>Not sure if these are good signs ... v0.1A seems a long way to a stable version :-o </p> http://bbpress.org/forums/topic/converting-xdforum-to-bbpress#post-17440 Sat, 19 Jul 2008 16:10:37 +0000 fastpipe 17440@http://bbpress.org/forums/ <p>No problem. I like to keep Wordpress up to date and the XDForum plug-in was holding me back. </p> http://bbpress.org/forums/topic/converting-xdforum-to-bbpress#post-17437 Sat, 19 Jul 2008 15:42:49 +0000 _ck_ 17437@http://bbpress.org/forums/ <p>Thanks for sharing this! </p> http://bbpress.org/forums/topic/converting-xdforum-to-bbpress#post-16873 Mon, 23 Jun 2008 16:48:26 +0000 fastpipe 16873@http://bbpress.org/forums/ <p>XDForum, another Wordpress forum plug-in, stopped development a few months ago.</p> <p>For anyone considering converting their XDForum to BBPress, I've posted detailed instructions for <a href="http://www.fastpipe.com/2008/06/23/converting-xdforum-to-bbpress">converting XDForum tables to BBPress tables</a> on my site. The instructions include a method for tagging your existing content.</p> <p>I looked for something like this a few months ago and couldn't find it. Hopefully, someone will find this useful. The result of the conversion can be viewed <a href="http://www.hdtvok.com/forums/">here</a>... </p> http://bbpress.org/forums/topic/phpbb3-converstion#post-16838 Fri, 20 Jun 2008 20:27:49 +0000 bryan868 16838@http://bbpress.org/forums/ <p>Any updates on this? </p> http://bbpress.org/forums/topic/importing-from-vanilla#post-16156 Mon, 12 May 2008 14:10:49 +0000 cicloid 16156@http://bbpress.org/forums/ <p>I'm also looking forward to your import.</p> <p>I'm thinking on moving a Vanilla forum to bbPress.</p> <p>If it works as charm, I will try you SQL statements right away. </p> http://bbpress.org/forums/topic/phpbb3-converstion#post-16071 Thu, 08 May 2008 21:57:35 +0000 bryan868 16071@http://bbpress.org/forums/ <p>I wish there was a beta script! I really want to move from phpbb3 to bbpress now. </p> http://bbpress.org/forums/topic/importing-from-vanilla#post-15963 Sun, 04 May 2008 16:13:59 +0000 smoothmoniker 15963@http://bbpress.org/forums/ <p>Thank you Scooter! I'll give this a try when I have a moment. Or, it look like, when I have a half a day. </p> http://bbpress.org/forums/topic/phpbb3-converstion#post-15925 Fri, 02 May 2008 07:41:36 +0000 yazerty 15925@http://bbpress.org/forums/ <p>Thanks for the news :).</p> <p>But isn't it a beta script to import phpbb3 to a bbpress ? </p> http://bbpress.org/forums/topic/importing-from-vanilla#post-15924 Fri, 02 May 2008 03:10:55 +0000 scooter7978 15924@http://bbpress.org/forums/ <p>I've refined it a bit further so that it grabs the last post ID of each of the topics so that the 'freshness' links work fine for old posts...</p> <p>I replaced the SQL to get the topics:<br /> (SELECT 0) as LastPostID<br /> to:<br /> (SELECT MAX(CommentID) FROM LUM_Comment WHERE DiscussionID=LUM_Discussion.DiscussionID) AS LastPostID</p> <p>I can't edit my original post so if you use the above SQL, make sure you add this bit in. </p> http://bbpress.org/forums/topic/phpbb3-converstion#post-15915 Thu, 01 May 2008 14:45:11 +0000 sambauers 15915@http://bbpress.org/forums/ <p>Import/Export is being improved as part of a Google Summer of Code project. We will hopefully have some results from that to share by the end of it.</p> <p>The basic idea is to create export plugins for other forum software which can export to a standard format. Then we will have one importer to import that standard format into bbPress. </p> http://bbpress.org/forums/topic/importing-from-vanilla#post-15899 Thu, 01 May 2008 02:16:32 +0000 scooter7978 15899@http://bbpress.org/forums/ <p>I'm using Vanilla on my forums and since I like to change things every now and then, I'm going to move to BBPress in the near future. Since I'm testing at the moment, I thought I'd hand over the SQL statements for grabbing the categories, topics and posts and formatting them as best as possible for bbpress.</p> <p>SQL to get the categories:<br /> SELECT CategoryID, Name, REPLACE( LCASE( Name ) , ' ', '-' ) AS Slug, Description, Priority<br /> FROM LUM_Category</p> <p>SQL to get the topics:<br /> SELECT DiscussionID, Name, REPLACE( Name, ' ', '-' ) AS Slug, AuthUserID,<br /> (SELECT LUM_User.Name FROM LUM_User WHERE UserID = AuthUserID) AS PosterName,<br /> LastUserID, (SELECT LUM_User.Name FROM LUM_User WHERE UserID = LastUserID) AS LastPosterName,<br /> DateCreated, DateLastActive, CategoryID, Closed, Active, (SELECT 0) AS LastPostID, Sticky, CountComments, (SELECT 0) AS TagCount<br /> FROM LUM_Discussion</p> <p>SQL to get the discussions:<br /> SELECT CommentID, LUM_Discussion.CategoryID AS ForumID, LUM_Comment.DiscussionID, LUM_Comment.AuthUserID, Body, LUM_Comment.DateCreated, RemoteIp<br /> FROM LUM_Comment<br /> JOIN LUM_Category ON LUM_Discussion.CategoryID = LUM_Category.CategoryID<br /> JOIN LUM_Discussion ON LUM_Discussion.DiscussionID = LUM_Comment.DiscussionID<br /> ORDER BY CommentID, ForumID</p> <p>SQL to get the tags:<br /> SELECT TagID, REPLACE( Tag, ' ', '-' ) , Tag, (SELECT 0) FROM LUM_DiscussionTags </p> <p>From there you will need to fix up the slugs in the bb_topics table and in the bb_forums so that the web browser doesn't have a conniption when it tries to load a forum thread but you can do that with a series of select(replace) queries like this:</p> <p>update bb_topics set topic_slug = replace(topic_slug,'?','');<br /> update bb_topics set topic_slug = replace(topic_slug,'.','');<br /> update bb_topics set topic_slug = replace(topic_slug,'/','');<br /> update bb_topics set topic_slug = replace(topic_slug,'&amp;','and');<br /> update bb_topics set topic_slug = replace(topic_slug,'&quot;','');<br /> update bb_topics set topic_slug = replace(topic_slug,'\\','');<br /> update bb_topics set topic_slug = replace(topic_slug,'\"','');<br /> update bb_topics set topic_slug = replace(topic_slug,'!','');<br /> update bb_topics set topic_slug = replace(topic_slug,',','');<br /> update bb_topics set topic_slug = replace(topic_slug,'\'','');<br /> update bb_topics set topic_slug = replace(topic_slug,'#','');</p> <p>There might be a better or quicker way of doing the last bit but since it works fine on mine I am not too concerned.</p> <p>I had to kludge some results in the queries like; SELECT 0 or SELECT 1 to get the answers I wanted or to pad out the columns to fit properly into the bbpress SQL layout. In most cases its just count fields or an active or open flag which is nearly always 1 or 0 anyway.</p> <p>Generally this is all you need to get started, from there you can just export this table data to a CSV or something and then import it into the requisite bbpress table. If you go into the admin interface of bbpress and get the system to recount everything it should be ok from there. I only recommend doing this if you're familiar with the inner workings of MySQL, otherwise you could bollocks things up and then noone wins.</p> <p>Please remember too that this is the basics, if you've integrated with wordpress you've still got some work ahead of you to coordinate your wordpress ID's with your forum ones. It can be done as I managed to do it, it's just painful.</p> <p>Cheers,<br /> Scott </p> http://bbpress.org/forums/topic/phpbb3-converstion#post-15891 Wed, 30 Apr 2008 16:38:31 +0000 Sally1 15891@http://bbpress.org/forums/ <p>Same here!!! </p> http://bbpress.org/forums/topic/phpbb3-converstion#post-15886 Wed, 30 Apr 2008 09:53:39 +0000 yazerty 15886@http://bbpress.org/forums/ <p>Wow, there isn't any tool to move from phpbb3 to bbpress ? How bad it is :-(.</p> <p>I hope there will be soon :))... </p> http://bbpress.org/forums/topic/importing-from-vanilla#post-15840 Mon, 28 Apr 2008 16:10:49 +0000 smoothmoniker 15840@http://bbpress.org/forums/ <p>yes please!</p> <p>I'd even be willing to kick in some cash if we want to get together, hire someone to write it, and then donate the code back to the bbpress project. </p> http://bbpress.org/forums/topic/phpbb3-converstion#post-15804 Sat, 26 Apr 2008 21:54:41 +0000 tommiehansen 15804@http://bbpress.org/forums/ <p>This is very important if one already got a forum but want to have a *GOOD* integration with Wordpress on a new site.</p> <p>Imagine loosing 4000 users just to be able to change to bbPress. It just won't happen and it's a damn shame that there isn't a converter yet. :/ </p> http://bbpress.org/forums/topic/successful-convert-smf-gt-phpbb2-gt-bbpress#post-15415 Wed, 16 Apr 2008 04:21:55 +0000 affacat 15415@http://bbpress.org/forums/ <p>wonderful! i'm glad to hear my post was helpful! </p> http://bbpress.org/forums/topic/successful-convert-smf-gt-phpbb2-gt-bbpress#post-15386 Tue, 15 Apr 2008 04:24:35 +0000 citizenkeith 15386@http://bbpress.org/forums/ <p>Just want to say THANK YOU!!</p> <p>I gave up converting my phpBB forum months ago:<br /> <a href="http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter/page/2" rel="nofollow">http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter/page/2</a></p> <p>But by utilizing the info here (and buy editing the SQL file by hand), I was able to get my forum into the very latest bbPress... it's even integrated with WP.</p> <p><a href="http://www.judyhenskefan.com/forums/" rel="nofollow">http://www.judyhenskefan.com/forums/</a></p> <p>Now I get to work on a new design for the forum and blog (as well as add lots of plugins to the new forum).</p> <p>Thanks again everybody! :-) </p> http://bbpress.org/forums/topic/successful-convert-smf-gt-phpbb2-gt-bbpress#post-15179 Wed, 09 Apr 2008 10:45:07 +0000 affacat 15179@http://bbpress.org/forums/ <p>yet another step.</p> <p>if you want pretty permalinks you'll need to fill in topic_slug in bb_topics. </p> http://bbpress.org/forums/topic/phpbb3-converstion#post-15056 Sat, 05 Apr 2008 12:26:23 +0000 DaMsT 15056@http://bbpress.org/forums/ <p>Here too!</p> <p>This really should be good for promotion of bbPress, to have a converter for phpbb3 that is. </p> http://bbpress.org/forums/topic/successful-convert-smf-gt-phpbb2-gt-bbpress#post-14831 Sun, 30 Mar 2008 22:10:34 +0000 affacat 14831@http://bbpress.org/forums/ <p>We realized many of the members seemed to be showing up on the site as 'inactive', despite having a record in wp_user_meta with matching records containing:<br /> bb_capabilities a:1:{s:6:"member";b:1;}</p> <p>I updated a single 'inactive' user to 'moderator', saved, then downgraded them back to 'member', saved... and everyone that was displaying as inactive started displaying correctly as member.</p> <p>I do not know what type of glitch this was, or if it was a result of the conversion but am posting it here in case others converting run into the same issue. </p> http://bbpress.org/forums/topic/successful-convert-smf-gt-phpbb2-gt-bbpress#post-14771 Fri, 28 Mar 2008 19:20:51 +0000 affacat 14771@http://bbpress.org/forums/ <p>oh, i was actually talking about a separate issue where I can't add/edit tags (well, I can add one per post then I get 'no permission' error:<br /> <a href="http://bbpress.org/forums/topic/no-rights-to-create-forum-as-key-master#post-14757" rel="nofollow">http://bbpress.org/forums/topic/no-rights-to-create-forum-as-key-master#post-14757</a></p> <p>But this issue is not actually related to this thread -- anyone reading this that wants to convert following the instructions above should. i just found it odd that tag management works here but not on my own site. </p> http://bbpress.org/forums/topic/successful-convert-smf-gt-phpbb2-gt-bbpress#post-14770 Fri, 28 Mar 2008 19:11:28 +0000 _ck_ 14770@http://bbpress.org/forums/ <p>I believe on bbPress users can only edit their own tags.<br /> But that's a good point where keymasters should be able to edit anyone's tags - I'll have to see if that's the behavior in 0.9 and if not, I'll put a ticket in trac.</p> <p>eta: on 0.9 (not sure about previous versions)<br /> keymasters can remove anyone's tags </p> http://bbpress.org/forums/topic/successful-convert-smf-gt-phpbb2-gt-bbpress#post-14753 Thu, 27 Mar 2008 20:21:34 +0000 affacat 14753@http://bbpress.org/forums/ <p>Tags fixed.</p> <p>Why can I edit tags here and not as keymaster on my own install? Erg.</p> <p>Also -- I reread my instructions. One thing I'd like to clarify:</p> <p>When reorganizing your forum users on phpBB using the mod, make sure to make anyone who exists in both phpBB and WP have matching User IDs. Then, when you delete them from the import script, the forum will still have all posts and topics pointing to the correct user because the record is already correct in your bb/wp user tables. </p> http://bbpress.org/forums/topic/successful-convert-smf-gt-phpbb2-gt-bbpress#post-14750 Thu, 27 Mar 2008 20:03:44 +0000 _ck_ 14750@http://bbpress.org/forums/ <p>Nice work and thanks for sharing...</p> <p>I just knew that using phpbb as an inbetween standard is a good idea...</p> <p>ps. you might want to fix the tags on this to separate words </p> http://bbpress.org/forums/topic/successful-convert-smf-gt-phpbb2-gt-bbpress#post-14736 Thu, 27 Mar 2008 17:45:47 +0000 affacat 14736@http://bbpress.org/forums/ <p>I noticed my import didn't import a forum's most recent post time correctly (it was set equal to forum start date instead)</p> <p>i ran this to fix it:</p> <p>UPDATE<br /> bb_topics<br /> set topic_time =<br /> (SELECT bb_posts.post_time<br /> from bb_posts<br /> where bb_posts.topic_id=bb_topics.topic_id<br /> ORDER BY bb_posts.post_time DESC LIMIT 1) </p> http://bbpress.org/forums/topic/successful-convert-smf-gt-phpbb2-gt-bbpress#post-14710 Thu, 27 Mar 2008 02:19:23 +0000 affacat 14710@http://bbpress.org/forums/ <p>After a day of on-again, off-again effort I have successfully imported my SMF to bbPress - and integrated it with WP.</p> <p>I did this on a local test server, then installed bbPress live, then drop/imported my bbpress tables and user tables (my wp user tables in this case).<br /> Steps:<br /> 1. Installed PhpBB 2.0.23 (legacy version available from phpbb people) and made sure it worked</p> <p>2. Used files within a zip file called convert_smf_111_v1b.zip to convert SMF -&gt; Phpbb. Unfortunately, I can't find the link to the thread right now... I found this<br /> <a href="http://www.phpbb.com/community/viewtopic.php?f=10&#38;t=306321&#38;st=0&#38;sk=t&#38;sd=a" rel="nofollow">http://www.phpbb.com/community/viewtopic.php?f=10&#38;t=306321&#38;st=0&#38;sk=t&#38;sd=a</a><br /> but it isn't as new a version.<br /> I believe the file I used is here:<br /> <a href="http://sourceforge.net/project/showfiles.php?group_id=141446" rel="nofollow">http://sourceforge.net/project/showfiles.php?group_id=141446</a><br /> sorry I lost the link to the discussion.<br /> NOTE 1 : I had to manually go into the database and upgrade my main account to 'level 1' to become admin again.<br /> NOTE 2 : Your password probably won't work and you probably can't send yourself an email either. I hacked phpbb/includes/emailer.php and included the variable $this-&gt;msg into the error message so that the email appeared on the screen. This gave me the ability to reset my account and get a new password. </p> <p>3. Implemented the following MOD on PhpBB to switch conflicting User Ids<br /> <a href="http://www.phpbb.com/community/viewtopic.php?t=388155&#38;sid=3d5e8f776a7086b6fec64c3e80c7cbca" rel="nofollow">http://www.phpbb.com/community/viewtopic.php?t=388155&#38;sid=3d5e8f776a7086b6fec64c3e80c7cbca</a><br /> (this part is tedious! the MOD is a pain to install and rearranging is no fun either)<br /> Here are directions on how to install a Phpbb mod:<br /> <a href="http://www.phpbb.com/community/viewtopic.php?t=61611" rel="nofollow">http://www.phpbb.com/community/viewtopic.php?t=61611</a></p> <p>4. installed Jaim3's PhpBB to bbPress converter per instructions<br /> <a href="http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter" rel="nofollow">http://bbpress.org/forums/topic/a-phpbb-to-bbpress-database-converter</a><br /> This created a .sql file.<br /> NOTE 1: Make sure to create a temp folder where the file wants to be created</p> <p>5. Important edits to .sql file<br /> A) since I did an integrated WP/BBpress install, I needed to search and replace bb_user for wp_user<br /> B) Delete any lines that add users who already exist in BB/WP<br /> C) add a field called topic_resolved to bb_topics<br /> D) Delete the sample test posts and forums in the bbpress tables</p> <p>6. Import the .sql into your database. The above should have solved any conflicts, but if you get an error it should be relatively easy to figure out.</p> <p>7. At this point, since I wasn't doing it live I installed bbPress live, and then drop/created my test tables (all bb tables plus user tables) on my live server and all went well.</p> <p>8. This should be everything. Have a drink. </p> http://bbpress.org/forums/topic/phpbb3-converstion#post-13167 Tue, 15 Jan 2008 11:54:02 +0000 tamebay 13167@http://bbpress.org/forums/ <p>We are also looking for a solution to this. </p>