SMF -> Joomlaboard conversion

[maxdg]

Is there a script to perform this conversion..?  :P

[quiquedcode]

Searching for same stuff
If someone knows... please let us know

[maxdg]

I tried this with a 80% of success..

TSMF

Here's the code posted:

" . mysql_error());
       
        //
        // On choppe l'id du dernier enregistrement
        $r = mysql_query( "SELECT id FROM mos_sb_messages order by id DESC limit 1" ) or die (mysql_error());
            $result = mysql_fetch_array( $r );
            $prec_sb_id = $result['id'];
       
        if( $parent == 0 )
            $threadupdate = $prec_sb_id;
       
        mysql_query( "UPDATE mos_sb_messages SET thread = '$threadupdate' WHERE id='$prec_sb_id'") or die(mysql_error());
       
        //
        // Et maintenant faut inserer le texte dans la base de sb aussi....
        $query = "INSERT INTO mos_sb_messages_text VALUES ('$prec_sb_id', '$body')";
        mysql_query($query) or die ("$query" . "" . mysql_error());
       
        $prec_smf_topic = $id_topic;
    }
    echo "done";
?>

Change

Code: Select all

mos_sb_

with the joomla table name

Code: Select all

jos_sb_

Notice that:

    include("mysql.php");

refers to a connection file you must create at the same level.

This:

Code: Select all

<?php

function connectbdd()
{
    if( false == mysql_connect("", "", "") )  /// FILL with your connections details
        die("Error");
    
    if( false == mysql_select_db("") ) // FILL with your database name
        die("Error.");
}

?>

In this way I saved about 80% of messages.. still don't know why.. 

Here's the results:
joomlaboard
SMF

[quiquedcode]

Thanks maxdg
I'll try this to see what happens

[maxdg]

...let us know.. 

[kai920]

I'm also considering moving over to Joomlaboard (currently running SMF 1.1RC2)

Any updates to this thread & stories of success porting the posts over?

Thanks!

[maxdg]

...I miss SMF.... 

PS.. SMF forum (link posted above) don't longer exist on my site.. so don't search for...

[kai920]

...I miss SMF.... 

PS.. SMF forum (link posted above) don't longer exist on my site.. so don't search for...

Hehe, I tried a few minutes ago and found it wasn't up...

Why do you miss SMF?

[maxdg]

Why do you miss SMF?

Because there is still some minor problems and isn't "that" killer application like SMF.
But users are tired of my "upgrading syndrome" and I want to take it easy for a while.. 
If you need a strong and multifunctional forum... leave JB where it is, for now.. (but if your needs are to let Community Builder driving the bus and have a little forum just-for-having-it.. it may be a solution).

Just my € 0,10 ..

[maxdg]

...and... there's another important reason that makes me change my mind about SMF...

It's called Mambelfish (actual Joomfish)

If you need to setting up a multilanguage website, which translates contents, menus, hyperlinks and stuff just clicking a button, Joomlaboard is for you.

As you know, in a bridged-SMF you (as user) have to set your preferred language in your profile preferences, this don't affects Joomla default language at all and vice-versa.

Take a look on this: www.78live.net
It's a Joomla 1.0.8 + Joomlaboard + Mambelfish + Community Builder almost fully integrated (sorry, but I didn't planned to have chinese visitors.. so there's only european languages to choose  )

Here: www.string.is.it there's some Japanese (just for take a look at UTF-8 results)

Ciao!

[tonybone]

Excuse my "newbieness" here but where do you have to run the script from to do the conversion? Also, I assume that the connection details and database in the mysql.php file is for the SMF database? Is this right?
Thanks.

[kai920]

Thanks maxdg for your input. as someone who has used both, I value your opinions very much 
I think I will stay put for now with SMF

[maxdg]

Excuse my "newbieness" here but where do you have to run the script from to do the conversion? Also, I assume that the connection details and database in the mysql.php file is for the SMF database? Is this right?
Thanks.

That's right.
Place both files in the SMF root and launch the convertor one.
Don't forget to backup, first !!! 

[chadness]

...and... there's another important reason that makes me change my mind about SMF...

It's called Mambelfish (actual Joomfish)

