Odoo Technical

Setup Aeroo Report Engine for OpenERP

SerpentCS

September 2013 - 3 min read

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!

End-to-End Odoo Services

From implementation and customization to migration, integrations, support, and training we help you maximize the value of Odoo.

Get Started

Search

Book Free Demo

Get real-time responses. Talk with our Industry Experts.

Book Demo

Professional Author

SerpentCS

Created by the SerpentCS Editorial Team, delivering trusted insights on Odoo, ERPNext, Zoho, SAP, custom
software development, and enterprise technology to help businesses grow smarter.