www.numberspeaks.com

BLOG

Coding / Odoo / OpenERP

Disable database manager in Odoo

Module for odoo 8 and 11 available on Github. Some tips found on the web hides only the link from Odoo homepage however URL are still reachable (~/web/database/manager). By installing this module, it will filter the access to Odoo database manager through the controller except connections coming from IPs listed in system parameters. Whitelist option: Key: disable_database_manager.database_manager_whitelist Value: 192.168.1.1,192.168.1.2,etc… This module will avoid unwanted connections attempts and secure your database manager access. Works with NGINX with some modification on nginx config file, click here for more detail. To disable completely database manager access: Add list_db = False in odoo.conf / …

Linux / Mail Server / Zimbra 8.6

Whitelist / Blacklist Amavis SpamAssassin Zimbra 8.6

Sometimes SpamAssassin scores email as False Positive spam, to avoid incoming emails to get junked, we can define globally in the config file /opt/zimbra/conf/amavisd.conf.in domain with a initial score. To whitelist a domain we add domain with a negative score: To blacklist a domain we add domain with positive score: To apply the modification restart Amavis: Now from the source of incoming emails we can see when it’s coming from mydomain.com the initial score is -3 and spammer.com is 5.

App / Coding / Odoo / OpenERP

Odoo dashboard mobile

Odoo dashboard is a simple app that displays predefined widgets set on Odoo server, this app requires an additional module available on Odoo store. – Create, rename, delete, reorder and reload dashboards.– Add, remove, reorder and reload widgets from dashboard.– Fast loading, data is retrieved by the server and cached. Odoo Dashboard Widgets – WidgetXVsY: displays 2 numbers, difference and variation is calculated.– WidgetLastX: it could be used to displays x last months orders / invoices, etc…– WidgetSingleX: displays a relevant numbers Odoo server module Odoo dashboard Remote database access Connect to remote databases (MSSQL, local postgreSQL, MySQL not implemented yet) …

Odoo / OpenERP

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. in folder view of your module create the file template.xml

Odoo / OpenERP

Edit PDF header – Odoo 11

Edit the format of the address By default with the localization i set for my company, addresses are displayed like this picture bellow: First, you need to enable developper mode through settings, and go to the menu contact -> Configuration -> localization -> countries. Select the country you set on your company settings and click edit. Edit and change the format as your convenience. And here the result.   Edit the format of header/footer Settings are available through the menu: Settings -> General settings -> Document template section: You will be able to customize logo, text position here, click edit …

More