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}
Add menu in dropdown list on tree view – Odoo 9
To add an additional menu in action dropdown list on tree view, we need to register “ir.actions.server” and “ir.values” on the qweb/xml file as follow. Note that code field name is using old Odoo python API. In your sale order model create the method as bellow with Odoo new API. Restart odoo and upgrade your module, you’ll have now cancel menu on your sales order tree view.
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
Problem with Godaddy VPS upgrade
I recently had a problem with Godaddy ubuntu 16.04 VPS, after updating and upgrading the system: SSH port wasn’t anymore reachable, it’s the only access we have to the server, however other services are working normally, so the system is still running. I tried many times to restart, call the support, but it didn’t solve the problem. The only solution was to destroy the server and rebuild it from scratch + restoration of backups. I’ve also tested the upgrade with a clean and freshly installed system, same issue occurred. If you’re running Ubuntu 16.04 VPS on Godaddy, Do not upgrade …
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.
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 :
