Forum Replies Created
-
In reply to: Documented import from snitz access database
Sure: I had an mdb backup. For some reason I inverted two columns in my table structure, so when I imported from csv file I had 0000-00-00 00:00:00 in column LAST_POST. Just a stupid mistake ^__^
Unfortunately I still have some troubles. Lots of replies are in the database but not connected with their parent topics. I still have to figure out why, the database is huge, it’s very difficult to do some debug.
Anyway, I’ll tell you when everything is ok.
Thanks!In reply to: Documented import from snitz access databaseHi, I think I did it: the problem with the dates dipended on topics table structure.
Everything seems to work fine now.
Thank you for your precious support!In reply to: Documented import from snitz access databaseYes, dates are in the correct format yyyy-mm-dd
In reply to: Documented import from snitz access databaseHi again, it seems I managed to import the database, but I get a weird error message in front end: [Incorrect DATETIME value: ‘0’]
SELECT p.ID FROM wp_posts AS p WHERE p.post_date > ‘0’ AND p.post_type = ‘forum’ AND ( p.post_status = ‘publish’ OR p.post_status = ‘private’ OR p.post_status = ‘hidden’ ) ORDER BY p.post_date ASC LIMIT 1Apparently import was ok. Here’s the code.
<?php /** * bbPress Example Converter * * @package bbPress * @subpackage Converters */ /** * Example converter base impoprter template for bbPress * * @since 2.3.0 bbPress (r4689) * * @link Codex Docs https://codex.bbpress.org/import-forums/custom-import */ class snitz extends BBP_Converter_Base { /** * Main Constructor */ public function __construct() { parent::__construct(); } /** * Sets up the field mappings */ public function setup_globals() { /** Forum Section *****************************************************/ // Setup table joins for the forum section at the base of this section // Old forum id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'FORUM_ID', 'to_type' => 'forum', 'to_fieldname' => '_bbp_old_forum_id' ); // Forum parent id (If no parent, then 0. Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'CAT_ID', 'to_type' => 'forum', 'to_fieldname' => '_bbp_old_forum_parent_id' ); // Forum topic count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'F_TOPICS', 'to_type' => 'forum', 'to_fieldname' => '_bbp_topic_count' ); // Forum reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'F_COUNT', 'to_type' => 'forum', 'to_fieldname' => '_bbp_reply_count' ); // Forum total topic count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'F_TOPICS', 'to_type' => 'forum', 'to_fieldname' => '_bbp_total_topic_count' ); // Forum total reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'F_COUNT', 'to_type' => 'forum', 'to_fieldname' => '_bbp_total_reply_count' ); // Forum title. $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'F_SUBJECT', 'to_type' => 'forum', 'to_fieldname' => 'post_title' ); // Forum slug (Clean name to avoid confilcts) $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'F_SUBJECT', 'to_type' => 'forum', 'to_fieldname' => 'post_name', 'callback_method' => 'callback_slug' ); // Forum description. $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'F_DESCRIPTION', 'to_type' => 'forum', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_null' ); // Forum display order (Starts from 1) $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'FORUM_ORDER', 'to_type' => 'forum', 'to_fieldname' => 'menu_order' ); // Forum type (Category = 0 or Forum = 1, Stored in postmeta) $this->field_map[] = array( // 'from_tablename' => 'FORUM_FORUM', // 'from_fieldname' => 'the_forum_type', 'to_type' => 'forum', 'to_fieldname' => '_bbp_forum_type', // 'callback_method' => 'callback_forum_type' 'default' => 'forum' ); // Forum status (Unlocked = 0 or Locked = 1, Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'F_STATUS', 'to_type' => 'forum', 'to_fieldname' => '_bbp_status', 'callback_method' => 'callback_forum_status' ); // Forum dates. $this->field_map[] = array( 'to_type' => 'forum', 'to_fieldname' => 'post_date', 'default' => date('Y-m-d H:i:s') ); $this->field_map[] = array( 'to_type' => 'forum', 'to_fieldname' => 'post_date_gmt', 'default' => date('Y-m-d H:i:s') ); $this->field_map[] = array( 'to_type' => 'forum', 'to_fieldname' => 'post_modified', 'default' => date('Y-m-d H:i:s') ); $this->field_map[] = array( 'to_type' => 'forum', 'to_fieldname' => 'post_modified_gmt', 'default' => date('Y-m-d H:i:s') ); // Setup the table joins for the forum section /* $this->field_map[] = array( 'from_tablename' => 'groups_table', 'from_fieldname' => 'forum_id', 'join_tablename' => 'forums_table', 'join_type' => 'INNER', 'join_expression' => 'USING groups_table.forum_id = forums_table.forum_id',*/ // 'from_expression' => 'WHERE forums_table.forum_id != 1', /* 'to_type' => 'forum' );*/ /** Forum Subscriptions Section ***************************************/ // Subscribed forum ID (Stored in usermeta) /* $this->field_map[] = array( 'from_tablename' => 'forum_subscriptions_table', 'from_fieldname' => 'the_forum_id', 'to_type' => 'forum_subscriptions', 'to_fieldname' => '_bbp_forum_subscriptions' );*/ // Subscribed user ID (Stored in usermeta) /* $this->field_map[] = array( 'from_tablename' => 'forum_subscriptions_table', 'from_fieldname' => 'the_user_id', 'to_type' => 'forum_subscriptions', 'to_fieldname' => 'user_id', 'callback_method' => 'callback_userid' );*/ /** Topic Section *****************************************************/ // Setup table joins for the topic section at the base of this section // Old topic id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'TOPIC_ID', 'to_type' => 'topic', 'to_fieldname' => '_bbp_old_topic_id' ); // Topic reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_REPLIES', 'to_type' => 'topic', 'to_fieldname' => '_bbp_reply_count', 'callback_method' => 'callback_topic_reply_count' ); // Topic total reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_REPLIES', 'to_type' => 'topic', 'to_fieldname' => '_bbp_total_reply_count', 'callback_method' => 'callback_topic_reply_count' ); // Topic parent forum id (If no parent, then 0. Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'FORUM_ID', 'to_type' => 'topic', 'to_fieldname' => '_bbp_forum_id', 'callback_method' => 'callback_forumid' ); // Topic author. $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_AUTHOR', 'to_type' => 'topic', 'to_fieldname' => 'post_author', 'callback_method' => 'callback_userid' ); // Topic author ip (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_IP', 'to_type' => 'topic', 'to_fieldname' => '_bbp_author_ip' ); // Topic content. $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_MESSAGE', 'to_type' => 'topic', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_html' ); // Topic title. $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_SUBJECT', 'to_type' => 'topic', 'to_fieldname' => 'post_title' ); // Topic slug (Clean name to avoid conflicts) $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_SUBJECT', 'to_type' => 'topic', 'to_fieldname' => 'post_name', 'callback_method' => 'callback_slug' ); // Topic status (Open or Closed) $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_STATUS', 'to_type' => 'topic', 'to_fieldname' => '_bbp_old_closed_status_id', 'callback_method' => 'callback_topic_status' ); // Topic parent forum id (If no parent, then 0) $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'FORUM_ID', 'to_type' => 'topic', 'to_fieldname' => 'post_parent', 'callback_method' => 'callback_forumid' ); // Sticky status (Stored in postmeta) /* $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_STICKY', 'to_type' => 'topic', 'to_fieldname' => '_bbp_old_sticky_status_id', 'callback_method' => 'callback_sticky_status' );*/ $this->field_map[] = array( // 'from_tablename' => 'FORUM_FORUM', // 'from_fieldname' => 'the_forum_type', 'to_type' => 'topic', 'to_fieldname' => '_bbp_old_sticky_status_id', // 'callback_method' => 'callback_forum_type' 'default' => 'normal' ); // Topic dates. $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_DATE', 'to_type' => 'topic', 'to_fieldname' => 'post_date', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_DATE', 'to_type' => 'topic', 'to_fieldname' => 'post_date_gmt', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_LAST_POST', 'to_type' => 'topic', 'to_fieldname' => 'post_modified', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_LAST_POST', 'to_type' => 'topic', 'to_fieldname' => 'post_modified_gmt', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_LAST_POST', 'to_type' => 'topic', 'to_fieldname' => '_bbp_last_active_time', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_MESSAGE', 'join_tablename' => 'thread', 'join_type' => 'INNER', 'join_expression' => 'USING (threadid) WHERE post.parentid = 0', 'to_type' => 'topic', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_html' ); // Setup any table joins needed for the topic section /* $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'TOPIC_ID', 'join_tablename' => 'FORUM_TOPICS', 'join_type' => 'INNER', 'join_expression' => 'USING FORUM_REPLY.TOPIC_ID = FORUM_TOPICS.TOPIC_ID', 'from_expression' => 'WHERE FORUM_FORUM.TOPIC_ID = 0', 'to_type' => 'topic' );*/ /** Tags Section ******************************************************/ /** Topic Subscriptions Section ***************************************/ /** Favorites Section *************************************************/ // Favorited topic ID (Stored in usermeta) /** Reply Section *****************************************************/ // Setup table joins for the reply section at the base of this section // Old reply id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'REPLY_ID', 'to_type' => 'reply', 'to_fieldname' => '_bbp_old_reply_id' ); // Reply parent forum id (If no parent, then 0. Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'FORUM_ID', 'to_type' => 'reply', 'to_fieldname' => '_bbp_forum_id', 'callback_method' => 'callback_forumid' ); // Reply parent topic id (If no parent, then 0. Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'TOPIC_ID', 'to_type' => 'reply', 'to_fieldname' => '_bbp_topic_id', 'callback_method' => 'callback_topicid' ); // Reply author ip (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'R_IP', 'to_type' => 'reply', 'to_fieldname' => '_bbp_author_ip' ); // Reply author. $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'R_AUTHOR', 'to_type' => 'reply', 'to_fieldname' => 'post_author', 'callback_method' => 'callback_userid' ); // Reply title and reply slugs // Note: We don't actually want either a reply title or a reply slug as // we want single replies to use their ID as the permalink. // Reply content. $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'R_MESSAGE', 'to_type' => 'reply', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_html' ); /* Snizt doesnt use reply order // Reply order. $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'the_reply_order', 'to_type' => 'reply', 'to_fieldname' => 'menu_order' ); */ // Reply parent topic id (If no parent, then 0) $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'TOPIC_ID', 'to_type' => 'reply', 'to_fieldname' => 'post_parent', 'callback_method' => 'callback_topicid' ); // Reply dates. $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'R_DATE', 'to_type' => 'reply', 'to_fieldname' => 'post_date', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'R_DATE', 'to_type' => 'reply', 'to_fieldname' => 'post_date_gmt', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'R_DATE', 'to_type' => 'reply', 'to_fieldname' => 'post_modified', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'R_DATE', 'to_type' => 'reply', 'to_fieldname' => 'post_modified_gmt', 'callback_method' => 'callback_datetime' ); // Setup any table joins needed for the reply section /* $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'TOPIC_ID', 'join_tablename' => 'FORUM_REPLY', 'join_type' => 'INNER', 'join_expression' => 'USING FORUM_TOPICS.TOPIC_ID = FORUM_REPLY.TOPIC_ID', 'from_expression' => 'WHERE FORUM_TOPICS.first_post != 0', 'to_type' => 'reply' );*/ /** User Section ******************************************************/ // Setup table joins for the user section at the base of this section // Store old user id (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'MEMBER_ID', 'to_type' => 'user', 'to_fieldname' => '_bbp_old_user_id' ); // Store old user password (Stored in usermeta serialized with salt) $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'M_PASSWORD', 'to_type' => 'user', 'to_fieldname' => '_bbp_password', 'callback_method' => 'callback_savepass' ); // Store old user salt (This is only used for the SELECT row info for the above password save) /* $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'the_users_password_salt', 'to_type' => 'user', 'to_fieldname' => '' );*/ // User password verify class (Stored in usermeta for verifying password) /*$this->field_map[] = array( 'to_type' => 'user', 'to_fieldname' => '_bbp_class', 'default' => 'Example' );*/ // User name. $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'M_NAME', 'to_type' => 'user', 'to_fieldname' => 'user_login' ); // User nice name. $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'M_NAME', 'to_type' => 'user', 'to_fieldname' => 'user_nicename' ); // User email. $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'M_EMAIL', 'to_type' => 'user', 'to_fieldname' => 'user_email' ); // User homepage. $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'M_HOMEPAGE', 'to_type' => 'user', 'to_fieldname' => 'user_url' ); /* Snitz doesn't use user registered // User registered. $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'the_users_registration_date', 'to_type' => 'user', 'to_fieldname' => 'user_registered', 'callback_method' => 'callback_datetime' ); */ /* Snitz doesn't use user status // User status. $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'the_users_status', 'to_type' => 'user', 'to_fieldname' => 'user_status' ); */ // User display name. $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'M_NAME', 'to_type' => 'user', 'to_fieldname' => 'display_name' ); // User Profile Field 1 (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'M_AIM', 'to_type' => 'user', 'to_fieldname' => 'aim' ); // User Profile Field 2 (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'M_YAHOO', 'to_type' => 'user', 'to_fieldname' => 'yim' ); // User Profile Field 3 (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'M_SIG', 'to_type' => 'user', 'to_fieldname' => '_bbp_snitz_user_sig' ); // Setup any table joins needed for the user section /* $this->field_map[] = array( 'from_tablename' => 'users_profile_table', 'from_fieldname' => 'the_users_id', 'join_tablename' => 'FORUM_MEMBERS', 'join_type' => 'INNER', 'join_expression' => 'USING users_profile_table.MEMBER_ID = FORUM_MEMBERS.MEMBER_ID', 'from_expression' => 'WHERE FORUM_MEMBERS.MEMBER_ID != -1', 'to_type' => 'user' );*/ } /** * This method allows us to indicates what is or is not converted for each * converter. */ public function info() { return ''; } /** * This method is to save the salt and password together. That * way when we authenticate it we can get it out of the database * as one value. Array values are auto sanitized by WordPress. */ public function callback_savepass( $field, $row ) { $pass_array = array( 'hash' => $field, 'salt' => $row['salt'] ); return $pass_array; } /** * This method is to take the pass out of the database and compare * to a pass the user has typed in. */ public function authenticate_pass( $password, $serialized_pass ) { $pass_array = unserialize( $serialized_pass ); return ( $pass_array['hash'] == md5( md5( $password ). $pass_array['salt'] ) ); } /** * Translate the forum status from Snitz v3.x numeric's to WordPress's strings. * * @param int $status Snitz v3.x numeric forum status * @return string WordPress safe */ public function callback_forum_status( $status = 1 ) { switch ( $status ) { case 0 : $status = 'closed'; // Snitz forum status closed 'F_STATUS = 0' break; case 1 : default : $status = 'open'; // Snitz forum status open 'F_STATUS = 1' break; } return $status; } /** * Translate the topic status from Snitz v3.x numeric's to WordPress's strings. * * @param int $status Snitz v3.x numeric topic status * @return string WordPress safe */ public function callback_topic_status( $status = 1 ) { switch ( $status ) { case 0 : $status = 'closed'; // Snitz topic status closed 'T_STATUS = 0' break; case 1 : default : $status = 'publish'; // Snitz topic status open 'T_STATUS = 1' break; } return $status; } /** * Translate the topic sticky status type from Snitz 3.x numeric's to WordPress's strings. * * @param int $status Snitz 3.x numeric forum type * @return string WordPress safe */ public function callback_sticky_status( $status = 0 ) { switch ( $status ) { case 1 : $status = 'sticky'; // Snitz Sticky 'T_STICKY = 1' break; case 0 : default : $status = 'normal'; // Snitz normal topic 'T_STICKY = 0' break; } return $status; } }
In reply to: Documented import from snitz access databaseHi Robin, thanks for your efforts.
It seems the problem with forum table was a field: “FORUM_ORDER” instead of “F_ORDER”.
Now forum table is ok, I’m going to check out every single field.
I’ll keep you updated 🙂In reply to: Documented import from snitz access databaseThank you Robin, here’s the code:
<?php /** * bbPress Example Converter * * @package bbPress * @subpackage Converters */ /** * Example converter base impoprter template for bbPress * * @since 2.3.0 bbPress (r4689) * * @link Codex Docs https://codex.bbpress.org/import-forums/custom-import */ class snitz extends BBP_Converter_Base { /** * Main Constructor */ public function __construct() { parent::__construct(); } /** * Sets up the field mappings */ public function setup_globals() { /** Forum Section *****************************************************/ // Setup table joins for the forum section at the base of this section // Old forum id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'FORUM_ID', 'to_type' => 'forum', 'to_fieldname' => '_bbp_old_forum_id' ); // Forum parent id (If no parent, then 0. Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'CAT_ID', 'to_type' => 'forum', 'to_fieldname' => '_bbp_old_forum_parent_id' ); // Forum topic count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'F_TOPICS', 'to_type' => 'forum', 'to_fieldname' => '_bbp_topic_count' ); // Forum reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'F_COUNT', 'to_type' => 'forum', 'to_fieldname' => '_bbp_reply_count' ); // Forum total topic count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'F_TOPICS', 'to_type' => 'forum', 'to_fieldname' => '_bbp_total_topic_count' ); // Forum total reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'F_COUNT', 'to_type' => 'forum', 'to_fieldname' => '_bbp_total_reply_count' ); // Forum title. $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'F_SUBJECT', 'to_type' => 'forum', 'to_fieldname' => 'post_title' ); // Forum slug (Clean name to avoid confilcts) $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'F_SUBJECT', 'to_type' => 'forum', 'to_fieldname' => 'post_name', 'callback_method' => 'callback_slug' ); // Forum description. $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'F_DESCRIPTION', 'to_type' => 'forum', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_null' ); // Forum display order (Starts from 1) $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'F_ORDER', 'to_type' => 'forum', 'to_fieldname' => 'menu_order' ); // Forum type (Category = 0 or Forum = 1, Stored in postmeta) $this->field_map[] = array( // 'from_tablename' => 'FORUM_FORUM', // 'from_fieldname' => 'the_forum_type', 'to_type' => 'forum', 'to_fieldname' => '_bbp_forum_type', // 'callback_method' => 'callback_forum_type' 'default' => 'forum' ); // Forum status (Unlocked = 0 or Locked = 1, Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_FORUM', 'from_fieldname' => 'F_STATUS', 'to_type' => 'forum', 'to_fieldname' => '_bbp_status', 'callback_method' => 'callback_forum_status' ); // Forum dates. $this->field_map[] = array( 'to_type' => 'forum', 'to_fieldname' => 'post_date', 'default' => date('Y-m-d H:i:s') ); $this->field_map[] = array( 'to_type' => 'forum', 'to_fieldname' => 'post_date_gmt', 'default' => date('Y-m-d H:i:s') ); $this->field_map[] = array( 'to_type' => 'forum', 'to_fieldname' => 'post_modified', 'default' => date('Y-m-d H:i:s') ); $this->field_map[] = array( 'to_type' => 'forum', 'to_fieldname' => 'post_modified_gmt', 'default' => date('Y-m-d H:i:s') ); // Setup the table joins for the forum section /* $this->field_map[] = array( 'from_tablename' => 'groups_table', 'from_fieldname' => 'forum_id', 'join_tablename' => 'forums_table', 'join_type' => 'INNER', 'join_expression' => 'USING groups_table.forum_id = forums_table.forum_id',*/ // 'from_expression' => 'WHERE forums_table.forum_id != 1', /* 'to_type' => 'forum' );*/ /** Forum Subscriptions Section ***************************************/ // Subscribed forum ID (Stored in usermeta) /* $this->field_map[] = array( 'from_tablename' => 'forum_subscriptions_table', 'from_fieldname' => 'the_forum_id', 'to_type' => 'forum_subscriptions', 'to_fieldname' => '_bbp_forum_subscriptions' );*/ // Subscribed user ID (Stored in usermeta) /* $this->field_map[] = array( 'from_tablename' => 'forum_subscriptions_table', 'from_fieldname' => 'the_user_id', 'to_type' => 'forum_subscriptions', 'to_fieldname' => 'user_id', 'callback_method' => 'callback_userid' );*/ /** Topic Section *****************************************************/ // Setup table joins for the topic section at the base of this section // Old topic id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'TOPIC_ID', 'to_type' => 'topic', 'to_fieldname' => '_bbp_old_topic_id' ); // Topic reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_REPLIES', 'to_type' => 'topic', 'to_fieldname' => '_bbp_reply_count', 'callback_method' => 'callback_topic_reply_count' ); // Topic total reply count (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_REPLIES', 'to_type' => 'topic', 'to_fieldname' => '_bbp_total_reply_count', 'callback_method' => 'callback_topic_reply_count' ); // Topic parent forum id (If no parent, then 0. Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'FORUM_ID', 'to_type' => 'topic', 'to_fieldname' => '_bbp_forum_id', 'callback_method' => 'callback_forumid' ); // Topic author. $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_AUTHOR', 'to_type' => 'topic', 'to_fieldname' => 'post_author', 'callback_method' => 'callback_userid' ); // Topic author ip (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_IP', 'to_type' => 'topic', 'to_fieldname' => '_bbp_author_ip' ); // Topic content. $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_MESSAGE', 'to_type' => 'topic', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_html' ); // Topic title. $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_SUBJECT', 'to_type' => 'topic', 'to_fieldname' => 'post_title' ); // Topic slug (Clean name to avoid conflicts) $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_SUBJECT', 'to_type' => 'topic', 'to_fieldname' => 'post_name', 'callback_method' => 'callback_slug' ); // Topic status (Open or Closed) $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_STATUS', 'to_type' => 'topic', 'to_fieldname' => '_bbp_old_closed_status_id', 'callback_method' => 'callback_topic_status' ); // Topic parent forum id (If no parent, then 0) $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'FORUM_ID', 'to_type' => 'topic', 'to_fieldname' => 'post_parent', 'callback_method' => 'callback_forumid' ); // Sticky status (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_STICKY', 'to_type' => 'topic', 'to_fieldname' => '_bbp_old_sticky_status_id', 'callback_method' => 'callback_sticky_status' ); // Topic dates. $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_DATE', 'to_type' => 'topic', 'to_fieldname' => 'post_date', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_DATE', 'to_type' => 'topic', 'to_fieldname' => 'post_date_gmt', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_LAST_POST_DATE', 'to_type' => 'topic', 'to_fieldname' => 'post_modified', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_LAST_POST_DATE', 'to_type' => 'topic', 'to_fieldname' => 'post_modified_gmt', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_LAST_POST', 'to_type' => 'topic', 'to_fieldname' => '_bbp_last_active_time', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'T_MESSAGE', 'join_tablename' => 'thread', 'join_type' => 'INNER', 'join_expression' => 'USING (threadid) WHERE post.parentid = 0', 'to_type' => 'topic', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_html' ); // Setup any table joins needed for the topic section $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'TOPIC_ID', 'join_tablename' => 'FORUM_TOPICS', 'join_type' => 'INNER', 'join_expression' => 'USING FORUM_REPLY.TOPIC_ID = FORUM_TOPICS.TOPIC_ID', 'from_expression' => 'WHERE FORUM_FORUM.TOPIC_ID = 0', 'to_type' => 'topic' ); /** Tags Section ******************************************************/ /** Topic Subscriptions Section ***************************************/ /** Favorites Section *************************************************/ // Favorited topic ID (Stored in usermeta) /** Reply Section *****************************************************/ // Setup table joins for the reply section at the base of this section // Old reply id (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'REPLY_ID', 'to_type' => 'reply', 'to_fieldname' => '_bbp_old_reply_id' ); // Reply parent forum id (If no parent, then 0. Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'FORUM_ID', 'to_type' => 'reply', 'to_fieldname' => '_bbp_forum_id', 'callback_method' => 'callback_forumid' ); // Reply parent topic id (If no parent, then 0. Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'TOPIC_ID', 'to_type' => 'reply', 'to_fieldname' => '_bbp_topic_id', 'callback_method' => 'callback_topicid' ); // Reply author ip (Stored in postmeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'R_IP', 'to_type' => 'reply', 'to_fieldname' => '_bbp_author_ip' ); // Reply author. $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'R_AUTHOR', 'to_type' => 'reply', 'to_fieldname' => 'post_author', 'callback_method' => 'callback_userid' ); // Reply title and reply slugs // Note: We don't actually want either a reply title or a reply slug as // we want single replies to use their ID as the permalink. // Reply content. $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'R_MESSAGE', 'to_type' => 'reply', 'to_fieldname' => 'post_content', 'callback_method' => 'callback_html' ); /* Snizt doesnt use reply order // Reply order. $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'the_reply_order', 'to_type' => 'reply', 'to_fieldname' => 'menu_order' ); */ // Reply parent topic id (If no parent, then 0) $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'TOPIC_ID', 'to_type' => 'reply', 'to_fieldname' => 'post_parent', 'callback_method' => 'callback_topicid' ); // Reply dates. $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'R_DATE', 'to_type' => 'reply', 'to_fieldname' => 'post_date', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'R_DATE', 'to_type' => 'reply', 'to_fieldname' => 'post_date_gmt', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'R_DATE', 'to_type' => 'reply', 'to_fieldname' => 'post_modified', 'callback_method' => 'callback_datetime' ); $this->field_map[] = array( 'from_tablename' => 'FORUM_REPLY', 'from_fieldname' => 'R_DATE', 'to_type' => 'reply', 'to_fieldname' => 'post_modified_gmt', 'callback_method' => 'callback_datetime' ); // Setup any table joins needed for the reply section /* $this->field_map[] = array( 'from_tablename' => 'FORUM_TOPICS', 'from_fieldname' => 'TOPIC_ID', 'join_tablename' => 'FORUM_REPLY', 'join_type' => 'INNER', 'join_expression' => 'USING FORUM_TOPICS.TOPIC_ID = FORUM_REPLY.TOPIC_ID', 'from_expression' => 'WHERE FORUM_TOPICS.first_post != 0', 'to_type' => 'reply' );*/ /** User Section ******************************************************/ // Setup table joins for the user section at the base of this section // Store old user id (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'MEMBER_ID', 'to_type' => 'user', 'to_fieldname' => '_bbp_old_user_id' ); // Store old user password (Stored in usermeta serialized with salt) $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'M_PASSWORD', 'to_type' => 'user', 'to_fieldname' => '_bbp_password', 'callback_method' => 'callback_savepass' ); // Store old user salt (This is only used for the SELECT row info for the above password save) /* $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'the_users_password_salt', 'to_type' => 'user', 'to_fieldname' => '' );*/ // User password verify class (Stored in usermeta for verifying password) /*$this->field_map[] = array( 'to_type' => 'user', 'to_fieldname' => '_bbp_class', 'default' => 'Example' );*/ // User name. $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'M_NAME', 'to_type' => 'user', 'to_fieldname' => 'user_login' ); // User nice name. $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'M_NAME', 'to_type' => 'user', 'to_fieldname' => 'user_nicename' ); // User email. $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'M_EMAIL', 'to_type' => 'user', 'to_fieldname' => 'user_email' ); // User homepage. $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'M_HOMEPAGE', 'to_type' => 'user', 'to_fieldname' => 'user_url' ); /* Snitz doesn't use user registered // User registered. $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'the_users_registration_date', 'to_type' => 'user', 'to_fieldname' => 'user_registered', 'callback_method' => 'callback_datetime' ); */ /* Snitz doesn't use user status // User status. $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'the_users_status', 'to_type' => 'user', 'to_fieldname' => 'user_status' ); */ // User display name. $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'M_NAME', 'to_type' => 'user', 'to_fieldname' => 'display_name' ); // User Profile Field 1 (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'M_AIM', 'to_type' => 'user', 'to_fieldname' => 'aim' ); // User Profile Field 2 (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'M_YAHOO', 'to_type' => 'user', 'to_fieldname' => 'yim' ); // User Profile Field 3 (Stored in usermeta) $this->field_map[] = array( 'from_tablename' => 'FORUM_MEMBERS', 'from_fieldname' => 'M_SIG', 'to_type' => 'user', 'to_fieldname' => '_bbp_snitz_user_sig' ); // Setup any table joins needed for the user section /* $this->field_map[] = array( 'from_tablename' => 'users_profile_table', 'from_fieldname' => 'the_users_id', 'join_tablename' => 'FORUM_MEMBERS', 'join_type' => 'INNER', 'join_expression' => 'USING users_profile_table.MEMBER_ID = FORUM_MEMBERS.MEMBER_ID', 'from_expression' => 'WHERE FORUM_MEMBERS.MEMBER_ID != -1', 'to_type' => 'user' );*/ } /** * This method allows us to indicates what is or is not converted for each * converter. */ public function info() { return ''; } /** * This method is to save the salt and password together. That * way when we authenticate it we can get it out of the database * as one value. Array values are auto sanitized by WordPress. */ public function callback_savepass( $field, $row ) { $pass_array = array( 'hash' => $field, 'salt' => $row['salt'] ); return $pass_array; } /** * This method is to take the pass out of the database and compare * to a pass the user has typed in. */ public function authenticate_pass( $password, $serialized_pass ) { $pass_array = unserialize( $serialized_pass ); return ( $pass_array['hash'] == md5( md5( $password ). $pass_array['salt'] ) ); } /** * Translate the forum status from Snitz v3.x numeric's to WordPress's strings. * * @param int $status Snitz v3.x numeric forum status * @return string WordPress safe */ public function callback_forum_status( $status = 1 ) { switch ( $status ) { case 0 : $status = 'closed'; // Snitz forum status closed 'F_STATUS = 0' break; case 1 : default : $status = 'open'; // Snitz forum status open 'F_STATUS = 1' break; } return $status; } /** * Translate the topic status from Snitz v3.x numeric's to WordPress's strings. * * @param int $status Snitz v3.x numeric topic status * @return string WordPress safe */ public function callback_topic_status( $status = 1 ) { switch ( $status ) { case 0 : $status = 'closed'; // Snitz topic status closed 'T_STATUS = 0' break; case 1 : default : $status = 'publish'; // Snitz topic status open 'T_STATUS = 1' break; } return $status; } /** * Translate the topic sticky status type from Snitz 3.x numeric's to WordPress's strings. * * @param int $status Snitz 3.x numeric forum type * @return string WordPress safe */ public function callback_sticky_status( $status = 0 ) { switch ( $status ) { case 1 : $status = 'sticky'; // Snitz Sticky 'T_STICKY = 1' break; case 0 : default : $status = 'normal'; // Snitz normal topic 'T_STICKY = 0' break; } return $status; } }
In reply to: Documented import from snitz access databaseThank you for your time, Robin 🙂
I tried making a new snitz.php file following the given example. I also added the lines you suggested. Again the importer only imports users and reply table. I really can’t figure out the problem.
I’m going to give up and ask for some company to do the job for me 🙁In reply to: Documented import from snitz access databaseHi everyone, although 4 years have passed, I hope someone can help me 🙂
I’m trying to import a snitz database following these instructions, but I can only import users and “reply” table.
Analyzing forum table configuration I noticed, comparing the snitz.php file with the other files, that‘to_fieldname’ => ‘_bbp_forum_id’
whereas in all the other files it’s
‘to_fieldname’ => ‘_bbp_old_forum_id’
I tried changing the value but had no success, though.
Maybe it depends on the fact that new bbPress version uses “post” and “postmeta” tables instead of custom bbPress tables?
I searched for ad updated snitz.php file but didn’t find any.
Thanks in advance 🙂