Setup Aeroo Report Engine for OpenERP

September 23, 2013 by

Hello Everyone,

These are the steps to setup and use Aeroo reports in OpenERP! Lets thank Alistek for this wonderful Reporting engine.

Install Aeroo Reports Library:
1. Download Aeroolib at following link:
  https://launchpad.net/aeroolib/+download (wget https://launchpad.net/aeroolib/trunk/1.0.0/+download/aeroolib.tar.gz) or wget https://github.com/aeroo/aeroolib/archive/master.zip
2. Extract aeroolib.tar.gz into the current folder
```
tar -xvzf aeroolib.tar.gz
```
3. Go to aeroolib folder and run following command to install library:
  $ sudo python ./setup.py install
4. Restart computer
  $ sudo shutdown -r now
5. Download aeroo modules for OpenERP
Install LibreOffice: using following command lines to setup for LibreOffice
1. $ sudo apt-get install aptitude
2. $ sudo aptitude install openoffice.org-headless openoffice.org-writer openoffice.org-draw openoffice.org-calc
3. $ sudo shutdown -r now
Install Aeroo standard module: Open your browser and log-in to your OpenERP installation as admin. Make sure you enabled extended view then go to Settings->Modules->Update Module List. Then click Open Modules and search for keyword aeroo. Install all the Aeroo report modules afterwards (report_aeroo, report_aeroo_ooo)
Create a script to start LibreOffice headless as a service every time the OpenERP server boots up
1. $ sudo nano /etc/init.d/openoffice.sh
  Paste the following below this line
  
  --------------------------------------------------------------
  
  #!/bin/bash
  
  # openoffice.org headless server script
  
  #
  
  # chkconfig: 2345 80 30
  
  # description: headless openoffice server script
  
  # processname: openoffice
  
  #
  
  # Author: Vic Vijayakumar
  
  # Modified by Federico Ch. Tomasczik
  
  #
  
  OOo_HOME=/usr/bin
  
  SOFFICE_PATH=$OOo_HOME/soffice
  
  PIDFILE=/var/run/openoffice-server.pid
  
  set -e
  
  case "$1" in
  
  start)
  
  if [ -f $PIDFILE ]; then
  
  echo "OpenOffice headless server has already started."
  
  sleep 5
  
  exit
  
  fi
  
  echo "Starting OpenOffice headless server"
  
  $SOFFICE_PATH -headless -nologo -nofirststartwizard -accept="socket,host=127.0.0.1,port=8100;urp" & > /dev/null 2>&1
  
  touch $PIDFILE
  
  ;;
  
  stop)
  
  if [ -f $PIDFILE ]; then
  
  echo "Stopping OpenOffice headless server."
  
  killall -9 soffice && killall -9 soffice.bin
  
  rm -f $PIDFILE
  
  exit
  
  fi
  
  echo "Openoffice headless server is not running."
  
  exit
  
  ;;
  
  *)
  
  echo "Usage: $0 {start|stop}"
  
  exit 1
  
  esac
  
  exit 0
  
  --------------------------------------------------------------
Exit the nano editor and save the file you just did. Make the script executable and make it start automatically at boot

$ sudo chmod 0755 /etc/init.d/openoffice.sh

$ sudo update-rc.d openoffice.sh defaults

$ sudo /etc/init.d/openoffice.sh start
Go to Settings->Customization->Aeroo Reports->Configure OpenOffice.org connection. Click Connect. It should display that connection was successful and PDF conversion is working.

Source : Collected from experience and various searches over internet!

in Odoo Technical

ERP Solutions

Mobile Applications

WEb Applications

The team

Setup Aeroo Report Engine for OpenERP