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 …
SQL query in Odoo
Sql query in Odoo model
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 …
How to search string in files Linux
Use this command bellow to find a pattern in the arborescence. https://stackoverflow.com/questions/16956810/how-do-i-find-all-files-containing-specific-text-on-linux
Start stunnel on Mac OS X Sierra startup
This file will start automatically sTunnel daemon on your Mac Os Sierra computer. sudo vi /Library/LaunchDaemons/macports.stunnel.plist for more information concerning sTunnel, OpenVPN setup please read this post: Make OpenVPN stealthy …
Flush DNS cache Mac OSX
Create a file flush_dns.sh edit and paste the code bellow:
POS order to quotation in Odoo 9
Odoo 9 community does not have a button to generate from the POS (Point of Sale) Order a quotation (Sales Order), here is the following code of my module pos_2_so. Folders …
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}
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 …
Whitelist / Blacklist Amavis SpamAssassin Zimbra 8.6
Sometimes SpamAssassin scores email as False Positive spam, to avoid incoming emails to get junked, we can define globally in the config file /opt/zimbra/conf/amavisd.conf.in domain with a initial score. To …
Send an email using a template
Create a function in your model: call the function by the following XML code:
Odoo 9 Email Template
This is a basic email template to put in the xml file: if the module name is abc and the model name is voyelle then module_name.model_model_name should be abc.model_voyelle. ${object} …
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: …
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 …
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]
