Our Blog

to find the product cost price from direct SQL query you need to join it from these tables: product.template product.product ir.property For example: select temp.name, prop.value_float from product_template temp left join product_product pp on pp.product_tmpl_id = temp.id left join ir_property prop on prop.res_id = 'product.product,' || pp.id where temp.name =...

How to upload file in website page with a normal HTML form ? On the template: <template id="upload"> <form action="process" method="POST" enctype="multipart/form-data" > Upload file: <input type="file" name="attachment"/> <button string="upload" type="submit" name="submit">Upload</button> </form> </template> On the controller # -*- coding: utf-8 -*- from odoo import http from odoo.http import request...

Suppose that we have so many docker images on our local computer as a result of building many versions of images... Show all images that contains "myimage": docker images | grep myimages Get only IMAGE ID column (the 3rd column): docker images | grep myimages | awk {'print $3'} Force delete...

Here is how to make your Docker image automatically pull GitHub or BitBucket repository on starting up... On your Github: create OAuth Token. Go to https://github.com/settings/tokens [1] Generate new token and save it. On your host working folder where you build the image, clone the repository, for example I put...

Here is how to auto build your Docker Image every time a connected GitHub Repository is updated... On your Docker Repository: Click the Repositories tab Click the Builds tab. Select the code repository service (GitHub or Bitbucket) where the image’s source code is stored Review the default Build Rules, make...

Question: I have a module that got the noupdate="1" attribute added to all views, actions and menuitems. Now those records can't be upgraded, even after the xml file in the module has been corrected. I'm already using the module, and would rather not have to reinstall it and lose the...

Use Odoo's Server Action solution! Go to Server Action menu under Settings, first enable the developer mode... Add new Server Action called Unlock SO. Select Base Model: Sale Order Select Action to Do: Execute Python Code Type the code below under Python Code tab: if env.context.get('active_model') == 'sale.order' and env.context.get('active_id'):...

This code is used to hide fields in one2many(tree) in Odoo > 11 *<field name="my_field" attrs="{'column_invisible': [('parent.field_name','=',False)]}" />* this type of code only works gives 'parent' in condition For example: sale.order and sale.order.line, where sale.order has a field called field_name to show/hide columns in sale.order.line tree view on sale.order form,...

Odoo kalau udah dikasi data banyak penyakitnya jadi Lemot dan LoLa (alias loading lambat).. itu terjadi dimana2 di setiap client kami. Salah satu sebabnya adalah di sisi tuning software agar bisa memanfaatkan semua resource yang ada di server (ram, harddisk, CPU, dll) yang defaultnya tidak dibuat untuk server kapasitas besar....

Mau jadi developer Odoo? Jangan lewatkan course Udemy ini. Karena disini dibahas semua topik tentang cara tercepat modifikasi addon Odoo dengan contoh module Partner, Invoice, PO.. dan dengan mudah dapat diimplementasikan pada module-module Odoo lainnya.. Hanya dengan durasi 3.5 jam, anda akan menemukan titik awal untuk bisa mulai menjadi developer...

*What you'll learn* Techniques to import external data into Odoo fast Using XMLRPC Standard Using Direct SQL Using Stored Procedure PL/PGSQL Automating the Import Process Filtering Record to Import *400+ Students have enrolled and get the benefit* Join now and start to become an expert! ENROLL NOW  [1] Description** what...

So you want to change "Odoo" text on the dialog boxes? Here are the steps: Make an addon to inherit these: addons/web/static/src/js/framework/dialog.js:37 title: _t('Odoo'), subtitle: '', addons/web/static/src/js/framework/crash_manager.js Line 108: title: "Odoo " + (_.str.capitalize(error.type) || _t("Warning")), Line 118: title: "Odoo " + _.str.capitalize(error.type), Line 165: title: "Odoo  " + (_.str.capitalize(error.type)...

If you defined a selection on website form that will hold 'many2many' field, so it will look like 'many2many_tags' widget, you need a special handling on the controller backend. By default, on the website form view you can select more than one value, but when you validated the form value...

If you have this code onchange: @api.onchange('a_field') def _onchange_cor(self): if self.a_field: self.env.cr.execute('SELECT name from a_table where field_id=%s' , (self.id,)) but self.id returns <openerp.models.NewId object at 0x7f904b586e10> How to get the id of self (the current record)? In onchange, odoo creates a new object and replaces self with it. The origin...

Pernah import data CSV dengan jumlah ratusan atau jutaan records? Odoo memang telah menyiapkan fasilitas import via web interface untuk semua model yang ada, tapi jika data yang mau diimport sudah ribuan bahkan jutaan, besar kemungkinan proses nya lama sekali.. atau bahkan time out... Solusi pertama bisa dengan split file...

These are the fields for Nested Set Model [1] . Used to manage hierarchical data structures with unbound depth in SQL. The article Managing Hierarchical Data in MySQL [2] explains this model details with examples in SQL. OpenERP uses Nested Set Model to manage trees like chart of accounts and...

An External ID (also called XML ID) is a string identifier that uniquely identifies a particular record in Odoo. They become important when you plan to import data into Odoo. When you import data, if you supply an External ID, Odoo checks if this record already exists. If it does...

Some times we need to 'override' the action window of an Odoo object. Action window is not overridable but we must replace it entirely to modify it. Example, to remove the kanban view at the hr.applicant views. The original action window is: <record model="ir.actions.act_window" id="action_hr_job_applications"> <field name="name">Applications</field> <field name="res_model">hr.applicant</field> <field...

If you are using Linux, the easiest way to remove the port number 8069 is using iptables which will redirect all traffic at port 80 (and 433 too) to port 8069. Add these lines to /etc/rc.local file: iptables -t nat -A PREROUTING -i eth0 -p tcp --dport 80 -j REDIRECT...

**Main Menu** Let's say you want to use your module icon as your main menu icon. Make sure this file exists at: module_name/static/description/icon.png In the XML where you define your main menu, add the *web_icon* attribute: <menuitem name="My Application" id="module_name.menu_root" web_icon="module_name,static/description/icon.png"/> Then upgrade your module. **Application Menu** To set the...