Wednesday 25 September 2013

SerpentCS goes green by buying a bicycle as an official vehicle !

In the days of Global warming and Fuel price hikes, we have to help our country, economy and this the world to breathe easy.
Serpent Consulting Services Pvt. Ltd., who is known always for unique activities, have this time gone for the route of economical way of transportation for employees. We have bought a bicycle as an official vehicle and SerpentCS staff will use it to save the world against noise pollution, air pollution and many more.
There are other certain benefits of cycling as shown below: It reduces stress, reduces the risk of many malfunctions, and mainly it runs on fat!




















Sohil and Bipin have chosen Hercules Sparta as our official vehicle and here it goes: You can see Bipin and Jay in the pictures. We plan to buy more bicycles in future.




You too do better for society, revert is assured.
Thank you,
Serpent Consulting Services Pvt. Ltd.

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!