www.numberspeaks.com

BLOG

Odoo / OpenERP

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.

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

Disable database manager in Odoo

Module for odoo 8 and 11 available on Github. Some tips found on the web hides only the link from Odoo homepage however URL are still reachable (~/web/database/manager). By installing this module, it will filter the access to Odoo database manager through the controller except connections coming from IPs listed in system parameters. Whitelist option: Key: disable_database_manager.database_manager_whitelist Value: 192.168.1.1,192.168.1.2,etc… This module will avoid unwanted connections attempts and secure your database manager access. Works with NGINX with some modification on nginx config file, click here for more detail. To disable completely database manager access: Add list_db = False in odoo.conf / …

App / Coding / Odoo / OpenERP

Odoo 11 community SO PO iOS approval

 Simple app to approve Odoo SO, PO from your iPhone / iPad, it has been tested only on Odoo Community 11, but it should work with newer version also. It requires an additional module on Odoo available on Github (link bellow). Odoo – NS module will add “Waiting for confirmation” Status on sale.order and purchase.order model.You will be able to customize the module and add any document that needs approval (like Invoices, payment confirmation, etc…)Long press on document from Odoo – NS iOS app will display PDF.If you have any question, you can contact me here:https://www.numberspeaks.com/contact/ 

App / Coding

Remote Mac computer from iPhone

CM – Remote Mac computers remote controller for macOS 13 Ventura and newer Control your Mac effortlessly from iPhone and iPad ApplicationsLaunch, exit and maximize program. SystemAdjust the volume, lock, put your Mac to sleep, restart from iPhone, iPad Installation of the macOS Agent is necessary. You can find the link below. CM – Remote works exclusively when both Mac and iOS devices are connected to the same network. Download Mobile App Mac computer Agent: CM Agent Latest version: 1.31 Designed to work with macOS version 13 Ventura and newer. Latest version: 1.34 macOS agent archive1.2 – Download1.3 – Download1.31 – Download

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.

More