www.numberspeaks.com

BLOG

Odoo / OpenERP

Import xlsx file Odoo 11 – Sales orders

I will describe the basis in python to import xlsx file and how to handle the imported data, in this exemple sales orders is imported. Uploaded file is stored in the variable upload_file and is encoded in base 64, to read it we have to decode first the data by using b64decode function, then save it, for me i chose “/tmp” folder. Result import_data is an array of dictionary as follow [{‘column_name_1’:data_column_1_row_1, ‘column_name_2’:data_column_2_row_1,…},{‘column_name_1’:data_column_1_row_2, ‘column_name_2’:data_column_2_row_2,…},…] Bellow XML view for the importation module.

Odoo / OpenERP

Odoo 9 Email Template

This is a basic email template to put in the xml file: if the module name is abc and the model name is voyelle then module_name.model_model_name should be abc.model_voyelle. ${object} is the model ${object.name} will display the attribute name of the current model.

Accessories / Mousepad

Artisan mousepad

Artisan is a Japanese brand that specializes in creating high-quality artisan mousepads. These mousepads are made using premium materials, such as silica gel and cloth, and are known for their smooth and consistent surface that provides an excellent tracking experience for gaming mice. What sets Artisan mousepads apart from other brands is their focus on both form and function. These mousepads are not just functional, but also have a unique and attractive design that adds to the overall aesthetic of a computer setup. They come in a variety of sizes, shapes, and colors, so there is something for everyone.Another notable …

Linux / Odoo / OpenERP

Fail2ban Odoo 9 Authentication

Odoo 9 community doesn’t come with autoban security. Fail2ban is an alternative to secure Odoo authentication. For more information concerning fail2ban click here Let’s start with creating a new filter: Paste the content from bellow code: Add those line in jail.local Change the value of syslog in the /etc/odoo/openerp-server.conf Restart Odoo then fail2ban to apply modification.

Coding / Odoo / OpenERP

How to protect Odoo against brute force attack behind Nginx or Caddy

Odoo community is not protected against brute force attack by default, the system is vulnerable over internet, however Odoo store provides auth_brute_force App which can handle this task, it’s available through this link. But it doesn’t work correctly behind a reverse proxy such as Caddy or Nginx. In the second part of this post, i’ll explain the little tip to make it work. Download and install the module Download the file corresponding to your version of Odoo. Unzip the file “auth_brute_force-9.0.1.1.0.zip”. Move the folder “auth_brute_force” to your module folder: “/usr/lib/python2.7/dist-packages/openerp/addons/“. Enable the developper mode through “About” popup. Then go to …

zimbra
Zimbra 8.6

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. 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/

More