How to Migrate from Mosets Tree to SobiPro

When I recommended that my customer upgrade from Joomla 1.5 and Mosets Tree to Joomla 2.5 and SobiPro, I had no idea how difficult the directory migration would be. I thought I could export using the Mosets Importer (which I thought was an import/export) and import using the SobiPro CSV importer. Well, that didn’t work out at all… I could not even get past the first step, exporting.

I could not find a solution for this, so I have created one myself. It was not easy, so I understand why there are no solutions available for this. Using my method is not point and click. You will need to match custom field ID’s and possibly make other tweaks, but this will take care of 90% of the work. Watch the long detailed video to see how I did it.

You may download the .txt files with the sql scripts below. Notice that all tables are located in the same database. If you are pulling from another database, you will need to modify the table calls. I found it easier to import jos_mt_cats, jos_mt_cfvalues, jos_mt_cl and jos_mt_links from the old database. You will also need to change the table prefixes to match your database. My Joomla 2.5 database table starts with “uizb1_” but you will need to find & replace this prefix with yours.

Good luck!

DOWNLOAD SCRIPTS ——————————————–
Mtree 2 to SobiPro Listing Migration Script
Mtree 2 to SobiPro Category Migration Script

————————————————————-

Be Sociable, Share!
Tarik Assagai
Tarik (@tarik916) is a web developer and owner of ACS Digital Media, a Sacramento based web development agency specializing in open source CMS systems. If you are looking for support for your current or upcoming projects, visit www.acs-digital.com.

11 Comments

  1. Hello,
    I need to import data into SobiPro from a table mySql where I have my contact information.
    As I can do it?

    • tarik916 /

      I am not sure exactly what you are trying to do, but I have not had to perform any other imports. This tutorial should help you though multiple relevant situations.

  2. Very very very usefull! I managed to migrate over 7.000 listings and 700 categories. You saved me from a lot of days of work!!! Thank you so much! 😀

  3. jolmeda /

    After doing everything said on your video the parent category for all in the base category, tried to change it directly on the database and none of those imported categories are available and also got this error when trying to view the listings..

    No controller to execute Cannot unserialize raw variable

    How to fix this? Thanks in advanced

    • Tarik Assagai /

      I am sorry, I have not seen this error but have used the steps a few times on different sites. I hope you have a backup to try again.

Leave a Reply