Reply To: Import Woltlap Forum Issues
Next issue, found a missing import field “_bbp_topic_voice_count” and i’m pretty sure, thats counted participants were ment. But in woltlap db thread tbl is no colum, so i think, i’ve could du it with a sql query like this:
SELECT COUNT(DISTINCT po.userID) as participants
FROM wbb1_thread th
INNER JOIN wbb1_post po
ON th.threadID = po.threadID
WHERE th.threadID = 2086
The sql query in phpmyadmin works as mentioned. So i copied a piece of code from another importer and customized it like this (? for parts i have no clou):
$this->field_map[] = array(
‘from_tablename’ => ‘wbb1_thread’,
‘from_fieldname’ => ‘?’,
‘join_tablename’ => ‘wbb1_post’,
‘join_type’ => ‘INNER’,
‘join_expression’ => ‘USING (?) WHERE wbb1_thread.?= wbb1_post.?’,
‘to_type’ => ‘topic’,
‘to_fieldname’ => ‘_bbp_topic_voice_count’
);
But i’ve no clou, how to bring the sql in the right way for the import, missing manuals from bbPress, to understand he possibilities.
Anybody firm in this?
