its random

SJDGC Forum - Completed ... Finally

So after a nice length of time (20+hours) I have finally finished the migration of the SJDGC vanilla forum to SilverStripe forum. It took a lot of hours for something so small.

The beauty of these types of projects for me is I get to use what ever method I would like to get things done. I get to use my old DB classes I have used for years and some straight no framework PHP coding.

things i missed when first planning

• html -> bbcode
• db collation issues

things overlooked

• posts last edited field when not a topic starter
• Members in the Community Member Status

After doing some test imports of the topics for the forum I realized a bunch of things I had missed when planning the migration. I forgot the fact that one database was using latin_swedish_ci for collation and one was using utf8-general-ci which led to some funky characters. This was fixed by the following.

1. if text field change to blob in db table
2. change back to your previous text field type
3. set collation to utf8 ... general_ci

The end result of all of this is the complete migration of the old forum into the new system. The users are linked to their respective posts. All the topics and comments are in place and the text is all correct.
A nice bundle of scripts for a Vanilla->SS Forum migration. Also some nice utility scripts for fixing text strings I had to make after some DB corruption/errors/mistakes. And the cherry on top is some nice snippets for my PHP editor for silverstripe and my libraries... gedit :-)

// a super simple to strip non-ascii characters from a string
preg_replace('/[^(x20-x7F)]*/','', $text_to_clean);


Tags · sites · silverstripe · issues · sjdgc · coding · php · development · update

October 17, 2009 5:28 am

This article hasn't been commented yet.