Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

[8.0] How can I install the official Aeroo Reports (Alistek) for Odoo version 8? [SOLVED + Installation Script]

Subscribe

Get notified when there's activity on this post

This question has been flagged
aerooaeroo_report8.0alistekv14
14 Replies
38795 Views
Avatar
Luke Branch

Has anyone come across a working guide for installing Aeroo reports in Odoo version 8.0 on Ubuntu 14.04 from these repositories?:

https://github.com/aeroo/aeroo_reports
https://github.com/aeroo/aeroo_docs
https://github.com/aeroo/aeroolib

0
Avatar
Discard
Avatar
Luke Branch
Author Best Answer

I have managed to get Aeroo Reports working in Odoo 8.0 using the following method on a clean Ubuntu 14.04 installation:

Ubuntu 14.04 Aeroo Reports installation script:

To install Aeroo Reports and all related dependencies please do the following at a terminal in Ubuntu 14.04:

#0      cd /tmp
#1      sudo wget https://raw.githubusercontent.com/OdooCommunityWidgets/install-scripts/8.0/aeroo_reports/aeroo_install.sh
#2      sudo sh aeroo_install.sh

#3      Follow steps #31-37 in the "Ubuntu 14.04 Aeroo Reports installation method:" section below for installation instructions inside                   Odoo.

This script has a yes/no option for installing Odoo 8.0, and the Aeroo reports Odoo modules. If you have a pre-existing Odoo installation you can choose no when you get to the prompt for installing Odoo 8, and choose yes when you get to the option for installing the Aeroo Reports (aeroo_reports) modules for Odoo 8.

For installing the Aeroo Reports (aeroo_reports) modules this script assumes you already have the following directory:

/opt/odoo/custom

and

/opt/odoo/custom/addons

and it also assumes that your /etc/odoo-server.conf file includes the following directory in your addons_path line, for example:

addons_path = /opt/odoo/odoo-server/addons,/opt/odoo/custom/addons

Ubuntu 14.04 Aeroo Reports installation method:

Install Git:

#0      sudo apt-get install git

Install AerooLib:

#1      sudo apt-get install python-setuptools
#2      sudo apt-get install python-genshi python-cairo python-lxml
#3      sudo apt-get install libreoffice-script-provider-python
#4      sudo mkdir /opt/aeroo
#5      cd /opt/aeroo
#6      sudo git clone https://github.com/aeroo/aeroolib.git
#7      cd /opt/aeroo/aeroolib
#8      sudo python setup.py install

