News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Migrating just products from db to VM3/Joomla 3.5

Started by bluMarmalade, June 24, 2016, 13:22:04 PM

Previous topic - Next topic

bluMarmalade

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?

jenkinhill

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....
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

bluMarmalade

I will not pay with my own money to do it. At least not untill i fail in doing it otherwise.

jenkinhill

Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Studio 42

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.

AH

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

2k products takes around 5 minutes
Regards
A

Joomla 3.10.11
php 8.0

bluMarmalade

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

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.