Odoo (Open ERP): November 2019

Tuesday, 26 November 2019

Customizing (Website) home page using Qweb in Odoo

Webpage redirection using Odoo Controller

from odoo import http
from odoo.http import request

class Custom(http.Controller):
@http.route('/oldpage', auth='public', website=True)
def newpage_redirect(self):
return request.redirect('newpage')

@http.route('/newpage', auth='public', website=True)
def newpage_render(self):
return http.request.render('appname.newpage', {})

Using the above code we can redirect the oldpage to newpage.

localhost:8069/oldpage will redirect to localhost:8069/newpage

Website showing product information using Odoo Controllers

Controller code

Template code:

Output Code:

Wednesday, 20 November 2019

Sublime Text editor Installation in terminal (Ubuntu)

The popular cross-platform Sublime Text editor finally offers official Linux apt repository to make it easy to install and receive update in Ubuntu.

Sublime Text is a proprietary source code editor with a Python API. It supports many programming languages and markup languages, and its functionality can be extended by users with plugins.

It’s available to download and use for free, but you’re supposed to buy a license if you plan on using it full-time.

Install Sublime Text 3 via the official apt repository:

1. Open terminal via Ctrl+Alt+T or by searching for “Terminal” from desktop app launcher. When it opens, run command to install the key:

wget -qO - https://download.sublimetext.com/sublimehq-pub.gpg | sudo apt-key add -

2. Then add the apt repository via command:

echo "deb https://download.sublimetext.com/ apt/stable/" | sudo tee /etc/apt/sources.list.d/sublime-text.list

3. Finally check updates and install sublime-text via your system package manager:

or by running commands:

sudo apt-get update

sudo apt-get install sublime-text

Once installed, launch it from your desktop app launcher and enjoy!

Uninstall:

To uninstall the editor, either use your system package manager or simply run command:

sudo apt-get remove sublime-text && sudo apt-get autoremove

And the official Sublime Text apt repository can be removed by going to System Settings -> Software & Updates -> Other Software tab.

Wednesday, 13 November 2019

Install Drupal on Ubuntu 18.04

1. sudo apt install -y curl tasksel2. sudo tasksel install lamp-server sudo a2enmod rewrite3.sudo apt install php-fdomdocument php-gd
4. sudo gedit /etc/apache2/sites-enabled/000-default.conf(copy those lines )<Directory /var/www/html/> Options Indexes FollowSymLinks AllowOverride All</Directory>
5. sudo systemctl restart apache2
6. curl --output /tmp/drupal.tar.gz https://ftp.drupal.org/files/projects/drupal-8.4.5.tar.gz
7.sudo rm -fr /var/www/html sudo tar xf /tmp/drupal.tar.gz -C /var/www/ sudo mv /var/www/drupal-8.4.5/ /var/www/html sudo chown -R www-data.www-data /var/www/html
8.sudo mysqladmin create drupal sudo mysql -e "CREATE USER 'admin'@'%' IDENTIFIED BY 'pass';" sudo mysql -e "GRANT ALL PRIVILEGES ON drupal.* TO 'admin'@'%' WITH GRANT OPTION;"

How to install Odoo 12 on Ubuntu 18.04

STEP 1
sudo apt-get update

STEP 2
sudo apt-get -y upgrade

STEP 3
sudo apt-get install python3-pip

INSTALL DEPENDENCIES USING PIP3

pip3 install Babel decorator docutils ebaysdk feedparser gevent greenlet html2text Jinja2 lxml Mako MarkupSafe mock num2words ofxparse passlib Pillow psutil psycogreen psycopg2 pydot pyparsing PyPDF2 pyserial python-dateutil python-openid pytz pyusb PyYAML qrcode reportlab requests six suds-jurko vatnumber vobject Werkzeug XlsxWriter xlwt xlrd

STEP 4
sudo apt-get install -y npm
sudo ln -s /usr/bin/nodejs /usr/bin/node
sudo npm install -g less less-plugin-clean-css
sudo apt-get install node-less

STEP 5
sudo apt-get install python-software-properties
sudo vim /etc/apt/sources.list.d/pgdg.list
add a line for the repository
deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install postgresql-9.6

STEP 6
Create Database user for Odoo
sudo su postgres
cd
createuser -s odoo
createuser -s ubuntu_user_name
exit

STEP 7
Create Odoo user and group
sudo adduser --system --home=/opt/odoo --group odoo

