Odoo Help

Welcome!

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.

3

Excel/CSV report - Odoo 8

By
Alejandro Perez Cosio
on 10/22/14, 7:39 AM 5,163 views

Hello,
Is there a working method to build an excel/CSV report for Odoo 8?
I tried with:

  • OpenOffice/LibreOffice plugin (works up to server connection, but can't read tables/columns structure from db)
  • jasper (odoo module not working)
  • aeroo (yes with the last updates from few days ago and ubuntu 12.04.5)
  • pentaho (pentaho button (from step 5) doesn't appear on the action menu)
  • QWeb (works for pdf, but no excel or csv support)

Am I missing something?
Is there a working and explained method to have an excel/csv report for Odoo 8?

Best regards
Alejandro

hello about pentaho have you appeas pentaho report in action technical odoo 8?

imad
on 3/1/15, 5:11 PM
1
Alejandro Perez Cosio
On 10/28/14, 10:25 PM

After lots of research, I found the only module which (up to this day) works with odoo 8: jasper reports.
If you choose to work with jasper, you will also need iReport to design the report.

Hope it helps.. 
Cheers 

0

Ludo - Neobis

--Ludo - Neobis--
2387
| 2 2 5
Hoogvliet, Netherlands
--Ludo - Neobis--

Developer

Ludo - Neobis
On 10/24/14, 4:57 AM

I know for a fact that Aeroo supports this on Odoo 7 and before. I don't know the current situation, nor have I tested it for Odoo 8.

Depending on the type of report, you could also take a look at the export-to-xls possibility as provided by the company zestybeans (google zb_web something).

Thank you Ludo, I think I will have to do a new module with all the values I need to report and "export" those rows to CSV or Excel. It's weird that a basic functionality like "CSV reports" isn't implemented on Odoo.

Alejandro Perez Cosio
on 10/24/14, 9:12 AM
0
Néstor Gómez Muñoz
On 10/28/14, 10:12 PM

I dont know if I am misunderstanding your question and answering the obvious, but yes, odoo 8 can build (export) cvs files by exporting on tree view. Just select/mark desired records and select 'export' on the 'more' button; the export tool will appear and allow to select fields to export on CVS format.

I hope this be useful.

Hello Nestor, actually, I need to build a report with custom computed fields which is not supported by the csv/excel odoo exporter.

Alejandro Perez Cosio
on 10/28/14, 10:17 PM
0
OdooFan
On 3/4/15, 10:44 AM

Not sure what it is you are looking for exactly, but it is possible to export to csv from any tree view. Make sure to click the checkbox at Settings/General Settings - > Import/Export.

In a tree view click checkboxes of the items you want to export (or click the box on top to select all) and select the fields of your choice. You can save the defined export to use any next time.

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

2 follower(s)

Stats

Asked: 10/22/14, 7:39 AM
Seen: 5163 times
Last updated: 3/16/15, 8:10 AM