I have been finding a way to Sync Data from LocalDB to Production Database. I have created a custom module and developed the web page using web controllers, however some web pages I created using drag and drop functionality of the web module, I guess these changes are saved in the database. How to synch those data from the local database to the production database?? whats the mechanism of Sync drag-drop functionality from Local to Production.
if we transfer odoo 15 sale order to odoo 17 sale order, and there are attachments / file store linked to this order. How will transfer this ? attachments/ file store ?
Definitely there will be changes in database tables on each version, at that time, we have to write the logic and fields mapping correctly in the script
this just way a showing how we can connect the two different odoo instance and transfer the data. Along with this if we can add some logic's for data migration, we can easily migrate odoo to forward or backward versions.
Thanks for this video, this code can be used in Automated Action or Schedule action?. When user create a Lead in a versión 11, this lead is too created in version 13.
Thank you for the great tutorials . Is it possible to sync data (one way) like once first transfer done to get only either new leads or updated leads to get transfer
yes will be possible, script has to designed such a way by understanding the difference between the DS in odoo 12 and odoo 13. For example, account.invoice is not existing in odoo 15, so the one who write script should know it and data has to be mapped correctly
Thanks for the video.. if we need to create data real time is possible. That is at the time of creation of a lead in Odoo 12 , same lead will be created in Odoo 13 also... is this possible...??? Or is it better running a automated action in Odoo 13 to fetch newly created datas in Odoo 12.. Awaiting your reply
Excellent as always friend, consult, is there a tool that can migrate all the tables and guide us on the order of tables to migrate first? Thank you very much in advance for your answer :)
Thanks for this video, I am trying to transfer data with this script from odoo13 to odoo14 and getting a "False" value in the uid_db1 variable uid_db1 = common_1.authenticate(db_1,username_db_1,password_db_1,{}) can you pls guide what's wrong with this line?
@@OdooMates Thanks issue has been resolved, I was passing the Postgres user credentials. I have one more question I want to transfer data (with database ids) from v13 to v15 db. I want to create the same database ids in my v15 db which exist in my v13 db, is it possible?
I have been finding a way to Sync Data from LocalDB to Production Database. I have created a custom module and developed the web page using web controllers, however some web pages I created using drag and drop functionality of the web module, I guess these changes are saved in the database. How to synch those data from the local database to the production database?? whats the mechanism of Sync drag-drop functionality from Local to Production.
you can export that views from the views menu in the settings - technical - user interface -> views and import it in production
@@OdooMates Thanks a lot buddy it worked like a charm
Glad that it helped
if we transfer odoo 15 sale order to odoo 17 sale order, and there are attachments / file store linked to this order. How will transfer this ? attachments/ file store ?
there is some way to transfert all table in the database to the new database for different version of Odoo?
Definitely there will be changes in database tables on each version, at that time, we have to write the logic and fields mapping correctly in the script
Thank you for guiding the community mates.
Thanks brother :)
Hi
for the migration purpose , is both db wants to be running and if so , can we run one db on normal window and other on private window?
yes you can
Does Odoo have backward compatibility at the database schema?
this just way a showing how we can connect the two different odoo instance and transfer the data. Along with this if we can add some logic's for data migration, we can easily migrate odoo to forward or backward versions.
If the field does not exist(or name change) while migration, that time what we do?
this has to be adjusted in the scrypt
Can the data be transferred with the external ID as well?
Thanks for this video, this code can be used in Automated Action or Schedule action?. When user create a Lead in a versión 11, this lead is too created in version 13.
Not directly from the UI, but from the code you can achieve it
Like that we can migrate Odoo 10 Database to Odoo 13 enterprise.? Or any helping materiel about that please.
proper logic's has to be done for that, across the version there will be changes, so we have to consider those and add it to script
Thank you for the great tutorials .
Is it possible to sync data (one way) like once first transfer done to get only either new leads or updated leads to get transfer
will be possible, but we have to make it
Excellent Tutorial thank you sir but i want ask you, this methode is valid for migration from version 12 to version 15 community ?
yes will be possible, script has to designed such a way by understanding the difference between the DS in odoo 12 and odoo 13.
For example, account.invoice is not existing in odoo 15, so the one who write script should know it and data has to be mapped correctly
Great video! Is this method capable for file transfer? Generally the records has multiple binary files come with them.
will be possible
Thanks for the video..
if we need to create data real time is possible. That is at the time of creation of a lead in Odoo 12 , same lead will be created in Odoo 13 also... is this possible...???
Or is it better running a automated action in Odoo 13 to fetch newly created datas in Odoo 12.. Awaiting your reply
yes possible you can override the create and write method of odoo12 and call the newly creating syncing method to update data in odoo13 instantly
How to display according to selected days data to weekly view in calendar?please, explain me for calendar view.
Very good tutorial, thanks.
You are welcome!
how can i add all fields and all views of each models??
You can create a script for it and apply the logic
Excellent as always friend, consult, is there a tool that can migrate all the tables and guide us on the order of tables to migrate first? Thank you very much in advance for your answer :)
That we have to analyse and check based on the installed in the database
@@OdooMates Thank you very much for your answer :)
can it work from odoo10 to odoo13?
Yes it wil
Please Where can we find these files
Unfortunately it is not hosted or shared in the github, even it get deleted.
This code will repeat the result wehen i excute the code again i want none repeat please
you have to further modify the scrypt/coding to check if the data exists in the db or not
How can i do this
Check the record exists in the db, this can be done using odoo search method and if conditions
Thanks for this video, I am trying to transfer data with this script from odoo13 to odoo14 and getting a "False" value in the uid_db1 variable
uid_db1 = common_1.authenticate(db_1,username_db_1,password_db_1,{})
can you pls guide what's wrong with this line?
may be you passed wrong db credentials ?
@@OdooMates Thanks issue has been resolved, I was passing the Postgres user credentials.
I have one more question I want to transfer data (with database ids) from v13 to v15 db. I want to create the same database ids in my v15 db which exist in my v13 db, is it possible?
It will be tricky, to create with same id there
@@OdooMates any guidance/hint on this, so I can further explore it.