Next in the Forum Section for the third database mapping ‘Title’ in Example.php Line#30
`
‘from_tablename’ => ‘forum_forums’
‘from_fieldname’ => ‘name’
`
I was not sure what matched with the fourth mapping for the ‘Forum Slug’ so I have commented that out for now assuming that there is just nothing to import.
For the fifth database mapping ‘Description’ in Example.php Line#43
`
‘from_tablename’ => ‘forum_forums’
‘from_fieldname’ => ‘description’
`
Sixth mapping for ‘Forum display order’ in Example.php Line#50
`
‘from_tablename’ => ‘forum_forums’
‘from_fieldname’ => ‘sort’
`
I also commented out the ‘Forum date update’ in Example.php Lines #56-72 section as there don’t appear to be any corresponding field names.
That wraps up the database mapping for the ‘Forums Section’. Moving along to the ‘Topics Section’ the ‘from_tablename’ appears to be ‘forum_threads’.
The first mapping for the ‘Topic id’ in Example.php Line#76
`
‘from_tablename’ => ‘forum_threads’
‘from_fieldname’ => ‘id’,
`
Mapping ‘Forum id’ in Example.php Line#82
`
‘from_tablename’ => ‘forum_threads’
‘from_fieldname’ => ‘parent_id’
`
Mapping ‘Topic author’ in Example.php Line#89
`
‘from_tablename’ => ‘forum_threads’
‘from_fieldname’ => ‘starter’
`
Mapping ‘Topic Title’ in Example.php Line#96
`
‘from_tablename’ => ‘forum_threads’
‘from_fieldname’ => ‘subject’
`
Mapping for ‘Topic Slug’ in Example.php Line#102
`
‘from_tablename’ => ‘forum_threads’
‘from_fieldname’ => ‘subject’
`
Mapping ‘Forum id’ (again?) in Example.php Line#109
`
‘from_tablename’ => ‘forum_threads’
‘from_fieldname’ => ‘id’
`
For the Topic dates I only found two matching tables instead of four. One is called ‘date’ the other ‘last post’. I assume that bbpress just needs either the GMT time or another format. I confirmed that the format Mingle uses does appear to be GMT based on the database showing “2012-04-29 20:55:59” and checking this. Therefore, I am only editing ‘post_date_gmt’ and ‘post_modified_gmt’ and commenting out the other two as follows.
Mapping ‘post_date_gmt’ in Example.php line#123
`
‘from_tablename’ => ‘forum_threads’
‘from_fieldname’ => ‘date’
`
Mapping ‘post_modified_gmt’ in Example.php line#133
`
‘from_tablename’ => ‘forum_threads’
‘from_fieldname’ => ‘last_post’
`
That completes the ‘Threads’ section, next are the ‘Tags’ which Mingle does not appear to support.
This section has been commented out entirely.
Next up the ‘Post’ Section appears to map to the ‘forums_posts’ table from Mingle. There are only two ID fields present (id and parent_id) but both have the same values. I was not sure whether it would be better to only import one of the bbpress ids (post,forum,topic) or all three, so I have done all three below.
Mapping ‘Post id’ in Example.php Line#156
`
‘from_tablename’ => ‘forum_posts’
‘from_fieldname’ => ‘id’
`
Mapping ‘Forum id’ in Example.php Line#162
`
‘from_tablename’ => ‘forum_posts’
‘from_fieldname’ => ‘parent_id’
`
Mapping ‘Topic id’ in Example.php Line#169
`
‘from_tablename’ => ‘forum_posts’
‘from_fieldname’ => ‘id’
`
No match found for ‘Author IP’ in Example.php Line#176 – Commented out
Mapping ‘Post author’ in Example.php Line#182
`
‘from_tablename’ => ‘forum_posts’
‘from_fieldname’ => ‘author_id’
`
Mapping ‘Topic Title’ in Example.php Line#189
`
‘from_tablename’ => ‘forum_posts’
‘from_fieldname’ => ‘subject’
`
Mapping ‘Topic slug’ in Example.php Line#195
`
‘from_tablename’ => ‘forum_posts’
‘from_fieldname’ => ‘subject’
`
Mapping ‘Post content’ in Example.php Line#202
`
‘from_tablename’ => ‘forum_posts’
‘from_fieldname’ => ‘text’
`
Mapping ‘Topic id’ in Example.php Line#209
`
‘from_tablename’ => ‘forum_posts’
‘from_fieldname’ => ‘id’
`
Mapping ‘Topic Dates’ for ‘post_date_gmt’ and ‘post_modified_gmt’ in Example.php Line#223 and #232 (commented out non-GMT imports)
`
‘from_tablename’ => ‘forum_posts’
‘from_fieldname’ => ‘date’
`
This ends the ‘Post’ section. I did not make any modifications to the ‘User’ Section. Are changes here required to import normal WordPress users?
The ‘wp_forum_groups’, ‘wp_forum_usergroups’, ‘wp_forum_usergroup2user’ and ‘wp_forum_reputation_posts’ tables are all empty so those must have been for other plugins that I have integrated with Mingle Forums.
I don’t see any further changes to make here so if someone would be kind enough to review this for any mistakes before I give it it a try I will let everyone know how it goes. 🙂