Create Init Script for OpenOffice (Headless Mode) - (see: https://www.odoo.com/forum/help-1/question/how-to-install-aeroo-reports-2780 for original post from Ahmet):

#9        sudo pico -w /etc/init.d/office
#10      Copy and paste this:

#!/bin/sh

/usr/bin/soffice --nologo --nofirststartwizard --headless --norestore --invisible "--accept=socket,host=localhost,port=8100,tcpNoDelay=1;urp;" &

#11        sudo chmod +x /etc/init.d/office
#12        sudo update-rc.d office defaults
#13        sudo /etc/init.d/office
#14        telnet localhost 8100
#15        You should see something like the following message (this means it has established a connection successfully):

Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
e--'com.sun.star.bridge.XProtocolPropertiesUrpProtocolProperties.UrpProtocolPropertiesTidE--L

Install AerooDOCS (see: https://github.com/aeroo/aeroo_docs/wiki/Installation-example-for-Ubuntu-14.04-LTS for original post):

#16      sudo apt-get install python3-pip
#17     sudo pip3 install jsonrpc2 daemonize
#18     cd /opt/aeroo
#19     sudo git clone https://github.com/aeroo/aeroo_docs.git
#20     sudo python3 /opt/aeroo/aeroo_docs/aeroo-docs start -c /etc/aeroo-docs.conf
#21     sudo ln -s /opt/aeroo/aeroo_docs/aeroo-docs /etc/init.d/aeroo-docs
#22     sudo update-rc.d aeroo-docs defaults
#23     sudo service aeroo-docs start
                 [ ! ]  If you encounter and error "Unable to lock on the pidfile while trying #16 just restart your server (sudo shutdown -r now)                         and try #16 again after reboot.

Install Odoo from Source:

#24      cd /tmp
#25     sudo wget https://raw.githubusercontent.com/lukebranch/odoo-install-scripts/master/odoo-saas4/ubuntu-14-04/odoo_install.sh
#26     sudo sh odoo_install.sh
#27     restart the server (sudo shutdown -r now)

Install Aeroo Reports:

#28    sudo apt-get install python-cups
#29    cd /opt/odoo/custom
#30    sudo git clone -b master https://github.com/aeroo/aeroo_reports.git

After following the (above) steps in this guide you should have Aeroo Reports installed correctly on your server for Ubuntu 14.04 and Odoo 8.0. You'll just need to create a database and install the required Aeroo reports modules you need for that database.

[ ! ]    Do not have aeroo_report_sample in your addons directory or you will get an error message when updating module list:
         Warning! Unmet python dependencies! No module named cups

Install report_aeroo module in Odoo database:

#31    Go to Settings >> Users >> Administrator in the backend of Odoo
#32    Tick the box next to 'Technical Features' and Save, then refresh your browser window.
#33    Go to Settings >> Update Modules List > Update
#34    Go to Settings >> Local Modules > Search for: Aeroo
#35    Install report_aeroo
#36    You'll be confronted with an installation wizard, click: Continue >> Choose Simple Authentication from the Authentication dropdown list, and add username and password: anonymous
[ ! ]     You can change the username and password in: /etc/aeroo-docs.conf if required.
#37    Click Apply and Test. You should see the following message if it was successful:

Success! Connection to the DOCS service was successfully established and PDF convertion is working.

You now have a fully operational Aeroo Reports installation in Ubuntu 14.04. If for any reason this is not working for you please post back in the comments and explain the error message you are seeing.

8
Avatar
Discard
Serpent Consulting Services Pvt. Ltd.

Nice work Luke! Will post a blog with credits to you! We will do some tests and help fixing this!

Serpent Consulting Services Pvt. Ltd.

This is core aeroo code lib issue...need just a self reference!

Luke Branch
Author

@SerpentCS,

Thanks! Aeroo reports seems to be a really great platform for building reports. Very easy to work with. I'll post some tutorials linked to this one on how to build custom quotation, invoice, PO, etc. templates as soon as I can find some time.

Luke Branch
Author

@Serpent,

FYI - I've just updated the steps to include the connection to OpenOffice in headless mode.

Luke Branch
Author

@Serpent,

Do you have any insight on this issue?:

https://www.odoo.com/forum/help-1/question/8-0-aeroo-reports-report-aeroo-direct-print-error-nameerror-global-name-context-is-not-defined-83234

I'll be putting together a tutorial on building a custom quotation/invoice template, as well as setting up the Direct Print settings shortly, but i've run into a roadblock with this in the report_aeroo_direct_print module.

Have you run into any similar issues in your own instance?

Akhil P Sivan

Hi Luke, am getting the error "Unable to lock on the pidfile" on step #20. How to resolve that? I tried restarting but dint work for me.

Luke Branch
Author

@Akhil,

I am working on an install script for Odoo 8.0 and Ubuntu 14.04 using the guide above. You can find the (work in progress) here:

https://github.com/OdooCommunityWidgets/install-scripts/blob/8.0/aeroo_reports/aeroo_install.sh

I'll post back here once it's finished.

Luke Branch
Author

@Akhil,

Try running this script on a clean Ubuntu 14.04 machine:

https://raw.githubusercontent.com/OdooCommunityWidgets/install-scripts/8.0/aeroo_reports/aeroo_install.sh

To run the script do the following in a terminal:

#1) sudo wget https://raw.githubusercontent.com/OdooCommunityWidgets/install-scripts/8.0/aeroo_reports/aeroo_install.sh
#2) sudo sh aeroo_install.sh

Please let me know if it works for you. It should install Aeroo reports along with Odoo. Once the script has finished running (it will probably take around 45 mins) just restart your server and you should have a working Odoo install with Aeroo modules available to you.

Luke Branch
Author

@Serpent CS,

FYI - i've completed an installation scrip here:

https://github.com/OdooCommunityWidgets/install-scripts/blob/8.0/aeroo_reports/aeroo_install.sh

Avatar
yeshwanth
Best Answer

How can I install the official Aeroo Reports (module) for Odoo version 8 on windows 7 ?


I dont have enough Karma(beginner in odoo) to reply again in this post..

Kindly help me through "tsyeshwanth@gmail.com" 


1
Avatar
Discard
Luke Branch
Author

@Yeshwanth,

What method of installation did you use for Odoo 8.0 on Windows? This will be necessary in order for people to offer you some advice.

OdooBot
Dear Luke,

I am really sorry to interrupt you through mail. I dont have enough Karma's to answer or reply to a question..

You can help me through this mail ID.  "tsyeshwanth@gmail.com"

I have directly downloaded the software from the Odoo website and installed, i did not use github installation method or other method.

If my installation is wrong, guide me.

Thank you.

On Tue, Mar 24, 2015 at 12:47 PM, Luke Branch <luke-weairsoft-com@mail.odoo.com> wrote:

@Yeshwanth,

What method of installation did you use for Odoo 8.0 on Windows? This will be necessary in order for people to offer you some advice.

--
Luke Branch
Sent by Odoo S.A. using Odoo access your messages

Luke Branch
Author

@Yeshwanth,

Unfortunately I do not have experience with Odoo running on Windows. There may be others in the community that can help you with this though.

Otherwise I recommend looking into installing Ubuntu 14.04 on VirtualBox in your windows computer and then following the instructions above.

Avatar
wizardz
Best Answer

@Luke Branch

IS there a way to install aeroolib and aeroodocs, when Odoo is not installed in /var/lib/odoo. For example odoo is installed in /opt/odoo =?

Because I get an error when I'm installing aeroolib



chown: cannot access ‘/var/lib/odoo’: No such file or directory

I think thats because I installed Odoo in an other directory.

0
Avatar
Discard
wizardz

Connection done , changed the port like in the aeroo-docs.conf file to "8989" All fine

Avatar
Fabrice Candau
Best Answer

As Akhil P Sivan, I have the same issue after step 20 "Unable to lock on the pidfile", even after reboot, it keeps saying the same error.

Please help! Thank you

0
Avatar
Discard
Luke Branch
Author

@Fabrice,

I am working on an install script for Odoo 8.0 and Ubuntu 14.04 using the guide above. You can find the script (work in progress) here:

https://github.com/OdooCommunityWidgets/install-scripts/blob/8.0/aeroo_reports/aeroo_install.sh

I'll post back here once it's finished.

Fabrice Candau

Oh thanks a lot! Any idea what is wrong with the Ünable to lock on the pidfile"? I followed this tutorial twice, but still have this error at step 20

Fabrice Candau

Oh thanks a lot! Any idea what is wrong with the Ünable to lock on the pidfile"? I followed this tutorial twice, but still have this error at step 20

Luke Branch
Author

@Fabrice,

I'm working through the steps in this tutorial step-by-step to build the script. Once I come across this error again, i'll comment back.

Fabrice Candau

OK thanks for your help and work!

Luke Branch
Author

@Fabrice,

No problem, this script should be almost ready now. Please try the script on an clean install of Ubuntu 14.04 and let me know if you run into any errors. If you already have a working instance of Odoo on the system then you need to comment out lines 50-54.

Fabrice Candau

I tried your script but it stops as it cannot connect to kaz.dl.sourceforge.net when installing Wkhtmltopdf 0.12.1

Fabrice Candau

it keeps saying failed : connection timed out

Luke Branch
Author

@Fabrice,

I'm working on a fix now. This is due to the download link having been changed for wkhtmltopdf in my Odoo install script.

I'll comment back here once it's fixed.

Luke Branch
Author

@Fabrice,

Please start again with a fresh Ubuntu 14.04 instance. I've updated the script.

The problem was due to the fact the installation script link was pointing to the master branch (https://raw.githubusercontent.com/lukebranch/odoo-install-scripts/master/odoo-saas4/ubuntu-14-04/odoo_install.sh) instead of the 8.0 branch (https://raw.githubusercontent.com/lukebranch/odoo-install-scripts/8.0/odoo-saas4/ubuntu-14-04/odoo_install.sh).

Please let me know how you get on, i've just tested it on my own clean Ubuntu 14.04 instance and it works fine.

Fabrice Candau

Installing right now, I'll let you know

OdooBot

Thanks for your precious help!

I will try it and I will let you know.

 

 

From: Luke Branch [mailto:luke-weairsoft-com@mail.odoo.com]
Sent: lundi 25 mai 2015 16:07
To: Fabrice Candau
Subject:

 

@Fabrice,

Please start again with a fresh Ubuntu 14.04 instance. I've updated the script.

The problem was due to the fact the installation script link was pointing to the master branch (https://raw.githubusercontent.com/lukebranch/odoo-install-scripts/master/odoo-saas4/ubuntu-14-04/odoo_install.sh) instead of the 8.0 branch (https://raw.githubusercontent.com/lukebranch/odoo-install-scripts/8.0/odoo-saas4/ubuntu-14-04/odoo_install.sh).

Please let me know how you get on, i've just tested it on my own clean Ubuntu 14.04 instance and it works fine.

--
Luke Branch
Sent by Odoo S.A. using Odoo access your messages

Luke Branch
Author

@Fabrice,

If you run into an issue with AerooDOCS when you install the aeroo_reports module in Odoo saying that it can't connect to AerooDOCS then try running the following at a terminal:

1) sudo apt-get install python-setuptools python-genshi python-cairo python-lxml libreoffice-script-provider-python libreoffice-base python-cups python3-pip -yf
2) sudo pip3 install jsonrpc2 daemonize

For some reason the script is not processing these lines correctly, however doing them manually after the script has run should do the trick if you do run into this issue.

OdooBot

Ok thank you so much!
I have launched the installation script but had to leave my office. Will tell you tomorrow if everything went well.
Thanks again for your help, it seems it is difficult sometimes to get help from odoo community.

Fabrice



-------- Original Message --------
From: Luke Branch <luke-weairsoft-com@mail.odoo.com>
Sent: Monday, May 25, 2015 09:59 PM
To: Fabrice Candau <fabrice_candau@hotmail.com>
Subject: Re: RE:

@Fabrice,

If you run into an issue with AerooDOCS when you install the aeroo_reports module in Odoo saying that it can't connect to AerooDOCS then try running the following at a terminal:

1) sudo apt-get install python-setuptools python-genshi python-cairo python-lxml libreoffice-script-provider-python libreoffice-base python-cups python3-pip -yf
2) sudo pip3 install jsonrpc2 daemonize

