Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

Odoo 10 xls or xlsx report

wizard xlsx xls odoo10

2 الردود

15125 أدوات العرض

Eduardo Huertas

Hi,

I use Odoo 10 and Odoo 10 Enterprise

I have a custom report to generate in excel format.

I have the report in pdf using a wizard.

Now I want it to be in excel.

How can I do that?

I tried report_xlsx, but I can't find documentation for using it with a wizard.

the example in the documentation for partners works ok:

class PartnerXlsx(ReportXlsx):

def generate_xlsx_report(self, workbook, data, partners):

_logger.info('generate_xlsx_report ')

for obj in partners:

report_name = obj.name

# One sheet by partner

sheet = workbook.add_worksheet(report_name[:31])

bold = workbook.add_format({'bold': True})

sheet.write(0, 0, obj.name, bold)

PartnerXlsx('report.res.partner.xlsx', 'res.partner')

So how to do it with a wizard?

Thanks!

Niyas Raphy (Walnut Software Solutions)

أفضل إجابة

Hi,

You can try like this to print the report from the wizard.

In the wizard,

<button name="print_xls_report" string="Print Report" type="object"  class="oe_highlight"  />

Then in the python "print_xls_report" is defined,

def print_xls_report(self, cr, uid, ids, context=None):
        data = self.read(cr, uid, ids)[0]
        return {'type': 'ir.actions.report.xml',
                'report_name': 'module_name.report_name.xlsx',
                'datas': data
                }

Then we have to define the report,

class ClassABCD(ReportXlsx):

    def generate_xlsx_report(self, workbook, data, lines):
        current_date = strftime("%Y-%m-%d", gmtime())
        logged_users = self.env['res.users'].search([('id', '=', data['create_uid'][0])])
        sheet = workbook.add_worksheet()
        # add the rest of the report code here

ClassABCD('report.module_name.report_name.xlsx', 'corresponding_model_name')

Above added python code is from v9, you can add necessary changes in v10.

Thanks

Eduardo Huertas

الكاتب

Thanks a lot Niyas

It was very helpful your answer.

And yes I had to "convert it" to 10 version, and I did it this way:

Then in the python "print_xls_report" is defined,

def print_xls_report(self, data):

data['form'] = self.read(['account_analytic_id', 'fecha_desde'])[0]

return self.env['report'].get_action(self, 'module.report_name.xlsx', data=data)

Then we have to define the report,

class ClassABCD(ReportXlsx):

def generate_xlsx_report(self, workbook, data, lines):

current_date = strftime("%Y-%m-%d", gmtime())

logged_users = self.env['res.users'].search([('id', '=', data['create_uid'][0])])

sheet = workbook.add_worksheet()

# add the rest of the report code here

ClassABCD('report.module_name.report_name.xlsx', 'corresponding_model_name')

I still have the problem that when running the report, outputs this error:

Bad Report ReferenceThis report is not loaded into the database: module_name.report_name.xlsx.

So I assume that a <report> clause is left in the .xml file and I write the following:

<report

id="report_name_xlsx"

model="corresponding_model_name"

name="model_name.report_name.xlsx"

report_name="model_name.report_name.xlsx"

report_type="xlsx"

file="report_nname.xlsx"

attachment_use="False"

But when I do that, outputs the following:

2017-08-03 01:03:16,541 11242 INFO module_name odoo.tools.convert: The XML file does not fit the required schema !

Traceback (most recent call last):

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/tools/convert.py", line 905, in convert_xml_import

relaxng.assert_(doc)

File "src/lxml/lxml.etree.pyx", line 3501, in lxml.etree._Validator.assert_ (src/lxml/lxml.etree.c:194922)

AssertionError: Element odoo has extra content: template, line 3 2017-08-03 01:03:16,578 11242 INFO module_name odoo.tools.convert: /home/eduardo/odoo-git/odoo-10e/local-addons/module_name/views/templates.xml:3:0:ERROR:RELAXNGV:RELAXNG_ERR_EXTRACONTENT: Element odoo has extra content: template 2017-08-03 01:03:16,579 11242 ERROR module_name odoo.modules.registry: Failed to load registry Traceback (most recent call last):

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/modules/registry.py", line 78, in new

