Managed to get a quick look at the database you sent me this morning. The problem starts with what is clearly a short-sighted issue with the importer – but then again, to be frank, the importer needs a complete overhaul anyway!
So – the importer assumes your bbPress forums, topics and posts have a post_status of ‘publish’ whereas, in fact your forums are all marked as ‘private’.
If you are OK making a small code edit we can deal with this and you can give things another whirl. I have been unable to try this yet myself as explained in the email I sent you.
The file you need to change, in the sp_import plugin is sp-import/importers/bbpress-plugin.php
Scroil down to about line 83 and find the comment SFFORUMS Table Mappings. There are two blocks of SQL for ‘select’ and ‘where’ clauses. Just remove the
AND post_status=’publish’ from each – or – change the ‘publish’ to ‘private’. Hopefully that will fix things. Don’t forget to change BOTH clauses.
A very quick check suggests that topics and forum posts do all have a status of ‘publish’.
Let me know how you get on.