www.numberspeaks.com

BLOG

Coding / Odoo / OpenERP

Add xlsx support in scheduled outgoing email – Odoo 11

Download updated report_xlsx module Report_xlsx module adds xlsx report support to Odoo with xlsxwriter python library. However when trying to send an email with a xlsx report attached. I got this error message: “Unsupported report type xlsx found”. Mail module handles only PDF document as attachement, to add xlsx type support, we have to make some modification on report_xlsx module by inheriting mail.template model and overriding generate_email method, you’ll find the code bellow, customized report_xlsx module is downloadable above or by clicking on the link at the bottom of the page. Updated report_xlsx module for Odoo 11 community is available …

Accessories / Keyboard

GMMK Pro – The Ultimate Modular Mechanical Keyboard

In today’s world, a keyboard is much more than just an input device. It’s an extension of your personality and an essential tool that helps you perform your daily tasks. With the Glorious GMMK Pro, you can take your typing experience to the next level. This keyboard is designed for gamers and professionals who want to get the best out of their typing and gaming sessions. In this article, we’ll take a closer look at the features that make the Glorious GMMK Pro a must-have for anyone who takes their typing and gaming seriously. Modular DesignThe Glorious GMMK Pro is …

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/

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.

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 …

Odoo / OpenERP

Odoo – Redirect user to a page in python

This code bellow will redirect the user to customer invoice page, you will be able to set the model you would like to use with res_model and the id of the record in res_id, the view template in views, target can have new or self value. new value will open a popup and display the requested page, self will load the page in the current window.

More