Odoo Help


This community 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.


Report designer with OpenOffice cancels modifications

on 4/3/13, 1:01 PM 2,680 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
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

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. 

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.

Bista Solutions US, Ray Carnes
on 4/4/13, 2:14 AM

Thank you for your help

on 4/4/13, 5:00 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)


Asked: 4/3/13, 1:01 PM
Seen: 2680 times
Last updated: 3/16/15, 8:10 AM