Aeroo Reports Linux Server

This article covers installation process for Aeroo reporting engine on Linux servers. If you find the article useful or want to add some information related to this topic, please feel free to express your op Inion on Aeroo Reports & OpenOffice.org Reporting Engine dedicated forum.

Development project pages is located on Launchpad.

• For Aeroo REPORTS-OPENERP modules:

Https://launchpad.net/aeroo

• For Aeroo Reports Library-python module:

Https://launchpad.net/aeroolib

Environment Dependencies

1.Open ERP Server v. 6.x

2.os:any Linux 32bit or 64bit. (Tested on Ubuntu 10.04 server and Centos5.6 64bit)

Note: clients can work on all OS systems, that support OpenERP.

Note: This module was tested on Windows, and works on this operating system as well with custom compiled OpenERP server. Installation manual yet to be written.

Download:sources available from Launchpad via Bazaar.

Source Online: Https://launchpad.net/aeroo

Download:packaged module available from https://launchpad.net/aeroo/+download

How to Get module

1.Download Aeroo module through Launchpad via Bazaar (A Distributed revision control system).

# cd/usr/src# BZR Branch https://launchpad.net/aeroo# BZR Branch Https://launchpad.net/aeroolib

installation (Dependencies and Base system Setup)System Requirements:

1. Python 2.4.x or higher (http://www.python.org/doc/)
2. Aeroolib (BZR branch lp:aeroolib)
3. Genshi (http://genshi.edgewall.org/)
4. OpenOffice Python
5. Openoffice.org-pyuno
6. Python-lxml

Note:server does not require ' X ' windows to is running, in order to run the This module.

System Dependencies:

Names of dependencies may differ regarding your Linux distribution.

1. AEROOLIB:A Templating Library able to output ODT files
2. Python-genshi:toolkit for stream-based generation of output for the web
3. Pycairo:python bindings for the Cairo library
4. Python-openoffice:python libraries for interacting with OpenOffice.org
5. Openoffice.org-pyuno:python Bindings for OpenOffice.org
6. OpenOffice.org v.2.3.x or above.
7. Python-lxml-pythonic binding for the LIBXML2 and LIBXSLT libraries

Aeroo Reports Installation

1.Install Aeroo Reports Library-python module:

# BZR Branch lp:aeroolib# cd aeroolib/# sudo python./setup.py Install

2.Restart Openerp-server

3.Install aeroo-openerp module via administration-> Modules Management

A) manually:copy Aeroo modules to $serverpath/openerp-server/addons/.

b) Through OpenERP interface:administration/modules/update Modules List

c) Install necessary modules via OpenERP standard module Installation interface:

• OpenERP Module-report_aeroo

Description of module: This is the base Aeroo report Engine module. It can installed alone and does only basic. Odt/.ods output for reports. No need for Openoffice/libreoffice UNO environment Setup If the This module is only.

• OpenERP module-report_aeroo_ooo

(Do not install in this point! Installation is described in section report_aeroo_ooo installation)

Description of module: This is the module for adding additional reports outputs such as. pdf,. doc,. xls. As it depends on openoffice/libreoffice conversion capabilities, a Openoffice/libreoffice UNO environment setup is necess ary.

• OpenERP Module-report_aeroo_printscreen

Description of module: This is the module for printing any GTK client interface object to desired output. Note:it doesn ' t work from the Web client, cause It has no Print screen capabilities.

• OpenERP Module-report_aeroo_sample

Description of module: This is the module for adding, sample reports for easier understanding basic reporting templates.

4.Restart OpenERP Server.

If everything went well, system was ready for reports printing basic. ODT reports.

OpenERP module-report_aeroo_ooo-module installation.

This module depends the correct openoffice/libreoffice UNO runtime setup on installation server machine and local or remote Running Openoffice/libreoffice service in headless mode, if your plan to do conversion via TCP/IP network on dedicated rep Orting server.

Openoffice/libreoffice UNO Environment Setup.

Setup an openoffice/libreoffice UNO environment, it's done by simply installing of OpenOffice and Python-openoffice Packa Ges.

Note: These dependencies is required only for the support of the additional report output formats like PDF:

• Openoffice.org-base
• Openoffice.org-calc (required)
• Openoffice.org-core (required)
• Openoffice.org-draw
• Openoffice.org-graphicfilter
• Openoffice.org-headless (required)
• Openoffice.org-impress
• Openoffice.org-sdk
• Openoffice.org-testtools
• Openoffice.org-ure
• Openoffice.org-writer (required)

Note: To avoid problems of dependencies we recommend to installation full Openoffice/libreoffice meta-package on Both-targ ET system and remote system if necessary.

Note: Headless OpenOffice below version 3.x. Requires Package–openoffice Headless. Package permits OpenOffice to launch in service mode. If you have OpenOffice 3.x or above and then you don't need to install the this package, because in versions 3.x or above Openoff Ice Headless is already implemented.

If you get a error message like this:

/usr/lib64/openoffice.org/program/soffice.bin X11 Error:can ' t open display:    Set display environment variable, use- Display option    or check permissions of your X-server    

When the starting OpenOffice in shell with "-headless" switch-it means the package openoffice-headless are not installed.

testing OpenOffice headless mode.

To test if OpenOffice are correctly set up, go to OpenOffice installation directory and launch it in headless mode.

Then test with Telnet:

If you get something like this:

... then OpenOffice was up and listening to Port 8100.

Note: in order to use UNO module included in OpenOffice, your OpenOffice distribution must is compiled for the same version of Python than you use for Open ERP server!

Installing and configuring Report_aeroo_ooo module

Install report_aeroo_ooo module via OpenERP standard module installation interface.

Restart OpenERP Server.

Note:make sure you made correct UNO environment setup, if you get a error-"Importerror:no module named Pyuno, when in Stalling report_aeroo_ooo module or restarting server.

Configure connection parameters to OpenOffice.org service

Administration->customization->aeroo reports->configure OpenOffice.org Connection

1. Open Wizard;
2. Fill in your custom values;
3. Save;

On success your should receive message: "Connection to the OpenOffice.org instance is successfully established and PDF Conv Ertion is working. "

If it fails with error:

Your setup of Aeroo Reporting in OpenERP are complete.

Aeroo Reports Linux Server