Odoo - OpenERP - How to install Aeroo Reports in Odoo OpenERP v7?
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
bzr branch lp:aeroolib
sudo python ./setup.py install
Create a new folder and download aeroo modules from launchpad to this folder with bzr.
sudo su openerp
bzr branch lp:aeroo
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
/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
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.
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.
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 &
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!