JasperSoft Studio 6.0.1 Parameters SQL syntax
To add string parameter in our report : String Parameter $P{P1} To add list parameter : $X{IN,sql_column_name,P1}
Number of digits after comma QWEB PDF Odoo
This code bellow will display on the QWEB PDF 4 digits after comma of qty field, for 2 digits just replace by ‘%.2f’%
WordPress Code Display
Plugin for displaying code in the front end: http://www.viper007bond.com/wordpress-plugins/syntaxhighlighter/ code to use in the backend: [code lang=”xml”][/code]
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 …
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 :
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:
