[xprojectsx]

@renabessa
were you able to figure out how to do this?

[xprojectsx]

I know this is an old thread but it is about the most useful on this issue but unfortunately did not solve my problem. (I got zero results returned in the TMP table) I wanted to point out however in case it is useful for anyone else, that in step 3 of @giobby post above there seems to be some extraneous text in there.

these three lines:

wp_posts.post_excerpt, 
pescasubac, 
wp_posts.quea.wp_posts.post_status, 

I believe should be:

wp_posts.post_excerpt, 
wp_posts.post_status, 

pescasubac doesn’t seem to refer to anything and “wp_posts.quea” also is not a thing. All of the other fields in wp_posts are accounted for without those two items.

[xprojectsx]

it’s a very old unsupported forum called bspeak. so I am using the Example importer. the imported fields are standard enough though. userid, forumid, threadid, msgid

I’ve been trying to figure out the logic in the importer but I cannot find the logic for converting the old userid to the new wp id. I suspect it is related to the join area in the example importer and the user logic in the converter.php but I simply don’t see any function like that.

I also tried an old suggestion from this forum to create a dummy user with a wp ID that is higher than the highest import userid. But this did not help.

[xprojectsx]

Thanks Robin. I did try it with no luck. I’ve completely reset my wp install and starting from scratch with bbpress as the first plugin. I will try data import again with a small test sample and try your plugin again.

[xprojectsx]

Still stuck on this issue. Pretty frustrating. I found this from two years ago. Not the exact scenario but sounds similar enough and trying to see if this will help.

Importer major issue

[xprojectsx]

to answer the last question that you gave: in mine
Replies with no post_parent: 13001
Replies with no parent in post meta: 0

Help me, Obi-Wan Kenobi. You're my only hope.

[xprojectsx]

Hi Robin,
I was delighted to find this thread. I’m actually having this same problem. I could see the topics in the Admin>Topics and the topics showed the correct forum. But on the front end nothing. I ran your plugin and it seemed to execute but but I did not get any response like “topic fixed” To make matters worse after I ran the Tools>Forums>repair the topics no longer show the correct forum in the Admin now it just shows a – under the Forum heading.

[xprojectsx]

robin I appreciate your efforts. I was not criticizing you I was just giving my opinion. I will checkout your plugin.

[xprojectsx]

I’m sorry for getting off on philosophy issues. But you could look at the flip side: Are developers entitled to end users’ “free” time? It’s a two way street (I’ve been on both sides of it). It is easy to only look at one side but well run businesses and organizations look at the bigger picture. A big word now is “empathy.” It is almost completely missing in Silicon Valley.

I know that this time/attention that is assumed to be “free” is actually very valuable not just to these individuals but to Silicon Valley and other big data, marketing etc.

[xprojectsx]

Robin, thank you. You are awesome. (period not exclamation point)

I’ve been using commercial and open source software for a long time and have donated both financially and in contributions to development, to several open source projects. There is definitely a disparity in how open source /free software projects, are managed and supported by their teams. Some do it very well, most do not. In my opinion there is a direct relationship between how well it is supported FOR the user base by the developers, and how successful they are. I’ve seen some spin off into IPOs over the years and in my opinion this was largely based upon having enthusiastic users. This type of enthusiasm is not generated from features. It isn’t just a matter of paying the bills. It’s an issue of quality management. It is not enough to just hang your hat on “free” and “you get what you pay for” (the implication being : so you have no say or recourse so just take what you get or get lost). If you put something out there as free, you should still manage its viability otherwise the end result will be wasting people’s time.

Also, wrt to commercial projects, the problem is not using products as sales tools, the problem is first providing reasonable support to a product that a customer has paid for. Then if you have add-on products or services, great. If I, or other customers are happy we will gladly buy more and in some cases (such as myself) we will become (unpaid) evangelists for your product(s). And that is the ideal situation for good companies and good customers.

But if you don’t start with core support and getting your user/customer base happy and familiar with normal issues and breaking-in issues then, that is not OK. That is basically just bait and switch. You are luring people in on the premise of something but really just trying to get them to spend more. The distinction being the false dichotomy of customer receiving reasonable value vs. the developers right to be paid.

Personally I have wasted a good portion of my life on poorly supported products and I have spent a (not small) fortune both in purchases, fixes and wasted time. I’m sure I’m not alone.

[xprojectsx]

Hi, I’m curious what plugin you are considering to switch to? I’ve purchased and tested several including trying to get “support” from commercial options, and have not found a very good/comprehensive forum solution with good support. The best forum for wp that I found was simple press but they were bought out a few years ago and since then the support is terrible. Any question will be answered with a pitch to get you to hire them to customize. Before that I tried wpforo but it is lacking a lot of features especially on the admin side and I had problems communicating with their support.

There just does not seem to exist such a plugin for wordpress that has both good support (either commercial or community) and comprehensive features needed to run an active forum. (I’ve used a bunch of non wp forums such as vb, phpbb, smf etc)

I’ve come to the conclusion that if you have to use WP and need a forum with comprehensive features and administration tools, then bbpress is the best option and you may need to hire a developer to get it to do what you need. The next option would be a non-wp forum that you could bridge. But again, if you have a legitimate WP forum plugin option to consider, I’d love to hear it.

[xprojectsx]

very cool. overall nice styling too

[xprojectsx]

perhaps I over thought this. I tried this below

$this->field_map[] = array(
			'from_tablename'  => 'messagebodies',
			'from_fieldname'  => 'msgid',
			'join_tablename'  => 'messages',
			'join_type'       => 'LEFT',
			'join_expression' => 'USING messagebodies.msgid = messages.msgid AND messagebodies.forumid = messages.forumid',
			'from_expression' => 'WHERE messages.msgid = 0',
			'to_type'         => 'topic'

however I cannot know if this is proper because I am getting an error that seems to point to the base converter logic for “topic” the to_type here of topic should refer to the destination table right?