Community mailing list archives
Re: migrating magentoerpconnectby
I Finally made the migration following those steps :
-uninstall magentoerpconnect and his dependencies from the v7 database.
-clean the v7 database by removing tables left by magentoerpconnect
-run the migration script of openupgrade
-install the odoo 8 version of connector on the db
-synchronize with magento
Now my problem is to reestablish the connection between orders, products, partners migrated from v7 to v8 and those which are in magento site to avoid duplicated items in the database.
I found that in v8, the connector link item(magento-odoo) with an intermediary table : magento_table_name.
So I'm writing some sql scripts to fill those table so the connector will know that those items are already imported and won't try to synchronize them again.
is it the good way ?
is there any better solution ?
2015-09-04 20:23 GMT+01:00 Harold Tamo <email@example.com>:
Hi,Could you please give me the steps ?. I have no experience with Talend Open Studio yet.Thanks--2015-09-03 17:10 GMT+01:00 Ragheb Amna <firstname.lastname@example.org>:Hi,I migrated data from 6.1 to 8 using Talend open Studio and it works correctly .Regards,2015-08-28 7:09 GMT-04:00 Harold Tamo <email@example.com>:Hi,Thanks i will take a look.regards,2015-08-28 8:48 GMT+01:00 Guewen Baconnier <firstname.lastname@example.org>:Hi,It was not generic because it took assumptions on the database being migrated for simplification.
I made a migration from 5 to 7, which should be close that 6.1 to 8. At that time it was using oerpscenario.Though, the queries here could be useful as a basis for your migration: https://gist.github.com/guewen/10095287On Thu, Aug 27, 2015 at 8:11 PM, Harold Tamo <email@example.com> wrote:Hello community,Does anyone tried to migrate an odoo 7 database with magentoerpconnect v6 (6.1.2) to odoo 8 using openupgrade ?I know it sound weird but we adapted the v6 of the connector for install on odoo v7 when the magentoerpconnect 7 was not yet released.So now, what i have :- Odoo v7 with magentoerpconnect v6.1.2What i want :-migrate the v7 database to v8 of odoo with the new version of the connectorwhat i have tried :-launch openupgrade migrate script with link to new connector and his dependencies but since the code change too much, many errors occurs and i don't know how to write scripts for that without analysis files.- uninstall magentoerpconnect from v7 database, run the migrate script on it. The migration ends well (with some errors fix) but i can't initialize the database on v8 because some fields in product table are missing (what is normal)If at least someone tried to migrate from v6 to v7, thanks in advance for your help.I was also thinking to look forward ETL migration like talend and I found this github repo : https://github.com/baumgaro/Odoo-Talend-Component. Any ideas ?Thanks in advance.regards,----