For some reason the script is not processing these lines correctly, however doing them manually after the script has run should do the trick if you do run into this issue.

--
Luke Branch
Sent by Odoo S.A. using Odoo access your messages
Luke Branch
Author

@Fabrice,

If your previous attempt above doesn't work you may want to try one more time with the newest version of the script (as of the time of writing of this message), as i've made some changes and tested the script a few times in my own dev instances.

The script will take quite awhile, and has a total of two prompts during installation; one for installing Odoo and one for installing aeroo_reports odoo modules from github (aeroo/aeroo_reports).

Please message back here or create an issue on github if you run into any issues.

OdooBot

Thanks for your email

I'll let you know if it goes well with your previous script or the new one.
Thanks  again!

Fabrice



-------- Original Message --------
From: Luke Branch <luke-weairsoft-com@mail.odoo.com>
Sent: Tuesday, May 26, 2015 01:37 AM
To: Fabrice Candau <fabrice_candau@hotmail.com>
Subject: Re: RE:

@Fabrice,

If your previous attempt above doesn't work you may want to try one more time with the newest version of the script (as of the time of writing of this message), as i've made some changes and tested the script a few times in my own dev instances.

The script will take quite awhile, and has a total of two prompts during installation; one for installing Odoo and one for installing aeroo_reports odoo modules from github (aeroo/aeroo_reports).

