Friday, August 2, 2013

Setup Aeroo Report Engine for OpenERP !

  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!