STEP 8
Install Gdata
cd /opt/odoo
sudo wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz
sudo tar zxvf gdata-2.0.18.tar.gz
sudo chown -R odoo: gdata-2.0.18
sudo -s
cd gdata-2.0.18/
python setup.py install
exit

STEP 9
Odoo 11 Download from GitHub
cd /opt/odoo
sudo apt-get install git
sudo su - odoo -s /bin/bash
git clone https://www.github.com/odoo/odoo --depth 1 --branch 12.0 --single-branch
exit

STEP 10
Create Odoo Log File
sudo mkdir /var/log/odoo
sudo chown -R odoo:root /var/log/odoo

STEP 11
Edit Odoo configuration file
sudo gedit /etc/odoo.conf

#Copy this lines and change with users and password
------------------------------------

[options]

; This is the password that allows database operations:

; admin_passwd = admin

db_host = False

db_port = False

db_user = odoo

db_password = False

logfile = /var/log/odoo/odoo-server.log

addons_path = /opt/odoo/addons,/opt/odoo/odoo/addons

---------------------------------------------------

sudo chown odoo: /etc/odoo.conf

STEP 12
sudo apt-get -f install
sudo wget https://github.com/wkhtmltopdf/wkhtmltopdf/releases/download/0.12.1/wkhtmltox-0.12.1_linux-trusty-amd64.deb
sudo dpkg -i wkhtmltox-0.12.1_linux-trusty-amd64.deb
sudo cp /usr/local/bin/wkhtmltoimage /usr/bin/wkhtmltoimage
sudo cp /usr/local/bin/wkhtmltopdf /usr/bin/wkhtmltopdf

STEP 13
Run Odoo Server
cd /opt/odoo/odoo

./odoo-bin

STEP 14
Open browser on :
http://localhost:8069

STEP 15

cd /usr/local/lib/
sudo git clone https://github.com/sass/sassc.git --branch 3.4.2 --depth 1
sudo git clone https://github.com/sass/libsass.git --branch 3.4-stable --depth 1
sudo git clone https://github.com/sass/sass-spec.git --depth=1

STEP 16
echo 'SASS_LIBSASS_PATH="/usr/local/lib/libsass"' | sudo tee -a /etc/environment
source /etc/environment

STEP 17
sudo make -C libsass

STEP 18
sudo make -C sassc
sudo make -C sassc install

STEP 19
Restart Odoo Server

How to install Odoo 12 on Ubuntu 19.04

sudo apt update && sudo apt-get dist-upgrade -y

sudo apt install git python3-pip build-essential wget python3-dev python3-venv python3-wheel libxslt-dev libzip-dev libldap2-dev libsasl2-dev python3-setuptools python3-img2pdf node-less

sudo apt-get install libpcap-dev libpq-dev

sudo apt-get install libtiff5-dev libjpeg8-dev zlib1g-dev libfreetype6-dev liblcms2-dev libwebp-dev libharfbuzz-dev libfribidi-dev tcl8.6-dev tk8.6-dev python-tk

** Install WkhtmlToPdf **

wget https://github.com/wkhtmltopdf/wkhtmltopdf/releases/download/0.12.4/wkhtmltox-0.12.4_linux-generic-amd64.tar.xz
tar xvJf wkhtmltox-0.12.4_linux-generic-amd64.tar.xz
sudo cp wkhtmltox/bin/wkhtmlto* /usr/bin/

** Create User Odoo 12 **

sudo useradd -m -d /opt/odoo12 -U -r -s /bin/bash odoo12

sudo apt-get install postgresql

sudo su - postgres -c "createuser -s odoo12"

sudo su - odoo12

git clone https://www.github.com/odoo/odoo --depth 1 --branch 12.0 /opt/odoo12/odoo

cd /opt/odoo12

** Python requirements **
python3 -m venv odoo-venv
source odoo-venv/bin/activate
pip3 install --upgrade setuptools
pip3 install fpdf img2pdf wheel gdata
pip3 install -r odoo/requirements.txt

pip3 install Babel decorator docutils ebaysdk feedparser gevent greenlet html2text Jinja2 lxml Mako MarkupSafe mock num2words ofxparse passlib Pillow psutil psycopg2 pydot pyparsing PyPDF2 pyserial python-dateutil python-openid pytz pyusb PyYAML qrcode reportlab requests six suds-jurko vatnumber vobject Werkzeug XlsxWriter xlwt xlrd gdata

deactivate

