I have an old VM 1.1.9 and Joomla 1.5. Instead of going the route of upgrading/migrating step by step, I'm wondering if there's another way.
I only need the products. I'm thinking of reinstalling joomla and VM to the latest versions, then just updating the database with the products table from the previous database.
Now, the old table is different than the new one. It looks like they've divided the old one into two tables. So there's alot of interlinked tables. But shouldn't it be possible to do this
via normal sql queries? I got thousands of products, and i would hate to implement them one by one.
any thoughts on this?
You can do that with the inbuilt VM migrator or by maipulating the db tables. But by far the easiest way with a large number of products is to use this migrator: http://extensions.virtuemart.net/import-export/virtuemart-migrator-detail It also takes far less time....
I will not pay with my own money to do it. At least not untill i fail in doing it otherwise.
Depends how much your time is worth....
Quote from: jenkinhill on June 24, 2016, 15:39:50 PM
Depends how much your time is worth....
Some have time and some have money, but i think it cost more in he's case to do it manually.
The simplest solution, to do it yourself(if you dont know the db Tables, is to use standard process : Full Migrate Joomla + Vm.
It is very easy to migrate into an existing setup using the included VM migrator
Just pick the product / category and manufacturer tables from vm
http://forum.virtuemart.net/index.php?topic=117216.msg396312#msg396312 (http://forum.virtuemart.net/index.php?topic=117216.msg396312#msg396312)
2k products takes around 5 minutes
Quote from: AH on June 24, 2016, 16:57:45 PM
It is very easy to migrate into an existing setup using the included VM migrator
Just pick the product / category and manufacturer tables from vm
http://forum.virtuemart.net/index.php?topic=117216.msg396312#msg396312 (http://forum.virtuemart.net/index.php?topic=117216.msg396312#msg396312)
2k products takes around 5 minutes
Thanks for the tip. But it didn't work flawlessly for me. I only got some of my products into VM3. I get an "1267 illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation..." error when I migrate. I tried to change the encoding so that the new tables has utf general and vice versa, but i get the same error.