Solved SQL query to populate user_topics table?

I'm definitely interested in your migration lessons. I've skimmed through some of the other "migrating from" topics, but not the ning one. I have a project ahead of me to migrate my old forums (10 years of history in 100,000+ topics) to Kunena. We're currently using something called MegaBBS from PD9Soft.

The Ning one is here: www.kunena.org/forum/migrate-to-kunena/4...rating-from-ning-com

It's actually a migration, effectively, from Buddypress (as an intermediate step, i.e., Ning-Buddypress-Kunena). Ning exports JSON files that are, reportedly, often corrupt. I ran into a couple of issues. My first import (Ning to Buddypress) left out 10% of the topics. I read somewhere that the solution was to duplicate and rename the larger exported discussions file. The other issues were to do with message sequencing and failure to import the first topic into Buddypress.

Once I had things in MySQL it was fairly straightforward to get things into Kunena using SQL. That still leaves plenty to do. One thing I would suggest checking out is whether you can process the content of messages satisfactorily to convert them to BBcode. There are passable converters (e.g., www.seabreezecomputers.com/html2bbcode/ ) which are fine for individual messages, but I found the PHP functions that I found online and which I could use not quite good enough. Ning has lots of irrelevant HTML in posts that put a bit of a spanner in the works readily enough.

I had only a few years with hundreds of topics and messages not thousands, so I was able to go through every single message and edit by hand where needed.

Whatever about Ning there ought to be an import from Buddypress. It should be straightforward, apart from the HTML to BBcode conversion perhaps. Buddypress handles Ning content very well and if the HTML conversion was a showstopper I might have stopped there. However, the security of Kunena + Joomla is considerably better and better suited to what I needed.

My original problem was getting attachments into Kunena without entering them manually, and this I have now done. I was about to about post that I then got an error on adding an attachment (despite recounting statistics), and I found that actually the error was topic related.

I'm trying to work through this myself. How did you generate the hash for the attachments? My post can be seen here .