exit

su odoo12
mkdir /opt/odoo12/custom-addons
exit
sudo nano /etc/odoo12.conf
----------------------------------

[options]
; This is the password that allows database operations:
admin_passwd = my_admin_passwd
db_host = False
db_port = False
db_user = odoo12
db_password = False
addons_path = /opt/odoo12/odoo/addons,/opt/odoo12/custom-addons

----------------------------------

sudo nano /etc/systemd/system/odoo12.service

[Unit]
Description=Odoo12
Requires=postgresql.service
After=network.target postgresql.service
[Service]
Type=simple
SyslogIdentifier=odoo12
PermissionsStartOnly=true
User=odoo12
Group=odoo12
ExecStart=/opt/odoo12/odoo-venv/bin/python3 /opt/odoo12/odoo/odoo-bin -c /etc/odoo12.conf
StandardOutput=journal+console
[Install]
WantedBy=multi-user.target

---------------------------------

sudo systemctl daemon-reload

sudo systemctl start odoo12

sudo systemctl enable odoo12

sudo systemctl status odoo12

How to install Odoo 11 on Ubuntu 16.04

 How to install Odoo 11 on Ubuntu 16.04 

STEP 1

sudo apt-get update

STEP 2

sudo apt-get -y upgrade

STEP 3

sudo apt-get install python3-pip

INSTALL DEPENDENCIES USING PIP3

pip3 install Babel decorator docutils ebaysdk feedparser gevent greenlet html2text Jinja2 lxml Mako MarkupSafe mock num2words ofxparse passlib Pillow psutil psycogreen psycopg2 pydot pyparsing PyPDF2 pyserial python-dateutil python-openid pytz pyusb PyYAML qrcode reportlab requests six suds-jurko vatnumber vobject Werkzeug XlsxWriter xlwt xlrd

STEP 4

sudo apt-get install -y npm

sudo ln -s /usr/bin/nodejs /usr/bin/node

sudo npm install -g less less-plugin-clean-css

sudo apt-get install node-less

STEP 5

sudo apt-get install python-software-properties

sudo vim /etc/apt/sources.list.d/pgdg.list

add a line for the repository

deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

sudo apt-get update

sudo apt-get install postgresql-9.6

STEP 6

Create Database user for Odoo

sudo su postgres

cd

createuser -s odoo

createuser -s ubuntu_user_name

exit

STEP 7

Create Odoo user and group

sudo adduser --system --home=/opt/odoo --group odoo

STEP 8

Install Gdata

cd /opt/odoo

sudo wget https://pypi.python.org/packages/a8/70/bd554151443fe9e89d9a934a7891aaffc63b9cb5c7d608972919a002c03c/gdata-2.0.18.tar.gz

sudo tar zxvf gdata-2.0.18.tar.gz

sudo chown -R odoo: gdata-2.0.18

sudo -s

cd gdata-2.0.18/

python setup.py install

exit

STEP 9

Odoo 11 Download from GitHub

cd /opt/odoo

sudo apt-get install git

sudo su - odoo -s /bin/bash

git clone https://www.github.com/odoo/odoo --depth 1 --branch 11.0 --single-branch

exit

STEP 10

Create Odoo Log File

sudo mkdir /var/log/odoo

sudo chown -R odoo:root /var/log/odoo

STEP 11

Edit Odoo configuration file

sudo gedit/etc/odoo.conf

#Copy this lines and change with users and password 

------------------------------------

[options]

; This is the password that allows database operations:

; admin_passwd = admin

db_host = False

db_port = False

db_user = odoo

db_password = False

logfile = /var/log/odoo/odoo-server.log

addons_path = /opt/odoo/addons,/opt/odoo/odoo/addons

---------------------------------------------------

sudo chown odoo: /etc/odoo.conf

STEP 12

sudo apt-get -f install

sudo wget https://github.com/wkhtmltopdf/wkhtmltopdf/releases/download/0.12.1/wkhtmltox-0.12.1_linux-trusty-amd64.deb

sudo dpkg -i wkhtmltox-0.12.1_linux-trusty-amd64.deb

sudo cp /usr/local/bin/wkhtmltoimage /usr/bin/wkhtmltoimage

sudo cp /usr/local/bin/wkhtmltopdf /usr/bin/wkhtmltopdf

STEP 13

Run Odoo Server

cd /opt/odoo/odoo

./odoo-bin

STEP 14

Open browser on :

http://localhost:8069