I’m importing a community forum from vbulletin. And I can’t wait to get it done, because I want to start using discourse pronto.
I’ve managed to get the script running and it can import: users, groups, categories, topics (i.e. first posts) and then failed. Because I gave it only read access to my vb db (to be safe). The backup / restore feature is also invaluable in testing this stuff because it’s so easy to go back to an empty forum.
At this stage, before I run it again I have some questions on this:
How should I do the user <-> group mappings? I see it takes the primary group in some way but I don’t see this on the imported forum anywhere. Plus other groups? I guess I’d be able to do the SQL from the mysql side, but how do I add the groups on discourse from the script? Thinking about it the easiest would be to do it “by hand” after import using bulk add user to group funciton.
Our forum uses the DragonByte Tech: Advanced Post Thanks / Like plugin. I guess I’d be able to figure out who liked/thanked which post from the MySQL database, but again, how do I import said like to discourse. Probably after posts have been imported I need to loop through all the likes/thanks in my database and like the corresponding post on discourse? (Can’t wait for the dislike button to disappear…).
I haven’t got to attachments yet, but our forum uses attachments that are stored in the DB it seems. Will this be handled by the script or do I need to make changes?
I see posts with vb code are not being formatted at present. I need to run something after import I believe?
I figured out a neat way to fix this. On the vb forum go to the attachment and switch storage to file based. It will ask for a folder and export all the attachments to that folder. When it is done, it will ask you to finalise this. At this point if you say no you have a folder with all the attachments but the forum is left untouched with attachments in the db.
I see the following remaining formatting issues on my transferred forum. That is after the post clean-up scripts ran:
Lists tags aren’t fixed
[LIST]
[*]item 1
[*]item 2
[*]item 3
[/LIST]
I guess I should just remove the tags and the brackets round the * and add a space and it should be formatted right. Any ideas how? I can update the import script regex I guess? Looking for some regex genius help.
I´ve updated the post_action table and imported our old likes. These are shown in queries, but not in the interface.
How do I refresh the interface?
Answer: rake user_actions:rebuild