www.numberspeaks.com

BLOG

Add menu in dropdown list on tree view – Odoo 9

To add an additional menu in action dropdown list on tree view, we need to register “ir.actions.server” and “ir.values” on the qweb/xml file as follow. Note that code field name is using old Odoo python API. In your sale order model create the method as bellow with Odoo new API. Restart odoo and upgrade your module, you’ll have now cancel menu on your sales order tree view.

Linux

Odoo 9 Linux bash backup script

Bash backup odoo script is available on GitHub for Odoo 8 and 11. This bash script will help you to backup Odoo database, set a password on the backup file and remove files older than 7 days. You’ll need curl and 7zip linux package to make it work. This example is backing up od11-01 and od11-02 databases. It’s not really optimized with the double compression. BACKUP_DIR=/opt/backup ODOO_DATABASES="od11-01 od11-02" ADMIN_PASSWORD="ODOO_DATABASE_MANAGER_PASSORD" FILE_PASSWORD="ZIP_FILE_PASSWORD" TIMESTAMP=`date +%Y-%m-%d_%H-%M-%S` for DB in ${ODOO_DATABASES} do # create a backup curl -X POST \ -F "master_pwd=${ADMIN_PASSWORD}" \ -F "name=${DB}" \ -F "backup_format=zip" \ -o ${BACKUP_DIR}/${DB}/${DB}.${TIMESTAMP}.zip \ http://localhost:8069/web/database/backup 7z a …

zimbra

DKIM Zimbra 8.6

DKIM is an email authentication method designed to detect email spoofing, for more detail : Wiki DKIM, i’m describing in this post how to enable it with Zimbra. Make sure your DKIM has been enabled in your mail server. su – zimbra /opt/zimbra/libexec/zmdkimkeyutil -a -d domain.com 148ERADC-FCE5-11E6-AF44-005A1B26B745._domainkey IN TXT ( "v=DKIM1; k=rsa; " "p=MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDg2uVLIssdfsfgu62+c7n0sxugzm8Lpr4A7o7veL4kIeifat2hD53P2KKQTV978HxBTQKrEFByLbG0WZuNracNJU9L5NOKtmYnE7ksxF9ODMKqFK+ltsmM9qkVxbU3xQOVdufDlV2Zk8Ya0WMkYWzKgWIwIDAQAB" ) ; —– DKIM key 148ERADC-FCE5-11E6-AF44-005A1B26B745 for domain.com Add DNS TXT record: 148ERADC-FCE5-11E6-AF44-005A1B26B745._domainkey IN TXT v=DKIM1; k=rsa;p=MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDg2uVLIssdfsfgu62+c7n0sxugzm8Lpr4A7o7veL4kIeifat2hD53P2KKQTV978HxBTQKrEFByLbG0WZuNracNJU9L5NOKtmYnE7ksxF9ODMKqFK+ltsmM9qkVxbU3xQOVdufDlV2Zk8Ya0WMkYWzKgWIwIDAQAB Test DKIM signature by sending email using this website: http://dkimvalidator.com/

How to get data from URL with a controller in Odoo 9

Create under your module a folder controller, in that folder create files controller.py and __init__.py and link your new file in __init__.py, don’t forget to add controller folder in the __init__.py at the root folder of your module. controller.py code bellow will make available the URL www.myodoo.com/page/random/random_variable, random_variable value will be stored in values dictionary on key variable. import openerp.http as http from openerp.http import request import logging _logger = logging.getLogger(__name__) class Controller(http.Controller): @http.route([’/page/random/<string:variable>’], type=’http’, auth="user", methods=[’GET’], website=True) def view(self, **kwargs): values = dict(kwargs) object_ids = request.env[’model.name’].search([(‘your_field’,’=’, values[’variable’])]) values[’object_ids’] = object_ids values[’customer’] = object_ids[0].customer_id.name return request.render(‘module.template_id’, values) in folder view …

windows logo

Kill remote desktop session

Remote desktop sometimes gives me this error message “The terminal server has exceeded the maximum number of allowed connections.” It means my previous remote desktop session has been lost or allowed connections are full. I order to solve this, if you don’t mind losing your unsaved work, you will need to kill a session to open a new one, replace 192.168.1.1 by your server’s IP on the following command. #Windows key + R #enter: \\192.168.1.1 #Enter admin username and password #Windows key + R cmd #MS DOS prompt query session /server:192.168.1.1 #Replace x by session ID. reset session x /server:192.168.1.1