Odoo - OpenERP - How to install Aeroo Reports in Odoo OpenERP v7?

Odoo - OpenERP - How to install Aeroo Reports in Odoo OpenERP v7?

Support
Support
5000
| 2 1 2
Asked on 6/20/15, 2:36 PM
0
vote
4040 Views

Aeroo Reports is a reporting engine for OpenERP v7. 
With the help of a openoffice instance runnig at server side you can have reports in many formats like. 
PDF XLS DOC ODT ODS TXT CSV.

Install required packages and openoffice. (Around 500 mb installation)

sudo apt-get install openoffice.org python-genshi python-cairo python-openoffice python-lxml python-uno
sudo apt-get install zip bzr python-setuptools

Download aeroo library from launchpad and install as a python module

cd ~
bzr branch lp:aeroolib
cd aeroolib/aeroolib/
sudo python ./setup.py install
Create a new folder and download aeroo modules from launchpad to this folder with bzr.

sudo su openerp
cd /opt/openerp/v7/
bzr branch lp:aeroo
exit

Add aeroo directory to the module search path of openerp by editing the config file

sudo nano /etc/openerp-server.conf
change the addons_path as

addons_path = /opt/openerp/v7/addons,/opt/openerp/v7/web/addons,/opt/openerp/v7/aeroo
create an init script for openoffice

sudo nano /etc/init.d/office
Paste this to your script

#!/bin/sh
/usr/bin/soffice --nologo --nofirststartwizard --headless --norestore --invisible "--accept=socket,host=localhost,port=8100,tcpNoDelay=1;urp;" &

Make the file executable and add init script to the startup

sudo chmod +x /etc/init.d/office
sudo update-rc.d office defaults

Run OpenOffice

sudo /etc/init.d/office
You can test your openoffice installation by connecting to openoffice from port 8100

telnet localhost 8100
If you see an output like below it means openoffice is working ok.
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.

Restart openerp server to be able to check the additional module directory

sudo /etc/init.d/openerp-server restart
Now you can install aeroo modules from openerp interface.

You can find detailed information about aeroo reports from alistek's web page http://www.alistek.com/

AEROO REPORTS WIKI

To install report_aeroo_ooo on windows, check this answer for OpenOffice and PyUno setup.
https://accounts.openerp.com/forum/Help-1/question/28464?answer=28504#post-id-28504

For those encountering "Connection refused" when trying to telnet to their soffice headless, 
you can try this alternative command (it worked for me):

/usr/bin/soffice -headless -accept="socket,host=localhost,port=8100;urp;" -nofirststartwizard &

Support
Support
5000
| 2 1 2
Answered on 6/20/15, 2:45 PM
0
vote

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!

Ask a Question

Keep Informed

About This Forum

This forum is for HiTechnologia Employees & just Odoo general knowledge purpose only.

Read Guidelines

Question tools

3 follower(s)

Stats

Asked: 6/20/15, 2:36 PM
Seen: 4040 times
Last updated: 6/20/15, 2:45 PM