Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
2 Odpovědi
8293 Zobrazení

I have installed my test and development OpenERP v6.1 on Windows.

If I rename the file sale_order.rml to sale_order.old within the folder sale/report/, I can still print the quotation order from the sales module. The quotation order is based on the sale_order.rml file or template.

This means that OpenERP stores the rml somewhere else.

As a consequence, if I modify the rml file manually, this new version of the rml file doesn't get used by OpenERP.

However, on my production installation, I don't have the same problem and the latest rml file is always used.

I have tried to clean up the cache from my browser (Waterfox), but it hasn't helped anything.

Where could the rml file be cached?

Avatar
Zrušit
Nejlepší odpověď

After you have edited the report the first time in OpenOffice it will be stored in database table ir_act_report_xml in fields:

  • report_rml_content_data (RML) and
  • report_sxw_content_data (SXW)

The report is only taken from file if those fields are empty, which is the case after a fresh install.

Avatar
Zrušit
Autor

Andreas, you seem to know everything! If I set these two fields to null, will OE read from the physical rml file then?

Nejlepší odpověď

If you cannot see any change after the direct edition, you must clear the db by following.

1.Open pgAdmin. check your report id in ir_act_report_xml.

2.Open a query.

SELECT id FROM ir_act_report_xml WHERE model = 'sale.order';

3.put the id (ir_act_report_xml.id) result into place of your_id

update ir_act_report_xml SET report_rml_content_data = NULL WHERE id = your_id;

4.Run and enjoy the rml edition. :-)

Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
1
bře 15
6417
5
bře 15
20424
1
bře 15
4019
1
bře 15
5128
1
bře 15
4791