Hello:
Could anybody help me with this error?
ValueError: External ID not found in the system: report.external_layout load could not load template Template: report.external_layoutI´m trying to create an odoo report for a libreria module
Thanks!!!
==================================================
REPORT_LIBRO.XML
<odoo>
<data>
<report
id="libreria.report_libro"
model="libreria.libro"
string="informe Libro"
name="libreria.report_libro_view"
file="libreria.report_libro_view"
report_type="qweb-pdf"
/>
<template id="libreria.report_libro_view">
<t t-call="report.html_container">
<t t-foreach="docs" t-as="libro">
<t t-call="report.external_layout">
<div class="page">
<h2 t-field="libro.name"></h2>
<div>
<strong>Precio:</strong>
<span t-field="libro.precio"></span>
</div>
<div>
<strong>Ejemplares:</strong>
<span t-field="libro.ejemplares"></span>
</div>
<div>
<strong>Categoría:</strong>
<span t-field="libro.categoria"></span>
</div>
</div>
</t>
</t>
</t>
</template>
</data>
</odoo>
==========================
MANIFEST:
..........
# any module necessary for this one to work correctly
'depends': ['base'],
# always loaded
'data': [
# 'security/ir.model.access.csv',
'views/views.xml',
'reports/report_libro.xml'
#'views/templates.xml',
],
==================
ERROR
Odoo Server Error
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\cache.py", line 88, in lookup
r = d[key]
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\func.py", line 69, in wrapper
return func(self, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\lru.py", line 44, in __getitem__
a = self.d[obj].me
KeyError: ('ir.qweb', <function IrQWeb.compile at 0x0366C810>, 'report.external_layout', ('es_ES', False, None, None, None, None))
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\cache.py", line 88, in lookup
r = d[key]
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\func.py", line 69, in wrapper
return func(self, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\lru.py", line 44, in __getitem__
a = self.d[obj].me
KeyError: ('ir.model.data', <function IrModelData.xmlid_lookup at 0x0206C198>, 'report.external_layout')
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\qweb.py", line 372, in get_template
document = options.get('load', self.load)(template, options)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_qweb.py", line 122, in load
template = env['ir.ui.view'].read_template(name)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_ui_view.py", line 1184, in read_template
return self._read_template(self.get_view_id(xml_id))
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_ui_view.py", line 1200, in get_view_id
return view and view.id or self.env['ir.model.data'].xmlid_to_res_id(template, raise_if_not_found=True)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_model.py", line 1413, in xmlid_to_res_id
return self.xmlid_to_res_model_res_id(xmlid, raise_if_not_found)[1]
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_model.py", line 1404, in xmlid_to_res_model_res_id
return self.xmlid_lookup(xmlid)[1:3]
File "<decorator-gen-25>", line 2, in xmlid_lookup
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\cache.py", line 93, in lookup
value = d[key] = self.method(*args, **kwargs)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_model.py", line 1393, in xmlid_lookup
raise ValueError('External ID not found in the system: %s' % xmlid)
ValueError: External ID not found in the system: report.external_layout
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\web\controllers\main.py", line 1671, in report_download
response = self.report_routes(reportname, docids=docids, converter=converter)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 519, in response_wrap
response = f(*args, **kw)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\web\controllers\main.py", line 1612, in report_routes
pdf = report.with_context(context).render_qweb_pdf(docids, data=data)[0]
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_actions_report.py", line 711, in render_qweb_pdf
html = self.with_context(context).render_qweb_html(res_ids, data=data)[0]
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_actions_report.py", line 751, in render_qweb_html
return self.render_template(self.report_name, data), 'html'
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_actions_report.py", line 534, in render_template
return view_obj.render_template(template, values)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_ui_view.py", line 1299, in render_template
return self.browse(self.get_view_id(template)).render(values, engine)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\web_editor\models\ir_ui_view.py", line 27, in render
return super(IrUiView, self).render(values=values, engine=engine, minimal_qcontext=minimal_qcontext)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_ui_view.py", line 1308, in render
return self.env[engine].render(self.id, qcontext)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_qweb.py", line 59, in render
result = super(IrQWeb, self).render(id_or_xml_id, values=values, **context)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\qweb.py", line 274, in render
self.compile(template, options)(self, body.append, values or {})
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\qweb.py", line 348, in _compiled_fn
raise e
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\qweb.py", line 346, in _compiled_fn
return compiled(self, append, new, options, log)
File "<template>", line 1, in template_953_54
File "<template>", line 2, in body_call_content_53
File "<template>", line 3, in foreach_52
File "<decorator-gen-54>", line 2, in compile
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\cache.py", line 93, in lookup
value = d[key] = self.method(*args, **kwargs)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_qweb.py", line 114, in compile
return super(IrQWeb, self).compile(id_or_xml_id, options=options)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\qweb.py", line 291, in compile
element, document = self.get_template(template, options)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\qweb.py", line 376, in get_template
raise QWebException("load could not load template", name=template)
odoo.addons.base.models.qweb.QWebException: None
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\cache.py", line 88, in lookup
r = d[key]
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\func.py", line 69, in wrapper
return func(self, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\lru.py", line 44, in __getitem__
a = self.d[obj].me
KeyError: ('ir.qweb', <function IrQWeb.compile at 0x0366C810>, 'report.external_layout', ('es_ES', False, None, None, None, None))
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\cache.py", line 88, in lookup
r = d[key]
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\func.py", line 69, in wrapper
return func(self, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\lru.py", line 44, in __getitem__
a = self.d[obj].me
KeyError: ('ir.model.data', <function IrModelData.xmlid_lookup at 0x0206C198>, 'report.external_layout')
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\qweb.py", line 372, in get_template
document = options.get('load', self.load)(template, options)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_qweb.py", line 122, in load
template = env['ir.ui.view'].read_template(name)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_ui_view.py", line 1184, in read_template
return self._read_template(self.get_view_id(xml_id))
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_ui_view.py", line 1200, in get_view_id
return view and view.id or self.env['ir.model.data'].xmlid_to_res_id(template, raise_if_not_found=True)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_model.py", line 1413, in xmlid_to_res_id
return self.xmlid_to_res_model_res_id(xmlid, raise_if_not_found)[1]
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_model.py", line 1404, in xmlid_to_res_model_res_id
return self.xmlid_lookup(xmlid)[1:3]
File "<decorator-gen-25>", line 2, in xmlid_lookup
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\cache.py", line 93, in lookup
value = d[key] = self.method(*args, **kwargs)
File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_model.py", line 1393, in xmlid_lookup
raise ValueError('External ID not found in the system: %s' % xmlid)
ValueError: External ID not found in the system: report.external_layout
load could not load template
Template: report.external_layout
Qweb Reporting Tips:
1- https://learnopenerp.blogspot.com/2016/09/how-to-create-custom-reports-in-odoo.html
2- https://learnopenerp.blogspot.com/2016/11/how-to-create-qweb-reports-in-openerp.html
3- https://learnopenerp.blogspot.com/2018/09/how-to-link-custom-paper-format-in-qweb-reports-in-odoo.html
4- https://learnopenerp.blogspot.com/2018/10/how-to-add-custom-header-and-footer-in-qweb-reports-in-odoo.html