+91-903-347-2982,+91-987-935-4457   contact@serpentcs.com

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) 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
  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
      # openoffice.org headless server script
      # chkconfig: 2345 80 30
      # description: headless openoffice server script
      # processname: openoffice
      # Author: Vic Vijayakumar
      # Modified by Federico Ch. Tomasczik
      set -e
      case "$1" in
      if [ -f $PIDFILE ]; then
      echo "OpenOffice headless server has already started."
      sleep 5
      echo "Starting OpenOffice headless server"
      $SOFFICE_PATH -headless -nologo -nofirststartwizard -accept="socket,host=,port=8100;urp" & > /dev/null 2>&1
      touch $PIDFILE
      if [ -f $PIDFILE ]; then
      echo "Stopping OpenOffice headless server."
      killall -9 soffice && killall -9 soffice.bin
      rm -f $PIDFILE
      echo "Openoffice headless server is not running."
      echo "Usage: $0 {start|stop}"
      exit 1
      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!
user image
Tin Van On, 27 July 2017

hi pro! I just run script like it, but it not working. Error: Details ('Connection aborted.', error(99, 'Cannot assign requested address')). what proplem?

Hi, Possibly the address has changed. The aeroolib can now be found at http://serpentcs.com/serpentcs-setup-aeroo-report-engine-for-openerp-272

user image
Tin Van On, 11 August 2017

hi pro! I tried my best to config on my host. It's still bugging :((. Detail Error: HTTPConnectionPool(host='erp.duhoctritien.com', port=8989): Max retries exceeded with url: / (Caused by NewConnectionError('<requests.packages.urllib3.connection.HTTPConnection object at 0x7f5b699563d0>: Failed to establish a new connection: [Errno 111] Connection refused',)) . please help me! thanks for read!!!

Please see to download from https://github.com/aeroo/aeroolib.git

user image
Clifford On, 11 December 2018

I've just graduated http://ttstaller.com ventolin The measures announced Wednesday included temporary tax cuts for businesses with sales of less than RMB20,000, and moves to simplify administration and approvals for exporters, along with initiatives to support railway financing. The focus on small and medium-size enterprises may be a response to the slowdown in SME-related manufacturing seen in recent months (SMEs have a heavier weight in in the HSBC/Markit PMI Index, which recorded a preliminary reading of 47.7 in July - the third straight month that the reading has been below the 50 level that indicates contraction). Evidence of weakness in activity has emerged despite continued credit growth, suggesting that incremental growth generated from credit has weakened.

user image
Jamel On, 11 December 2018

What university do you go to? http://ttstaller.com cialis Grohe said the transaction was the largest ever investmentmade by a Japanese company in Germany. It also ranks as thesecond-largest overseas acquisition by a Japanese firm in 2013behind the nearly $6 billion purchase of Thailand's Bank ofAyudhya PCL by Mitsubishi UFJ Financial Group.

user image
Jenna On, 11 December 2018

On another call http://soprof.com.mx ventolin His lead on the field after yesterday&rsquo;s surprise attack by Contador&rsquo;s Saxo-Tinkoff team has been slashed to only 2min 28sec, which still sounds significant, but old Ventoux just laughs at that.