[@wendellh Participant 8 years, 8 months ago]

Also, if the old xenForo site is still live and people are posting to it, can I re-run the import tool to have it grab the latest posts or would I want to start over? I know that I’ll probably want to start over since you’ve added new import functionality, but in the future, would it work to just run the import tool from time to time until I’m ready to shut down the old site?

[@wendellh Participant 8 years, 8 months ago]

I’m not quite sure what to do with attachments as bbPress import system does not yet support attachments ¯\_(ツ)_/¯

Yeah, I’m actually thinking it might be best to require the user (me) to manually move the images directory from the old site to the new site. Then, maybe just use the xenForo URL to the image to display it in the post. It “should” be safe since xenForo reduced the images based on admin settings when they were originally uploaded. Just some random thoughts from a guy not looking at import code. 😉

I’m wondering if https://bbpress.dev4press.com would actually cure some of the bbcode issues automatically.

Also I’ve added support for YouTube, Daily Motion and Vimeo BBCode conversion

Sweet!

I’ve added some styling to the quotes now, so it wraps that quotes in “blockquote” and cites the authors name, e.g “wendellh wrote:”

That’s perfect. The post and member numbers are really just useless information at that point anyway. I don’t see any real importance in providing the links back to the quoted posts either. I mean, it would be really cool, but not a big deal.

Ah, I didn’t know about these types of posts, I’ve now done this, for topics/threads replies/posts that were “soft deleted” these are now imported with bbPress/WordPress “pending” status.

Thank you!

[@wendellh Participant 8 years, 8 months ago]

Hey Stephen,

I really appreciate your help! 🙂

Probably the most noticeable issue after the import are the attachments. They are basically a number with opening and closing ATTACH bbcodes. For example:
[ATTACH=full]872[/ATTACH]
In xenForo, this links to attachments/photo-jpg.872

Then there are the quotes to other posts. These simply just come in as text and the post IDs don’t match those in bbpress. In xenForo, the quoted posts link back to the post that was quoted. For example, here is an imported post with a quote:
http://surveyorconnect.com/portal/index.php/forums/topic/july-2015-photo-submittal/#post-1647874
and here is the original post in xenForo:
http://surveyorconnect.com/threads/july-2015-photo-submittal.323039/#post-331560

I’ve also noticed that soft deleted posts (only viewable by mods and admins) in xenForo are coming in as public posts.

I realize I may be asking for too much, but I figure it doesn’t hurt to ask. 😉 I do understand though if it’s just not possible. I’ll keep looking around for other bbcodes as well.

Thanks!

[@wendellh Participant 8 years, 8 months ago]

Tried the import again and saw some results I hadn’t seen before. The last several lines of the conversion said something about converting anonymous posts. That’s the first time it’s ever done that and it seems to have worked great. 🙂

Now I just have to find a way to convert all of the xenForo bbcode into something that will work in bbpress (such as image attachments).

Thanks for the help!

[@wendellh Participant 8 years, 8 months ago]

I ran the query but I’m not sure what information you are looking for from the result.

[@wendellh Participant 8 years, 8 months ago]

TBH, I’m a bit nervous about changing anything in the live xenForo database…

[@wendellh Participant 8 years, 9 months ago]

Yes, exactly.

[@wendellh Participant 8 years, 9 months ago]

The import completed and I’m still having the problem with users being associated with their posts. For example:

Original thread on xenForo: http://surveyorconnect.com/threads/converting-from-lat-long-clarke-spheroid-to-spc.326148/

Imported thread on bbpress: http://surveyorconnect.com/portal/index.php/forums/topic/converting-from-lat-long-clarke-spheroid-to-spc/

[@wendellh Participant 8 years, 9 months ago]

I reset the forum, then upgraded to bbpress 2.6 alpha, checked the “purge previous import” checkbox (just to be sure), then started the import process again and got this lovely error message:

“WordPress database error: [Specified key was too long; max key length is 1000 bytes]
CREATE TABLE blp_bbp_converter_translator ( meta_id mediumint(8) unsigned not null auto_increment, value_type varchar(25) null, value_id bigint(20) unsigned not null default ‘0’, meta_key varchar(255) null, meta_value varchar(255) null, PRIMARY KEY (meta_id), KEY value_id (value_id), KEY meta_join (meta_key, meta_value) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci”

So I unchecked the purge option and tried again. It’s currently importing the users.

[@wendellh Participant 8 years, 9 months ago]

I’m testing with a conversion from xenForo to bbpress as well. I’m using the latest bbpress available to the public, 2.5.8. My xenForo site has about 33,000 topics, 330,000 posts and 6,000 users. Running the bbpress import feature seems to work without a hitch. Then when I go to repair, all functions work great except for the “Recalculate the position of each reply”, as another user here has mentioned. After several seconds, I get a 500 error.

After the import and running the repair items (except for the one that doesn’t work), the forums *seem* to all be intact and working well until you look a bit closer. Many users aren’t associated with their posts — they show 0 posts in bbpress even though they have thousands of posts in xenForo.

I may go ahead and try bbpress 2.6 alpha and see how it goes.

FWIW, I’m running both forums on the same VPS, so the import is relatively quick. It takes a few hours.