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
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.
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
|Asked: 4/3/13, 1:01 PM|
|Seen: 2680 times|
|Last updated: 3/16/15, 8:10 AM|