Sunday, 22 September 2013

Setup Aeroo Report Engine for OpenERP!

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

  1. 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)
    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
      1. http://www.alistek.com/en/products-catalogue/4-product_single/222-aeroo-reports-for-openerp-version-7x.html
  2. 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
  3. 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)
  4. 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
      --------------------------------------------------------------
  5. 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
  6. 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!

No comments:

Post a Comment