Odoo Help


Moving desired changes from one database to another avoiding complete migration

umer farooq
on 10/23/13, 8:51 AM 2,579 views

Hello, So the next big thing which is worrying me alot that once i have setup everything on testing server now i am migrating my database to production server Ok it's working fine on production server too all setup nicely as it was on testing server. Now I need to make some changes in Testing server tested it got the desired output now i want to do it on production server as well I dont want make changes directly on production server Just want my testing server work to be copied there without migration of complete database.what's the solution i will have to move whole database again and restore it on production?? Yes it's a solution but it's not the smartest solution I reckon now what i want is just to move those files which are being changed during testing new things on Testing server how can I just avoid whole migration of database. Urgent plz.

The folder you are referring to in your question. Is it a folder in the addon folder or changes made in database such as adding customer or products to the database?

on 10/23/13, 11:53 AM

No some technical things I do like I forgot to set My CASH journal to set ALLOW CANCELLING ENTRIES.Now I recall it and now I will have to mark it in Qc server now what to do like what i must copy or transfer to my production server to make it act like my testing server hope it clears a bit..

umer farooq
on 10/23/13, 11:58 AM

In my case we are not supposed to do any changes in production that's the main problem that's why i am looking for the frequent transportation of changes applied in Testing server whatever we change just those particular files move to Production server that's it.

umer farooq
on 10/23/13, 12:02 PM

the best option is to make the changes directly in the Qc server alternatively you can export the journal(s) in question and import them into the Qc database. When you export, make sure you select all the fields.

on 10/23/13, 12:30 PM

kayins thank you for your response.But it's still a blur picture for me can you please expand it a little in terms of explanation what exactly the solution is..

umer farooq
on 10/23/13, 3:08 PM

If you have not setup this particular journal yet in your Qc server version already, simply open the test database where you have the journal setup and export the journal with all the information that goes with it. You will get a CSV file, save it and open the Qc database and go to the same module where the journal should be and import.

on 10/24/13, 9:04 AM

@kaynis Thank you for your assistance but brother I am getting this error whenever itry to do it No matching record found for external id '__export__.account_invoice_11_1' in field 'Period' at row 2 Get all possible values

umer farooq
on 10/25/13, 11:01 AM

Try this. Open the CSV file and search which column contains the same text string. If it is not the id column then try not importing that column when you do your import.

on 10/25/13, 11:22 AM

Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 10/28/13, 10:39 PM

The best way is to write a module that encapsulates your changes in code and XML records.

You can then test this module in any number of databases before deploying the module in production.

Ray Carnes I tried for different solutions for moving desired changes to my production but I am failed in it I can't find any solution now How can I write a module that encapsulates my changes (I usually do changes through interface not from code) and I am using windows7 and openerpallinone setup file kindly help me in it.

umer farooq
on 12/13/13, 9:44 AM

Hello Ray Carnes. I am trying to develop my own custom module I am able to bring 2 new fields in (project.project) model.OK fine working. but now I want to create a field in (account.invoice) model what would I do I will have to write another custom module defining all the things about account.invoice?? please answer me :(

umer farooq
on 1/22/14, 11:47 AM

You can either add to your existing module or create a new one, depending on how the changes are related.

Ray Carnes
on 1/22/14, 1:20 PM

Ok in my custom_module.py I have defined my fields in _inherit="project.project" and another _inherit="account.invoice" both are written and class is closed custom_fields(); what about xml?? how will I write it in a same file ??

umer farooq
on 1/22/14, 1:32 PM

Have a look at some of the examples - you can do separate files or one file. A python file contains one or more classes, an XML file contains one or more records to be inserted into the database. How you manage it is really up to you. A single XML file would just contain the contents of all other XML files, but they are separated logically or for maintenance purposes.

Ray Carnes
on 1/22/14, 3:16 PM

Thanks man for your concern:) http://help.openerp.com/question/42257/finding-difficulties-in-writing-xml-files-for-my-custom-module/ kindly have a look at this question of mine if it gives you any clue about what I want it to be act like :) thank you and if you have any example of it kindly give me a link of it too :)

umer farooq
on 1/23/14, 10:25 AM

Thanks man for your concern:) http://help.openerp.com/question/42257/finding-difficulties-in-writing-xml-files-for-my-custom-module/ kindly have a look at this question of mine if it gives you any clue about what I want it to be act like :) thank you and if you have any example of it kindly give me a link of it too :)

umer farooq
on 1/24/14, 8:57 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 10/23/13, 8:51 AM
Seen: 2579 times
Last updated: 3/16/15, 8:10 AM