VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: sui_page on July 16, 2013, 10:13:54 AM

Title: [SOLVED] Migrating products from Joomla 1.5 to 2.5
Post by: sui_page on July 16, 2013, 10:13:54 AM
I've exported then imported the following files from my old Joomla 1.5 site to the newer 2.5 version:
However I'm getting the following error when I try to import the CSVI Google Base Export XML file – 'Cannot load the configuration fields. There is a problem with the import file'

That's not my concern though. Basically the products and categories are showing but 1. the products aren't being linked to any of their respective categories 2. None of the product images are showing up even after moved them from their old folder 'com_virtuemart/shop_image/product' to 'images/stories/virtuemart/product'. This is why I want to import the file above^ as I i believe it will solve my problems. Cheerio
Title: Re: Migrating products from Joomla 1.5 to 2.5
Post by: jenkinhill on July 16, 2013, 10:46:50 AM
Migration of Virtuemart 1.1 to 2 is best managed using the inbuilt script. VM2.0.22a has an enhanced migrator. For a howto see http://docs.virtuemart.net/tutorials/30-installation-migration-upgrade-vm-2/77-upgrading-vm1-to-vm2.html

CSVI issues should be posted on the CSV forum at http://csvimproved.com
Title: Re: Migrating products from Joomla 1.5 to 2.5
Post by: Yesceeohhh on July 18, 2013, 08:32:23 AM
Install latest virtumert version. Latest version have default migration option. So you can use that migration option. Consider the below steps:

1. In old virtumart table present in new version, don't change prefix.
Title: Re: Migrating products from Joomla 1.5 to 2.5
Post by: AH on July 18, 2013, 21:47:55 PM
Use the inbuilt Vm migrator and follow the process shown in the forum

Works pretty well!
Title: Re: Migrating products from Joomla 1.5 to 2.5
Post by: sui_page on July 18, 2013, 22:34:35 PM
Quote from: Hutson on July 18, 2013, 21:47:55 PM
Use the inbuilt Vm migrator and follow the process shown in the forum

Works pretty well!

Thanks for the link, I also found http://www.ostraining.com/blog/joomla/virtuemart-11-to-version-2 (http://www.ostraining.com/blog/joomla/virtuemart-11-to-version-2) tutorial. I'll let you know guys know how it goes. cheers
Title: Re: Migrating products from Joomla 1.5 to 2.5
Post by: sui_page on July 20, 2013, 13:47:35 PM
Quote from: Hutson on July 18, 2013, 21:47:55 PM
Use the inbuilt Vm migrator and follow the process shown in the forum

Works pretty well!

So I've searched various migration methods and haven't been found what I'm looking for. What I'm trying to do is move all VM products from a Joomla 1.5 site to another website with Joomla 2.5. I can't simply migrate via the various upgrade methods I've seen as all the products and images need to be moved to the other site
Title: Re: Migrating products from Joomla 1.5 to 2.5
Post by: AH on July 20, 2013, 14:09:36 PM
So if you already have a Joomla 2.5 site and want to move your VM prods etc over to it:-

(Luckily that is how I want to do it and what I have tested  8) )

Procedure:-

1.      Install virtuemart and VM AIO on the new site
2. Move your media into images/stories/virtuemart and make sure they're in the right subfolders. (category, manufacturer, product, vendor)
3. Move all the old  VM database tables to your new Joomla database  (copy/rename them to the databse folder) ensure they are named newprefix_vm_tablename
4. Enable The "Enable database Update tools" in Virtuemart Configuration
5. Go to Tools/Tools & Migration "Migration" Tab
6. Choose "Everything" and click "Start Migration"

Voila!

Title: Re: Migrating products from Joomla 1.5 to 2.5
Post by: sui_page on July 20, 2013, 15:25:21 PM
Quote from: Hutson on July 20, 2013, 14:09:36 PM
So if you already have a Joomla 2.5 site and want to move your VM prods etc over to it:-

(Luckily that is how I want to do it and what I have tested  8) )

Procedure:-

1.      Install virtuemart and VM AIO on the new site
2. Move your media into images/stories/virtuemart and make sure they're in the right subfolders. (category, manufacturer, product, vendor)
3. Move all the old  VM database tables to your new Joomla database  (copy/rename them to the databse folder) ensure they are named newprefix_vm_tablename
4. Enable The "Enable database Update tools" in Virtuemart Configuration
5. Go to Tools/Tools & Migration "Migration" Tab
6. Choose "Everything" and click "Start Migration"

Voila!

This method looks very promising but I just need some clarification on this – the databases look quite different on the different Joomla versions. Should I be changing the 'vm' prefix to 'virtuemart' as well? Even some of the fields are name diffrelnty for example 'country' and 'countries. Is this something the VM migration will sort out?
(http://s21.postimg.org/f2dnqkj03/vm_comparison.jpg) (http://postimg.org/image/f2dnqkj03/)
Title: Re: Migrating products from Joomla 1.5 to 2.5
Post by: AH on July 20, 2013, 15:39:39 PM
Yes this method should work for you based on they way you are wanting to migrate!

The old VM1 tables should only have the joomla dbprefix changed to match the new joomla dbprefix

The vm_xxx remains the same so if old joomla prefix is dog and new joomla prefix is cat

dog_vm_product.xxx  becomes cat_vm_product.xxx

You can mass rename using a great piece of freeware- Bulk Rename Utility

http://www.bulkrenameutility.co.uk/Download.php (http://www.bulkrenameutility.co.uk/Download.php)

Migration
When the migration takes place the data is copied to the relevant new tables with the dbprefix_virtuemart_newtable

The old VM tables remain in the database unchanged for you to review or re-try failed migrations or timeouts
Title: Re: Migrating products from Joomla 1.5 to 2.5
Post by: sui_page on July 20, 2013, 16:07:20 PM
Quote from: Hutson on July 20, 2013, 15:39:39 PM
Yes this method should work for you based on they way you are wanting to migrate!

The old VM1 tables should only have the joomla dbprefix changed to match the new joomla dbprefix

The vm_xxx remains the same so if old joomla prefix is dog and new joomla prefix is cat

dog_vm_product.xxx  becomes cat_vm_product.xxx

You can mass rename using a great piece of freeware- Bulk Rename Utility

http://www.bulkrenameutility.co.uk/Download.php (http://www.bulkrenameutility.co.uk/Download.php)

Migration
When the migration takes place the data is copied to the relevant new tables with the dbprefix_virtuemart_newtable

The old VM tables remain in the database unchanged for you to review or re-try failed migrations or timeouts

This worked flawlessy, you're a lifesaver. Thanks so much!  ;)