http://bbpress.org/forums/ bbPress support forums Tag: vanilla en Tue, 02 Dec 2008 06:32:43 +0000 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/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/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/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/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/importing-from-vanilla#post-11779 Fri, 02 Nov 2007 17:04:25 +0000 Righton 11779@http://bbpress.org/forums/ <p>Anyone ever come up with a solution from Vanilla to BBPress? I'm having daily requests to move from Vanilla and NO ONE has a converter. </p> http://bbpress.org/forums/topic/importing-from-vanilla#post-4715 Wed, 21 Feb 2007 10:48:53 +0000 Ziyphr 4715@http://bbpress.org/forums/ <p>The last phpBB to Vanilla converter doesn't work perfectly with the latest Vanilla so needs some fiddling. Both Vanilla and bbPress could do with investing in a universal converter similar to what punBB has. It's a lot of work but will be worthwhile. </p> http://bbpress.org/forums/topic/importing-from-vanilla#post-4704 Wed, 21 Feb 2007 00:46:55 +0000 bbolman 4704@http://bbpress.org/forums/ <p>Is there a vanilla to phpbb deal? That seems like the easiest way to go...</p> <p>the bbPress folks ought to consider hiring a team member or somebody to just work on importers. Without them it makes getting people to make the move just that much harder. </p> http://bbpress.org/forums/topic/importing-from-vanilla#post-4676 Tue, 20 Feb 2007 09:40:08 +0000 Ziyphr 4676@http://bbpress.org/forums/ <p>I'm currently looking at Vanilla and bbPress, may I ask what you didn't like about Vanilla, in comparison to bbPress? </p> http://bbpress.org/forums/topic/importing-from-vanilla#post-4675 Tue, 20 Feb 2007 09:22:14 +0000 Bruz 4675@http://bbpress.org/forums/ <p>I would also do the switch - if there was an importer... </p> http://bbpress.org/forums/topic/importing-from-vanilla#post-1715 Wed, 29 Nov 2006 19:57:30 +0000 thomasklaiber 1715@http://bbpress.org/forums/ <p>ehm ... i think with a lot of work it should be doable to grab the rss-feed, re-format it and put it into the bbpress database ... but i can't do that :-D </p> http://bbpress.org/forums/topic/importing-from-vanilla#post-1714 Wed, 29 Nov 2006 19:42:08 +0000 so1o 1714@http://bbpress.org/forums/ <p>vanilla has rss feeds </p> http://bbpress.org/forums/topic/importing-from-vanilla#post-1687 Wed, 29 Nov 2006 04:13:34 +0000 Trent 1687@http://bbpress.org/forums/ <p>I have checked for importers for any forum package out there and I am not sure if Vanilla will import to any software package. Does anyone know if it has rss feed so at least you could try exporting it that way?</p> <p>Trent </p> http://bbpress.org/forums/topic/importing-from-vanilla#post-1675 Tue, 28 Nov 2006 11:39:03 +0000 Bruz 1675@http://bbpress.org/forums/ <p>Same over here - I need a convertor to switch... really can't do this by hand :-) </p> http://bbpress.org/forums/topic/importing-from-vanilla#post-399 Mon, 23 Oct 2006 20:08:39 +0000 karmatosed 399@http://bbpress.org/forums/ <p>Ok, I see there is an importing from phpbb but I've got a slightly different issue with vanilla. I like it but love bbpress much more now and would love to bring over my site to it. Is there anyone with any ideas on where to start on this and possibly some help over that. It would be greatly appreciated. </p>