Read this post carefully to the end.  He found a way to integrate SMF's language switching in with Joomfish.

[maxdg]

...and... there's another important reason that makes me change my mind about SMF...

It's called Mambelfish (actual Joomfish)

Read this post carefully to the end.  He found a way to integrate SMF's language switching in with Joomfish.

Chadness... I actually don't know if I got to love or hate you....
This is a very important point (with the other one regarding layouting).. but you've waked up my sleeping "upgrading syndrome" .. 

Anyway... many thanks.. 

[tonybone]

Excuse my "newbieness" here but where do you have to run the script from to do the conversion? Also, I assume that the connection details and database in the mysql.php file is for the SMF database? Is this right?
Thanks.

That's right.
Place both files in the SMF root and launch the convertor one.
Don't forget to backup, first !!! 

So, for the converter to work do the Joomla and SMF tables have to be in the same database? I have them on separate databases and when I tried to run the converter, I basically get an error telling me that 'jos_sb_categories' doesn't exist in my SMF database (which of course, it doesn't).

[manuelap]

Who has managed to do a succesful conversion for smf 1.1 rc2 to joomlaboard? Am looking for months to find a working solution.... am willing to provide a small financial compensation to whoever manages to get it to work!

[maxdg]

So, for the converter to work do the Joomla and SMF tables have to be in the same database?

Yes, they should..

[manuelap]

Maxdg, have you managed to get a conversion working for smf 1.1. rc2 to joomlaboard and can you reproduce this?

[maxdg]

Maxdg, have you managed to get a conversion working for smf 1.1. rc2 to joomlaboard and can you reproduce this?

As I wrote above, I've FOUND a script to manage this conversion but it worked for me at 80%, since I've lost some messagges and actually don't know why.

There's a link to the original article in my post... I can't say much more about this.

[HolmesSPH]

I unfortunately switched from Simpleboard to SMF, and while SMF is by far the more superior program in way of Forums are concerned, they are not good for those integrating into CB, or CBE... Unfortunately, it's even worse if you using a bridge too, because the search engines did NOT pick my forum posts because I set up the bridge to wrapp it, so it's .... a loose loose... Im going back to Joomlaboard because I have 16K members and I can't continueally be having trouble any more...

Oh yeah, also the SMF< CB login module does not take advantage of new the login bug fixes present in Joomla 1.0.8 so AOL users and others behind proxies will have ALOT of trouble.....

[radianation]

I'm getting this error message:

96202CATEGORIE INEXISTANTE DANS LA BASE MAMBO!!!

I have no idea what it's trying to tell me?

[maxdg]

Maybe "he" wants you to manually generate your old-SMF category tree in new-JB.
This is a conditio sine-qua-non for this script to works..

(it isn't written somewhere?)

[radianation]

I seem to recall seeing this about 6 months ago when I first looked into the conversion, but I didn't see it anywhere when I looked this time. So I need to recreate the forum categories by hand in Joomlaboard and then make the conversion. Got it. I'll give it a shot.

[Selwyn Wacks]

conversion from smf 1.1.rc2 to joomlaboard is perfect

see it on http://www.turbocashtraining.co.za/joomla

first you convert smf to phpbb2 (you have to install phpbb2 on same dbase as joomla. and load the ucs convert as well as the smf converter)

then you do the phpbb2 to joomlaboard converter

perfect

[radianation]

Excellent. Thank you for the tip.

[ITzorro]

Hi,
I am new at Joomla and are preparing a site that has multilanguage support (Joomfish) together with Joomlaboard and I saw that maxdg's site had that, so my question is how do I do this?

[maxdg]

Hi,
I am new at Joomla and are preparing a site that has multilanguage support (Joomfish) together with Joomlaboard and I saw that maxdg's site had that, so my question is how do I do this?

Hi,
When you have successfully completed your Joomfish installation the only thing to do is to popolate the /languages folder for each component you want to be Joomfished..
Joomfish do the rest, so when you clic a flag it calls the appropriate language.php file.

[ITzorro]

Thanks, just got it to work

[ITzorro]

Just one more question, how did you get the flags (instead of drop downlist) on your site 78live?
I have Joomfish and Multilingual aware Main Menu installed.
http://www.stefansukulele.se