Please message back here or create an issue on github if you run into any issues.

--
Luke Branch
Sent by Odoo S.A. using Odoo access your messages
Luke Branch
Author

@Fabrice,

No problem.

Fabrice Candau

I installed odoo and aeroo from your script but I don't understand why Odoo shows me in settings/Apps Aeroo not installed. Shoud I try to install it again from Odoo settings?

Fabrice Candau

Ok I tried but it crashes and gave me many errors

Luke Branch
Author

@Fabrice,

Could we continue this discussion on a github issue thread here:

https://github.com/OdooCommunityWidgets/install-scripts/issues

I just need you to create an issue on github (you'll need to sign up for a github account if you don't have one).

If you could detail some of the errors you've run into this will help in troubleshooting. For the installation script, it doesn't install Aeroo reports in the actual Odoo database, it just places it in the /custom/addons folder so that you just need to do 'Update Modules List' and search for Aeroo in the modules list, just like you would with installing any other community module.

Did you get errors from the script itself, or from the Aeroo Reports installation wizard inside Odoo?

I've run this on 5 clean ubuntu 14.04 instances, and although there are some errors during the script that I need to resolve, the result is a working Odoo instance with a working AerooDOCS, and AerooLib installation.

If there are any bugs in the script though i'd like to iron them out, so any insight into errors you've run into would be appreciated.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
[8.0] How to build a report in Aeroo Reports?
aeroo tutorials aeroo_report 8.0 examples
Avatar
0
May 16
6502
Migrating Aeroo XLS reports from Odoo 7 to Odoo 18: existing alternatives?
aeroo aeroo_report v18
Avatar
0
Aug 25
876
Aeroo Report Modul already in V9? Solved
aeroo aeroo_report odoo9
Avatar
Avatar
Avatar
5
Mar 19
7914
How Do I Install Aeroo Reports for Odoo v8.0?
v8 aeroo reports aeroolib doc xlsx 8.0 alistek
Avatar
Avatar
2
Mar 15
18224
[12.0] Aeroo for Odoo.sh? Solved
aeroo aeroo_report odoo.sh odoo12
Avatar
Avatar
1
May 20
5024
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now