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 …

App / Coding

Merge documents to PDF from iPhone

Are you looking for a quick and easy way to combine multiple files into a single document? Look no further than MergePDF!. This powerful PDF merging tool offers a simple and intuitive, making it easy to add files and merge them into one document. With MergePDF!, you can also scan on-fly ,reorder documents. Get organized and save time with MergePDF – the ultimate PDF merging tool! Only available in Apple Store for iOS devices. Valid extension: docx, doc, xls, xlsx, pptx, ppt, pdf, image files. Camera scan Rectangular shape detection Edit PDF Re-order and remove page Edit Images Crop and select …

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

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.

Linux

How to use datetime in Python

  Exemple 1 : subtract 2 dates run the command. Exemple 2 : add or subtract days to a date run the command. Exemple 3 : today date Exemple 4 : convert string to datetime Exemple 5 : convert datetime to string

More