odoo.modules.load_modules(registry._db, force_demo, status, update_module)

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/modules/loading.py", line 335, in load_modules

force, status, report, loaded_modules, update_module)

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/modules/loading.py", line 237, in load_marked_modules

loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/modules/loading.py", line 156, in load_module_graph

_load_data(cr, module_name, idref, mode, kind='data')

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/modules/loading.py", line 95, in _load_data

tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/tools/convert.py", line 848, in convert_file

convert_xml_import(cr, module, fp, idref, mode, noupdate, report)

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/tools/convert.py", line 905, in convert_xml_import

relaxng.assert_(doc)

File "src/lxml/lxml.etree.pyx", line 3501, in lxml.etree._Validator.assert_ (src/lxml/lxml.etree.c:194922)

AssertionError: Element odoo has extra content: template, line 3 2017-08-03 01:03:16,875 11242 INFO module_name werkzeug: 127.0.0.1 - - [03/Aug/2017 01:03:16] "POST /longpolling/poll HTTP/1.1" 500 - 2017-08-03 01:03:17,000 11242 INFO module_name odoo.modules.loading: loading 1 modules...

2017-08-03 01:03:17,018 11242 ERROR module_name werkzeug: Error on request:

Traceback (most recent call last):

File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.py", line 193, in run_wsgi

execute(self.server.app)

File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.py", line 181, in execute

application_iter = app(environ, start_response)

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/service/server.py", line 246, in app

return self.app(e, s)

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/service/wsgi_server.py", line 184, in application

return application_unproxied(environ, start_response)

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/service/wsgi_server.py", line 170, in application_unproxied

result = handler(environ, start_response)

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/http.py", line 1306, in __call__

return self.dispatch(environ, start_response)

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/http.py", line 1280, in __call__

return self.app(environ, start_wrapped)

File "/usr/local/lib/python2.7/dist-packages/werkzeug/wsgi.py", line 599, in __call__

return self.app(environ, start_response)

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/http.py", line 1454, in dispatch

odoo.registry(db).check_signaling()

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/__init__.py", line 52, in registry

return modules.registry.Registry(database_name)

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/modules/registry.py", line 55, in __new__

return cls.new(db_name)

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/modules/registry.py", line 78, in new

odoo.modules.load_modules(registry._db, force_demo, status, update_module)

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/modules/loading.py", line 335, in load_modules

force, status, report, loaded_modules, update_module)

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/modules/loading.py", line 237, in load_marked_modules

loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/modules/loading.py", line 156, in load_module_graph

_load_data(cr, module_name, idref, mode, kind='data')

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/modules/loading.py", line 95, in _load_data

tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/tools/convert.py", line 848, in convert_file

convert_xml_import(cr, module, fp, idref, mode, noupdate, report)

File "/home/eduardo/odoo-git/odoo-10e/src/odoo/odoo/tools/convert.py", line 905, in convert_xml_import

relaxng.assert_(doc)

File "src/lxml/lxml.etree.pyx", line 3501, in lxml.etree._Validator.assert_ (src/lxml/lxml.etree.c:194922)

AssertionError: Element odoo has extra content: template, line 3

So I created the report in the UI

Settings -> Technical -> Reports

fields:

name: report_name

model: corresponding_model

report type: xlsx

template name: model_name.report_name.xlsx

printer report name: report_name.xlsx

And it worked just fine :-)

But the question still persists:

How I can do the <report> clause for the report in the xml file, as simulating what I did in the UI ??

Gautam

try
for index, line in enumerate(obj.timesheet_ids): sheet.write(index,2, line.date) ...

for index, obj in enumerate(partners): sheet = workbook.add_worksheet("timesheet"+str(index))

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
Update Wizard without closing it after button click wizard odoo10	0 أكتوبر 23	2486
How to save the values of fields ? wizard odoo10	4 أكتوبر 18	9314
Is it possible to create a new record with wizard? تم الحل wizard odoo10	3 يونيو 18	7685
Get data of xls file loaded to a binary field as two dimensional list[SOLVED] تم الحل xls odoo10	1 مارس 17	18231
How to get the name of file attached to a binary field before saving.? تم الحل wizard ir_attachment odoo10	2 ديسمبر 21	27345

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!