Swapon's Diary -

Install PostgreSQL 10 in Linux

September 6, 2024 / Odoo

1. First, we’ll obtain the authentication keys needed to validate packages from the PostgreSQL repo. $ wget –quiet -O – https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add – 2. As a best practice, we will update our server before installing PostgreSQL. $ sudo sh -c ‘echo “deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -sc)-pgdg main” > /etc/apt/sources.list.d/PostgreSQL.list’ 3. After the update […]

postgres

Install PostgreSQL 10 in Linux Read Post »

Odoo

VLOOKUP in Linux Libre, Microsoft Office, and Google Excel Sheet

September 6, 2024 / Odoo

VLOOKUP Most of the time you are looking for an exact match when you use the VLOOKUP function in Excel. Let’s take a look at the arguments of the VLOOKUP function. The VLOOKUP function below looks up the value 53 (first argument) in the leftmost column of the red table (second argument). Linux Libre Office

vlookup

VLOOKUP in Linux Libre, Microsoft Office, and Google Excel Sheet Read Post »

Odoo

Create a Sticky Header in Tree View in Odoo

September 2, 2024 / Odoo

Introduction When it comes to a huge data set, tree view table header is invisible in odoo when scrolling down to below. So to fix a table header we can easily map the column with value. Pre-requisite To achieve sticky feature in odoo tree view we need to implement a scss file feature. Implementation Create

Create a Sticky Header in Tree View in Odoo Read Post »

Odoo

Generate an XLSX Report in Odoo 10

September 1, 2024 / Odoo

Introduction Odoo doesn’t support custom XLSX report generation by default, it has some features that generate reports for XLSX but it can’t be used for custom generation. To Generate XLSX report in odoo 10 some dependent steps always need to follow. So let’s start the process Pre-requisite As there is no default support available for

Generate an XLSX Report in Odoo 10 Read Post »