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.

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.

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..