Odoo Help


Report designer with OpenOffice cancels modifications

on 4/3/13, 1:01 PM 3,470 views

I am on 6.0.3 and made modifications on General ledger and General ledger landscape report with module report designer + OpenOffice. I would like to come back to the original reports for in data base I've done the modification, how shall I do ? Thank you


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 4/4/13, 2:13 AM

As you have discovered, you can make changes to the RML on the filesystem and it will affect all databases.

You also know you can make changes via OpenOffice, but the RML is stored in the database and only affects that database, AND you can no longer edit the RML on the filesystem since OpenERP will always use what is has in the database and never look at the RML files.

If you want to switch back to RML editing after you have edited in OpenOffice (and don't want to lose what you did in OpenOffice), you need to re-open the report in OpenOffice and save it as an SXW file. Then you need to convert it into RML (addons/base_report_designer/openerp_sxw2rm/openerp_sxw2rml.py <file.sxw> <file.rml>). Then delete the binary RML field in the database and copy the RML file back to the server. Now the changes you made in OpenOffice are in the RML file that the server will use and you can edit it again and see the changes on all databases.

The binary RML is stored in the report_rml_content_data column of the ir_act_report_xml table.

You can edit either the RML or via OpenOffice or any combination, you just have to remember where things get changed and reset accordingly.

Remember, once you delete the RML from the database, the RML on disk will be used. Once you edit a report in OpenOffice, the RML in the database will be used.

Very clear and detailed answer. Thank you for your time.

on 4/4/13, 5:02 AM


--Borni DHIFI--
| 6 8 9
Tunis, Tunisia
--Borni DHIFI--

Techno Functional Consultant Odoo(OpenERP) 


Skype : dhifi.borni

On 4/3/13, 1:09 PM

replace the modified files by the original.


I don't think it is a matter of file because my reports are working fine for my other dbases. I "send to server" on OpenOffice so my modifications are on the dbase and haven't changed the files ?

on 4/3/13, 1:22 PM

So you can delete these reports in Settings/Actions/Reports . then restart your server with -u account

on 4/3/13, 1:59 PM

Are you sure ? I don't want to delete them but to come back to the orginal ones.

on 4/3/13, 2:06 PM

yes ,I have already met this problem.and you can also try it with a test database before you apply in your base.

on 4/3/13, 2:09 PM

So, in Administration / Customization / Low level objects / Actions / Reports I delete the 2 reports that I have modified. Then I restart my openerp server and my 2 reports will be back in the original format.

on 4/3/13, 2:25 PM

Sorry, but what does "restart your server with -u account" means excatly ?

on 4/3/13, 2:40 PM

restart server : ~./openerp-server -u account . -u account (update module account).

on 4/3/13, 6:22 PM

This will replace your reports with the original ones, the ones that don't have any changes made in OpenOffice. If you want to save your changes, see my answer.

Ray Carnes
on 4/4/13, 2:14 AM

Thank you for your help

on 4/4/13, 5:00 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: 4/3/13, 1:01 PM
Seen: 3470 times
Last updated: 3/16/15, 8:10 AM