Bellow script will list incoming connections and remote ip geo localization of the server, it will search in logs file emails addresses related to the remote ip address. usage : ./script.sh {port} exemple :
Odoo dashboard is a simple app that displays predefined widgets set on Odoo server, this app requires an additional module available on Odoo store. – Create, rename, delete, reorder and reload dashboards.– Add, remove, reorder and reload widgets from dashboard.– Fast loading, data is retrieved by the server and cached. Odoo Dashboard Widgets – WidgetXVsY: displays 2 numbers, difference and variation is calculated.– WidgetLastX: it could be used to displays x last months orders / invoices, etc…– WidgetSingleX: displays a relevant numbers Odoo server module Odoo dashboard Remote database access Connect to remote databases (MSSQL, local postgreSQL, MySQL not implemented yet) …
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.
Sql query in Odoo model
This code bellow will display on the QWEB PDF 4 digits after comma of qty field, for 2 digits just replace by ‘%.2f’%
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]
