www.numberspeaks.com

BLOG

Linux / Odoo / OpenERP

Create scheduled actions Odoo 9

Scheduled actions can be set by adding this code in your xml file. This exemple will call the function schedule_action from the model hr.employee and send a notification by email if the boolean enable_send_notification is True. This model inherits hr.employee and defines 1 additional field, and 2 additional functions. send_notification is sending email based on the the template my_module.email_hr_employee_notification, see this post how to create email template with xml, schedule_action is the function called by the scheduler.

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 …

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 …

Linux

Geektool : Display system information on your MacOS X desktop

If you would like to display system information on your desktop of your Mac OS X, Geektool is the right utility you need. First download and install geektool : https://www.tynsoe.org/v2/geektool/ Open geektool app. Drag and drop Shell on your desktop, and click on command button Paste this code bellow to display your local ip and public ip. But you will need to replace 192.168.101 by your network ip address. Result :

Microsoft / MsSql

Mssql differential restoration error

After trying to restore differential backup after a full backup, i got this error message : The log or differential backup cannot be restored because no files are ready to roll forward. To be able to complete differential restoration, full backup needs to be restored with “WITH NORECOVERY” option as follow:

More