I wrote a perl procedure to migrate my PhpBB2 forum to E-Blah SQL beta4, it's attached to the message.

The procedure requires both the boards on the same machine, and will migrate:

• Members, including passwords, signatures, administrative flag and avatars (both uploaded and URL)
  
• Categories
  
• Boards
  
• Topics
  
• Posts

While migrating several text fields will be converted from ISO-8859-1 to UTF-8, and their BBCode cleaned up:

• Members "sn" and signatures
  
• Category name and description
  
• Board name and description
  
• Topics title and originating poster
  
• Posts body
  

Before using it copy the attached script onto your linux server, edit it in its very first variable (%O, options), and launch it by using as the only argument the database password.
Requires perl modules DBI and Encode.

It's supposed to be used on an E-Blah fresh install, and will migrate all users from PhpBB2 with user_id greater than 1.

Now that is excellent, thank you.

Quoted from Martin

Now that is excellent, thank you.

You're welcome.... I like E-Blah, and I'm happy if I can give back something to the community using it.

By the way about the script: be aware, the migration will delete all users, categories, boards and posts (except user with id 1)!
As I wrote, it's supposed to be used on a fresh E-Blah install.

The version I posted was migrating a wrong setting for user (a minor one, a confusion between "owns an avatar" and "show avatars"), and was always converting to UTF.

Here it's a fixed version.

Thank's again.

We do have a converter here: http://www.eblah.com/forum/m-1192743106/s-1/highlight-converter/#num3

With your knowledge, maybe you can take a look and update it if necessary.

Quoted from Martin

We do have a converter here: http://www.eblah.com/forum/m-1192743106/s-1/highlight-converter/#num3

I had a look to it, in fact I read it before deciding I wanted to write a new one... It's only designed for the non-SQL version of blah, while the most part of the work performed by my version is a SQL-to-SQL using simple queries.

By having a look at E-Blah code I found also that it could be useful to change the way it handles the HTML behaviour, first of all removing all hardcoded padding/spacing and introducing a lot of classes and ID attributes in order to make the CSS more effective.
In addition, the use of something like HTML::Template (saving in cache interpreted templates, through Storable) instead of hard-coding HTML could enhance the role of templates.

Unfortunately I'm currently working on the SQL version of E-Blah, and it sounds like a branch, a variation from the "main" release, then it wouldn't make very sense to operate such changes on this secondary branch...

Thanks, this is great.  

Could you package it up with a help file and allow me to add it to the downloads page?

And yes, it was branched in Feb/Mar 2007, I believe.  There's a lot that could be done with it, but I've just not had any time to spend working on either version lately.